Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Principles And Practice Of Auditing

Authors: George Puttick, Sandra Van Esch

7th Edition

0702137723, 978-0702137723

More Books

Students also viewed these Accounting questions