Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the answer from Chapter 10 Performing Variance Analysis from Excel based Decisions in Managerial Accounting. I am going to attach the questions and

I need the answer from Chapter 10 Performing Variance Analysis from Excel based Decisions in Managerial Accounting. I am going to attach the questions and the required information in the pdf form. Thank you so much in advance

image text in transcribed \fActual Sales - A - Q Sales - A - $ Sales B - Q Sales B - $ Variable - A Variable - B CM - A CM - B Total CM 1,250 $12 625 $48 $6 $35 $6 $13 Flex -Constant Mix 1,406 $15,000 469 $30,000 ($7,500) ($21,875) $7,500 $8,125 $15,625 $9,492 $3,164 $12,656 CM Variance Budget Avg CM Static Bud 1,500 $10 500 $50 $6 $35 $4 $15 $ $2,969 formulas for this is below 50,000 3.75% actual Market Share Variance Market Size Variance 6.75 = (844) overall which is becaus sold: planned: difference times wtd 20,000 budgeted 10.00% Sum of 2,125 two separate variances Market Size $25,000 ($9,000) ($17,500) $6,000 $7,500 $13,500 $2,125 CM Vol Var. Flex Budget Variance $15,000 ($21,094) $20,250 ($844) This is the CM Vol Var split into two pieces sales mix variance: Product A Product B sales price variance: Product A Product B Actual Units 1,250 625 Budgeted Units 1,406 469 Budgeted CM $4 $15 Actual CM Budget CM Actual Units 6 4 $1,250 13 15 $625 SMV ($625) $2,344 $1,719 SPV $2,500 ($1,250) $1,250 Variances are favorable if positive 13,500 divided by Assignment: A. What is the budget variance? B. What is the budgeted average contribution margin? C. What is the contribution margin volume variance? D. What is the flex variance? E. What is our actual share of the market? F. What is the market share variance? G. What is the market size variance H. What is the sales mix variance? I. What is the sales price variance? 2,000 units overall which is because we sold more (fewer) units overall than planned 1,875 2,000 (125) $ 6.75 ($844) t into two pieces $2,969 \fRevenue Direct Materials Direct Labor Applied MOH Gross Profit Static Budget $ 2,199,000 $ 1,528,000 $ 80,000 $ 200,000 $ 391,000 Flexible Budget $ 3,298,500 $ 2,292,000 $ 120,000 $ 200,000 $ 686,500 Actual Results $ 3,307,500 $ 2,888,850 $ 125,325 $ 300,000 $ (6,675) Notes: In this division we had no beginning or ending inventorys of direct materials or finished goods. Manufacturing overhead is a fixed expense, but applied on the basis of candle-inches. Actual Units Sold: 150,000

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

Authors: Robert Libby, Patricia Libby, Frank Hodge

10th edition

1259964949, 1259964947, 978-1259964947

More Books

Students also viewed these Accounting questions

Question

A greater tendency to create winwin situations.

Answered: 1 week ago

Question

Improving creative problem-solving ability.

Answered: 1 week ago