Competitors' Financial Performance Monitoring Model

The objective of the thesis was to develop a competitors’ financial performance monitoring model for management reporting. The research consisted of the selections of the comparison group and the performance meters as well as the actual creation of the model. A brief analysis of the current situation was also made. The aim of the results was to improve the financial reporting quality in the case organization by adding external business environment observation to the management reports. The comparison group for the case company was selected to include five companies that were all involved in power equipment engineering and project type business. The most limiting factor related to the comparison group selection was the availability of quarterly financial reporting. The most suitable performance meters were defined to be the developments of revenue, order backlog and EBITDA. These meters should be monitored systematically on quarterly basis and reported to the company management in a brief and informative way. The monitoring model was based on spreadsheet construction with key characteristics being usability, flexibility and simplicity. The model acts as a centered storage for financial competitor information as well as a reporting tool. The current market situation is strongly affected by the economic boom in the recent years and future challenges can be clearly seen in declining order backlogs. The case company has succeeded well related to its comparison group during the observation period since its business volume and profitability have developed in the best way.

TitGer: uma planilha eletrônica para simulação de titulação de mistura de compostos polipróticos

The aim of this paper is to present a simple way of treating the general equation for acid-base titrations based on the concept of degree of dissociation, and to propose a new spreadsheet approach for simulating the titration of mixtures of polyprotic compounds. The general expression, without any approximation, is calculated a simple iteration method, making number manipulation easy and painless. The user-friendly spreadsheet was developed by using MS-Excel and Visual-Basic-for-Excel. Several graphs are drawn for helping visualizing the titration behavior. A Monte Carlo function for error simulation was also implemented. Two examples for titration of alkalinity and McIlvaine buffer are presented.

Planilha de validação: uma nova ferramenta para estimar figuras de mérito na validação de métodos analíticos univariados

This work presents the VALIDATION SPREADSHEET, a public domain tool that can be used to evaluate the figures of merit for univariate analytical methods. A real example of BTEX determination in environmental samples is included to illustrate its use. The spreadsheet has been developed for Excel® and Open Office®, and is available on the internet at http//lqta.iqm.unicamp.br.

Sales and Operations Planning Implementation

The master’s thesis focused on implementing a sales and operations planning process. The main objectives were to create planning methods and tools for the implementation. The ultimate goal of the process, beyond this master’s thesis, is to balance the supply of products with customer demand, with optimized profitability. The theoretical part focused on giving a thorough view on the sales and operations planning process. The basis for a monthly planning cycle was identified. Methods, tools, and metrics for demand forecasting and operations planning were also introduced. Based on the theoretical part, a method for forecasting, a forecast spreadsheet, and a forecast accuracy metric were designed. A spreadsheet tool and methods were also designed for the monthly planning of production volumes, capacity, and inventory. The implementation progress was reviewed for two product families for three months. The sales and operations planning process was able to successfully identify a demand peak for the product families. Suggestions for the future of sales and operations planning were also made.

Sopimusvalmistajan tarjouslaskentamallin kehittäminen monituoteympäristöön

Työn tavoitteena oli luoda yhtenäinen, tehokas ja helppokäyttöinen tarjouslaskentamalli sopimusvalmistajan käyttöön. Konsernin käytössä oli aiemmin neljä erilaista tarjouslaskentamallia ja niitä oli erittäin vaikea vertailla keskenään, eikä niillä voitu laskea tarjouksia kaikille tehtaille. Työ jakautuu kirjallisuuskatsaukseen ja empiiriseen osaan. Kirjallisuuskatsauksessa käsitellään erilaisia hinnoitteluvaihtoehtoja, kustannuslaskennan roolia ja kustannuslaskentamenetelmiä. Empiirinen osa koostuu tarjouslaskennan nykytilan analysoinnista, uuden tarjouslaskentamallin rakentamisesta sekä kehitetyn tarjouslaskentamallin toimintakuvauksesta. Tarjouslaskentamallin pohjaksi valittiin kustannusperusteinen hinnoittelu, koska sitä oli käytetty aikaisemminkin ja se oli koettu hyväksi. Kustannusperusteisen tarjouslaskentamallin pohjaksi luotiin yhtenäiset työ – ja konetuntihinnat koko konserniin. Konetuntihinnat laskettiin 28 koneelle. Konetuntihintoja analysoitiin ja ryhmiteltiin siten, että päädyttiin 16 konelisän käyttöön. Tarjouslaskentamalli käsittelee vain valmistuksen kustannuksia eikä ota kantaa hallintokustannusten syntyyn. Yhtenäinen tarjouslaskentamalli helpottaa eri myyntimiesten tekemien tarjousten vertailua ja mahdollistaa tuotteiden myynnin useille tehtaille. Tarjouslaskentamalli toteutettiin taulukkolaskentaohjelmalla.

Determinação de ácido acéttico em amostra de vinagre adulterada com ácido clorídrico - um experimento integrado de titulação potenciométrica e condutométrica

The determination of acetic acid in vinegar adulterated sample using simultaneous potentiometric and condutometric titrations was used as an example of integrated experiment in instrumental analysis. An Excel® spreadsheet, which allows the entry of simultaneous data and the construction of the superimposed experimental curves (condutometric, potentiometric, first and second derivative potentiometric curve and, distribution diagrama of the acetic species as function of pH), was used as powerful tool to discuss the fundamental concepts involved in each technique and choose the best of them to quantify, without mutual interference, H3CCOOH and HCl in vinegar adulterated sample.

AVALIAÇÃO DO USO DE PLANILHAS COMPUTACIONAIS COMO UMA FERRAMENTA DIDÁTICA EM QUÍMICA ANALÍTICA QUALITATIVA

The use of spreadsheet softwares is not widespread in Chemical Education in Brazil as a computational education tool. By its turn the Qualitative Analytical Chemistry is considered a discipline with classical and non-flexible content. Thus in this work the spreadsheet software Excel® was evaluated as a teaching tool in a Qualitative Analytical Chemistry course for calculations of concentrations of the species in equilibrium in solutions of acids. After presenting the theory involved in such calculations the students were invited to elaborate the representation of the distribution of these species in a graphical form, using the spreadsheet software. Then the teaching team evaluated the resulting graphics regarding form and contents. The graphics with conceptual and/or formal errors were returned for correction, revealing significant improvement in the second presentation in all cases. The software showed to be motivating for the content of the discipline, improving the learning interest, while it was possible to prove that even in classical disciplines it is possible to introduce new technologies to help the teaching process.

Asuntosijoittamisen kilpailukykyisyys eläkesäästämismuotona

Tutkielman tarkoituksena on selvittää asuntosijoittamisen kilpailukykyisyyttä eläkesäästämismuotona. Vertailu tehdään kvantitatiivisena ja vertailukohtana ovat ns. perinteiset eläkesäästämismuodot, kuten rahastosijoitus, osakesijoitus, eläkevakuutus ja pankkitilisijoitus. Vertailu on tehty neljällä eri sijoittajaprofiililla. Profiilit eroavat toisistaan säästöajan ja säästösumman suhteen. Kaikissa tapauksissa kokonaissäästösumma on 36 000 euroa. Asuntosijoituksen lähtökohtana on osakehuoneisto, joka vuokrataan eteenpäin asumiskäyttöön. Asunnon ostoon otetaan pankkilaina, jota maksetaan pois vuokratuloilla sekä omalla osuudella niin, että kuukausittainen omaosuus lainan lyhennyksestä olisi vastaavan suuruinen kuin vaihtoehtoissijoituksen ns. perinteiseen eläkesäästämistuotteeseen. Tutkielmassa esiintyvät laskelmat on tehty Excel-taulukkolaskentaohjelmalla. Analyysissä keskitytään ensisijaisesti analysoimaan verojen ja kaikkien kulujen jälkeistä sijoitusten loppuarvoa, todellista vuosittaista tuottoprosenttia sekä koko sijoitetun pääoman tuottoprosenttia koko sijoitusajalta.

Teknologiateollisuuden sopimusvalmistajayrityksen kustannuslaskennan kehittäminen

