Integrative assignment 4 Directions: For this assignment you will need to evaluate the scenario “Product Launch” (directly below) and determine which of the two products, “Redesign” or “New”, this...

1 answer below »
please read the attached files


Integrative assignment 4 Directions:  For this assignment you will need to evaluate the scenario “Product Launch” (directly below) and determine which of the two products, “Redesign” or “New”, this company should launch and at what price point.   Scenario: “Product Launch” You are the lead project manager for two product launches. Product "Redesign" is a redesigned product of your company’s bestselling product.  Product "New" is a completely new product in a new product category. The initial plan is to price product "Redesign" at $425 per unit and product "New" at $600 per unit.   Based on these prices, the head of marketing believes that over the next 5 years the company could sell anywhere from 235,000 to 550,000 of product "Redesign" and 125,000 to 425,000 of product "New".  He believes that there is a 50% chance that demand will be at the low end and a 50% chance that demand could be at the high end.  In essence an equal chance that actual demand will fall anywhere on this demand curve.  To achieve these projected sales numbers, for each product, the company will need to spend $8,000,000 dollars in marketing over 5 years, plus compensate the company’s direct sales staff with a 5% sales commission on the purchase price of the product for each unit that is sold.   In order to understand the impact to the company’s financial position, you discuss with the Vice President of Operations the operational cost structure of these two products. For product "Redesign", she is projecting that the company will need to invest $30,000,000 for manufacturing equipment which will allow the company to make 500,000 units of this product over 5 years.  For product "New", she is projecting that the company will need to invest $36,000,000 for manufacturing equipment which will give the company the capacity to make 350,000 units of this product over 5 years.  As seen in Exhibit A (excel file “Exhibit A - Integrative Assignment #4”), The V.P. of operations has also developed a thorough list of the raw material and labor cost needed to manufacture each product as well as the manufacturing overhead.  As you study this information you notice an interesting detail, the company will not have enough manufacturing capacity if demand for both products is on the high-end of the sales projections.  You discuss this limitation with the VP of Operations.  In your discussion, she feels that with an additional investment of $10,000,000 million dollars for product "Redesign", operations can increase capacity to 750,000 units over 5 years, and for an additional investment of $5,000,000 million dollars for product "New", operations can increase capacity to 475,000 units over 5 years.  However, based on your initial breakeven analysis this additional investment will not pay for itself unless demand for both products significantly increases.   Based on this dilemma you strategize with the VP of Marketing on ways to increase demand. He proposes to lower the price of each product.  The V.P. of marketing believes that if the price of product "Redesign" is lowered to $370 per unit, forecasted sales will be anywhere from 375,000 to 800,000 units over 5 years, and if the price for product "New" is lowered to $550 per unit forecasted sales will be anywhere from 185,000 to 457,000 units over 5 years.  Again, he believes there is an equal chance that actual demand could be anywhere on this forecasted demand curve.  Based on the data from this scenario, what decision do you make?  Do you launch product "Redesign" or product "New" and at what price point do you launch the product at?   Your analysis will include looking at the expected operating profit and risk under four scenarios: 1. Scenario 1: Price product "Redesign" at $425 per unit and keep capacity at 500,000 units 2. Scenario 2: Lower the price of product "Redesign" to $370 per unit and expand capacity to 750,000 units. 3. Scenario 3: Price product "New" at $600 per units and keep capacity at 350,000 units 4. Scenario 4: Lower the price of product "New" to $550 per units and expand capacity to 475,000 units Specifically, you will answer the following questions in Canvas: 1. From the four scenarios listed, which scenario do you believe adds the most expected total profits with the least amount of operational risk over a 5-year period? Please provide a 2-3 paragraph explanation to support your decision.   2. Based on the scenario that you selected what is the scenario’s__________? 1. Total fixed cost 2. Total variable cost per unit 3. Contribution margin per unit 4. Number of units sold needed to break-even point over 5 years   Here are useful tips: · Assume a 5-year time horizon in your analysis. · To calculate expected profit, try calculating the total profit at both the low end and the high end of the demand curve under each scenario.  Since, there is a 50% chance of reaching either the low end or the high end of the demand curve, you can then simply calculate an average total profit between the two data points that you just calculated to determine your expected profits. · In your analysis of operational risk evaluate each scenario's breakeven points and compare this to the total amount of units that are projected to be sold under each scenario.  Which scenario allows for a quicker payback. · Also, when evaluating the trade-offs between increasing profits and incurring additional operational risk don't ignore the concept of operational leveragefrom your readings in Module 16 pages 16-18 through 16-20.
Answered 1 days AfterMar 11, 2021

Answer To: Integrative assignment 4 Directions: For this assignment you will need to evaluate the scenario...

Jyoti answered on Mar 13 2021
143 Votes
Integrative assignment 4
PRODUCT LAUNCH
Table of Contents
1. Executive Summary
2. Scenario Analysis
3. Decision
4. References
1. Executive summary
As a lead project manager, the task is to analyze the available data for two products namely, ‘Redesign’ and ‘New’ and decide which product should be launched and at what price ?
Following four scenarios are taken under consideration and we are determining
operating profit and risk under each scenario:
1. Scenario 1: Price product ‘Redesign’ at $425 per unit and capacity at 5,00,000 units
2. Scenario 2: Lower the price of product ‘Redesign’ to $370 per unit and expand capacity to 7, 50,000 units.
3. Scenario 3: Price product ‘New’ at $600 per units and keep capacity at 3,50,000 units
4. Scenario 4: Lower the price of product ‘New’ to $550 per units and expand capacity to 4,75,000 units
On the basis of our analysis, we are recommending selection of product ‘redesign’ to be launched at $ 370 per unit and for that, production capacity needs to be enhanced to 7,50,000 units by making additional capital investment.
Further, we are also summarizing following components for our selected product to be launched at $ 370 per unit:
(a) Annual Fixed costs = 6, 32, 10,000
(b) Total variable cost per unit = 248.001
(c) Contribution margin per unit = 122
(d) Breakeven point = 5, 18,115
2. Scenario Analysis
(i) Scenario 1: Product “Redesign” at to be sold at $425 per unit and capacity at 500,000 units
    Particulars
    Low end demand at 235000 units
    High end demand restricted to 5,00,000 units
    Revenue (selling price 425 per unit)
     9,98,75,000
     21,25,00,000
    Less: Variable costs
     
     
    Material cost (148.75 per unit)
     3,49,56,250
     7,43,75,000
    Labour cost (3 hours per unit paid at 27.5 per hour)
     1,93,87,500
     4,12,50,000
    Sales commission (Refer note 1)
    4375823.68
    9310263.15
    Contribution (Revenue- Total variable costs)
     4,11,55,426
     8,75,64,737
    Less: Fixed costs
     
     
    Management salary (1,00,000 p.a. to a manager)
    300000
    300000
    Supervisor salary (75,000 p.a. to a supervisor)
    750000
    750000
    Marketing expense
    160000
    160000
    Operating profit before depreciation (Contribution- total fixed costs)
     3,99,45,426
     8,63,54,737
    Depreciation
    60000000
    60000000
    Operating profit after depreciation
     (2,00,54,574)
     2,63,54,737
    Note 1: Calculation of purchase price per unit
    
    Material per unit
    148.87
    Labour per unit
    82.5
    Direct sales commission per unit
    0.05x
    Fixed costs
    122.42
    Total purchase price
     x
    
    
    x = 353.79+0.05x
    
    0.95x = 353.79
    
    x = 353.79/0.95
    
     = 372.4105263
    
    
    
    Now , direct sales commission per unit
    18.62052632
    
    
    Note 2: Average operating profit
    
    Total operating income of 5 years at 235000 units
     -10,02,72,868
    Total operating income of 5 years at 500000 units
     13,17,73,684
    
    
    Average operating profit
     1,57,50,408
Operating leverage (OL) = Contribution margin/operating income
At 2, 35,000 units = 4, 11, 55,426 / (2, 00, 54,574)
= -2.05
At 5, 00,000 units = 8, 75, 64,737/ 3.322542637
= 3.32
Here, operating at low production will result in operating loss and fixed costs are not covered.
(ii) Scenario 2: Product “Redesign” at to be sold at $370 per unit and expand capacity to 7, 50,000 units
    Particulars
    Low end demand at 375000 units
    High end demand restricted to 7,50,000 units
    Revenue (selling price 370 per unit)
     13,87,50,000
     27,75,00,000
    Less: Variable costs
     
     
    Material cost (148.75 per unit)
     5,57,81,250
     11,15,62,500
    Labour cost (3 hours per unit paid at 27.5 per hour)
     3,09,37,500
     6,18,75,000
    Sales commission (Refer note 1)
    6236842.10
    12473684.21
    Contribution...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here