need help with flexible budget problem

BudgetProject.xlsx

Information

Midwest Veterinary Clinic & Hotel
The static budget was based on the following.
		Static
	Actual	Budget
Average animal fee	27.5	33
Annual unit sales	3200	4000
Variable cost per animal
Feed	5.25	3.00
Veterinary Fees	4.25	4.00
Labor	3.50	2.00
Supplies	0.85	1.00

Fixed Costs - See Static Budget Tab
Flexible Budget Tab requirements
1. Prepare a flexible budet and variance analysis based on the data provided.
If applicable, list assumptions via row 38.
Questions Tab requirements
1. Answer the questions incorporated therein.

Midwest Veterinary Clinic & Hotel
Static Budget
		Static		Favorable/
	Actual	Budget	Variance	(Unfavorable)
Sales	88,000	132,000	(44,000)	Unfavorable
Less: Variable Expenses
Feed	16,800	12,000	4,800	Unfavorable
Veterinary Fees	13,600	16,000	(2,400)	Favorable
Labor	11,200	8,000	3,200	Unfavorable
Supplies	2,720	4,000	(1,280)	Favorable
Total Variable Expenses	44,320	40,000	4,320	Unfavorable
Contribution Margin	43,680	92,000	(48,320)	Unfavorable
Less: Fixed Expense
Depreciation	500	500	- 0	Favorable
Interest & Penalties	300	300	- 0	Favorable
Insurance	7,500	7,500	- 0	Favorable
Rent	8,500	8,500	- 0	Favorable
Advertisement	7,500	4,200	3,300	Unfavorable
Repairs & Maintenance	4,625	2,750	1,875	Unfavorable
Entertainment	3,500	3,650	(150)	Favorable
SG&A	1,750	1,500	250	Unfavorable
Utilities	3,760	4,200	(440)	Favorable
Taxes	10,500	7,800	2,700	Unfavorable
Total Fixed Expense	48,435	40,900	7,535	Unfavorable
Net Income (Loss)	(4,755)	51,100	(55,855)	Unfavorable

Midwest Veterinary Clinic & Hotel
Flexible Budget
		Flexible		Favorable/
	Actual	Budget	Variance	(Unfavorable)
Sales
Less: Variable Expenses
Feed
Veterinary Fees
Labor
Supplies
Total Variable Expenses
Contribution Margin
Less: Fixed Expense
Depreciation
Interest & Penalties
Insurance
Rent
Advertisement
Repairs & Maintenance
Entertainment
SG&A
Utilities
Taxes
Total Fixed Expense
Net Income (Loss)
Assumptions: