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:
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%?
-
What is the effect of multinational operations on capital budgeting decisions. Discuss.
-
1. What form of departmentalization has Nokia relied on throughout most of the past three decades? Why have these forms of departmentalization been adopted? 2. Evaluate Nokias changing organizational...
-
The wiring in the wall of your house to and from an outlet \(\mathbb{N T}\) has a total resistance of typically \(0.10 \Omega\). Suppose a device plugged into a \(120 \mathrm{~V}\) outlet draws...
-
Steve and Sue are married with three dependent children. Their 2014 joint income tax return shows $390,000 of AGI and $60,000 of itemized deductions made up of $30,000 of state income taxes and...
-
Harris Company manufactures and sells a single product. A partially completed schedule of the company's total costs and costs per unit over the relevant range of 64,000 to 104,000 units is given...
-
The following diagram represents a high-temperature reaction between CH4 and H2O. Based on this reaction, how many moles of each product can be obtained starting with 4.0 mol CH4?
-
Generally speaking, what are some of the causes of psychopathology according to three of the different theoretical perspectives (including psychodynamic, biological, psychological, and sociocultural...
-
A DC motor and a speed reducer transmission needs to be designed to power a hip joint of a robot as shown below. You are asked to choose the right DC motor for this robot to support the motion of the...
-
Explain 3 factors which might limit the effectiveness of Fiscal policy in controlling the AD of a country.
-
Suppose the price of gasoline decreases from $4.10 to $3.00, and in response quantity demanded increases from 10700 to 11600. Using the mid-point formula, what is the price elasticity of demand?...
-
Explain why the convexity of the indifference curve is a different concept from diminishing marginal utility.
-
What are some examples of real-world microeconomics issues, for households and individuals?
-
Write a set of functions and design requirements for a hydraulic jack used for car repair and a conveyor to elevate and load gravel into a truck.
-
Assume that a trial balance is prepared with an account balance of $21,360 listed as $21,630 and an account balance of $1,500 listed as $15,000. Identify the transposition and the slide.
-
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...
-
In the cooling tower of Example 8.7, to what temperature would the water be cooled if, after the tower was built and operated at the design water and air rates, the air entered at a dry-bulb...
-
Water is to be cooled at the rate of \(10 \mathrm{~kg} / \mathrm{s}\) from \(317 \mathrm{~K}\) to \(300 \mathrm{~K}\) in a countercurrent cooling tower under conditions such that \(H_{t O G}=2.5...
-
Modify the Mathcad program developed in Problem 3.16 to estimate the minimum gas flow rate in strippers so that it can be used to estimate the minimum air flow required for water cooling. Test your...
Study smarter with the SolutionInn App