PLEASE Review Problem: Variance Analysis Using a Flexible Budget Fixed Cost Data Revenue Cost of inventory Wages and salaries Utilities Insurance Rent Miscellaneous Revenue & Cost Per Door $878.75 $536.35 $95.00 $2.05 $3.65 Revenue & Cost Per Window $601.00 $293.00 $67.00 $1.30 $1.70 $30,614 $3,194 $3,972 $7,222 $1,833 $45.00 $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 155 Actual unit activity Planning budget unit activity Windows Sold 275 298 140 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 Flexible Budget Actual Results U/F U/F Doors Sold Windows Sold U/F U/F U/F U/F U/F 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/F U/F U/F