Työn päätavoitteena oli kohdeyrityksen kustannuslaskennan kehittäminen, jota varten selvitettiin toimintojen todelliset kustannukset sekä rakennettiin uusi taulukkolaskentaan perustuva hinnoittelumalli. Todellisten kustannukset selvitettiin toimintolaskennan avulla. Yrityksen aiempi kustannuslaskenta perustui perinteiseen lisäyslaskentaan. Työ jakaantui kahteen vaiheeseen: yrityksen kustannuslaskennan nykytilaselvitykseen ja toimintolaskennan toteuttamiseen. Ensimmäisen vaiheen teoriaosuudessa esiteltiin perinteisen kustannuslaskennan ja toimintolaskennan menetelmät sekä vertailtiin niitä keskenään. Empiriaosuudessa käsiteltiin yrityksen kustannusrakenne, tuotekustannuslaskenta, hinnoitteluprosessi ja eri hinnoittelukohteet. Nykytilaselvityksen perusteella laadittiin lista nykyisen kustannuslaskennan ja hinnoittelun kehitettävistä asioista. Kehittäminen päätettiin toteuttaa toimintolaskennan avulla. Toisessa vaiheessa esiteltiin toimintolaskennan toteuttamiseen ja käyttöönottoon liittyvä teoria. Tämän jälkeen suoritettiin toimintokustannusten laskeminen ja uuden hinnoittelumallin rakentaminen. Hinnoittelumallissa haettiin nopeutta uudella materiaalinlaskentatavalla. Työn tuloksina havaittiin, että toteutuneet kustannukset erosivat monen toiminnon kohdalla lisäyslaskennalla lasketuista kustannuksista ja tämä oli vääristänyt tuotteiden hinnoittelua. Toimintolaskennan käyttöönotolla yrityksen kustannuslaskenta ja tuotehinnoittelu saatettiin vastaamaan todellisia kustannuksia. Hinnoittelun nopeutumisella saavutettiin merkittäviä kustannussäästöjä.

Metaanin muodostumisen mallintaminen kaatopaikalla

Methane-rich landfill gas is generated when biodegradable organic wastes disposed of in landfills decompose under anaerobic conditions. Methane is a significant greenhouse gas, and landfills are its major source in Finland. Methane production in landfill depends on many factors such as the composition of waste and landfill conditions, and it can vary a lot temporally and spatially. Methane generation from waste can be estimated with various models. In this thesis three spreadsheet applications, a reaction equation and a triangular model for estimating the gas generation were introduced. The spreadsheet models introduced are IPCC Waste Model (2006), Metaanilaskentamalli by Jouko Petäjä of Finnish Environment Institute and LandGEM (3.02) of U.S. Environmental Protection Agency. All these are based on the first order decay (FOD) method. Gas recovery methods and gas emission measurements were also examined. Vertical wells and horizontal trenches are the most commonly used gas collection systems. Emission measurements chamber method, tracer method, soil core and isotope measurements, micrometeorological mass-balance and eddy covariance methods and gas measuring FID-technology were discussed. Methane production at Ämmässuo landfill of HSY Helsinki Region Environmental Services Authority was estimated with methane generation models and the results were compared with the volumes of collected gas. All spreadsheet models underestimated the methane generation at some point. LandGEM with default parameters and Metaanilaskentamalli with modified parameters corresponded best with the gas recovery numbers. Reason for the differences between evaluated and collected volumes could be e.g. that the parameter values of the degradable organic carbon (DOC) and the fraction of decomposable degradable organic carbon (DOCf) do not represent the real values well enough. Notable uncertainty is associated with the modelling results and model parameters. However, no simple explanation for the discovered differences can be given within this thesis.

Parallella, dynamiska representationer i gymnasiefysiken : implementering av ett interaktivt datorverktyg i didaktiska situationer och uppfattning av effektivt lärande

