McCordy Company provided information on the following three overhead activities:

Activity	Driver	Fixed Cost	Variable Rate
Maintenance	Machine hours	$75,000	$1.50
Power	Machine hours	20,000	$2.05
Setting up	Setups	-	$1,500

McCordy has found that the following driver levels are associated with two different levels of production:

Driver	30,000 units	70,000 units
Machine hours	50,000	95,000
Setups	25	65

Required: Prepare an activity-based flexible budget. If required, round the variable rates to two decimal places. If an amount box does not require an entry, leave it blank or enter "0".

McCordy Company
Flexible Budge
			Required for 30,000 units	Required for 70,000 units
	Fixed Cost	Variable Rate	50,000 mhrs.	95,000 mhrs.
Maintenance	$	$
Power		$
		$
	Fixed Cost	Variable Rate	25 setups	65 setups
Setting up	$	$	$	$
Total