OPEARATIONS MANAG.REV CUSTOM 2017
17th Edition
ISBN: 9781323590058
Author: Pearson
Publisher: PEARSON C
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem 16P
Solved example 4.1
Sales of Volkswagen’s popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). The sales manager had predicted before the new model was introduced that first year sales would be 410 VWs. Using exponential smoothing with a weight of α =.30, develop forecasts for years 2 through 6.
| YEAR | SALES | |
| 1 | 450 | 410 |
| 2 | 495 | |
| 3 | 518 | |
| 4 | 563 | |
| 5 | 584 | |
| 6 | ? |
• 4.16 Refer to Solved Problem 4.1.
- a. Using the trend projection (regression) method, develop a forecast for the sales of Volkswagen Beetles in Nevada through year 6.
- b. What is the MAD?
- c. What is the MSE?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
QUESTION 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 expenses
Question 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
3412M4
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
17
Chapter 4 Solutions
OPEARATIONS MANAG.REV CUSTOM 2017
Ch. 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. 26PCh. 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. 31PCh. 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 - CEO John Goodale, at Southern Illinois Power and...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 - Question 4.49 Boulanger Savings and Loan is proud...Ch. 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_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.arrow_forward
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?arrow_forward25. What is this year's forecast using exponential smoothing with alpha = 0.4, if smoothed forecast was 2,600? A. 2,680 B. 2,808 C. 2,760 D. 3,128 E. 3,160 year 2007'sarrow_forwardQuestion 1 a. Jason Ltd. operates a store in the Byera area and sells a special brand of cologne to customers in the surrounding areas. The manager of the store has been tracking the sales of the cologne for the last ten years. Table 1 below gives information about the sale of this product. Table 1 Year Sales 2014 90 2015 110 2016 127 2017 165 2018 190 2019 220 2020 275 2021 390 2022 320 2023 350 i. Assuming a linear trend, use the tabular method to derive the values for:- 11. 111. iv. I. the slope II. the intercept Formulate the linear equation for this problem. Plot the linear equation line on a graph. Develop a forecast for the store's sales for the next year. b. Ann's department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.5, and an initial forecast of 30.0 for period 1. Table 2 Period Demand 1 24 2 23 3 26 4 36 5 26arrow_forward
- If the forecasted value of the time series variable for one period is 28.5 and the actual value observed for the same period is 32, what is the forecast error for that period? Question 19 options: 3.5 2 -3.5 4arrow_forward» 95 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80 + 25t where Ft = Annual sales (000 bottles), t is in years. Predict annual sales for year 6? 170 230 10 % 6 52 min 42 secsarrow_forwardQUESTION 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.arrow_forward
- Q 6 Identify two business situations where the Delphi method might be used to generate forecasts. Can you think of any difficulties and pitfalls associated with using the Delphi method?arrow_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_forwardPeriod Actual Forecast Error Abs Error 1 35 40 -5 5 2 38 37 1 1 3 45 41 4 4 4 39 43 -4 4 5 44 42 2 2 6 49 45 4 4 7 46 48 -2 2 8 46 48 -2 2 9 52 47 5 5 10 57 52 5 5 Sum 451 443 8 34 Average 45.1 44.3 0.8 3.4 Calculate the Tracking Signal to two decimal places.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License