Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please help. 7. answer the following questio

Please Help. 7. Answer the following questions: a. What...

90.2K

Verified Solution

Question

Accounting

Please Help. image
image
image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Two infants are in NICU. One has meconium aspiration syndrome (MAS) while the other has an...

Medical Sciences
Q

Question Data collected for a particular subject during the acid base experiment were time between urine collections...

Medical Sciences
Q

The following pertain to ribosomes during protein synthesis except __________.they participate in both transcription and...

Biology
Q

1 You are given a mixture containing two compounds A and B Both compounds have...

Biology
Q

For the given triangle, find the missing lengths. Give an exact answer and, whereappropriate, an...

Basic Math
Q

Find f 4 f 3 if possible y f x 4 3 A 2 3...

Calculus
Q

A machine is rolling a metal cylinder under pressure. The radius of the cylinderis decreasing...

Calculus
Q

Blaine, Inc., produces three products-Argon, Xon, and Zeon-from a joint production process. Data...

Accounting
Q

Describe a behavioral aspect that you need to be aware of when choosing how to...

Accounting
Q

1) Provide 5 tips for managing credit card debt with an explanation. 2) Write 1...

Accounting
Q

Daisy, who experienced worked with notable technology consulting firm for 10 years decides ...

Accounting
Q

In general, how do credit analysts determine the risk-free rate? ...

Accounting