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...

50.1K

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

Q

Suppose we titrate 20.0 mL of 0.20 M of formic acid (HCHO2, Ka= 1.8 x 10^-4)...

Chemistry
Q

Choose a policy designed to address a social problem. Briefly describe the policy and at least...

Psychology
Q

A bus contains a 1500 kg flywheel (a disk that has a 0.55 m radius) and...

Physics
Q

V and W are finite dimensional inner product spaces,T:V?W is a linear map, and?represents the adjoint. 1A:...

Advance Math
Q

Theorem 3.4. Let a and b be integers, not both zero, and suppose that b =...

Advance Math
Q

You wanted to be an entrepreneur after you graduate from university Along with your friends –...

General Management
Q

9 A behavioral ecologist gives hummingbirds a choice between an array of feeders with a...

Biology
Q

1 3 2 8 3 8 4 3 3 5 12 6 6 3 7...

Basic Math
Q

Simplify the expression: 102x 10dx10x101 210-2z1 2

Calculus
Q

Answer Attempt 1 out of 2 Watch Video Question Members of a softball team raised...

Algebra
Q

Dawson Toys, Limited, produces a toy called the Maze. The company has recently...

Accounting
Q

Rank the products in order of their current pothablity from most pronitable to least profitable....

Accounting