Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need calculations of cell name-cell name not just numerical answer in each cell. 1 Performance Evaluation Complete a master budget performance report A hypothetical partial
Need calculations of cell name-cell name not just numerical answer in each cell.
1 Performance Evaluation Complete a master budget performance report A hypothetical partial master budget performance report for New England Fudge Company has been provided on 4 the ENTERANSWERS tab. Use the blue shaded areas on the ENTE RANSWERS tab for inputs. 7 Always use cell references and formulas where appropriate to receive full credit 9 Requirement 10 Fill in the missing amounts in the table. Be sure to indicate whether variances are favorable (F) or unfavorable (U). Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances For variances that result in a zero amount, make sure to leave the result (it may show as a "O or"" in the appropriate cell and indicate that these variances are favorable (F) t. 12 C9 1 (Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances. Mar 2 (Always use cell references and formulas where appropriate to receive full credit.) New England Fudge Company Flexible Budget Performance Report: Sales and Operating Expenses For the Year Ended December 31 4 Flexible Budget Variance Flexible Volume Master Actual F/U Budget Variance 9 Sales volume (number of cases sold) 10 11 Sales revenue ($26 per case) 12 Less variable expenses: 13 Sales expense ($2 per case sold 24,500 14 Shipping expense ($5 per case sold) 15 Contribution margin 6 Less fixed expenses: 17 Salaries 18 Office rent 19 Operating income 20 13,200 13,200 12,000 $ 338,200 $343,200 $312,000 65,500 248,200 $ 26,400 66,000 250,800 $ 24,000 60,000 228,000 12,200 3,500 $ 232,500 10,800 3,500 $236,500 10,800 3,500 $213,700Step 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