The Alpine Manufacturing Co. offers the following information in relation to manufacturing for the month of April. The planned hours for April were 1,000 hours and the actual hours totalled 1,100.

Item	Budget	Actual	Variance
Raw Material	$80,000	$90,000	($10,000)
Direct Labour	24,000	25,000	($1,000)
Variable Factory overhead	30,000	32,000	($2,000)
Fixed Factory overhead	30,000	32,000	($2,000)
Total cost of production	164,000	179,000	($15,000)

Assume that raw materials, direct labour and variable overhead will increase proportionally with the increase in factory activity. The actual fixed factory overhead increased as a result of the need to rent additional storage this was not anticipated in the budget.

Required

How do I prepare a Flexible Budget and Variance Report for the Month of April using the format below

		Hours
Budgeted Hours		1,000
Actual Hours		1,100
Increase		110%
Item	Budget	Actual	Flexible Budget	Variance	F or U
Raw Material
Direct Labour
Variable Factory overhead
Fixed Factory overhead
Total cost of production