The computer is a useful tool in the teaching of upper secondary school physics, and should not have a subordinate role in students' learning process. However, computers and computer-based tools are often not available when they could serve their purpose best in the ongoing teaching. Another problem is the fact that commercially available tools are not usable in the way the teacher wants. The aim of this thesis was to try out a novel teaching scenario in a complicated subject in physics, electrodynamics. The didactic engineering of the thesis consisted of developing a computer-based simulation and training material, implementing the tool in physics teaching and investigating its effectiveness in the learning process. The design-based research method, didactic engineering (Artigue, 1994), which is based on the theoryof didactical situations (Brousseau, 1997), was used as a frame of reference for the design of this type of teaching product. In designing the simulation tool a general spreadsheet program was used. The design was based on parallel, dynamic representations of the physics behind the function of an AC series circuit in both graphical and numerical form. The tool, which was furnished with possibilities to control the representations in an interactive way, was hypothesized to activate the students and promote the effectiveness of their learning. An effect variable was constructed in order to measure the students' and teachers' conceptions of learning effectiveness. The empirical study was twofold. Twelve physics students, who attended a course in electrodynamics in an upper secondary school, participated in a class experiment with the computer-based tool implemented in three modes of didactical situations: practice, concept introduction and assessment. The main goal of the didactical situations was to have students solve problems and study the function of AC series circuits, taking responsibility for theirown learning process. In the teacher study eighteen Swedish speaking physics teachers evaluated the didactic potential of the computer-based tool and the accompanying paper-based material without using them in their physics teaching. Quantitative and qualitative data were collected using questionnaires, observations and interviews. The result of the studies showed that both the group of students and the teachers had generally positive conceptions of learning effectiveness. The students' conceptions were more positive in the practice situation than in the concept introduction situation, a setting that was more explorative. However, it turned out that the students' conceptions were also positive in the more complex assessment situation. This had not been hypothesized. A deeper analysis of data from observations and interviews showed that one of the students in each pair was more active than the other, taking more initiative and more responsibilityfor the student-student and student-computer interaction. These active studentshad strong, positive conceptions of learning effectiveness in each of the threedidactical situations. The group of less active students had a weak but positive conception in the first iv two situations, but a negative conception in the assessment situation, thus corroborating the hypothesis ad hoc. The teacher study revealed that computers were seldom used in physics teaching and that computer programs were in short supply. The use of a computer was considered time-consuming. As long as physics teaching with computer-based tools has to take place in special computer rooms, the use of such tools will remain limited. The affordance is enhanced when the physical dimensions as well as the performance of the computer are optimised. As a consequence, the computer then becomes a real learning tool for each pair of students, smoothly integrated into the ongoing teaching in the same space where teaching normally takes place. With more interactive support from the teacher, the computer-based parallel, dynamic representations will be efficient in promoting the learning process of the students with focus on qualitative reasoning - an often neglected part of the learning process of the students in upper secondary school physics.

Weather based warning systems for bean angular-leaf-spot and anthracnose

Data available in the literature were used to develop a warning system for bean angular leaf spot and anthracnose, caused by Phaeoisariopsis griseola and Colletotrichum lindemuthianum, respectively. The model is based on favorable environmental conditions for the infectious process such as continuous leaf wetness duration and mean air temperature during this subphase of the pathogen-host relationship cycle. Equations published by DALLA PRIA (1977) showing the interactions of those two factors on the disease severity were used. Excell spreadsheet was used to calculate the leaf wetness period needed to cause different infection probabilities at different temperature ranges. These data were employed to elaborate critical period tables used to program a computerized electronic device that records leaf wetness duration and mean temperature and automatically shows the daily disease severity value (DDSV) for each disease. The model should be validated in field experiments under natural infection for which the daily disease severity sum (DDSS) should be identified as a criterion to indicate the beginning and the interval of fungicide applications to control both diseases.

Energia- ja ilmastotoimenpiteiden käynnistäminen pk-yrityksissä

Tämän diplomityön tarkoituksena oli kehittää toimintamalli pk-yritysten energia- ja ilmastotoimenpiteiden käynnistämiseksi HINKU-kunnissa. Esimerkkiyrityksenä työssä toimi Tehomet Oy:n Parikkalan tehdas. Työssä tutustuttiin ensimmäisenä erilaisiin jo olemassa oleviin toimintamalleihin, hiilijalanjäljen laskentastandardeihin sekä erilaisiin mahdollisuuksiin hiilineutraaliuden saavuttamiseksi. Lisäksi Tehomet Oy:n Parikkalan tehtaalta kerättiin tarvittavaa tietoa yrityksen ja tuotteen hiilijalanjälkien laskentaa varten. Kerätyn tiedon ja jo olemassa olevien standardien ja toimintamallien pohjalta kehitettiin toimintamalli, johon sisältyy laskentataulukko, jonka avulla yritykset voivat laskea hiilijalanjälkensä ja tunnistaa kasvihuonekaasupäästöjen merkittävyyden liiketoimintansa kehittämisen näkökulmasta. Tehomet Oy:n valmistaman puupylvään hiilijalanjälki pieneni merkittävästi, kun laskennassa huomioitiin hiilen sitoutuminen tuotteeseen sekä tuotteen käytöstä poisto. Parikkalan tehtaan tapauksessa suurin yksittäinen kasvihuonekaasujen päästölähde on sähkönkulutus. Energiankulutuksen kannalta merkittävin säästökohde olisi mitä todennäköisimmin teholtaan liian suuresta kompressorista luopuminen. Kasvihuonekaasupäästöjen hiilineutraaliksi saattamiseksi mahdolliset toimenpiteet olisivat tässä tapauksessa hiilivapaan sähkön ostaminen tai päästöjen kompensoiminen ostamalla päästöoikeuksia. Toimintamallin todellinen toimivuus nähdään tulevaisuudessa, kun sitä päästään testaamaan laajemmalti eri aloilla toimiviin yrityksiin.

