The Snow City Public Works Department asked you to conduct a variance analysis of its January...

The Snow City Public Works Department asked you to conduct a variance analysis of its January expenditures for snow plowing. The Department expected that there would be about 99 dispatches of snowplow truck during January but found that the Department actually dispatched snowplow trucks 111 times. The budgeted number of packs of salt per truck was 56 but each truck actually used 62 packs of salt per truck. The budgeted cost per pack of salt was $14 but the actual purchase price was $10. Conduct a variance analysis for the BSAS in an Excel file and show flexible budget, Volume and Quantity Adjusted (VQA) budget, actual budget, as well as original budget. Remember that all budgets should provide details on volume, quantity, price, and total budgets. In addition, you should also provide variances associated with volume, quantity, price, and total budgets and show whether they are favorable or unfavorable. Each relevant cell in your Excel file should show accurate formulas. Briefly summarize your findings to report to the director of the Department.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Gloucester Township Department of Public Works, in an effort to encourage use of its public parks...

Gloucester Township Department of Public Works, in an effort to encourage use of its public parks during the summer months, began a campaign to encourage vacationers to use the parks. Studies for the past five years indicate that only one-fourth of all vacationers use the park for three days or more per week. A survey conducted after the new campaign was initiated reveals that 55 of 200 vacationers use the parks three or more days per week. At α =...

This requires you to conduct a one-way analysis of variance. Data are given to you on...

This requires you to conduct a one-way analysis of variance. Data are given to you on the “days on market” for a random sample of homes for sale by realtors using 5 different training programs that the realtors experienced. The 5 programs can be described as: computer-based course, campus training (on-site in a classroom), apprentice (work side-by-side with a mentor), field (solo field training), and self (a self-paced training course with books and coursework at home). Present the null and...

A large city wants to conduct a survey about its public transportation system. The intended population...

A large city wants to conduct a survey about its public transportation system. The intended population is all current residents, regardless of whether or not they use public transportation. Match each scenario below with one of the following sampling methods. A. Convenience Sample B. Cluster Sample C. Simple Random Sample D. Stratified Sample E. Systematic Sample F. Voluntary Response Sample G. None of the above Select an answer Convenience Sample Cluster Sample Simple Random Sample Stratified Sample Systematic Sample Voluntary Response Sample None of the above 1....

A large city wants to conduct a survey about its public transportation system. The intended population...

A large city wants to conduct a survey about its public transportation system. The intended population is all current residents, regardless of whether or not they use public transportation. Match each scenario below with one of the following sampling methods. A. Convenience Sample B. Cluster Sample C. Simple Random Sample D. Stratified Sample E. Systematic Sample F. Voluntary Response Sample G. None of the above 1. Advertise on local television and radio, inviting residents to call a toll-free number and...

Assume you are allocating indirect costs for the purchasing office in the Department of Public Works...

Assume you are allocating indirect costs for the purchasing office in the Department of Public Works to two mission centers, street paving and snow removal. What are two allocation bases (not allocation methods!) that could be used to distribute indirect costs from the director’s office to the mission centers? Which of your two is a better base and why? (6 points)

How frequently do you believe that firms should conduct variance analysis and why?

You are asked by your boss to conduct a life cycle cost analysis and make a...

You are asked by your boss to conduct a life cycle cost analysis and make a decision on a truck purchase. There are two alternatives: (a) Diesel Truck: first cost - $22,000, service life - 4 years, annual operation costs - $5,000, maintenance/repair costs - $1,000 after 2 years and $1,000 after 4 years, salvage value - $12,000; (b) (a) Gas Truck: first cost - $20,000, service life - 4 years, annual operation costs - $6,250, maintenance/repair costs - $1,000...

You are asked to conduct a short-term analysis of the net benefits of a new proposed...

You are asked to conduct a short-term analysis of the net benefits of a new proposed set of regulations designed to improve air quality. Short term means over its first five years. You have three sets of information: i) Firms affected by the regulation have reported that their costs will increase by 150 million dollars each year to meet the new regulatory requirements that are technology based standards (and you can believe them). ii The second set of information is...

A town's department of public works is concerned about adverse public reaction to a sewer project...

A town's department of public works is concerned about adverse public reaction to a sewer project that is currently in progress. Because of this, the Commissioner of Public Works has authorized a weekly survey to be conducted of town residents. Each week, a sample of 100 residents is questioned on their feelings towards the project. The results to date are shown below. Analyze this data using a P-chart with a 5% risk of Type I error (Z=3). Is the community...

The Department of Public Works and Highways (DPWH) is considering the construction of a new highway...

The Department of Public Works and Highways (DPWH) is considering the construction of a new highway through a scenic rural area. The road is expected to cost 60 Million Birr with annual upkeep estimated at 500,000 Birr. The improved accessibility is expected to result in additional income from tourists of 7.5 Million Birr per year. The road is expected to have a useful life of 25 years. If the rate of interest is 15%, should the road be constructed?

Subjects