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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Medical Sciences
1.2K views

9. How many grams of dextrose does 400mL of 20% solution contain ? 10. A 2.7kg cat...

Accounting
1.2K views

The following data are from the accounting records of Niles Castings for year 2. Units produced and...

Biology
1.2K views

For the questions below determine if the particle that is described in an atom or...

Physics
1.2K views

A flexible wire loop carrying a current I is placed in a uniform magnetic field...

Algebra
1.2K views

Write the expression as a single logarithm Express powers as factors log 3 x log...

Accounting
1.2K views

Hannibal Steel Company has a Transport Services Department that provides trucks...

Accounting
1.2K views

what are the basic financial statements in quickbooks online?

Accounting
1.2K views

Given the balance sheet below, calculate the Debt to Equity ratio for 2020

Accounting
1.2K views

pregunta en fotos 3. Dado las funciones f(x)=3x4,g(x)=(x+1)2 y p(x)=x1x+2...

Accounting
1.2K views

4. What is the Database Management System (DBMS)? Give example companies who are using DBMS...

Finance
1.2K views

Question 2 (1 point) Ye Shiwen has lived her entire life in Canada. She had...

Finance
1.2K views

Q4 Please show work and explain answer Question 4 6.25 pts Your...