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 ?
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 ??
How can I explain these numbers in terms of the trends and positive/negative nature of the...
How can I explain these numbers in terms of the trends and positive/negative nature of the ratios? Work Capital $        9,351 $        7,478 $        6,466 Current Ratio                 1.3 1.3 1.2 Accounts Receivable 9.4 10.7 10.5 Days Sales in RA 38.8 34.0 34.6 Inventory Turnover 5.0 5.9 5.8 Days Sales in Inventory 73.4 61.8 62.7 Times Interest Earning 8.0 11.1 11.2 Free Cash Flow 5,320 6,534 7,975 Profitability Measure Cross Profit Margin 62.6% 60.7% 60.5% Rreturn On Assets ROA 1.4%...
What does a positive and negative fixed overhead budget variance and fixed overhead volume variance mean?...
What does a positive and negative fixed overhead budget variance and fixed overhead volume variance mean? In the answer, ensure to go beyond stating that it is favourable or unfavourable.
Sales Price Variance, Sales Volume Variance, Overall Sales Variance Saginaw Company is a garden products wholesale...
Sales Price Variance, Sales Volume Variance, Overall Sales Variance Saginaw Company is a garden products wholesale firm. In December, Saginaw Company expects to sell 21,000 bags of vegetable fertilizer at an average price of $5.3 per bag. Actual results are 21,800 bags sold at an average price of $5.2 per bag. Required: 1. Calculate the sales price variance for December. $ - Select your answer -FavorableUnfavorableItem 2 2. Calculate the sales volume variance for December. $ - Select your answer...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT