Cost-volume-profit models, Financial Management

Assignment Help:

Bennis Shafts produces three types of golf club shafts which it sells to golf club manufacturers.  Prepare ONE worksheet to answer the following questions and to determine the outcomes of the different scenarios below.

Instructions:

1.  Read all instructions and information carefully. 

2.  Prepare one spreadsheet that can be used to evaluate each of these scenarios. Your spreadsheet should be neatly organized and easy to read.  Include dollar signs as appropriate, but not in every cell.  You should clearly identify the input section (this should include all of the given information) and separate it from the computation section.  All parameter changes should be in the input section.

3.  No numbers should be typed in the computation section of your spreadsheet except for the number 1 if necessary for change calculations. The spreadsheet should automatically and correctly update when input information is changed.  You may add information to the input section of your spreadsheet as needed.  With the exception of breakeven quantities, do not use the rounding function, but only show 2 decimal places.  For breakeven quantities, use the roundup function in Excel to round up the breakeven quantity of each type of shaft.  Do not round up the total number of units needed to breakeven.  This is the rounding function to use:  =ROUNDUP(CELL1*CELL2,0).  CELL1*CELL2 = the formula entered into the cell and the 0 means to round up to a whole number.

4.  The computation section of your spreadsheet should have two sections:

Section A.

  Answer the following questions based on the information as given:

1)  What is the sales mix?

2)  What is the contribution margin per unit for each type of shaft?

3)  What is the weighted average unit contribution margin for this mix of shafts (show both the CMU method and the total CM method)

4)  How many of each type of shaft must Bennis sell to breakeven?

5)  Given the limited production time, which type of shaft is most profitable?

Section B.

Prepare a variable costing income statement for each scenario below.  The assumptions/changes for each scenario should be shown in the input section and clearly labeled for that scenario.  The changes in scenarios 2, 3 and 4 are based on scenario 1 which is the information as given.  This means that all items should be at the values used in scenario 1 except the item(s) that are indicated to change for that particular scenario.  Prepare and clearly label a separate income statement for each scenario.  

5.  Prepare a Word document with a short memo  (1/2 page single spaced) to Bennis Shafts management explaining the effects of scenarios 2, 3 and 4 on their operating income compared to scenario 1.  Please be clear but concise. 

Scenario 1 - Bennis sells shafts in the quantities, prices and costs as indicated in the given information.

Scenario 2 - Due to a decrease in orders by 10%, management attempts to compensate for lower sales by increasing all prices by 10%.

Scenario 3 - Bennis hires a new production supervisor at $50,000 in response to an increase in orders of 10%. 

Scenario 4 - Bennis changes its sales mix to Steel - 20%, Titanium - 60% and Beryllium - 20% while producing the same total number of golf club shafts.

 

Steel

Titanium

Beryllium

Total

Number of sets

6000

2000

1000

 

Price per set

$120.00

$150.00

$192.00

 

Direct material per set

$18.00

$33.00

$42.00

 

Direct labor per set

$12.00

$12.00

$12.00

 

Time to produce each shaft

0.5

0.4

0.7

 

Fixed costs

 

 

 

$300,000

Excel Spreadsheet

1. Using the following information, perform a sensitivity analysis and indicate to which variable would have the greatest effect on operating income.  Present the complete table.

 

Base

High

Low

Quantity Produced

                6,000

              7,000

              5,000

Price

$120.00

$130.00

$80.00

DM

$18.00

$25.00

$12.00

DL

$12.00

$30.00

$7.25

FC

 $      20,000.00

 $    23,000.00

 $    15,000.00


Related Discussions:- Cost-volume-profit models

Evolution of hedge funds, Evolution of Hedge Funds: The establishment o...

Evolution of Hedge Funds: The establishment of the first Hedge Fund in the United States in the year 1949 by Alfred W. Jones marked the evolution of Hedge Fund industry. It was

Monitoring and controlling budgets, Monitoring and Controlling Budgets: ...

Monitoring and Controlling Budgets: The preparation of budgets is only part of the budget cycle.  Once set, an organisation should actively monitor actual revenue and expenditu

What are the rationales of interest swaps, Question: i) What are the ...

Question: i) What are the rationales of interest swaps? ii) You are the corporate treasurer of LSE International Inc. Your firm, rated as AAA, is able to raise capital in

Determine the scope of financial management, Scope of Financial Management ...

Scope of Financial Management The approach to scope and functions of financial management is divided, forpurposes of exposition, into two broad categories: (a) Traditional A

What are the components of return, What are the Components of Return Re...

What are the Components of Return Return is fundamentally made up of two components: Periodic cash receipts or income on the investment in the form of interest,

Swap-linked notes, Swap-Linked Notes: Interest rate swaps are derivativ...

Swap-Linked Notes: Interest rate swaps are derivative products which help in transforming the cash flows of existing debt issues. These are not only useful in covering the exis

Debt holders versus shareholders, Debt holders versus Shareholders A se...

Debt holders versus Shareholders A second agency problem arises because of potential conflict between stockholders and creditors. Creditors lend finances to the firm at rates w

Capiital budgating, calculate payback period of each project and according ...

calculate payback period of each project and according to payback whice project should be accepted

Calculate tax gain or loss, High Tech Production Inc. purchased a comp...

High Tech Production Inc. purchased a computerized measuring device two years ago for $80,000. This equipment falls into the five-year category for MACRS depreciatio

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd