The City of Lansing is located in the Midwest United States. The director of public works...
Fantastic news! We've Found the answer you've been seeking!
Question:
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64cb3c0b60912_1691040779071.jpg)
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64cb3c17da86b_1691040790320.jpg)
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/08/64cb3c2749211_1691040807118.jpg)
Transcribed Image Text:
The City of Lansing is located in the Midwest United States. The director of public works has prepared a budget for each department for the current fiscal year, and has computed quarterly budgets as one-fourth of each department's annual budget. To prepare the budgets, he analyzed the prior three years' costs, and had learned that almost all of them had increased each year, with more rapid increases in the last two years. To encourage department heads to reduce operating costs, he developed the current year's budget based on the prior year's costs less 3 percent. For the snow removal department, he also estimated the cubic miles of snow to be removed, which he set at an average of the past years. Mike Ross, the head of the snow removal department for the City of Lansing, received an email from the director along with Exhibit 1. Mike, your report indicates that several of your costs are significantly above your quarterly budget. You need to pay particular attention to the salaries of your snowplow drivers. Please get back to me by the end of next week with a plan for making the needed reductions. Mike knew he needed a plan, yet midwinter was the busiest time of the year for snow removal, and a big storm had been predicted for the weekend. He reflected on the content of Exhibit 1: Some of my costs don't change, even if there's a change in the cubic miles of snow we plow. On the other hand, drivers, supplies, fuel, and maintenance vary almost directly with changes in cubic miles. Shouldn't my budget reflect this distinction? Also, my budget didn't include my October salary increase-was I supposed to refuse it to help keep my budget in balance? Finally, I think it is important to note that I had to pay overtime to the drivers because of some very heavy storms we had back in mid-December. Because of this, my average hourly rate for the whole three months was $21 instead of the $18 that was in my budget. In fact, and maybe this is a little picky, the average number of minutes it took my drivers to plow a cubic mile of snow during the quarter actually dropped from 48, which was my budget target, to 47. Somehow, even though it's pretty small, I think this improvement should be taken into consideration. Exhibit 1. Performance report-Snow removal department October-December Snow days (a) Cubic miles of snow (b) Budget 10 1,250 Actual (Over) Under Budget % (Over) Under Budget (2) (20) (250) (20) 12 1,500 Costs Drivers (c) Supplies (d) Fuel Maintenance (e) Supervisor's salary Equipment depreciation (¹) Total 18,000 1,125 1,750 1,375 15,000 1,250 38,500 24,675 1,875 2,500 2,200 18,000 1,250 50,500 (6,675) (750) (750) (825) (3,000) (12,000) (37) (67) (43) (60) (20) 0 (31) (a) Days when there was at least one inch of snow. (b) Computed, for each storm, by multiplying the depth of snowfall (according to the official measure by the town clerk) by the miles of roadways to be plowed. (c) Drivers were paid hourly, not by the mile. The number of hours needed to clear the roadways depend to a great extent on cubic miles of snow. For example, an inch of snow from a relatively light storm would take less time to plow, than six inches of snow from a moderate storm. When a driver worked more than 8 hours in a 24-hour period, he/she was paid an overtime premium for the additional hours. (d) Mainly sand and salt. Office and other administrative supplies were not included. (e) was almost directly related to miles driven. Thus, a 24 hour storm, requiring several passes, would lead to more maintenance costs than a storm of only a few hours. (1) Exclusively for the snow plows. The department had no other sets to be depreciated. Requirements 1. What is your assessment of the method the public works director used to construct the budget? Identify and explain your concerns. No calculations are required. (4 marks) 2. Prepare a flexible budget for the snow plowing department. What does it tell you about the performance of the snow plowing department? Calculation should be rounded to two decimal places. (7 marks) 3. Compute the appropriate variances for cost of drivers. What do the analyses tell you in addition to requirement 2? Calculation should be rounded to two decimal places. (6 marks) 4. What plan should Mr. Ross present to the public works director for making cost reductions? No calculations are required. (3 marks) The City of Lansing is located in the Midwest United States. The director of public works has prepared a budget for each department for the current fiscal year, and has computed quarterly budgets as one-fourth of each department's annual budget. To prepare the budgets, he analyzed the prior three years' costs, and had learned that almost all of them had increased each year, with more rapid increases in the last two years. To encourage department heads to reduce operating costs, he developed the current year's budget based on the prior year's costs less 3 percent. For the snow removal department, he also estimated the cubic miles of snow to be removed, which he set at an average of the past years. Mike Ross, the head of the snow removal department for the City of Lansing, received an email from the director along with Exhibit 1. Mike, your report indicates that several of your costs are significantly above your quarterly budget. You need to pay particular attention to the salaries of your snowplow drivers. Please get back to me by the end of next week with a plan for making the needed reductions. Mike knew he needed a plan, yet midwinter was the busiest time of the year for snow removal, and a big storm had been predicted for the weekend. He reflected on the content of Exhibit 1: Some of my costs don't change, even if there's a change in the cubic miles of snow we plow. On the other hand, drivers, supplies, fuel, and maintenance vary almost directly with changes in cubic miles. Shouldn't my budget reflect this distinction? Also, my budget didn't include my October salary increase-was I supposed to refuse it to help keep my budget in balance? Finally, I think it is important to note that I had to pay overtime to the drivers because of some very heavy storms we had back in mid-December. Because of this, my average hourly rate for the whole three months was $21 instead of the $18 that was in my budget. In fact, and maybe this is a little picky, the average number of minutes it took my drivers to plow a cubic mile of snow during the quarter actually dropped from 48, which was my budget target, to 47. Somehow, even though it's pretty small, I think this improvement should be taken into consideration. Exhibit 1. Performance report-Snow removal department October-December Snow days (a) Cubic miles of snow (b) Budget 10 1,250 Actual (Over) Under Budget % (Over) Under Budget (2) (20) (250) (20) 12 1,500 Costs Drivers (c) Supplies (d) Fuel Maintenance (e) Supervisor's salary Equipment depreciation (¹) Total 18,000 1,125 1,750 1,375 15,000 1,250 38,500 24,675 1,875 2,500 2,200 18,000 1,250 50,500 (6,675) (750) (750) (825) (3,000) (12,000) (37) (67) (43) (60) (20) 0 (31) (a) Days when there was at least one inch of snow. (b) Computed, for each storm, by multiplying the depth of snowfall (according to the official measure by the town clerk) by the miles of roadways to be plowed. (c) Drivers were paid hourly, not by the mile. The number of hours needed to clear the roadways depend to a great extent on cubic miles of snow. For example, an inch of snow from a relatively light storm would take less time to plow, than six inches of snow from a moderate storm. When a driver worked more than 8 hours in a 24-hour period, he/she was paid an overtime premium for the additional hours. (d) Mainly sand and salt. Office and other administrative supplies were not included. (e) was almost directly related to miles driven. Thus, a 24 hour storm, requiring several passes, would lead to more maintenance costs than a storm of only a few hours. (1) Exclusively for the snow plows. The department had no other sets to be depreciated. Requirements 1. What is your assessment of the method the public works director used to construct the budget? Identify and explain your concerns. No calculations are required. (4 marks) 2. Prepare a flexible budget for the snow plowing department. What does it tell you about the performance of the snow plowing department? Calculation should be rounded to two decimal places. (7 marks) 3. Compute the appropriate variances for cost of drivers. What do the analyses tell you in addition to requirement 2? Calculation should be rounded to two decimal places. (6 marks) 4. What plan should Mr. Ross present to the public works director for making cost reductions? No calculations are required. (3 marks)
Expert Answer:
Answer rating: 100% (QA)
1 Assessment of the budget construction method The public works directors method of constructing the budget seems flawed in several aspects a Using prior years costs less 3 percent The director applie... View the full answer
Related Book For
Accounting for Governmental and Nonprofit Entities
ISBN: ?978-0073379609
15th Edition
Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
What is the future value at the end of the 20th semester of an annuity due with 20 semiannual payments of $500 each, evaluated at an annual interest rate of 10%?
-
Presented here are an incomplete income statement and balance sheet for Schwenke Corporation. Additional information: 1. The gross profit margin is 40%. 2. The income tax rate is 20%. 3. The...
-
In a press release dated April 23, 2005, Canadian Natural Resources Limited (CNRL) reported a loss of $ 679 million from cash flow hedges of its future crude oil and natural gas production, for the...
-
The Weiss Chemical Corporation plans to build or lease a new plant that will produce liquid fertilizer for the agricultural market. The plant is expected to cost $800,000,000 and will be located in...
-
Grid Iron Prep Inc. (GIPI) is a service business incorporated in January of the current year to provide personal training for athletes aspiring to play college football. The following transactions...
-
Suppose panama is a "small country"in the world market for corn. the following graph shows the demand and supply curves for the panamanian domestic market for corn. The world price is $125 per ton of...
-
You recently received the following e-mail from a client and friend: Hey Great Student, I cannot believe it is almost year end! Only a few days before its 2019. As you recall, I was lucky enough to...
-
Convert the polar equation to rectangular form and sketch its graph. \f
-
A construction company needs to borrow $340 comma 000 for a new job. They decide to borrow the funds at 14% for 150 days. In 1980, the same note would have been at a rate of 23%. Find the difference...
-
Exercise 4 - 8. PAYROLL PROCEDURES. NN Company operates on a 6-day week, with time and one-quarter for all hours over eight during the regular days. The time cards for the week ending November 30...
-
Use the ratios below to answer the following questions. You must support and be sure to consider all relevant ratios. A B Return on assets (%) 7.4% 13.9% 12.8% Profit margin (%) 8.2% 5.3% 13.3% Gross...
-
PRINCIPLE OF FINANCE MicroSun Computer Berhad (MSCB) is one of the well-known computer manufacturers in town. With good expertise, it is expected that the latest model of MSCB computer will be...
-
An 100.0-kg dresser is pushed up a 35.0 ramp with an applied force of 1000. N. The coefficient of friction is 0.250. What is the acceleration of the dresser
-
Measurement approaches and the accounting standards Fair value-realisable or settlement value: Fair value: the price that would be received to sell an asset or paid to transfer a liability in an...
-
QUESTION 9 HC-O-C-R R-C-O-CH HC-O-P-O-CH-CH-NH3* O || O a. Phosphatidic acid, Serine O b. Lysophosphatidic acid, Serine, Free FA O c. Lysophosphatidylserine, Free FA O d. 2 Free FAs, Serine, Glycerol...
-
Multiple Choice. Choose the best answer. Items 1 through 3 relate to the following information. The county administers a tax agency fund that collects taxes on behalf of the county city, and a...
-
Multiple Choice. Choose the best answer. 1. Which of the following activities would always indicate that an auditors independence has been impaired? a. Providing advice on establishing an internal...
-
Single Audit. Quad-States Community Service Agency expended federal awards during the most recent fiscal year in the following amounts for the pro- grains shown: Additional information indicates that...
-
Use of means and standard deviations Kosh Tour Travel Agency uses two 70-passenger buses for its organized tours. Daily revenues vary considerably on the Devil's Hole tour and appear to be much more...
-
Using the mean and standard deviation Willmar Company produces a variety of food products. Its 16 oz. bottles of concentrated black cherry juice cost $8.00 to produce and sell for $12 each. Sales are...
-
Estimation of mean by sampling Jupiter Corporation collects daily information on the number of differential assemblies produced by its employees. The following data have been collected during the...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App