Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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,700

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

Students also viewed these Accounting questions

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago