Operations Management: Sustainability and Supply Chain Management (12th Edition)
12th Edition
ISBN: 9780134130422
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 43P
Question
•• 4.24 Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Mark has collected the data shown in the following table:
- a. Graph these data to see whether a linear equation might describe the relationship between the group’s television shows and guitar sales.
- b. Use the least-squares regression method to derive a
forecasting equation. - c. What is your estimate for guitar sales if Maroon 5 performed on TV nine times last month?
- d. What are the correlation coefficient (r) and the coefficient of determination (r2) for this model, and what do they mean?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
1
2. 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.
Question
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.
Chapter 4 Solutions
Operations Management: Sustainability and Supply Chain Management (12th Edition)
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 - Prob. 22DQCh. 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.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 - Question 4.33 The number of internal disk drives...Ch. 4 - Dr. Lillian Fok, a New Orleans psychologist,...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 - Question 4.47 Storrs Cycles has just started...Ch. 4 - Question 4.49 Boulanger Savings and Loan is proud...Ch. 4 - Question 4.24 Mark Gershon, owner of a musical...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.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 - Using the data in Problem 4.39, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Thirteen students entered the business program at...Ch. 4 - Question 4.48 Dave Fletcher, the general manager...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 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
- 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 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_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 should Sharon do in this situation?arrow_forward
- Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniquesarrow_forwardQuestion content area Part 1 Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 450 2 510 3 516 4 555 5 575 Part 2 a) Forecasted sales for year 6 using the trend projection (linear regression) method are enter your response here sales (round your response to one decimal place). Part 3 b) The MAD for a linear regression forecast is enter your response here sales (round your response to one decimal place). Part 4 c) The MSE for the linear regression forecast is enter your response here sales (round your response to one decimal place).arrow_forwardPlease solve the question in the picture.arrow_forward
- Font Paragraph Styles Question 3 Consider the following from an estate agent's business nationally: Month Houses Sold Jan Feb Mar 380 360 390 Apr May June July Aug Sep Oct 400 390 380 394 454 460 460 Nov Dec 430 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) Define moving averages and how they're useful in forecasting (use Harvard referencing) c) At races, your horse, White Rum, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of 4 in coming 3rd. First place pays $5,000 to the winner, second place $4,000 and third place $1,350. Hence, is it worth entering the race if it costs $1050?arrow_forward(White A) QUESTION: "Successful Companies examine the future outcome using previous evidence."Does RMG in Bangladesh employ this forecasting technique in order for their business to continue?arrow_forwardQ 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_forward
- part barrow_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_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
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 LearningContemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN: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
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