Case 9-25 (Algo) Critiquing a Report; Calculating Spending Variances [LO9-3, LO9-5] Boyne University offers an extensive continuing education program in many cities throughout the state. For the convenience of its faculty and administrative staff and to save costs, the university operates a motor pool. The motor pool's monthly planning budget is based on operating 21 vehicles; however, for the month of March the university purchased one additional vehicle. The motor pool furnishes gasoline, oil, and other supplies for its automobiles. A mechanic does routine maintenance and minor repairs. Major repairs are performed at a nearby commercial garage. The following cost control report shows actual operating costs for March of the current year compared to the planning budget for March. Miles Autos Gasoline Boyne University Motor Pool Cost Control Report For the Month Ended March 31 Oil, minor repairs, parts Outside repairs Insurance Salaries and benefits Vehicle depreciation Total March Actual 56,700 22 $ 10,220 4,230 765 1,465 8,610 4,158 $ 29,448 Planning Budget 48,700 21 $ 9,253 3,896 588 1,344 8,610 3,969 $ 27,660 (Over) Under Budget The planning budget was based on the following assumptions: a. $0.19 per mile for gasoline. o. $0.08 per mile for oil, minor repairs, and parts. c. $28 per automobile per month for outside repairs. d. $64 per automobile per month for insurance. e. $8,610 per month for salaries and benefits. f. $189 per automobile per month for depreciation. $ (967) (334) (177) (121) 0 (189) $ (1,788) The supervisor of the motor pool is unhappy with the report, claiming it paints an unfair picture of the motor pool's performance.
Case 9-25 (Algo) Critiquing a Report; Calculating Spending Variances [LO9-3, LO9-5] Boyne University offers an extensive continuing education program in many cities throughout the state. For the convenience of its faculty and administrative staff and to save costs, the university operates a motor pool. The motor pool's monthly planning budget is based on operating 21 vehicles; however, for the month of March the university purchased one additional vehicle. The motor pool furnishes gasoline, oil, and other supplies for its automobiles. A mechanic does routine maintenance and minor repairs. Major repairs are performed at a nearby commercial garage. The following cost control report shows actual operating costs for March of the current year compared to the planning budget for March. Miles Autos Gasoline Boyne University Motor Pool Cost Control Report For the Month Ended March 31 Oil, minor repairs, parts Outside repairs Insurance Salaries and benefits Vehicle depreciation Total March Actual 56,700 22 $ 10,220 4,230 765 1,465 8,610 4,158 $ 29,448 Planning Budget 48,700 21 $ 9,253 3,896 588 1,344 8,610 3,969 $ 27,660 (Over) Under Budget The planning budget was based on the following assumptions: a. $0.19 per mile for gasoline. o. $0.08 per mile for oil, minor repairs, and parts. c. $28 per automobile per month for outside repairs. d. $64 per automobile per month for insurance. e. $8,610 per month for salaries and benefits. f. $189 per automobile per month for depreciation. $ (967) (334) (177) (121) 0 (189) $ (1,788) The supervisor of the motor pool is unhappy with the report, claiming it paints an unfair picture of the motor pool's performance.
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter11: Linear Optimization Models
Section: Chapter Questions
Problem 9P: The Westchester Chamber of Commerce periodically sponsors public service seminars and programs....
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
![Case 9-25 (Algo) Critiquing a Report; Calculating Spending Variances [LO9-3, LO9-5]
Boyne University offers an extensive continuing education program in many cities throughout the state. For the convenience of its
faculty and administrative staff and to save costs, the university operates a motor pool. The motor pool's monthly planning budget is
based on operating 21 vehicles; however, for the month of March the university purchased one additional vehicle. The motor pool
furnishes gasoline, oil, and other supplies for its automobiles. A mechanic does routine maintenance and minor repairs. Major repairs
are performed at a nearby commercial garage.
The following cost control report shows actual operating costs for March of the current year compared to the planning budget for
March.
Miles
Autos
Gasoline
Boyne University Motor Pool
Cost Control Report
For the Month Ended March 31
Oil, minor repairs, parts
Outside repairs
Insurance
Salaries and benefits
Vehicle depreciation
Total
March Actual
56,700
22
$ 10,220
4,230
765
1,465
8,610
4,158
$ 29,448
Gasoline
Oil, minor repairs, parts
Outside repairs
Insurance
Salaries and benefits
Vehicle depreciation
Total
Planning (Over) Under
Budget
Budget
48,700
The planning budget was based on the following assumptions:
d. $64 per automobile per month for insurance.
e. $8,610 per month for salaries and benefits.
f. $189 per automobile per month for depreciation.
21
$ 9,253
3,896
588
1,344
8,610
3,969
$ 27,660
a. $0.19 per mile for gasoline.
b. $0.08 per mile for oil, minor repairs, and parts.
c. $28 per automobile per month for outside repairs.
Boyne University Motor Pool
Spending Variances
For the Month Ended March 31
The supervisor of the motor pool is unhappy with the report, claiming it paints an unfair picture of the motor pool's performance.
Required:
1. Calculate the spending variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for
unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
$ (967)
(334)
(177)
(121)
0
(189)
$ (1,788)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F37090eef-025f-4619-bebd-91b936ece1eb%2F5a952466-8af8-46a1-9b8c-4e946197bb75%2Fwg9szn7_processed.png&w=3840&q=75)
Transcribed Image Text:Case 9-25 (Algo) Critiquing a Report; Calculating Spending Variances [LO9-3, LO9-5]
Boyne University offers an extensive continuing education program in many cities throughout the state. For the convenience of its
faculty and administrative staff and to save costs, the university operates a motor pool. The motor pool's monthly planning budget is
based on operating 21 vehicles; however, for the month of March the university purchased one additional vehicle. The motor pool
furnishes gasoline, oil, and other supplies for its automobiles. A mechanic does routine maintenance and minor repairs. Major repairs
are performed at a nearby commercial garage.
The following cost control report shows actual operating costs for March of the current year compared to the planning budget for
March.
Miles
Autos
Gasoline
Boyne University Motor Pool
Cost Control Report
For the Month Ended March 31
Oil, minor repairs, parts
Outside repairs
Insurance
Salaries and benefits
Vehicle depreciation
Total
March Actual
56,700
22
$ 10,220
4,230
765
1,465
8,610
4,158
$ 29,448
Gasoline
Oil, minor repairs, parts
Outside repairs
Insurance
Salaries and benefits
Vehicle depreciation
Total
Planning (Over) Under
Budget
Budget
48,700
The planning budget was based on the following assumptions:
d. $64 per automobile per month for insurance.
e. $8,610 per month for salaries and benefits.
f. $189 per automobile per month for depreciation.
21
$ 9,253
3,896
588
1,344
8,610
3,969
$ 27,660
a. $0.19 per mile for gasoline.
b. $0.08 per mile for oil, minor repairs, and parts.
c. $28 per automobile per month for outside repairs.
Boyne University Motor Pool
Spending Variances
For the Month Ended March 31
The supervisor of the motor pool is unhappy with the report, claiming it paints an unfair picture of the motor pool's performance.
Required:
1. Calculate the spending variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for
unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
$ (967)
(334)
(177)
(121)
0
(189)
$ (1,788)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning