Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help. 7. Answer the following questions: a. What is the master budget variance for Shipping exp.? $ %,U or F? What does it mean?

Please Help. image text in transcribed
image text in transcribed
image text in transcribed
7. Answer the following questions: a. What is the master budget variance for Shipping exp.? $ %,U or F? What does it mean? b. What is the master budget variance for Lease Exp? \$ %,U or F ? What does it mean? 8. Use management by exception to determine which variances to investigate. HINT: In column K, use the "If function", along with "Absolute value function" to find the variances that are larger than the decision rule. Also, since the decision rule is in B2L and you want Excel to always compare to B21, you need to make it an absolute reference: $B$21. For example, =IF(ABS(K7)>($BS21), "yes", "no" ). 9. Now check to see if everything ripples through the budget if you change an assumption. Try changing the assumed sales volume to 20,500 and Shipping expense to $2.10 per case. You should have a new total variance for operating income of $21,287,9.8% variance, F. 10. Change the sales volume assumption back to $20,000 and the shipping expense assumption back to $2.00

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

Financial Accounting For MBAs

Authors: Peter D. Easton, John J. Wild, Robert F. Halsey, Mary Lea McAnally

3rd Edition

0978727932, 978-0978727932

More Books

Students also viewed these Accounting questions

Question

2. Do not crowd the student. Do not get in the students face.

Answered: 1 week ago