Question

In: Finance

Gro-right manufactures and sells greenhouses to large commercial farms. The 2020 Budget for the company shows...

Gro-right manufactures and sells greenhouses to large commercial farms. The 2020 Budget for the company shows the following information:

Selling Price per unit

$15,000

Variable manufacturing Costs per unit

$7,500

Variable Selling Costs per unit

$1,500

Annual Fixed Costs

$12,000,000

Desired Net Income

$1,020,000

Income Tax Rate

15%

Required:

  1. Find the break-even level of sales in units for 2020 based on the budgeted information.
  2. Find the level of sales in sales dollars needed to achieve the desired budgeted net income of the company.
  3. Create a Contribution format income statement for the level of sales needed to achieve the desired level of net income.
  4. At the level of sales to achieve the desired net income, what is the margin of safety in dollars?
  5. What is the margin of safety percentage? What is the margin of safety percentage indicating?
  6. At the level of sales to achieve the desired net income, what is the degree of operating leverage for the company?
  7. Using the operating leverage, if sales were to increase by 10% by what percent would the operating income increase?

Solutions

Expert Solution

Solution a
Variable manufacuting cost                   7,500
Variable selling cost                   1,500
Total variable cost                   9,000
Selling price $        15,000.00
Variable Cost $          9,000.00
Contribution =selling price-variable cost
=15000-9000
Contribution per unit $          6,000.00
Fixed cost $      12,000,000
Break even point= Fixed cost/contribution per unit
Break even point= 12000000/6000
Break even point=                   2,000
Solution b
Desired net income $        1,020,000
Tax rate 15%
Pre-tax income required= 1020000/(1-15%)
Pre-tax income required= $        1,200,000
Required sale units =(Fixed cost+Required Profits)/Contribution per unit
=(12000000+1200000)/6000
No of units                   2,200
Solution c
Per unit For 2200 units
Sale $             15,000 $       33,000,000
Variable cost $             (9,000) $     (19,800,000)
Contribution $               6,000 $       13,200,000
Fixed cost $     (12,000,000)
Profit before tax $         1,200,000
Tax @ 15% 1200000*15% $          (180,000)
Net income $         1,020,000
Solution d
Sale above BEP point 2200-2000
Sale above BEP point                 200.00 units
Margin of safety= 200*15000
Margin of safety= $        3,000,000
Solution e
Margin of safety percentage= Margin of safety/Estimated sale
Margin of safety percentage= 3000000/33000000
Margin of safety percentage= 9.091%
The percentage indicates that this much level of sale will generate net income
Solution f
Operating leverage= Contribution/(Contribution -fixed cost)
Operating leverage= 13200000/(13200000-12000000)
Operating leverage=                   11.00
Solution g
Increase in sale 10.00%
Change in operating income Increase in sale * Operating leverage
Change in operating income 10%*11
Change in operating income 110.00%

Related Solutions

A large company which owns several farms sells potatoes grown on these farms. The company claims...
A large company which owns several farms sells potatoes grown on these farms. The company claims that the weights of the potatoes grown on their farms are approximately normally distributed with a mean of 195.6g and a standard deviation of 23.8g. Restaurant A, which buys potatoes from this company, decides to weigh 60 potatoes grown by the company to determine whether the company's claim is true. (A)Assuming the farm's claim is true, describe the sampling distribution of the sample mean...
Gaermont Paper manufactures paper and in turn sells it to commercial vendors. The company manufactures a...
Gaermont Paper manufactures paper and in turn sells it to commercial vendors. The company manufactures a 20-inch-wide "standard" roll of paper. However, not all orders are necessarily for this width. The company often receives orders for narrower rolls. To meet those requests, the narrower rolls are cut from the standard rolls. For the following month, the company has committed orders for the next number of rolls. Ancho del rollo demanda 12 in. 800 8 in 500 5 in 200 4...
Englehart Company sells two types of pumps. One is large and is for commercial use. The...
Englehart Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residential swimming pools. The following inventory data is available for the month of March. Accounting (a) Assuming Englehart uses a periodic inventory system, determine the cost of inventory on hand at March 31 and the cost of goods sold for March under first-in, first-out (FIFO). (b) Assume Englehart uses dollar-value LIFO and one pool, consisting of the...
Whispering Company sells two types of pumps. One is large and is for commercial use. The...
Whispering Company sells two types of pumps. One is large and is for commercial use. The other is smaller and is used in residential swimming pools. The following inventory data is available for the month of March. Units Price per Unit Total Residential Pumps Inventory at Feb. 28: 222 $ 444 $ 98,568 Purchases: March 10 555 $ 500 $ 277,500 March 20 444 $ 527 $ 233,988 March 30 333 $ 555 $ 184,815 Sales: March 15 555 $...
A Company manufactures and sells two products: A and B. The following table shows the information...
A Company manufactures and sells two products: A and B. The following table shows the information relating to these products: A B Total Selling price per unit $20 $40 Variable cost per unit $10 $20 Total Fixed costs $80,000 Required: If Sales mix is 2 :3 for A and B respectively, calculate the breakeven point in units and in dollars for each of the two products.
Comfort Company manufactures pillows. The 2020 operating budget is based on production of 1,000 pillows with...
Comfort Company manufactures pillows. The 2020 operating budget is based on production of 1,000 pillows with 0.50 machine-hour allowed per pillow. Budgeted variable overhead per hour was $10. Actual production for 2020 was 750 pillows using 400 machine-hours. Actual variable costs were $9 per machine-hour. Required: Calculate the variable overhead spending and efficiency variances.
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 7,000 $15.00 February 56,000 $8.25 7,500 $15.00 March 80,000...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 7,000 $15.00 February 56,000 $8.25 7,500 $15.00 March 80,000...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.75 7,000 $16.00 February 58,000 $8.75 7,500 $16.00 March 80,000...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Sales Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: ____________Practice Balls_______________ Match Balls _______Units_________ Selling Price________ Units _________Selling Price January ____50,000 ______$8.25____________ 7,000 _________$16.00 February___ 58,000______ $8.25____________ 7,500_________ $16.00 March _____80,000______...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT