Question

In: Finance

Shelly's Boutiques and Crafts had revenue of $5,700,000 this year on sales of 575,000 units. Variable...

Shelly's Boutiques and Crafts had revenue of $5,700,000 this year on sales of 575,000 units. Variable costs were 35% and fixed costs totaled $3,150,000. Although the first five years were relatively profitable, increases in competition have led to a negative trend in profitability that has led them to the point where they have to make some changes to stay afloat. The company is evaluating two options to stay afloat.

Option 1: Purchase machinery to automate their operations. this machinery cost $625,000 but will decrease variable costs by 9%

Option 2: Outsource the production of one of their main components that requires a substantial amount of machinery and skilled labor. This will reduce fixed costs by $425,000, but increases variable costs from their current 35% of sales to 40% of sales.

a. determine break even points in units before changes. what is fixed cost total? what is the contribution margin per unit? what is the break even point in units?

b.) Assuming an income tax rate of 35%, what dollar value of sales is required to earn an after tax profit of $800,000 What before tax profit would be needed to earn an after tax profit of $800,000? what is the contribution margin raton? What dollar amount of sales would be required to earn the after tax profit described above?

c.) Calculate the operating leverage before applying any of the options: What is the contribution margin in Total? What is the operating income in total? what is the operating leverage factor?

d.) Calculate the break even point in units after applying Option 1: What is the new fixed cost in total? What is the new contribution margin per unit? What is the new break even point in units?

e.) Calculate the operating leverage after applying Option 1: What is the new contribution margin in Total? What is the new operating income in total? what is the new operating leverage factor?

f.) Calculate the break even point in units after applying Option 2: What is the new fixed cost in total? What is the new contribution margin per unit? What is the new break even point in units?

g.) Calculate the operating leverage after applying Option 2: What is the new contribution margin in Total? What is the new operating income in total? what is the new operating leverage factor?

Solutions

Expert Solution

Sales per unit (S) = total revenue/ number of units = 5,700,000/575,000 = $9.91 per unit

Variable cost per unit (VC) = Total variable cost/ number of units = 35%*total revenue/number of units

= (35%*5,700,000)/575,000 = 3.47

a). Break-even quantity Q = FC/(S - VC) = 3,150,000/(9.91 - 3.47) = 488,866.40 units

Contribution margin = S - FC = 9.91 - 3.47 = $6.44 per unit

b). To earn an after-tax profit of 800,000, the before-tax profit has to be after-tax profit/(1 - tax rate)

= 800,000/(1-35%) = 1,230,769.23

Let number of units be n.

n*(S-VC) - FC = 1,230,769.23

n*6.44 - 3,150,000 = 1,230,769.23

n = (1,230,769.23 - 3,150,000)/6.44 = 679,876.47

Dollar value of sales = S*n = 9.91*679,876.47 = 6,739,644.97

c). Operating Cash Flow (OCF) without taxes = n*(S-VC) - FC = 5,700,000 - 1,995,000 - 3,150,000 = 555,000

Operating leverage factor = Total contribution margin/operating income = (5,700,000 - 1,995,000)/555,000 = 6.68

Parts d,e,f,g:

Question Formula Option 1 Formula Option 2
Number of units (u)           5,75,000           5,75,000
Sales (R)         5,700,000         5,700,000
Variable cost (V) (35%-9%)*R         1,482,000 40%*R         2,280,000
Fixed cost (FC) Unchanged         3,150,000 Decreases by 425,000         2,725,000
Sales per unit (S) R/u                   9.91 R/u                   9.91
Variable cost per unit (VC) V/u                   2.58 V/u                   3.97
part (d), (f)
Break-even quantity FC/(S-VC)     429,409.67 FC/(S-VC)     458,150.58
New Fixed cost in total         3,150,000         2,725,000
New contribution margin per unit S-VC                   7.34 S-VC                   5.95
part (e), (g)
Contribution margin in total (CM) R-V         4,218,000 R-V         3,420,000
Operating income in total (OI) R-V-FC         1,068,000 R-V-FC           695,000
Operating leverage factor CM/OI                   3.95 CM/OI                   4.92

Related Solutions

