This company plans to enter a new market next year and asks you to estimate the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This company plans to enter a new market next year and asks you to estimate the customer demand in year 2023. You get the past 5-year demand information as below which has been quickly increasing. As an initial simple try, you adopt exponential smoothing. (Q3-1) (4) What is your best choice of the "alpha" value out of (0.2, 0.5, 0.8) and what is the reason? (Q3-2) (4) Write down the table below and assume "alpha" = 0.8 now. Find the forecasts for 2019-2023 showing your detailed computations. Year 2018 2019 2020 2021 2022 2023 Actual Demand 1,500 2,000 2,400 3,000 3,500 Forecast 1,450 MAD Tracking Signal (Q3-3) (4) Find the MAD (mean absolute deviation) in 2022 for 2019~2022 forecasts. (Q3-4) (4) Find the Tracking Signal in 2022 for 2019-2022 forecasts. (Q3-5) (4) What can you say about your forecasting method based on the Tracking Signal? How can you improve your forecasts using exponential smoothing considering Tracking Signal? (Q4) (6) You realize that the past customer demand data values are actually sales volumes instead of true demand. Thus, as a consultant, you decide to explain the importance of demand unconstraining process in the future forecast tasks in the client company. For more accurate future "demand" forecasts, list up 2 reasons that we should not use past "sales" data without careful processing. (Q5) (6) They want to develop their approximate inventory management plan from year 2023 in the new market after they start a long-term business there. They consider a fixed-quantity ordering model by which they place an order of the same quantity each time. They guess that monthly demand is uniformly distributed in [200,400] and independent between months. When the transportation lead time to the new market is 1 month, what is the optimal reorder point to achieve 90% service level for the uncertain demand? (Q6) (6) They also ask you to analyze their production quality for an oil product. In each 1 kg of this product, a specific chemical element's weight in gram should be in the range of [0.99,1.01] according to their quality specification. You take many samples over time and find that the sample weight follows a normal distribution with the mean μ = 1.002 gram and the standard deviation = 0.004 gram. (Q6-1) (3) What is the process capability index for this production process? (Q6-2) (3) What is the probability that they produce defective oil? (Hint: For a normal random variable X, Pr(|X->o) = 31.73 % , Pr( | X-μ| > 20) = 4.55%, Pr ( | X-μ| >30) = 0.27%.) This company plans to enter a new market next year and asks you to estimate the customer demand in year 2023. You get the past 5-year demand information as below which has been quickly increasing. As an initial simple try, you adopt exponential smoothing. (Q3-1) (4) What is your best choice of the "alpha" value out of (0.2, 0.5, 0.8) and what is the reason? (Q3-2) (4) Write down the table below and assume "alpha" = 0.8 now. Find the forecasts for 2019-2023 showing your detailed computations. Year 2018 2019 2020 2021 2022 2023 Actual Demand 1,500 2,000 2,400 3,000 3,500 Forecast 1,450 MAD Tracking Signal (Q3-3) (4) Find the MAD (mean absolute deviation) in 2022 for 2019~2022 forecasts. (Q3-4) (4) Find the Tracking Signal in 2022 for 2019-2022 forecasts. (Q3-5) (4) What can you say about your forecasting method based on the Tracking Signal? How can you improve your forecasts using exponential smoothing considering Tracking Signal? (Q4) (6) You realize that the past customer demand data values are actually sales volumes instead of true demand. Thus, as a consultant, you decide to explain the importance of demand unconstraining process in the future forecast tasks in the client company. For more accurate future "demand" forecasts, list up 2 reasons that we should not use past "sales" data without careful processing. (Q5) (6) They want to develop their approximate inventory management plan from year 2023 in the new market after they start a long-term business there. They consider a fixed-quantity ordering model by which they place an order of the same quantity each time. They guess that monthly demand is uniformly distributed in [200,400] and independent between months. When the transportation lead time to the new market is 1 month, what is the optimal reorder point to achieve 90% service level for the uncertain demand? (Q6) (6) They also ask you to analyze their production quality for an oil product. In each 1 kg of this product, a specific chemical element's weight in gram should be in the range of [0.99,1.01] according to their quality specification. You take many samples over time and find that the sample weight follows a normal distribution with the mean μ = 1.002 gram and the standard deviation = 0.004 gram. (Q6-1) (3) What is the process capability index for this production process? (Q6-2) (3) What is the probability that they produce defective oil? (Hint: For a normal random variable X, Pr(|X->o) = 31.73 % , Pr( | X-μ| > 20) = 4.55%, Pr ( | X-μ| >30) = 0.27%.)
Expert Answer:
Answer rating: 100% (QA)
Q31 Best choice of alpha value and reason The choice of the alpha value depends on the desired level of responsiveness to recent changes in demand A higher alpha value places more weight on recent obs... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
An application program is executed on a nine-computer cluster. A benchmark program took time T on this cluster. Further, it was found that 25% of T was time in which the application was running...
-
There are many tablets on the market today. They all serve different purposes for the user's needs. Should Colleges and Universities go digital with books and tablets to the student body? Discuss.
-
Discuss critically, with your own supporting examples, the effects of technology on organisation structure.
-
On October 1, 2020, New Co. issued an eight-year, \(6 \%, \$ 1,000\) bond at face value, with cash interest payable semiannually on April 1 and October 1. Required Provide journal entries to be made...
-
On December 31, 2014, Hattie McDaniel Company had $1,200,000 of short-term debt in the form of notes payable due February 2, 2015. On January 21, 2015, the company issued 25,000 shares of its common...
-
lesson 9 homework help. Assume that, in the same month in which RVEC purchased the plant in problem 3, it sold the same plant for $1,050,000. Prepare for the four journal entries necessary to account...
-
Your client, Leona Ledford, was personally served with a summons and complaint on October 23 in the case of Masters v Ledford Her answer is due in 30 days. You will mail the answer to the court. What...
-
How does agile change the scoping and sequencing of a project? How does agile influence projects differently from a regular project?
-
Willoughby Wooster plc has a total issued share capital of 1,000,000 in 25p shares. The company decid to make a rights issue of 1 for 2 at a price of 2.70 per share. How much will the holder of...
-
Raymond was one of the two male nurses working in an ICU in an inner-city hospital. The nurse manager always put him in charge of the ICU whenever he worked his twelve-hour shift. When Raymond was in...
-
1 The anatomical position is when a person is standing straight, feet pointing forward, the arms hanging down besides the body and the palms of the hands facing forward. One can describe the...
-
Compare and contrast the revenue recognition criteria in the two different industries: ( i ) Sale of goods in a supermarket and ( ii ) Construction services. Explain specifically in context to the...
-
Olsen Outfitters Inc. believes that its optimal capital structure consists of 70% common equity and 30% debt, and its tax rate is 25%. Olsen must raise additional capital to fund its upcoming...
-
3. (a) Maendeleo Co., a U.S. firm plans to use a money market hedge to hedge its payment of 5 million Australian dollars for Australian goods in one year. The U.S interest rate is 6 percent, while...
-
Select a mass spectrometric technique with the highest mass resolution for identifying an unknown compound being eluted from a liquid chromatography column
-
Three years of combined data for two firms appear below (in millions). One of these firms is FedEx, a relatively high-growth firm that provides courier services, and the other is Kellogg Company, a...
-
Tesla Motors manufactures high-performance electric vehicles that are extremely slick looking. Exhibit 3.18 presents the statement of cash flows for Tesla Motors for 2010 through 2012. REQUIRED...
-
Aer Lingus is an international airline based in Ireland. Exhibit 3.24 provides the statement of cash flows for Year 1 and Year 2, which includes a footnote from the financial statements. Year 2 was...
-
RJR Nabisco also had $10 billion in bonds outstanding at the time of the dividend increase in Problem 10. How would you expect the bonds to react to the announcement? Why? Reference from in problem...
-
To examine how much cash your firm has returned to its stockholders and in what form (dividends or stock buybacks) and to evaluate whether the trade-off favors returning more or less. Key Questions ...
-
To estimate earnings and cash flows on a typical project for the firm. Key Questions: 1. Does your firm have a typical investment? 2. If so, can you estimate the earnings and cash flows on a typical...
Study smarter with the SolutionInn App