282 resultados para spreadsheet
Resumo:
O presente trabalho cujo título é Implementação do ABC numa empresa prestadora de serviços de Saúde, tem como finalidade a obtenção do grau de licenciatura em Contabilidade e Administração e tem como principal objectivo a implementação do método ABC numa pequena e média empresa de prestação de serviços de saúde, como um instrumento de apoio á gestão. Para a introdução da Contabilidade de Gestão na empresa, há que se escolher um método/sistema de apuramento de gastos que espelha a realidade da empresa, e de uma certa forma o ABC é o método ideal para apuramento de resultados sem distorções. O ABC (Activity-Based Cost) apura os resultados através da relação de causa-efeito, considerando que as actividades é que geram gastos e os objectos de custeio é que consomem as actividades. É aplicável tanto nas empresas industriais como nas empresas prestadoras de serviços, apesar de inicialmente ter sido concebido para as empresas industrias, isto é, para as grandes empresas devido aos avultados recursos financeiros e humanos como também pelo tempo necessário para a sua implementação. Mas o modelo matricial apresentado por Roztcki et al (1999) permite a aplicação deste método nas PME com poucos recursos financeiros e de tempo, utilizando uma folha de cálculo no Excel. Será este modelo a ser proposto e poderá ser implementado na clínica. O modelo apresentado foi testado num estudo de caso realizado numa clínica. Com a realização dos testes foi detectado algumas dificuldades e limitações, as maiores dificuldades encontradas foram a identificação das actividades e dos cost drivers, devido à complexidade do sector. A implementação foi concluída com sucesso, proporcionando informações detalhadas dos gastos dos produtos/serviços prestados em toda a clínica. This work was done as a requisite for obtaining a degree in Accounting and Administration, and is titled “The Implementation of ABC – Activity Based Cost in a company that provides health services”. Its main purpose is to analyze the implementation of ABC method in a small and medium-sized enterprise which provides health services to support decision making by the Managers. To adopt management accounting in a company, it’s necessary to choose a cost qualifying system that reflects the reality of the company and in a certain way ABC is the method which can determine the results without any distortion. ABC (Activity-Based Cost) determines the results through cause-and-effect relationship, whereas the activities generate spending while costing objects consume the activities. It’s applicable both in industrial companies as in services providers, although it was initially designed for industrial companies, that is, to large companies, due to the huge financial and human resources existent as well as by the time required for its implementation. But the matrix model presented by Roztckiet al (1999) allows application of this method in small and medium-sized enterprises with limited financial resources and time, using a spreadsheet in Excel. This model will be proposed and could be implemented in any clinic. The model was tested in a case study, undertaken in a private clinic. With the realization of the tests, some problems and limitations were detected, and the major difficulties encountered were the identification of activities and cost drivers, due to the complexity of the sector. The implementation was completed successfully, providing detailed information of the products services spending throughout the clinic.
Resumo:
In Neo-Darwinism, variation and natural selection are the two evolutionary mechanisms which propel biological evolution. Our previous article presented a histogram model [1] consisting in populations of individuals whose number changed under the influence of variation and/or fitness, the total population remaining constant. Individuals are classified into bins, and the content of each bin is calculated generation after generation by an Excel spreadsheet. Here, we apply the histogram model to a stable population with fitness F(1)=1.00 in which one or two fitter mutants emerge. In a first scenario, a single mutant emerged in the population whose fitness was greater than 1.00. The simulations ended when the original population was reduced to a single individual. The histogram model was validated by excellent agreement between its predictions and those of a classical continuous function (Eqn. 1) which predicts the number of generations needed for a favorable mutation to spread throughout a population. But in contrast to Eqn. 1, our histogram model is adaptable to more complex scenarios, as demonstrated here. In the second and third scenarios, the original population was present at time zero together with two mutants which differed from the original population by two higher and distinct fitness values. In the fourth scenario, the large original population was present at time zero together with one fitter mutant. After a number of generations, when the mutant offspring had multiplied, a second mutant was introduced whose fitness was even greater. The histogram model also allows Shannon entropy (SE) to be monitored continuously as the information content of the total population decreases or increases. The results of these simulations illustrate, in a graphically didactic manner, the influence of natural selection, operating through relative fitness, in the emergence and dominance of a fitter mutant.
Resumo:
This project demonstrated the capabilities for load testing bridges in Iowa, developed and presented a webinar to local and state engineers, and produced a spreadsheet and benefit evaluation matrix that others can use to preliminarily assess where bridge testing may be economically feasible given truck traffic and detour lengths.
Resumo:
This report presents the results of work zone field data analyzed on interstate highways in Missouri to determine the mean breakdown and queue-discharge flow rates as measures of capacity. Several days of traffic data collected at a work zone near Pacific, Missouri with a speed limit of 50 mph were analyzed in both the eastbound and westbound directions. As a result, a total of eleven breakdown events were identified using average speed profiles. The traffic flows prior to and after the onset of congestion were studied. Breakdown flow rates ranged between 1194 to 1404 vphpl, with an average of 1295 vphpl, and a mean queue discharge rate of 1072 vphpl was determined. Mean queue discharge, as used by the Highway Capacity Manual 2000 (HCM), in terms of pcphpl was found to be 1199, well below the HCM’s average capacity of 1600 pcphpl. This reduced capacity found at the site is attributable mainly to narrower lane width and higher percentage of heavy vehicles, around 25%, in the traffic stream. The difference found between mean breakdown flow (1295 vphpl) and queue-discharge flow (1072 vphpl) has been observed widely, and is due to reduced traffic flow once traffic breaks down and queues start to form. The Missouri DOT currently uses a spreadsheet for work zone planning applications that assumes the same values of breakdown and mean queue discharge flow rates. This study proposes that breakdown flow rates should be used to forecast the onset of congestion, whereas mean queue discharge flow rates should be used to estimate delays under congested conditions. Hence, it is recommended that the spreadsheet be refined accordingly.
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
Researchers should continuously ask how to improve the models we rely on to make financial decisions in terms of the planning, design, construction, and maintenance of roadways. This project presents an alternative tool that will supplement local decision making but maintain a full appreciation of the complexity and sophistication of today’s regional model and local traffic impact study methodologies. This alternative method is tailored to the desires of local agencies, which requested a better, faster, and easier way to evaluate land uses and their impact on future traffic demands at the sub-area or project corridor levels. A particular emphasis was placed on scenario planning for currently undeveloped areas. The scenario planning tool was developed using actual land use and roadway information for the communities of Johnston and West Des Moines, Iowa. Both communities used the output from this process to make regular decisions regarding infrastructure investment, design, and land use planning. The City of Johnston case study included forecasting future traffic for the western portion of the city within a 2,600-acre area, which included 42 intersections. The City of West Des Moines case study included forecasting future traffic for the city’s western growth area covering over 30,000 acres and 331 intersections. Both studies included forecasting a.m. and p.m. peak-hour traffic volumes based upon a variety of different land use scenarios. The tool developed took goegraphic information system (GIS)-based parcel and roadway information, converted the data into a graphical spreadsheet tool, allowed the user to conduct trip generation, distribution, and assignment, and then to automatically convert the data into a Synchro roadway network which allows for capacity analysis and visualization. The operational delay outputs were converted back into a GIS thematic format for contrast and further scenario planning. This project has laid the groundwork for improving both planning and civil transportation decision making at the sub-regional, super-project level.
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
The IDPH Public Health Tracking Program is an excellent way to collect data related to various indicators for Iowans, but those looking for national statistics or data from other states may want to check out the Health Indicators Warehouse (healthindicators.gov). Run and maintained by the CDC’s National Center for Health Statistics, this site is a centralized source for national, state, and county data for a wide variety of indicators. The data is available to the public, and can be accessed either through the tables and charts directly on the website, or indicators can be downloaded to use in a spreadsheet. Once on the site, users are able to search for their desired data either by topic or geographic region. Filters can then be applied to the chosen field to narrow down the user’s search and obtain the preferred statistics. In addition, users are also able to search for indicators derived from state and federal health indicator initiatives: County Health Rankings, Community Health Status Indicators, Healthy People 2020, and CMS Community Indicators. The warehouse provides an overview of each indicator after the user has made their selection. This overview includes information on how the data was calculated and what characteristics are being represented. For example, percent of binge drinking adults is prefaced in the overview that data was based on the question: “Considering all types of alcoholic beverages, how many times during the past 30 days did you have [5 for men, 4 for women] or more drinks on an occasion?" Data is viewable either in the basic table format, chart format, or for some indicators it is possible to view it in terms of a national map. The Health Indicators Warehouse updates indicators as data becomes available, but the collection of years varies amongst the indicators. Nonetheless, this site is a useful resource to anyone looking for comparative indicators throughout the nation or is interested in one of the hundreds of indicators housed by the site. For more information or to check out what the warehouse has to offer visit: http://healthindicators.gov/
Resumo:
Multiplan spreadsheet solutions were developed for a set of hydraulic and highway engineering computations of common interest to county engineers. These include earthwork, vertical and horizontal curves, staking superelevated curves and sign inventories for highways. The hydraulic applications were ditch flow, runoff, culvert size and stage discharge.
Resumo:
This report contains an evaluation and design manual for strengthening and replacing low volume steel stringer and timber stringer bridges. An advisory panel consisting of county and municipal engineers provided direction for the development of the manual. NBI bridge data, along with results from questionnaires sent to county and municipal engineers were used to formulate the manual. Types of structures shown to have the greatest need for cost-effective strengthening methods are steel stringer and timber stringer bridges. Procedures for strengthening these two types of structures have been developed. Various types of replacement bridges have also been included so that the most cost effective solution for a deficient bridge may be obtained. The key results of this study is an extensive compilation, which can be used by county engineers, of the most effective techniques for strengthening deficient existing bridges. The replacement bridge types included have been used in numerous low volume applications in surrounding states, as well as in Iowa. An economic analysis for determining the cost-effectiveness of the various strengthening methods and replacement bridges is also an important part of the manual. Microcomputer spreadsheet software for several of the strengthening methods, types of replacement bridges and for the economic analysis has been developed, documented and presented in the manual. So the manual, Chp. 3 of the final report, can be easily located, blue divider pages have been inserted to delineate the manual from the rest of the report.
