Question

In: Accounting

This is regarding Cost Accounting. How do I calculate positive(negative) SALES MIX variance and positive(negative) PRICE...

This is regarding Cost Accounting. How do I calculate positive(negative) SALES MIX variance and positive(negative) PRICE Variance in respects to current and previous year's sales. The data I need to use are from actual 10-K reports from the SEC.

Solutions

Expert Solution

Sales mix variance is the difference between a company’s budgeted sales mix and the actual sales mix. Sales mix is the proportion of each product sold relative to total sales. Sales mix affects total company profits because some products generate higher profit margins than others. Sales mix variance includes each product line sold by the firm.

A variance is the difference between budgeted and actual amounts. Companies review sales mix variances to identify which products and product lines are performing well and which ones are not. It tells the "what" but not the "why." As a result, companies use the sales mix variance and other analytical data before making changes. For example, companies use profit margins (net income/sales) to compare the profitability of different products

Assume, for example, that a hardware store sells a $100 trimmer and a $200 lawnmower and earns $20 per unit and $30 per unit, respectively. The profit margin on the trimmer is 20% ($20/$100), while the lawnmower’s profit margin is 15% ($30/$200). Although the lawnmower has a higher sales price and generates more revenue, the trimmer earns a higher profit per dollar sold. The hardware store budgets for the units sold and the profit generated for each product the business sells.

Ie.The sales mix variance measures the difference in unit volumes in the actual sales mix from the planned sales mix. ... Subtract budgeted unit volume from actual unit volume and multiply by the standard contribution margin. Contribution margin is revenue minus all variable expenses


Related Solutions

Calculate total sales mix variance, Direct Materials Variance Price, Direct Materials Variance Efficiency, Dircet Labor Variance...
Calculate total sales mix variance, Direct Materials Variance Price, Direct Materials Variance Efficiency, Dircet Labor Variance Rate & Efficiency, Variable overhead variance spending, and Selling and General Admin Variance. Scooter's Inc Summary of Standard Costs Summary of Standard Costs Deluxe Beginner Assembly kit per scooter $               400 $         200 Direct labor hours per scooter                       3                 1 Direct labor rate per hour $                  25 $           15 Variable overhead rate per scooter $                  35 $           35 Sales Price 2017 2018...
What does a positive and negative : (i) direct labour rate variance mean ? Explain in...
What does a positive and negative : (i) direct labour rate variance mean ? Explain in details and go beyond favourable and unfavourable variance? (II) direct labour efficiency variance mean? Explain in details and go beyond favourable and unfavourable variance?
What does a positive and negative direct material price variance mean? Explain in details using examples...
What does a positive and negative direct material price variance mean? Explain in details using examples and ensure to go beyond stating only favourable or unfavourable variances ?
What are positive and negative reinforcement? How are positive and negative reinforcement different? How are they...
What are positive and negative reinforcement? How are positive and negative reinforcement different? How are they similar? What is punishment?
(i)How much negative charge and how much positive charge are there on the electrons and the...
(i)How much negative charge and how much positive charge are there on the electrons and the protons in a cup of water (0.25 kg)? Note Avogadro’s number is NA = 6.022 × 1023, and each oxygen atom has 8 electrons. (ii) What is the magnitude of the attractive force exerted by the electrons in a cup of water on the protons in a second cup of water at a distance of 10 m?
How do I calculate variance for sample of different scores, estimated standard error for the mean...
How do I calculate variance for sample of different scores, estimated standard error for the mean difference and repeated measure T statistic
Question 2: Further Aspects of Budgeting and Variance Analysis-Sales mix and volume variance                            
Question 2: Further Aspects of Budgeting and Variance Analysis-Sales mix and volume variance                                                                                                                                                                                   Jack plc makes and sells three types of fan for which the following budget/standard information and actual information are available for a four-week period. Model Budgeted sale (unit) Standard unit data Selling price ($) Variable cost ($) Actual sales (unit) Superb 5,000 15 1.0 8,000 Excellent 15,000 14 2.0 11,000 Good 5,000 13 1.0 4,000 Budgeted fixed costs are $250,000 for the four-week period. Jack...
how do i calculate the ETF Value(in $). HOW DO I CALCULATE WHAT FOR THIS ANSWER?...
how do i calculate the ETF Value(in $). HOW DO I CALCULATE WHAT FOR THIS ANSWER? Day Value of Index Index Daily Change ETF Expected % Change ETF Value (in $) 1 100 100 2 110 10.0 20 120.00 3 100 -9.1 -18.2 98.16 4 90 -10.1 -20.2 78.33
How do I calculate EPS for the following years with the current information I have. Price...
How do I calculate EPS for the following years with the current information I have. Price 52.47 Year EPS 2.51 2018 ?? Current P/E 20.9 2019 ?? Current Year 2017 2020 ?? Projected Growth 10.00% 2021 ?? Average P/E 23 2022 ?? Dividend Payout 29.00% 2023 ?? Target Price ?? 2024 ?? E(Rate of Return) ?? 2025 ?? Price<20% Target ?? 2026 ?? 2027 ?? Total ??
Instead, let’s talk about sales mix. This relates to the mix of products. How do changes...
Instead, let’s talk about sales mix. This relates to the mix of products. How do changes in the mix of products impact breakeven? How could a shift in sales mix result in both a higher breakeven point and a lower net income? Use specific examples from a company you know something about. (for instance, for Apple you could do laptop vs. I-series items) What are the assumptions underlying sales mix and cost volume profit that are potentially misleading?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT