Answered step by step
Verified Expert Solution
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
\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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started