Question

In: Accounting

Felde Bucket Co., a manufacturer of rain barrels, had the following data for 2018: Sales: 2,500...

Felde Bucket Co., a manufacturer of rain barrels, had the following data for 2018: Sales: 2,500 unitsSales price: $40 per unitVariable costs: $24 per unit Fixed costs$ 19,500 per month Instructions

(a). What is the contribution margin per unit (b). What is contribution margin ratio? (c). How many units Felde has to sell per month to be break-even? (d). What is the total sales in dollars Felde has to sell per month to be break-even? (e). What is the margin of safety in dollars and as a ratio? (f) What is the total sales in dollars that must be generated for the company to earn a profit of $60,000? Bonus Question (g) If the company wishes to increase its total dollar contribution margin by 30% in 2019, by how much will it need to increase its sales if all other factors remain constant? Show all work please

Solutions

Expert Solution

This problem is related to marginal costing basic-

Data given-

Sale price per unit= $40, Variable cost per unit= $26, Fixed cost per month= $19500, Sales Quantity= 2500 units

a) Calculation of contribution margin per unit

contribution margin per unit = Sale price per unit - Variable cost per unit)

                                                $40 - $24      = $16

b) Contribution margin ratio= Contribution margin / Sale price per unit *100

                                                 = $16 / $40 *100 = 40%

c) Calculation of Break even point in units= Break even point is the point at which there is no profit & no loss.

Break-even point (in units) per month = Fixed cost / (Sale price per unit - Variable cost per unit)

                                          = $19500 / ($40- $26)= 1218.75 or 1219 units

d) Break-even sales in dolar terms = Fixed cost / Contribution margin rate

                                                       = $19500 / 40% = $48750

e) Calculation of margin of safety sales in dollars and ratio- Margin of safety is point above break-even point.

Margin of safety sales (in Dollars) = (Actual Sales Quantity - Breakeven Sales Quantity)* Price per unit

(2500 - 1219) *40= $51240

                                                                               OR

                                                          Actual Sales - Break-even sales

                                                  =       (2500*40) - 48750 = $51250

Ratio of Sales= Margin of safety sales/ Total sales * 100

                              = 51250/100000 = 51.25%

f) Desired Sales to earn desired profit of $60000-

Desired sales = Fixed cost + Desired profit / Contribution margin ratio

                       = (19500 + 60000) / 40%

                       = $169500

g) Calcualtion of current total $ contribution margin= 2500* $16 = $40000

Company want's to increase it by 30% in projection so new contribution = 40000*1.30 = $52000

Calculation of Profit = Revised contribution - Fixed cost = 52000= 19500 = $32500

As other factors remain constant -

Selling price per unit will be same and variable cost per unit will remain same

As per marginal cost equation assumng sales quantity be x

Sales revenue- variable cost= fixed cost+ profit

X*(40-26) = 19500+32500

X = 52500 / 14 = 3750 units.

                                        


Related Solutions

Ivanhoe Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,830...
Ivanhoe Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,830 units Sales price $50 per unit Variable costs $35 per unit Fixed costs $16,980 What is the contribution margin ratio? Contribution margin ratio Type your answer here % eTextbook and Media       What is the break-even point in dollars? Break-even point $Type your answer here eTextbook and Media       What is the margin of safety in dollars and as a ratio? Margin...
1. Ivanhoe Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales...
1. Ivanhoe Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,260 units Sales price $45 per unit Variable costs $27 per unit Fixed costs $20,340 What is the contribution margin ratio? work out problem step by step. (write what to do step by step and why)
Crane Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,040...
Crane Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,040 units Sales price $40 per unit Variable costs $22 per unit Fixed costs $18,360 (a) What is the contribution margin ratio? Contribution margin ratio % (b) What is the break-even point in dollars? Break-even point $ (c) What is the margin of safety in dollars and as a ratio? Margin of safety $ Margin of safety ratio % (d) If the company wishes to...
Monty Co., a manufacturer of rain barrels, had the following data for 2016. Sales 2,800 units...
Monty Co., a manufacturer of rain barrels, had the following data for 2016. Sales 2,800 units Sales price $50 per unit Variable costs $20 per unit Fixed costs $70,560 What is the break-even point in dollars? What is the margin of safety in dollars and as a ratio? If the company wishes to increase its total dollar contribution margin by 30% in 2017, by how much will it need to increase its sales if all other factors remain constant? (Round...
1. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000,...
1. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000, average operating assets $3,000,000, return on investment 18%, minimum required rate of return 16%. What was the amount of margin (or profit margin) for the division A. 4% B. 5% C. 6% D. 7% 2. A division in ABC Co. had the following financial data for March 2019: sales $9,000,000, average operating assets $3,000,000, return on investment 18%, minimum required rate of return 16%....
The following data represent the pH of rain for a random sample of 12 rain dates....
The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suggests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts​ (a) through​ (d) below. 5.30 5.72 4.99 4.80 5.02 4.57 4.74 5.19 5.29 4.76 4.56 4.91 ​(a) Determine a point estimate for the population mean. A point estimate for the population mean is nothing. ​(Round to two decimal places...
The following data represent the pH of rain for a random sample of 12 rain dates....
The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suggests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts​ a) through​ d) below. 5.05 5.72 5.24 4.80 5.02 4.59 4.74 5.19 5.29 4.76 4.56 5.70 LOADING... Click the icon to view the table of critical​ t-values. c) Construct and interpret a 99​% confidence interval for the mean pH...
The following data represent the pH of rain for a random sample of 12 rain dates....
The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suggests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts​ (a) through​ (d) below 5.58 5.58 5.72 5.24 5.24 4.80 5.02 5.03 5.03 4.74 5.19 4.87 4.87 4.76 4.56 4.91 4.91 ​(a) Determine a point estimate for the population mean. A point estimate for the population mean is nothing....
The following data represent the pH of rain for a random sample of 12 rain dates....
The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suggests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts​ a) through​ d) below. 5.58 5.72 4.89 4.80 5.02 4.58 4.74 5.19 4.61 4.76 4.56 5.69
The following data represent the pH of rain for a random sample of 12 rain dates....
The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suggests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts​ (a) through​ (d) below. Open in StatCrunch + Copy to Clipboard + Open in Excel + 5.585.58 5.72 4.624.62 4.80 5.02 4.684.68 4.74 5.19 5.345.34 4.76 4.56 5.305.30 ​(a) Determine a point estimate for the population mean. A point...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT