Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please make sure to read the requirements and when give me the answer please make sure to give explanation Inl 26 70 00 A5 A
please make sure to read the requirements and when give me the answer please make sure to give explanation
Inl 26 70 00 A5 A B E 4 1 Performance Evaluation 2 Relationship between ROI and residual income 3 Data on three unrelated companies are given in the table in the ENTERANSWERS tab. 5 6 Use the blue shaded areas on the ENTERANSWERS tab for inputs, Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instruction 1 tab you will be marked wrong. 8 9 Requirement 10 Fill in the missing information into the table. 11 w TI B D (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 1 Instruction tab you will be marked wrong.) 2 3 Georgeville, Inc. Bayside Company Blue Hat Industries 4 Sales $117,000 $520,000 5 Operating income $35,100 $164,000 6 Total assets $90,000 7 Sales margin 20% 8% 8 Capital turnover 9 Return on investment (ROI) 10 Target rate of return 20% 9% 21% 11 Residual income (RI) 12 $4,160 13 4.10 DIT Generai A4 Xfx A hypothetical partial master budget performance report for New England Fudge % A B W NH Performance Evaluation 2 Complete a master budget performance report D E F G A hypothetical partial master budget performance report for New England Fudge Company has been provided on the 4 ENTERANSWERS tab. 5 6 Use the blue shaded areas on the ENTERANSWERS 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). a Use the ABS function when calculating variances, and use the drop-down selections for For U when 11 describing the variances. b. For variances that result in a zero amount, make sure to leave the result (it may show as a "0" or -") in 12 the appropriate cell and indicate that these variances are favorable (F). 13 C. Paste B U Custom 09 x v fe Conditional Formatting 1 8 c D E G H (Use the ABS function when calculating variances, and use the drop-down selections for For U when describing the variances. Mark any ovariances as "E.) 2 (Always use cell references and formulas where appropriate to receive full credit. ) K 3 4 New England Fudge Company Flexible Budget Performance Report: Sales and Operating Expenses For the Year Ended December 31 Actual Flexible Budget Variance F/U Flexible Budget 13,200 Volume Variance F/U 13,200 Master Budget 12,000 $ 338,200 $ 343,200 $ 312,000 $ 19 Sales volume (number of cases sold) 10 11 Sales revenue ($26 per case) 12 Less variable expenses: 13 Sales expense ($2 per case sold) 14 Shipping expense ($5 per case sold) 15 Contribution margin 16 Less fixed expenses: 112 Salaries 18 Office rent 19 Operating income 120 24,500 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,700 21 22 23 24 25 26 27 28 29 INSTRUCTIONS ENTERANSWERS 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