Dayton company had sales revenue of $900,000 for the year. Inaddition, the following information is...
Dayton company had sales revenue of $900,000 for the year. In addition, the following information is available related to the cost of the units sold:Beginning Inventory$ 480,000Purchases  233,000Freight-in  8,300Purchase Discounts25,000Purchases Allowances5,300Operating expenses177,000Ending inventory243,000At what amount would the company report gross profit?A. $439,700B. $452,000C. $460,300D. $430,000
Polzin Company had sales in 2010 of $1,800,000 on 60,000 units. Variable costs totalled $860,000, and...
Polzin Company had sales in 2010 of $1,800,000 on 60,000 units. Variable costs totalled $860,000, and fixed costs totaled $550,000. A new raw material is available that will decrease the variable costs per unit by 20% (or $2.80). However, to process the new raw material, fixed operating costs will increase by $65,000. Management feels that one-half of the decline in the variable costs per unit should be passed on to customers in the form of a sales price reduction. The...
Volmar Company had sales in 2020 of $1,602,000 on 53,400 units. Variable costs totalled $534,000, and...
Volmar Company had sales in 2020 of $1,602,000 on 53,400 units. Variable costs totalled $534,000, and fixed costs totalled $911,400. A new raw material is available that will decrease the variable costs per unit by 20% (or $2.00). However, to process the new raw material, fixed operating costs will increase by $43,500. Management feel that one half of the decline in the variable costs per unit should be passed on to customers in the form of a sales price reduction....
The following information is available for year 1 for Pepper Products:    Sales revenue (180,000 units)...
The following information is available for year 1 for Pepper Products:    Sales revenue (180,000 units) $ 3,240,000 Manufacturing costs Materials $ 191,000 Variable cash costs 162,000 Fixed cash costs 373,000 Depreciation (fixed) 1,138,000 Marketing and administrative costs Marketing (variable, cash) 481,000 Marketing depreciation 171,000 Administrative (fixed, cash) 582,000 Administrative depreciation 85,000 Total costs $ 3,183,000 Operating profits $ 57,000     All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products:    Sales revenue (250,000 units)...
The following information is available for year 1 for Pepper Products:    Sales revenue (250,000 units) $ 5,750,000 Manufacturing costs Materials $ 338,000 Variable cash costs 287,000 Fixed cash costs 661,000 Depreciation (fixed) 2,016,000 Marketing and administrative costs Marketing (variable, cash) 852,000 Marketing depreciation 302,000 Administrative (fixed, cash) 1,027,000 Administrative depreciation 151,000 Total costs $ 5,634,000 Operating profits $ 116,000     All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000...
2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000 Income Tax Expense 27,000 30,000 Net Income 61,000 52,000 Cash Flow from Operations 65,000 55,000 Capital Expenditures 65,000 55,000 Acc Receivable (net) 31 Dec 126,000 120,000 Inventory 31 Dec 196,000 160,000 Stockholders' Equity 31 Dec 450,000 400,000 Total Assets 31 Dec 750,000 675,000 Required: Calculate the following ratios for 2016. The 2015 results are given for comparative purposes. Round answers to one (1) decimal...
In the current year, the Best Corporation had sales revenue of $380,000, operating expenses of $390,000,...
In the current year, the Best Corporation had sales revenue of $380,000, operating expenses of $390,000, and charitable contributions totaling $9,000. In addition, the company received a $50,000 cash dividend from another domestic corporation, a company in which it held a 15 percent ownership interest. What is Best Corporation’s taxable income?
Question 1: CVP relation Sales volume in units 100 Revenue $7,000   Variable costs $4,000 Contribution margin...
Question 1: CVP relation Sales volume in units 100 Revenue $7,000   Variable costs $4,000 Contribution margin $3,000   Fixed costs $1,800 Profit $1,200 a) Compute the following items:     price=         unit VC=         unit CM=   b) Write down the CVP relation.   Profit = ___________ * volume - __________ (e.g., if Profit=4*volume-1000, enter 4 in the first box and 1000 in the second box). c) Predict profit at sales volume of 120 units: d) Your boss gave you a profit target...
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $575,000;...
McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $575,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 52 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. b. What is the average amount of...
Exercise 22-14 Carey Company had sales in 2016 of $1,560,000 on 60,000 units. Variable costs totaled...
Exercise 22-14 Carey Company had sales in 2016 of $1,560,000 on 60,000 units. Variable costs totaled $900,000, and fixed costs totaled $500,000. A new raw material is available that will decrease the variable costs per unit by 20% (or $3). However, to process the new raw material, fixed operating costs will increase by $100,000. Management feels that one-half of the decline in the variable costs per unit should be passed on to customers in the form of a sales price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT