Question
Referring to the following data: AUTOLAV INC Flexible Budget Monthly activity (cars washed) Per car 7,000 8,000 9,000 Sales 10 70,000 $80,000 90,000 Variable Expenses:
Referring to the following data:
AUTOLAV INC Flexible Budget | ||||
Monthly activity (cars washed) | ||||
Per car | 7,000 | 8,000 | 9,000 | |
Sales | 10 | 70,000 | $80,000 | 90,000 |
Variable Expenses: | ||||
Cleaning Supplies | 0.75 | 5,250 | 6,000 | 6,750 |
Utilities | 0.60 | 4,200 | 4,800 | 5,400 |
Maintenance | 0.15 | 1,050 | 1,200 | 1,350 |
Total variable expenses | 1.50 | 10,500 | 12,000 | 13,500 |
Contribution margin | 8.50 | 59,500 | 68,000 | 76,500 |
Fixed Expenses: | ||||
Operator Wages | 10,000 | 10,000 | 10,000 | |
Depreciation | 20,000 | 20,000 | 20,000 | |
Rent | 8,000 | 8,000 | 8,000 | |
Insurance | 1,000 | 1,000 | 1,000 | |
Selling and Administrative | 4,000 | 4,000 | 4,000 | |
Total fixed expenses | 43,000 | 43,000 | 43,000 | |
Operating income | 16,500 | 25,000 | 33,500 |
AutoLav Incs actual level of activity was 7,800 cars. The actual revenues and expenses for August are given below:
Actual Data for 7,800 cars | |
Sales | 78,000 |
Variable Expenses: | |
Cleaning Supplies | 5,725 |
Utilities | 4,795 |
Maintenance | 1,400 |
Fixed Expenses: | |
Operator Wages | 10,270 |
Depreciation | 20,100 |
Rent | 8,000 |
Insurance | 1,090 |
Selling and Administrative | 3,750 |
Prepare a flexible budget performance report for August.
Prepare a comprehensive performance report for August. Assume that the static budget for August was based on an activity level of 8,000 cars.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started