70.2K

Verified Solution

Link Copied!

WHAT IF ANALYSIS DATA (2ND Excel File): CHECK FIGURES: Revenue and Spending Variance for Net Operating Income is $2,457.75 Favorable. Activity Variance for Net Operating Income is $2,339.25 Unfavorable In August, the restaurant budgeted for 2,150 pizzas at an average selling price of $19.00 per pizza, and 220 deliveries. Data concerning the restaurant's actual results for August 2023 were as follows: Actual Results Revenue Ingredients Kitchen Staff Utilities Delivery Person Delivery Vehicle Equipment Depreciation Rent Miscellaneous Pizzas Sold 1,975 Deliveries Made 180 $ 41,012.00 $ 9,057.00 $ 6,520.00 1,217.00 $ 621.00 $ 1,107.00 $ 560.00 $ 2,270.00 $ 1,345.00 REQUIRED: Prepare Flexible Budget Performance Report that show both revenue and spending variances as well as activity variances - variances between the planning budget and the flexible budget. The cost formulas for August are the same as they were for July. You must include unfavorable or favorable indicators (U or F) for each line item and they must be created using a nested IF statement. Your spreadsheets should automatically recalculate using the new data. You should not have to change any of the cell references or formulas for your statements. (If you do then you have done the cell referencing incorrectly.) You are only changing the Data Block page.

WHAT IF ANALYSIS DATA ( 2ND Excel File): CHECK FIGURES: Revenue and Spending Variance for Net Operating Income is $2,457.75 Favorable. Activity Variance for Net Operating Income is $2,339.25 Unfavorable In August, the restaurant budgeted for 2,150 pizzas at an average selling price of $19.00 per pizza, and 220 deliveries. Data concerning the restaurant's actual results for August 2023 were as follows: Pizzas Sold 1,975 Deliveries Made 180 REQUIRED: Prepare Flexible Budget Performance Report that show both revenue and spending variances as well as activity variances - variances between the planning budget and the flexible budget. The cost formulas for August are the same as they were for July. You must include unfavorable or favorable indicators ( U or F ) for each line item and they must be created using a nested IF statement. Your spreadsheets should automatically recalculate using the new data. You should not have to change any of the cell references or formulas for your statements. (If you do-then you have done the cell referencing incorrectly.) You are only changing the Data Block page

Answer & Explanation Solved by verified expert

See Answer