Mylab Operations Management With Pearson Etext -- Access Card -- For Operations Management: Sustainability And Supply Chain Management (13th Edition)
13th Edition
ISBN: 9780135225899
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 29P
Question
• 4.33 The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows:
| YEAR | DISK DRIVES |
| 1 | 140 |
| 2 | 160 |
| 3 | 190 |
| 4 | 200 |
| 5 | 210 |
- a.
Forecast the number of disk drives to be made next year using linear regression. - b. Compute the mean squared error (MSE) when using linear regression.
- c. Compute the mean absolute percent error (MAPE).
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales:
Year
Quarter
Sales (millions of dollars)
1
1
9.2
1
2
5.4
1
3
4.3
1
4
14.1
2
1
10.3
2
2
6.4
2
3
5.4
2
4
16.0
Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
QUESTION 4
Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series:
Quarter
Seasonal Index
Q1
72.4
Q2
85.3
Q3
109.6
Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below:
Coefficients
Intercept
2,506
Time
71.3
If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
Chapter 4 Solutions
Mylab Operations Management With Pearson Etext -- Access Card -- For Operations Management: Sustainability And Supply Chain Management (13th Edition)
Ch. 4 - Prob. 1EDCh. 4 - What is a qualitative foretasting model, and when...Ch. 4 - Identify and briefly describe the two general...Ch. 4 - Identify the three forecasting time horizons....Ch. 4 - Briefly describe the steps that are used to...Ch. 4 - A skeptical manager asks what medium-range...Ch. 4 - Explain why such forecasting devices as moving...Ch. 4 - What is the basic difference between a weighted...Ch. 4 - What three methods are used to determine the...Ch. 4 - Research and briefly describe the Delphi...
Ch. 4 - What is the primary difference between a...Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Which forecasting technique can place the most...Ch. 4 - In your own words, explain adaptive forecasting.Ch. 4 - What is the purpose of a tracking signal?Ch. 4 - Explain, in your own words, the meaning of the...Ch. 4 - What is the difference between a dependent and an...Ch. 4 - Give examples of industries that are affected by...Ch. 4 - Give examples of industries in which demand...Ch. 4 - Prob. 21DQCh. 4 - The following gives the number of pints of type B...Ch. 4 - 4.2 a. Plot the above data on a graph. Do you...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - The actual demand for the patients at Omaha...Ch. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Consider the following actual and forecast demand...Ch. 4 - As you can see in the following table, demand for...Ch. 4 - Following are two weekly forecasts made by two...Ch. 4 - Refer to Solved Problem 4.1 on page 138. a. Use a...Ch. 4 - Solved example 4.1 Sales of Volkswagens popular...Ch. 4 - Refer to Solved Problem 4.1. Using smoothing...Ch. 4 - Consider the following actual (At) and forecast...Ch. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Question 4.20 Resolve Problem 4.19 with =.1 and ...Ch. 4 - Question 4.21 Refer to the trend-adjusted...Ch. 4 - Question 4.22 Refer to Problem 4.21. Complete the...Ch. 4 - Question 4.23 Sales of quilt covers at Bud Baniss...Ch. 4 - Question 4.24 Mark Gershon, owner of a musical...Ch. 4 - Question 4.25 The following gives the number of...Ch. 4 - Prob. 25PCh. 4 - Question 4.27 George Kyparisis owns a company...Ch. 4 - Question 4.28 Attendance at Orlandos newest...Ch. 4 - Question 4.29 North Dakota Electric Company...Ch. 4 - Lori Cook has developed the following forecasting...Ch. 4 - Prob. 45PCh. 4 - Question 4.32 The following data relate the sales...Ch. 4 - Question 4.33 The number of internal disk drives...Ch. 4 - Question 4.34 The number of auto accidents in...Ch. 4 - Question 4.35 Rhonda Clark, a Slippery Rock,...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - Question 4.38 City government has collected the...Ch. 4 - Dr. Lillian Fok, a New Orleans psychologist,...Ch. 4 - Using the data in Problem 4.39, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.43, forecast...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Thirteen students entered the business program at...Ch. 4 - Question 4.47 Storrs Cycles has just started...Ch. 4 - Question 4.48 Dave Fletcher, the general manager...Ch. 4 - Prob. 35PCh. 4 - Prob. 36PCh. 4 - Prob. 37PCh. 4 - Prob. 38PCh. 4 - Prob. 39PCh. 4 - Prob. 40PCh. 4 - Prob. 41PCh. 4 - Prob. 42PCh. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Prob. 58PCh. 4 - Prob. 61PCh. 4 - Case study Southwestern University: (B) This...Ch. 4 - Case study Southwestern University: (B) This...Ch. 4 - Southwestern University: (B) This integrated case...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Under what conditions might a firm use multiple forecasting methods?arrow_forwardQUESTION 2 The number of patients coming to the Healthy Start Maternity clinic has been increasing steadilyover the past eight months. You are provided with some historical data as follows: Month Clinic attendance (in thousands)1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7 a. Identify and give a brief explanation of the:-i. Dependent variableii. Independent variable b. Use simple linear regression to forecast annual demand for months 9 and 10 by using thetabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation. iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.arrow_forwardQuestion 3: Jane is trying to forecast demand for her store, using moving average with n=2, Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000 E Enroll- Year Quarter ment Forecast Error Abs Error 1997 313 3. 2 285 4 3 312 5. 4 339 6. 1998 1 359 7 320 356 385 6. 10 1999 396 367 11 397 12 423 13 14 2000 1 15 2000 3412M4arrow_forward
- Question 3 An organization uses a business intelligence system to predict products that tend to be purchased together. This is an example of. O A) Regression Analysis B) Cluster Analysis C) REM Analysis D) Market Basket Analysisarrow_forwardQuestion 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.arrow_forwardQuestion 03 Suppose you sell stylish leather bags targeting young office going people who can use your bags to carry laptops and necessary stuff. You have already launched leather bags in February of this year and now based on the demand results of last 7 months, you want to predict the demand for your bags for the month of September. Hence, you want to select the right forecasting techniques and you are considering 2 period Moving Average, Naive technique and Exponential Smoothing (use any value between .10 - .15 as the value of alpha). Now figure out the better forecasting technique among 2 period Moving Average, Naive technique and Exponential Smoothing by doing the error calculation with the help of MAD, MSE, MAPE. Period Demand 2period Moving Average (Demand forecast) Naive technique (Demand forecast) Exponential Smoothing (Demand forecast) February 70 75 ** ** March 74 78 ** ** April 80 ** ** ** May 88 ** ** ** June…arrow_forward
- Q4 ABC University wants to develop forecasts for next year's quarterly enrollment. It has collected quarterly enrollments for the past two years. It has also forecast total annual enrollment for next year to be 95,000 students. What is the forecast for each quarter of next year? Enrollment (in 000') Quarter Year 1 Year 2 Fall 24 25 Winter 23 22 Spring 18 19 Summer 15 17arrow_forwardQuestion DEMAND FOR FERTILIZER YEAR (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the exponential smoothing model or the weighted average model developed? Explain your answer.arrow_forwardQUESTION 8 You are given the following information, comprising of an individual's expenses for the year 2015. Use the information provided hereunder to answer the following questions. Month January February March April May June July August September October November December Expenses 1977 820 970 1082 1220 1281 1546 1788 895 1108 1824 1954 a) Determine the expenses forecast using a two (2) period moving average. Calculate the MAD and MSE. b) Determine the expenses forecast using a two (2) period weighted moving average. Use 0.8 & 0.2 for the weights of the most recent and second most recent periods respectfully. Calculate the MAD and MSE. c) Develop an exponential smoothing forecast using a=0.2. Assume the forecast for the first month is the actual expenses for that month. Calculate the MAD and MSE. d) Developed a trend line to forecast expensesarrow_forward
- q. 14 Given the same data, calculate the CFE for when using a MA for this data. Tip: You will need to calculate the MA forecast for as many periods as possible before calculating the CFE. Group of answer choices a. 0 b. -1 c. 1 d. 2 e. -2arrow_forwardQuestion A reputable FMCG company is holding its Annual Sales Conference on January 30th 2021 for its New Year sales plan. The company is interested in launching new product beside its existing product lines. The new product will be novel in the history of the company. explain what FMCG company seeks for and following for above mentioned firm, with reason/limitations specified for the FMCG company. Discuss the techniques of forecasting that will be used by the company for its existing and new products. Explain specific type and reason for using those techniques. Also identify the limitations of these techniques. Use word/Excelarrow_forward2. The AirGo is the largest publicly listed low budget airlines company. On the negative side for the company, which spent billions of dollars in development costs, is the consistently negative cash flow due to poor prediction of its passengers. Question: Airlines company approaches you to suggest possible methods for an effective Forecast and it's Monitoring & Controlling. Help the airlines for the better prediction of its passengers.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Introduction to Forecasting; Author: Ekeeda;https://www.youtube.com/watch?v=5eIbVXrJL7k;License: Standard YouTube License, CC-BY