Question

In: Accounting

The next year's budget for Benny, Inc., is given below: Product 1/2 Sales $945,000/688500 Variable costs...

The next year's budget for Benny, Inc., is given below: Product 1/2 Sales $945,000/688500 Variable costs 459,900/297,000 Fixed costs 300,000/300,000 Net income $185,100/$91,500 Units 126,000/54,000 Market share 12%/20.0% At the end of the year, the total fixed costs and the variable costs per unit were exactly as budgeted, but the following units per product line were sold: Product Line- Units- Sales- Mkt share 1- 126,200- $958,579- 16.0% 2- 56,800- $721,010- 14.2% Required: (Be sure to indicate whether the variance is favorable or unfavorable.) a. Compute the sales activity variance for each product. b. Compute the market share variance for each product. c. Compute the industry volume variance for each product.

Solutions

Expert Solution

Part a)

To compute the sales activity variance we need to arrive at the contribution margin per unit for each product as below:

Contribution Margin Per Unit (Product 1) = (Sales - Variable Costs)/Sales in Units = (945,000 - 459,900)/126,000 = $3.85

Contribution Margin Per Unit (Product 2) = (Sales - Variable Costs)/Sales in Units = (688,500 - 297,000)/54,000 = $7.25

Now, we can determine the sales activity variance as below:

Sales Activity Variance = Contribution Margin Per Unit*(Actual Sales - Budgeted Sales)

Sales Activity Variance (Product 1) = 3.85*(126,200 - 126,000) = $770 (Favorable)

Sales Activity Variance (Product 2) = 7.25*(56,800 - 54,000) = $20,300 (Favorable)

_____

Part b)

The market share variance for each product is determined as below:

Market Share Variance = Contribution Per Unit*(Actual Sales - Actual Sales/Actual Market Share*Budgeted Market Share)

Using the values provided in the question in the above formula, we get,

Market Share Variance (Product 1) = 3.85*(126,200 - 126,200/16%*12%) = $121,467.50 (Favorable)

Market Share Variance (Product 2) = 7.25*(56,800 - 56,800/14.2%*20%) = $168,200 (Unfavorable)

_____

Part c)

The industry volume variance for each product is calculated as follows:

Industry Volume Variance = Contribution Per Unit*(Actual Sales/Actual Market Share*Budgeted Market Share - Budgeted Sales)

Using the values provided in the question in the above formula, we get,

Industry Volume Variance (Product 1) = 3.85*(126,200/16%*12% - 126,000) = $120,697.50 (Unfavorable)

Industry Volume Variance (Product 2) = 7.25*(56,800/14.2%*20% - 54,000) = $188,500 (Favorable)


Related Solutions

Dallas Inc. sells a product for $62. Variable costs are 60% of sales, and monthly fixed...
Dallas Inc. sells a product for $62. Variable costs are 60% of sales, and monthly fixed costs are $58,776. a. What is the break-even point in units? (Do not round intermediate calculations.) b. What unit sales would be required to earn a target profit of $123,256? (Do not round intermediate calculations.) c. Assume they achieve the level of sales required in part b, what is the margin of safety in sales dollars? (Do not round intermediate calculations.)
Financial forecasting-% of sales) Tulley Appliances Inc. projects next year's sales to be $19.6 million. Current...
Financial forecasting-% of sales) Tulley Appliances Inc. projects next year's sales to be $19.6 million. Current sales are $15.4 million, based on current assets of $5.1 million and fixed assets of $5.2 million. The firm's net profit margin is 4.9% after taxes. Tulley forecasts that its current assets will rise in direct proportion to the increase in sales, but that its fixed assets will increase by only $109,000. Currently, Tulley has $1.5 million in acct. payable (which vary directly with...
1)A company’s flexible budget for 12,000 units of production showed sales, $48,000; variable costs, $18,000; and...
1)A company’s flexible budget for 12,000 units of production showed sales, $48,000; variable costs, $18,000; and fixed costs, $16,000. The variable costs expected if the company produces and sells 16,000 units is: Multiple Choice $48,000. $64,000. $40,000. $24,000. $18,000. 2)A company’s flexible budget for 12,000 units of production showed sales, $48,000; variable costs, $18,000; and fixed costs, $16,000. The contribution margin expected if the company produces and sells 16,000 units is: Multiple Choice $48,000. $64,000. $40,000. $24,000. 3) = Hassock...
Variable costs as a percentage of sales for Lemon Inc. are 80%, current sales are $600,000,...
Variable costs as a percentage of sales for Lemon Inc. are 80%, current sales are $600,000, and fixed costs are $130,000. What is the break even point in sales? 610000 520000 650000 none of the above
(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$14.95...
(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$14.95 million. Current sales are ​$13 ​million, based on current assets of ​$4.33 million and fixed assets of ​$6.50 million. The​ firm's net profit margin is 3 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which...
​(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$15.60...
​(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$15.60 million. Current sales are ​$13 ​million, based on current assets of ​$4.33 million and fixed assets of ​$6.50 million. The​ firm's net profit margin is 5 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which...
Here are next year's projections for a firm you are valuing: Sales are expected to be...
Here are next year's projections for a firm you are valuing: Sales are expected to be $100 million. Gross margin is forecasted to be 30%. COGS and SG&A are $90 million, of which depreciation is $10 million. The firm is very inefficient in collecting its bills from customers. It is expected that: Industrial customers (70% of sales) will take 100 days to pay their bills. Retail chains (30% of sales) make cash sales. The firm expects to turn over its...
Tile Co. Income Statement Budget sales volume, unit: 3,000 Sales: 18.00 Variable product: 6.50 variable selling...
Tile Co. Income Statement Budget sales volume, unit: 3,000 Sales: 18.00 Variable product: 6.50 variable selling and admin: 3.50 contribution margin: 8.00 fixed product: 2.00 fixed variable selling and admin: 0.70 operating income: 5.30 Tile Co. is budgeting for next year. Their initial budget is shown above. If they wish to budget for 8,000 units, what would the new budgeted profit be? Enter as a whole number, no commas and no dollar signs.
Given Sales in units 10,000 Variable manufacturing costs per unit 5 Variable administrative costs per unit...
Given Sales in units 10,000 Variable manufacturing costs per unit 5 Variable administrative costs per unit 2 Fixed manufacturing costs per unit 2 Fixed administrative costs per unit 1 Variable costs 75% of sales Selling price per unit? $2.22 $9.33 $17.50 $20 Given for XM Company the following data for January 20X1. Direct material purchased and used in production accounted for $ 50000 Units purchased 5000 The standard units 4200 Managers estimate price variance not to exceed +1% of the...
A company produces a product that currently costs $8 in variable costs and $2 in fixed...
A company produces a product that currently costs $8 in variable costs and $2 in fixed costs. It sells the product for $14. If processed further, the company will spend an additional $6 in variable costs and $2 in fixed costs. Each unit would then be sold for $24. Why would the company choose to process further?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT