Please show formulas so that I am able to answer the questions for myself. Excel would be awesome! Thanks in advance! :)

The budgeted prices for materials and direct labor per unit of finished product are $9 and $4 respectively. The prodcution manager is happy about the following data:

	Static Budget	Actual Costs	Variance
Direct Materials	65700	54000	11,700 F
Direct Labor	29200	23100	6100 F

1.

Is the manager's happiness justified? Prepare a report that might provide a more detailed explanation of why the static budget was not achieved. Good output was 5,200 units. (Enter all amounts as positive numbers. For variances with a zero balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label.)

	Actual Cost	Flexible Budget Variance	Flexible Budget	Activity Variance	Static Budget
Units of Product
Direct Materials
Direct Labor
Total