Spectrometrical Monitoring of Laser Sintering Process of Ceramic Material

This thesis is done as a part of project called FuncMama that is a project between Technical Research Centre of Finland (VTT), Oulu University (OY), Lappeenranta University of Technology (LUT) and Finnish industrial partners. Main goal of the project is to manufacture electric and mechanical components from mixed materials using laser sintering. Aim of this study was to create laser sintered pieces from ceramic material and monitor the sintering event by using spectrometer. Spectrometer is a device which is capable to record intensity of different wavelengths in relation with time. In this study the monitoring of laser sintering was captured with the equipment which consists of Ocean Optics spectrometer, optical fiber and optical lens (detector head). Light from the sintering process hit first to the lens system which guides the light in to the optical fibre. Optical fibre transmits the light from the sintering process to the spectrometer where wavelengths intensity level information is detected. The optical lens of the spectrometer was rigidly set and did not move along with the laser beam. Data which was collected with spectrometer from the laser sintering process was converted with Excel spreadsheet program for result’s evaluation. Laser equipment used was IPG Photonics pulse fibre laser. Laser parameters were kept mainly constant during experimental part and only sintering speed was changed. That way it was possible to find differences in the monitoring results without fear of too many parameters mixing together and affecting to the conclusions. Parts which were sintered had one layer and size of 5 x 5 mm. Material was CT2000 – tape manufactured by Heraeus which was later on post processed to powder. Monitoring of different sintering speeds was tested by using CT2000 reference powder. Moreover tests how different materials effect to the process monitoring were done by adding foreign powder Du Pont 951 which had suffered in re-grinding and which was more reactive than CT2000. By adding foreign material it simulates situation where two materials are accidently mixed together and it was studied if that can be seen with the spectrometer. It was concluded in this study that with the spectrometer it is possible to detect changes between different laser sintering speeds. When the sintering speed is lowered the intensity level of light is higher from the process. This is a result of higher temperature at the sintering spot and that can be noticed with the spectrometer. That indicates it could be possible to use spectrometer as a tool for process observation and support the idea of having system that can help setting up the process parameter window. Also important conclusion was how well the adding of foreign material could be seen with the spectrometer. When second material was added a significant intensity level raise could be noticed in that part where foreign material was mixed. That indicates it is possible to see if there are any variations in the material or if there are more materials mixed together. Spectrometric monitoring of laser sintering could be useful tool for process window observation and temperature controlling of the sintering process. For example if the process window for specific material is experimentally determined to get wanted properties and satisfying sintering speed. It is possible if the data is constantly recorded that the results can show faults in the part texture between layers. Changes between the monitoring data and the experimentally determined values can then indicate changes in the material being generated by material faults or by wrong process parameters. The results of this study show that spectrometer could be one possible tool for monitoring. But to get in that point where this all can be made possible much more researching is needed.

Economic analysis for sizing of sugarcane (Saccharum spp.) mechanized harvesting

Sugarcane has a significant role on Brazilian agribusiness economy. The harvesting cane is considered as one of the most important operations of the process for it has to attend the raw material demanded by the sugar mill in quality and a competitive cost. The objective of this work it is it of analyzing, of systemic way, the variables influence on economical and operational performance in sugarcane mechanized harvesting process for sizing of machines. For this purpose a model called "ColheCana", was developed in a spreadsheet and in a programming language. The results showed that the field efficiency and harvester´s initial value are variables of great impact in the cost and that there is a maximum area that one equipment can attend and for this area the cost is minimum.