Question
As part of its comprehensive planning and control system, Mopar Company uses a master budget and subsequent variance analysis. You are given the following information
As part of its comprehensive planning and control system, Mopar Company uses a master budget and subsequent variance analysis. You are given the following information that pertains to the companys only product, XL-10, for the month of December.
Required:
1. Using text Exhibit 14.4 as a guide, complete the missing parts of the following profit report for December.
2. Based on your completed profit report, determine the dollar amount, and label (Favorable or Unfavorable) each of the following variances for December:
a. Total master (static) budget variance (also referred to as the total operating income variance for the period).
b. Total flexible-budget variance.
c. Sales volume variance, in terms of operating income.
d. Sales volume variance, in terms of contribution margin.
e. Selling price variance.
Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using text Exhibit 14.4 as a guide, complete the missing parts of the following profit report for December. (If a variance has no amount, select "None" in the corresponding dropdown cell.) Actual results Flexible-budget variances Flexible budget Sales volume variances Unit sales Sales $ 112,000 560,000 425,600 Master (static) budget 100,000 $ 500,000 300,000 $ 200,000 87,000 $ 113,000 Variable costs $ Contribution margin Fixed costs Operating income 134,400 74,000 $ 60,400 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using text Exhibit 14.4 as a guide, complete the missing parts of the following profit report for December. (If a variance has no amount, select "None" in the corresponding dropdown cell.) Actual results Flexible-budget variances Flexible budget Sales volume variances Unit sales 112,000 $ Sales Variable costs Contribution margin Fixed costs 560,000 425,600 134,400 74,000 60,400 Master (static) budget 100,000 $ 500,000 300,000 $ 200,000 87,000 $ 113,000 $ Operating income $ EXHIBIT 14.4 Breakdown of Total Operating Income Variance SCHMIDT MACHINERY COMPANY Analysis of Financial Results For October 2019 (2) (3) Flexible-Budget Flexible Variances Budget (1) (4) Sales Volume Variances Actual Units 780 Sales Variable costs Contribution margin Fixed costs Operating income 780 $639,600 350,950 $288,650 160,650 $128,000 $15,600F 50F $15,650F 10,650U $5,000F $624,000 351,000 $273.000 150,000 $123,000 2200 $176,0000 99,000F $ 77,000U 0 $ 77,000U (5) Master (Static) Budget 1,000 $800,000 450,000 $350,000 150,000 $200,000 Analysis of Total Operating-Income Variance Total operating-income variance** = $128,000-$200,000=$72,000U Flexible-budget variance = $128,000 - $123,000 =$5,000F Sales volume variance =$123,000 - $200,000 = $77,000U *Budgeted fixed factory overhead cost = $120.000: budgeted fixed selling and administrative expense = $30,000. **Also called the total master (static) budget variance. Note: U denotes an unfavorable effect on operating income; F denotes a favorable effect on operating income
Step 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