Please Show All Calculations! Thank You!

Review Problem: Variance Analysis Using a Flexible Budget Data Revenue Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous Revenue & Cost Fixed Cost Per Door $878.75 $536.35 $30,614 $95.00 $3,194 $2.05 $3,972 $3.65 $7,222 $1,833 $45.00 Revenue & Cost Per Window $601.00 $293.00 $67.00 $1.30 $1.70 $37.00 Actual results: Revenue Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous $299,075 $157,618 $67,588 $2,153 $5,665 $7,222 $17,963 Doors Sold Actual unit activity Planning budget unit activity 155 140 Windows Sold 275 298 Enter a formula into each of the cells marked with a ? below Must enter an IF Statement for the U/F selection; can be different between revenue and expenses but same IF statement must be used for entire column of expenses. Construct a flexible budget performance report Revenue and Spending Variances Planning Budget Activity Variances U/F Flexible Budget Actual Results U/F Doors Sold Windows Sold U/F ? U/F Revenue Expenses: Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous Total expenses Net operating income U/F U/F U/F U/F ? U/F U/F U/F U/F U/E U/F U/F U/F U/F U/F U/F ? U/F