Question

In: Accounting

**Can u show the steps and formula used for each question please and thank you! Super...

**Can u show the steps and formula used for each question please and thank you!

Super Sales Company is the exclusive distributor for a high-quality knapsack. The product sells for $120 per unit and has a CM ratio of 25%. The company’s fixed expenses are $405,000 per year. The company plans to sell 14,000 knapsacks this year.

1. What are the variable expenses per unit?

2. Use the equation method for the following:

a. What is the break-even point in units and in sales dollars?

b. What sales level in units and in sales dollars is required to earn an annual profit of $117,000?

c. What sales level in units is required to earn an annual after-tax profit of $117,000 if the tax rate is 25%?

d. Assume that through negotiation with the manufacturer, Super Sales Company is able to reduce its variable expenses by $6 per unit. What is the company’s new break-even point in units and in sales dollars? (Do not round intermediate calculations. Round your final answers to the nearest whole number.)

3. Use the formula method for the following:

a. What is the break-even point in units and in sales dollars?

b. What sales level in units and in sales dollars is required to earn an annual profit of $117,000?

c. What sales level in units is required to earn an annual after-tax profit of $117,000 if the tax rate is 25%?

d. Assume that through negotiation with the manufacturer, Super Sales Company is able to reduce its variable expenses by $6 per unit. What is the company’s new break-even point in units and in sales dollars? (Do not round intermediate calculations. Round your final answers to the nearest whole number.

Solutions

Expert Solution

1. Variable expenses per unit = $ 120 x ( 1 -0.25 ) = $ 90

2.a.

Let the break-even quantity be X

PX = VX + FC + Profit

where P is the price per unit'

X is the number of units

V is the variable cost per unit, and

FC is total fixed cost.

Break-even point in units:

PX = VX + FC + 0

or 120 X = 90 X + 405,000

X = 405,000 /( 120 - 90) = 13,500 units

Break-even point in sales dollars = Price per unit x Break-even Sales Units = $ 120 x 13,500 = $ 1,620,000

b. Sales level required to earn annual profit of $ 117,000 : 17,400 units

120 X = 90 X + 405,000 + 117,000

or X = ( 405,000 + 117,000 ) / 30 = 17,400 units

Sales dollars to earn a profit of $ 117,000 = $ 120 x 17,400 units = $ 2,088,000

c. Before tax target profit = $ 117,000 / ( 1 - 0.25) = $ 156,000

Sales units required to earn after-tax profit of $ 117,000 = $ ( 405,000 + 156,000 ) / $ 30 = 18,700 units

Sales dollars required to earn after-tax profit of $ 117,000 = 18,700 units x $ 120 = $ 2,244,000

d. New variable expense per unit = $ 90 - $ 6 = $ 84

120 X = 84 X + 405,000

or New break-even point in units = 405,000 / 36 = 11,250 units

New break-even point in sales dollars = 11,250 units x $ 120 = $ 1,350,000

3. a. Contribution margin ( CM) per unit = $ 120 x 25 % = $ 30

Break-even point in units = Total FC / CM per unit = $ 405,000 / $ 30 = $ 13,500

Break-even point in sales dollars = Total FC / CM ratio = $ 405,000 / 0.25 = $ 1,620,000

b. Sales level required to earn profit of $ 117,000 = ( Total FC + Target Profit ) / CM per unit = $ ( 405,000 + 117,000 ) / $ 30 = 17,400 units

Sales dollars required to earn profit of $ 117,000 = ( Total FC + Target Profit ) CM ratio = $ ( 405,000 + 117,000 ) 0.25 = $ 2,088,000

c. Before-tax target profit = Desired After-tax Profit / ( 1 - t ) = $ 117,000 / ( 1 - 0.25) = $ 156,000

Sales level required to earn $ 156,000 = ( Total FC + Target Profit ) / CM per unit = $ ( 405,000 + 156,000 ) / $ 30 = 18,700 units

Sales dollars required to earn $ 156,000 = ( Total FC + Target Profit ) / CM ratio = $ ( 405,000 + 156,000 ) / 0.25 = $ 2,244,000

d. New variable expenses per unit = $ 90 - $ 6 = $ 84

New CM per unit = $ 120 - $ 84 = $ 36

New CM ratio = $ 36 / $ 120 = 0.30

New break-even point in units = $ 405,000 / $ 36 = 11,250 units

New break-even point in sales dollars = $ 405,000 / 0.30 = $ 1,350,000


Related Solutions

Please use Excel and show the formula you used. Thank you :) A manufacturing process produces...
Please use Excel and show the formula you used. Thank you :) A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
on the following question please show the formula for the steps and from were you get...
on the following question please show the formula for the steps and from were you get the numbers) Cost-volume-profit analysis Di & Co. has the following budgeted information for a contract: - Fixed costs $ 270,000 Variable cost per unit $         20 Selling price per unit   $         40 Budgeted output / sales units          15,000 Required: (a) Compute the number of units that must be sold to breakeven.                              (b) How many units must be sold to earn $80,000 target profit?                                    ...
(on the following question please show the formula for the steps and from were you get...
(on the following question please show the formula for the steps and from were you get the numbers) Cost-volume-profit analysis Di & Co. has the following budgeted information for a contract: - Fixed costs $ 270,000 Variable cost per unit $         20 Selling price per unit   $         40 Budgeted output / sales units          15,000 Required: (a) Compute the number of units that must be sold to breakeven.                              (b) How many units must be sold to earn $80,000 target profit?                                    ...
Please if you could do each problem, and show steps for excel! Thank you! You will...
Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...
Can someone show me how to break this down by steps please and thank you. You...
Can someone show me how to break this down by steps please and thank you. You sell short 200 shares of a stock at $95 on a 60% initial margin requirement with a 30% maintenance margin. In 3 months, the stock is $79. What is your margin at this time? When would a margin call occur? If you cover your position when the stock is $79, what would be your HPR? Assume you did the same trade as before but...
Hi all, Can someone please answer this question with all steps! Thank you! As a result...
Hi all, Can someone please answer this question with all steps! Thank you! As a result of improvements in product engineering, United Automation is able to sell one of its two milling machines. Both machines perform the same function but differ in age. The newer machine could be sold today for $69,500. Its operating costs are $22,600 a year, but in five years the machine will require a $18,700 overhaul. Thereafter operating costs will be $31,300 until the machine is...
Important: please show work for each question. Thank you! In a previous section of PSY230, the...
Important: please show work for each question. Thank you! In a previous section of PSY230, the second exam was worth 80 points. The scores from that class were normally distributed with a mean (μ ) of 65 and a standard deviation (σ) of 5. If the exam scores were converted to a Z distribution, the distribution would form a perfect bell shape. The following questions require locating individual exam scores on the Z distribution and examine the percentage (or proportion)...
Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You...
Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You have just been hired as the staff accountant for Maximum Corporation. However, the accounting manager is unclear about your ability to determine where certain increases and decreases should be placed. Indicate in the columns below by placing a check-mark (√        ) in the appropriate column identified. Office rent is increased.                                   Service Revenue is increased. Prepaid Expense is reduced. Cash is decreased. Plant and machinery...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The following information applies to Problems 1-4) The Collins Group, a leading producer of custom automobile accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets                                        $ 38,000,000 Net plant, property, and equipment                    101,000,000 Total assets                                          $139,000,000 Liabilities and Equity Accounts payable                                      $ 10,000,000 Accruals                                                9,000,000 Current liabilities                                   $...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT