Develop a set of decisions for each product in r and d

Assignment Help Case Study
Reference no: EM131100039

Forecasting and Best/ Worst Case Scenario Building

Class Exercise

In the simulation you need to balance two risks -- the risk of missed sales because of stock outs, and the risk of building too much inventory. In your worst case, competition is fierce and you end up carrying lots of inventory. In your best case, you sell everything but one unit on each product.The spread between these two positions represents a policy decision. In the worst case, you have lots of Inventory and little Cash. In the best case, you have the opposite, lots of Cash and little Inventory.

If you add the Balance Sheet's Cash and Inventory together, you get a sense for your reserves. A small reserve exposes you to both risks. But a big reserve in itself earns you nothing, not even bank interest. Therefore, you want to keep the reserve as small as possible. With a perfect forecast, your reserve could be tiny. The better your forecasting, the smaller the reserve you require.

Be aware that the computer's unit sales forecast is unreliable, because the computer does not know what competitors have done. Instead it assumes a mediocre product from every competitor in every segment. The computer's forecast is useful for sensitivity analysis. For example, if you drop price 10% and observed a 15% increase in unit sales, that relationship will hold - unless your competitors also drop the price 10%.

Therefore, you need to become proficient at forecasting, and should develop a method to develop a best/worst case for a product.

1. Using any of the methods discussed in class to forecast, develop a set of decisions for each product in R&D, Marketing, and Production. For example,

2. Next, predict a worst-case unit sales forecast for each product. That is, you want to be able to say, "This product's sales could not reasonably be any worse than this number of units." Enter the values in the "Your Sales Forecast" column.

3. Then, predict a best-case unit sales forecast for each product. That is, "This product's sales cannot be better than this number of units." On the production spreadsheet, produce enough so that your starting inventory plus the production will equal your best case forecast.

4. Examine your Balance Sheet. You should observe lots of Inventory and little or no Cash. If your Cash is negative, use Current Debt to bring Cash to a small positive. In your worst case scenario you have a little Cash and lots of Inventory.

5. Examine your Income Statement. You will observe worst-case sales and profits. This is as bad as it can get.

6. Save your decisions.

7. Return to the Marketing Spreadsheet. Enter your best case forecast. Observe that your Balance Sheet will now reflect lots of Cash and no Inventory. The Income Statement will show your best possible Sales (you are selling everything) and your best possible profits.

You are now prepared to answer some important questions. In your responsestake numbers from your spreadsheet's proformas:

1. Record Cash and Inventory from your worst case. How much do they total?

2. Record your best and worst case numbers for Sales. What is the spread between them? For example, in your worst case, total sales might be $120M. In the best, $150M. The spread is $150M - $120M = $30M. Another way to look at this would be in months of sales. $30M/$120M = .25 years or 3 months. Your policy, then, is to carry sufficient reserves to survive a three month build-up of inventory.

3. How much does this spread cost you? Idle cash could be used to pay down debt or improve plant. Inventory carry costs eat into profits. Estimate the cost of the spread as follows. Add together Cash and Inventory. Multiply this by your current short-term debt rate. Add the Inventory Carry Cost from your worst case. Record the result.

4. Suppose you narrowed the spread from say 3 months to 1 month. This would save you the cost of carrying large working capital reserves, but if you were wrong on the downside, you would run out of cash and take an emergency loan. What policy, expressed as months, would you set for your company's reserves?

Reference no: EM131100039

Questions Cloud

What is one new customer characteristic : What is one new customer characteristic that you can wrap into your future advertising messages? What is one interactive opportunity you can suggest for the product's existing and potential customer
Health and well-being experienced through literature : For this Assignment, you take on the role of a literary critic. The job of the critic is to read, question, and dissect the technical and substantive elements of a work of literature to gauge quality, effectiveness, and ability to convey informati..
Determining the real interest rate changes : Suppose that people expect the Fed to hit its inflation target. In the short run, if output growth is just 2 percent for two years and the equation determining the real interest rate changes to r=4.5-%^Y, what money growth rate should the Fed aim ..
Describe the audience and the music : Describe as many factors as possible: who/what/where/ when, how many musicians performed, what instruments did they play, name several of the musical pieces, how did they sound (use some of the terms we learned in the course), what did the musicia..
Develop a set of decisions for each product in r and d : Using any of the methods discussed in class to forecast, develop a set of decisions for each product in R&D, Marketing, and Production. Next, predict a worst-case unit sales forecast for each product.
Transferable skills reflection : A description of each of the transferable skills that you've chosen to demonstrate proficiency of for your exemplary portfolio project.
Analyse the characteristics of distributed and virtual teams : The learning objectives for this week are: Analyse the characteristics of distributed and virtual teams and Analyse leadership best practises and behaviour for distributed and virtual teams
Rate of inflation between : Suppose the consumer price index was 180.5 last year and this year is 202.2. What is the rate of inflation between last year and this year? What is the rate of inflation between the base year and this year?
Required rate of return on the second-year investment : Assume your required rate of return on the second-year investment is 11 percent; otherwise, you will choose to go with the 2-year security. What rationale do you offer for your preference?

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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