On-Line Analytical Processing of Inventory Turnover

Operatiivisen tiedon tuottaminen loppukäyttäjille analyyttistä tarkastelua silmällä pitäen aiheuttaa ongelmia useille yrityksille. Diplomityö pyrkii ratkaisemaan ko. ongelman Teleste Oyj:ssä. Työ on jaettu kolmeen pääkappaleeseen. Kappale 2 selkiyttää On-Line Analytical Processing (OLAP)- käsitteen. Kappale 3 esittelee muutamia OLAP-tuotteiden valmistajia ja heidän arkkitehtuurejaan sekä tyypillisten sovellusalueiden lisäksi huomioon otettavia asioita OLAP käyttöönoton yhteydessä. Kappale 4, tuo esille varsinaisen ratkaisun. Teknisellä arkkitehtuurilla on merkittävä asema ratkaisun rakenteen kannalta. Tässä on sovellettu Microsoft:n tietovarasto kehysrakennetta. Kappaleen 4 edetessä, tapahtumakäsittelytieto muutetaan informaatioksi ja edelleen loppukäyttäjien tiedoksi. Loppukäyttäjät varustetaan tehokkaalla ja tosiaikaisella analysointityökalulla moniulotteisessa ympäristössä. Vaikka kiertonopeus otetaan työssä sovellusesimerkiksi, työ ei pyri löytämään optimaalista tasoa Telesten varastoille. Siitä huolimatta eräitä parannusehdotuksia mainitaan.

Psychometric properties and dimensional structure of the Spanish version of the Coping Responses Inventory - Adult Form

One of the goals of psychological assessment focuses on the adaptation of its instruments to different populations. The objective of this study is to establish the psychometric properties and dimensional structure of the Spanish version of the Coping Responses Inventory- Adult Form (CRI-Adult, Moos, 1993). The following criteria were analyzed: a) descriptive statistics; b) internal consistency reliability (Cronbach"s alpha, and intercorrelations between scales); c) test-retest reliability (4-week interval); d) dimensionality of CRI-Adult (exploratory factor analysis); e) construct validity (confirmatory factor analysis); f) convergent criterion validity (correlations between CRI-Adult and Coping Strategies Indicator, CSI, Amirkhan, 1990), and g) predictive criterion validity (correlations between CRI-Adult, and SCL-90-R, Derogatis, 1983). The results, obtained with 800 adults from Barcelona and surrounding area (334 men and 466 women, aged between 18 to 76 years) indicate that the Spanish version of CRIAdult has satisfactory psychometric properties that allow using this test with guarantee.

The Psychometric Properties of the French Version of the Personality Inventory for DSM-5.

In the context of the publication of DSM-5, the Personality Inventory for DSM-5 (PID-5) has been proposed as a new dimensional assessment tool for personality disorders. This instrument includes a pool of 220 items organized around 25 facets included in a five-factor second-order domain structure. The examination of the replicability of the trait structure across methods and populations is of primary importance. In view of this need, the main objective of the current study was to validate the French version of the PID-5 among French-speaking adults from a European community sample (N=2,532). In particular, the assumption of unidimensionality of the 25 facet and the five domain scales was tested, as well as the extent to which the five-factor structure of the PID-5 and the DSM-5 personality trait hierarchical structure are replicated in the current sample. The results support the assumption of unidimensionality of both the facets and the domains. Exploratory factor and hierarchical analyses replicated the five-factor structure as initially proposed in the PID-5.

Health-related quality of life in school children: validation of instrument, child self assessment, parent-proxy assessment and school nursing documentation of health check-ups

The aims of this study were to validate an international Health-Related Quality of Life (HRQL) instrument, to describe child self and parent-proxy assessed HRQL at child age 10 to 12 and to compare child self assessments with parent-proxy assessments and school nursing documentation. The study is part of the Schools on the Move –research project. In phase one, a cross-cultural translation and validation process was performed to develop a Finnish version of Pediatric Quality of Life Inventory™ 4.0 (PedsQL™ 4.0). The process included a two-way translation, cognitive interviews (children n=7, parents n=5) and a survey (children n=1097, parents n=999). In phase two, baseline and follow-up surveys (children n=986, parents n=710) were conducted to describe and compare the child self and parent-proxy assessed HRQL in school children between the ages 10 and 12. Phase three included two separate data, school nurse documented patient records (children n=270) and a survey (children n=986). The relation between child self assessed HRQL and school nursing documentation was evaluated. Validity and reliability of the Finnish version of PedsQL™ 4.0 was good (Child Self Report α=0.91, Parent-Proxy Report α=0.88). Children reported lower HRQL scores at the emotional (mean 76/80) than the physical (mean 85/89) health domains and significantly lower scores at the age of 10 than 12 (dMean=4, p=<0.001). Agreement between child self and parent-proxy assessment was fragile (r=0,4, p=<0.001) but increased as the child grew from age 10 to 12 years. At health check-ups, school nurses documented frequently children’s physical health, such as growth (97%) and posture (98/99%) but seldom emotional issues, such as mood (2/7%). The PedsQLTM 4.0 is a valid instrument to assess HRQL in Finnish school children although future research is recommended. Children’s emotional wellbeing needs future attention. HRQL scores increase during ages between childhood and adolescence. Concordance between child self and parent-proxy assessed HRQL is low. School nursing documentation, related to child health check-ups, is not in line with child self assessed HRQL and emotional issues need more attention.

Assessment of purchasing maturity in spare parts supply chain

To describe the change of purchasing moving from administrative to strategic function academics have put forward maturity models which help practitioners to compare their purchasing activities to industry top performers and best practices. However, none of the models aim to distinguish the purchasing maturity from the after-sales point of view, even though after-sales activities are acknowledged as a relevant source of revenue, profit and competitive advantage in most manufacturing firms. The maturity of purchasing and supply management practices have a large impact to the overall performance of the spare parts supply chain and ultimately to the value creation and relationship building for the end customer. The research was done as a case study for a European after-sales organization which is part of a globally operating industrial firm specialized in heavy machinery. The study mapped the current state of the purchasing practices in the case organization and also distinguished the relevant areas for future development. The study was based on the purchasing maturity model developed by Schiele (2007) and investigated also how applicable is the maturity model in the spare parts supply chain context. Data for the assessment was gathered using five expert interviews inside the case organization and other parties involved in the company’s spare parts supply chain. Inventory management dimension was added to the original maturity model in order to better capture the important areas in a spare parts supply chain. The added five questions were deduced from the spare parts management literature and verified as relevant areas by the case organization’s personnel. Results indicate that largest need for development in the case organization are: better collaboration between sourcing and operative procurement functions, use of installed base information in the spare parts management, training plan development for new buyers, assessment of aligned KPI’s between the supply chain parties and better defining the role of after-sales sourcing. The purchasing maturity model used in this research worked well in H&R Leading, Controlling and Inventory Management dimensions. The assessment was more difficult to conduct in the Supplier related processes, Process integration and Organizational structure –dimensions, mainly because the assessment in these sections would for some parts require more company-wide assessment. Results indicate also that the purchasing maturity model developed by Schiele (2007) captures the relevant areas in the spare parts supply as well.

A Portuguese version of the Christo Inventory for Substance-Misuse Services: a simple outcome evaluation tool

The Christo Inventory for Substance-Misuse Services (CISS) is a single page outcome evaluation tool completed by drug alcohol service workers either on the basis of direct client interviews or of personal experience of their client supplemented by existing assessment notes. It was developed to assist substance misuse services to empirically demonstrate the effectiveness of their treatments to their respective funding bodies. Its 0 to 20 unidimensional scale consists of 10 items reflecting clients' problems with social functioning, general health, sexual/injecting risk behavior, psychological functioning, occupation, criminal involvement, drug/alcohol use, ongoing support, compliance, and working relationships. Good reliability and validity has already been demonstrated for the CISS [Christo et al., Drug and Alcohol Dependence 2000; 59: 189-197] but the original was written in English and a Portuguese version is presented here. The present review explores its applicability to a Brazilian setting, summarizes its characteristics and uses, and describes the process of translation to Portuguese. A pilot study conducted in a substance misuse service for adolescents indicated it is likely to be suitable for use among a Brazilian population. The simplicity, flexibility and brevity of the CISS make it a useful tool allowing comparison of clients within and between many different service settings.

Validation of the Social Phobia and Anxiety Inventory for Children (SPAI-C) in a sample of Brazilian children

The purpose of the present study was to examine the factor structure and psychometric properties of the Social Phobia and Anxiety Inventory for Children (SPAI-C), an instrument developed in the United States and applied to a sample of Brazilian schoolchildren. The process included the translation of the original material from English into Portuguese by two bilingual psychiatrists and a back translation by a bilingual physician. Both the front and back translations were revised by a bilingual child psychiatrist. The study was performed using a cross-sectional design and the Portuguese version of the SPAI-C was applied to a sample of 1954 children enrolled in 3rd to 8th grade attending 2 private and 11 public schools. Eighty-one subjects were excluded due to an incomplete questionnaire and 2 children refused to participate. The final sample consisted of 1871 children, 938 girls (50.1%) and 933 boys (49.8%), ranging in age from 9 to 14 years. The majority of the students were Caucasian (89.0%) and the remainder were African-Brazilian (11.0%). The Pearson product-moment correlation showed that the two-week test-retest reliability coefficient was r = 0.780 and Cronbach's alpha was 0.946. The factor structure was almost similar to that reported in previous studies. The results regarding the internal consistency, the test-retest reliability and the factor structure were similar to the findings obtained in studies performed on English speaking children. The present study showed that the Portuguese language version of SPAI-C is a reliable and valid measure of social anxiety for Brazilian children.

The assessment of self-directed learning among pre-service students in an Ontario faculty of education

The study determined students' perceptions of self-directed learning in their courses. Tests to assess perceptions are not being used in many programs. Assessments such as the Self-Directed Readiness Scale (SDLRS) and the Oddi continuing Learning Inventory (OCLI) have weaknesses that may have affected the use of tests. In this study, the creation of the Self-Directed Learning Test (SDLT) monitored students' perceptions by addressing what students were told before registration, how much input students had in developing the structure of the course, how much input students have in determining the evaluation for the course, what style of learning is taking place, and the characteristics of learning found among students. Fifty-one students in the pre-service program at Brock University completed the SDLT. Results showed that 47.1% of the sample liked self-directed learning. Several students who stated that they did not like selfdirected learning did not know what self-directed learning was. Results supported Brookfield's (1986) claim for more education on what self-directed learning is. The study did not support Knowles' (1980) assumption that adult students know and want to follow self-directed approaches to learning. The SDLT is a good method for monitoring self-directed learning and how students perceive their courses.

Inventory management in public sector electrical industry in Kerala

The thesis entitled Inventory Management In Public Sector Electrical Industry In Kerala. Investigations were carried out on inventory management in public sector electrical industry in Kerala and suggest methods to improve their efficiency. Various aspects of inventory management, its scope and need in industry are detailed. The objectives of the present study concentrates to get an overall view of the system of inventory management, assess the positions and levels of inventory. It analyzes the inventory management policies and practices, the organizational set-up for materials by the electrical undertakings. The study examines the liquidity of the electrical undertakings as well as techniques of inventory management in the electrical industry in Kerala. Hypotheses state that the existing organizational systems and practices are inadequate to ensure efficient management of inventories in electrical industry. Introduction of scientific inventory techniques has a favourable effect on the workings of inventory departments. The financial performance of the public sector electrical undertakings is not at all satisfactory on account of the high raw material costs, heavy borrowings and huge interest burdens. The scope of this study is limited to the assessment of savings, in inventories of electrical products due to inventory management. The methodology of the study is to project the cost reduction of the inventory department on the basis of data collected and to validate this projection with the aid of analysis and survey. The limitations of the study is that the data obtained relate to the period 1989-90 and earlier and the current position is not available and uniform norms cannot be applied to evaluate different inventory management organisation.

Risk Aversion in Inventory Management

Traditional inventory models focus on risk-neutral decision makers, i.e., characterizing replenishment strategies that maximize expected total profit, or equivalently, minimize expected total cost over a planning horizon. In this paper, we propose a framework for incorporating risk aversion in multi-period inventory models as well as multi-period models that coordinate inventory and pricing strategies. In each case, we characterize the optimal policy for various measures of risk that have been commonly used in the finance literature. In particular, we show that the structure of the optimal policy for a decision maker with exponential utility functions is almost identical to the structure of the optimal risk-neutral inventory (and pricing) policies. Computational results demonstrate the importance of this approach not only to risk-averse decision makers, but also to risk-neutral decision makers with limited information on the demand distribution.

Evaluación de la severidad de la ideación suicida autoinformada en escolares de 8 a 12 año = Assessment of self-report suicidal ideation severity in 8 to 12 years old school children

El objetivo de este estudio es la evaluación de la ideación suicida infantil y su severidad a partir de la información proporcionada por el propio niño. Para ello se ha aplicado el Children’s Depression Inventory a una muestra representativa de 361 escolares de edades comprendidas entre los 8 y 12 años. Un mes más tarde se ha verificado la persistencia de los deseos de morir mediante la Children’s Depression Rating Scale-Revised. Se evalúa la severidad de la ideación suicida autoinformada con relación a la persistencia, la alteración del estado de ánimo y el conocimiento intelectual de la muerte. Los resultados indican que la persistencia de la intencionalidad suicida esta asociada a una mayor sintomatología depresiva

Implementation of global make to inventory strategy at BASF SE

La optimización y armonización son factores clave para tener un buen desempeño en la industria química. BASF ha desarrollado un proyecto llamada acelerador. El objetivo de este proyecto ha sido la armonización y la integración de los procesos de la cadena de suministro a nivel mundial. El proceso básico de manejo de inventarios se quedó fuera del proyecto y debía ser analizado. El departamento de manejo de inventarios en BASF SE ha estado desarrollando su propia estrategia para la definición de procesos globales de manufactura. En este trabajo se presentará un informe de las fases de la formulación de la estrategia y establecer algunas pautas para la fase de implementación que está teniendo lugar en 2012 y 2013.

Psychometric characteristics of the BRIEF scale for the assessment of executive functions in Spanish clinical population

Resumen tomado de la publicaci??n

Glacier shrinkage and climatic change in the Russian Altai from the mid-20th century: An assessment using remote sensing and PRECIS regional climate model

This paper examines changes in the surface area of glaciers in the North and South Chuya Ridges, Altai Mountains in 1952-2004 and their links with regional climatic variations. The glacier surface areas for 2004 were derived from the Advanced Spaceborne Thermal Emission and Reflection Radiometer (ASTER) imagery. Data from the World Glacier Inventory (WGI)dating to 1952 and aerial photographs from 1952 were used to estimate the changes. 256 glaciers with a combined area of 253±5.1 km2 have been identified in the region in 2004. Estimation of changes in extent of 126 glaciers with the individual areas not less than 0.5 km2 in 1952 revealed a 19.7±5.8% reduction. The observed glacier retreat is primarily driven by an increase in summer temperatures since the 1980s when air temperatures were increasing at a rate of 0.10 - 0.13oC a-1 at the glacier tongue elevation. The regional climate projections for A2 and B2 CO2 emission scenarios developed using PRECIS regional climate model indicate that summer temperatures will increase in the Altai in 2071-2100 by 6-7oC and 3-5oC respectively in comparison with 1961-1990 while annual precipitation will increase by 15% and 5%. The length of the ablation season will extend from June-August to the late April – early October. The projected increases in precipitation will not compensate for the projected warming and glaciers will continue to retreat in the 21st century under both B2 and A2 scenarios.

Results of an aqueous source term model for a radiological risk assessment of the Drigg LLW Site, U.K.

A radionuclide source term model has been developed which simulates the biogeochemical evolution of the Drigg low level waste (LLW) disposal site. The DRINK (DRIgg Near field Kinetic) model provides data regarding radionuclide concentrations in groundwater over a period of 100,000 years, which are used as input to assessment calculations for a groundwater pathway. The DRINK model also provides input to human intrusion and gaseous assessment calculations through simulation of the solid radionuclide inventory. These calculations are being used to support the Drigg post closure safety case. The DRINK model considers the coupled interaction of the effects of fluid flow, microbiology, corrosion, chemical reaction, sorption and radioactive decay. It represents the first direct use of a mechanistic reaction-transport model in risk assessment calculations.