Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WRITE A BUSINESS MEMO USING THIS DATA. PROMT BELOW A D Selling Price $ 5.00 Particulars - Variable cost $ (2.75) Selling Price $ 4.60

WRITE A BUSINESS MEMO USING THIS DATA. PROMT BELOW

A D
Selling Price $ 5.00 Particulars
- Variable cost $ (2.75) Selling Price $ 4.60
Contribution $ 2.25 - Variable cost $ 2.55
Total Contribution $ 446,400.00 Contribution $ 2.05
- Fixed Costs $ (180,000.00) Units sold 198,400
Net Operating Income $ 266,400.00 Total Contribution $406,720
Contibution Margin 45.00% - Fixed Costs ($180,000)
Break Even Point $ 400,000.00 Net Operating Income $ 226,720.00
Margin of Safety Ratio 26.85% Contibution Margin 44.57%
Operating Leverage 1.68 Break Even Point $403,903
Margin of Safety 24.84%
B Operating Leverage 1.79
Particulars E
Selling Price $ 4.60
- Variable cost $ (2.75) Amount
Contribution 1.85 Sales $992,000
Units sold 198,400 Less: Variable expenses $416,640
Total Contribution $ 367,040.00 Contribution Margin $575,360
- Fixed Costs ($180,000) Less: Fixed Cost $230,000
Net Operating Income $187,040 Net Operating Income $345,360
Contibution Margin 40.22% Contribution Margin Ratio 0.58
Break Even Point $ 447,566.20 Break Even Point $396,552
Margin of Safety 20.49% Margin of safety ratio 0.60025
Operating Leverage 1.96 Margin of safety 119089.6
C F
Selling Price $ 5.00 Current sales 198,400
- Variable cost $ 2.55 20% increase in sales 39,680
Contribution $ 2.45 Total sales 238,080
Units sold 198,400
Total Contribution $486,080 Particulars Amount
- Fixed Costs ($180,000) Sales $1,190,400
Net Operating Income $306,080 Less: Variable expenses ($714,240)
Contibution Margin 49.00% Contribution Margin $476,160
Break Even Point $ 367,345.00 Less: Fixed Cost ($200,000)
Margin of Safety 30.85% Net Operating Income $752,320
Operating Leverage 1.59 Contribution Margin Ratio 40%
Break Even Point $500,000
Margin of safety ratio 0.58
Margin of safety 138,080.00

Situation for Analysis: Gary Novelty produces and sells a small novelty item through tourist shops in Gary and other northern Indiana locations. Last year the company sold 198,400 units. The income statement for Gary Novelty for last year is shown below:

Sales

$992,000

Less: Variable Expenses

545,600

Contribution Margin

446,400

Less: Fixed Costs

180,000

Net Operating Income

$266,400

While the company has been profitable, as shown in the above income statement, sales began falling near the end of last year and have continued to decline this year. There is concern that new competitors are beginning to take market share from Gary Novelty. As a result, Sarah Burroughs, the company president, has asked you to provide some information to assist her in making decisions about the companys strategy for this product. These alternatives should be evaluated individually as stated. You are free to offer your own alternative based on any of the parameters given in the data.

a. While the company is currently profitable, the president wants to know the contribution margin and the breakeven in both units and dollars using last years level of sales. Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales.

b. One of the possible strategies (Alt 1) is to reduce the current price by 8%. Using last years level of sales, what is the new contribution margin and break-even in units and dollars based on the price reduction? Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales.

c. A second strategy (Alt 2) is to reduce the current variable cost by 0.20 per unit. The company has identified available efficiencies that can be implemented without any additional changes to the current cost. What is the new contribution margin and break-even in units and dollars based on the variable cost reduction of 0.20 per unit? Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales.

d. A third strategy (Alt3) is to decrease the current price by 8% and reduce the variable cost per unit by 0.20. What is the new contribution margin and break-even in units and dollars based on making both changes? Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales.

e. A fourth strategy (Alt 4) under consideration is to invest in more automated equipment for the manufacturing process. This investment will reduce variable costs by 0.65 per unit, primarily reducing the direct labor. At the same time, this will increase the fixed costs by $50,000. What is the new contribution margin and break-even in units and dollars based on this change in operating structure? Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales.

f. A final strategy (Alt 5) is to change the current structure for the companys sales person. The current fixed cost includes the salary of Grayslakes one sales person at $60,000 per year. The companys marketing study suggests that sales could be increased by 20% if the company hired an additional sales person; paid both individuals $40,000 fixed salaries; and a 0.25 commission per unit sold. What is the new contribution margin and break-even in units and dollars based on this change? Additionally, compute the margin of safety, margin of safety ratio, and degree of operating leverage based on last years sales as the starting point for this change.

Write a business memo addressed to the president recommending the best course of action based on your analysis. In your memo, discuss changes in break-even points, and impacts to the operating leverage. Including a table summarizing your findings would be appropriate. The companys long-range plan is to grow sales to 250,000 units in the next two to three years. In your memo, summarize the advantages and disadvantages of each of the alternatives. Critically evaluate the alternatives based on current market conditions and any impact each alternative may have on the long-range plan.

Clearly state your recommended course of action explaining why your recommendation is the best for the company. Your memo should be at least one page, but no longer than two full pages. You may also attach an Excel spreadsheet that shows all your calculations or you may embed your computations into the memo using tables. The calculations supporting your data and analysis must be included.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Lean Auditing Driving Added Value And Efficiency In Internal Audit

Authors: James C. Paterson

1st Edition

1118896882, 978-1118896884

More Books

Students also viewed these Accounting questions

Question

Mark to market adjustment involves

Answered: 1 week ago