Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write the formulas im not sure how to do them plz CHECK FIGURES: Revenue and Spending Variance for Net Operating Income is $2,457.75 Favorable. Activity
write the formulas im not sure how to do them plz
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: Pinas 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started