Purchase Solution

Farrar University: performance report spending variances

Not what you're looking for?

Ask Custom Question

Farrar 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 operated with 20 vehicles until February, when an additional automobile was acquired at the request of the university administration. 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. Each year, the supervisor of the motor pool prepares an annual budget, which is reviewed by the university and approved after suitable modifications.
The following cost control report shows actual operating costs for March of the current year compared to one- twelfth of the annual budget.
Farrar University Motor Pool
Cost Control Report
For the Month Ended March 31

Annual Monthly Budget ( 1/ 12 March (Over) Under
Budget of Annual Budget) Actual Budget

Miles . . . . . . . . . . . . . . . . . 600,000 50,000 58,000
Autos. . . . . . . . . . . . . . . . . 20 20 21
Gasoline . . . . . . . . . . . . . . $ 96,000 $ 8,000 $ 8,970 $ ( 970)
Oil, minor repairs, parts . 30,000 2,500 2,840 (340) Outside repairs . . . . . . . . . . 9,600 800 980 (180) Insurance . . . . . . . . . . . . . . 18,000 1,500 1,625 (125) Salaries and benefits . . . . 103,320 8,610 8,610 0 Vehicle depreciation . . . . . 48,000 4,000 4,200 (200) Total . . . . . . . . . . . . . . . . $ 304,920 $ 25,410 $ 27,225 $( 1,815)

The annual budget was based on the following assumptions:
a. $ 0.16 per mile for gasoline.
b. $ 0.05 per mile for oil, minor repairs, and parts.
c. $ 480 per automobile per year for outside repairs.
d. $ 900 per automobile per year for insurance.
e. $ 8,610 per month for salaries and benefits.
f. $ 2,400 per automobile per year for depreciation.

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. Prepare a new performance report for March based on a flexible budget that shows spending variances.

2. What are the deficiencies in the original cost control report? How does the report that you prepared in part (1) above overcome these deficiencies?

Attachments
Purchase this Solution

Solution Summary

Your tutorial contains a new report and two short paragraphs of instruction about what the deficiencies were and how they were fixed. Click in cells to see computations.

Solution Preview

See attached for report.

1. The above report is a better picture of what the motor pool supervisor's performance for March. Why? It should an accurate number of vehicles and the actual miles driven. Given the actual activity, rather than the ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Operations Management

This quiz tests a student's knowledge about Operations Management

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.