a. Compute a three-week moving average forecast for the arrival of medical clinic patients in week 4. The numbers of arrivals for the past 3 weeks were as follows: Week Patient Arrivals1 4002 3803 411 b. If the actual number of patient arrivals in week 4 is 415, what is the forecast error for week 4?c. What is the forecast for week 5?
Q: Given an actual demand of 103, a previous forecast value of 99, and an alpha of .4, the exponential…
A: Forecast using the exponential smoothing method: Demand for current period = 103 Forecast for…
Q: Rosa’s Italian restaurant wants to develop forecasts of daily demand for the next week. Th e…
A: Solution - Given that Day Week 1 Week 2 No of Customers No of Customers Tuesday 52 48…
Q: 5-15 Develop a 4-month moving average forecast for Wallace Garden Supply, and compute the MAD. A…
A:
Q: Below is data of lobster sales volume from a seafood company. We're are using exponential smoothing…
A: Forecasting is the process of estimating future demands using previous or historic information and…
Q: Problem 4 - do both a three period moving average and an exponential smoothing forecast with an…
A: Forecasting is the process of predicting the future demand based on the previous data and demand.
Q: Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing…
A:
Q: Consider the following actual (A,) and forecast (F,) demand levels for a commercial multiline…
A: The forecast for period 5 can be computed as follows:
Q: A number of factors must be taken into consideration when selecting a particular forecasting model.…
A: A.The determination of a technique relies upon numerous elements—the setting of the estimate, the…
Q: B: Find forecasting error from the following table by using Tracking Signal. Period Actual…
A: The difference in predicted and actual demand values is known as the forecasting error and it is…
Q: Three months ago Two months ago Last month 400 units 350 units 320 units a. Using a simple…
A: Exponential smoothing is a forecast method based on time series with focus on uni-variate data.…
Q: 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to…
A: Note: - Since we can answer only up to three subparts we will answer the first three(a, b, and c)…
Q: John's House of Pancakes uses a weighted moving average method to forecast pancake sales. It…
A: Weighted moving average:In weighted moving average equal weights are assigned to all periods in the…
Q: a) Graph the seasonal data and attach the graph to this page. b) Determine the slope for each day of…
A: The regression equation is of the form y=mx+b where, y is the value of a dependent variable, m is…
Q: 3. You are using a 3 period moving average to calculate your forecast. Demand for period 1 was 90…
A: Given information:Demand period 1=90unitsDemand period 2=80unitsDemand period4=90unitsHere we have…
Q: When a new busines is startered, or a patent idea needs fundig, venture capitalst or investment…
A: Whenever a new business is initiated, funding forms the pre-requisite and approaching to the venture…
Q: a) Compute MAD and MAPE for management's technique. b) Do management's results outperform (i.e.,…
A: MAD stands for mean absolute deviations MSE stands for mean squared error.
Q: orecast demand for each week, including week 10, using exponential smoothing with a 5 .5 (initial…
A: Exponential smoothing is forecasting method which identifying the farecasting value based on the…
Q: 5. (a) When a new business is started, or a patent idea needs funding, venture capitalists or…
A: The process used to predict future data and analysis of the trend is known as forecasting. With the…
Q: Calculate the forecast for week 16 using - a 2-period moving avergage - a 3-period moving average
A: Forecasting means predicting in advance the future sales.
Q: Using seasonal relatives. Apple’s Citrus Fruit Farm ships boxed fruit anywhere in the world.…
A:
Q: Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: why forecasting is needed in business a. to ascertain resource requirements b. to project profit…
A: Forecasting is a form of making knowledgeable predictions by utilizing historical data as the major…
Q: Explain how can does the number of periods in a moving average affect the responsiveness of the…
A: Moving Average (MA) forecasting calculates the average over a certain number of periods in order to…
Q: Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast…
A: This question is related to the topic- Forecast approaches and This Topic falls under Operations…
Q: Describe three different forecasting applications at Hard Rock.Name three other areas in which you…
A: Introduction: Hard Rock Cafe is a restaurant chain which is founded in the year 1971 in London and…
Q: Assume that the actual sales volume were 1,800; 2,000; 1,700; 1,600; 1,900; and 2,100 for Days 1 to…
A:
Q: Forecasting Historical records show the past ten Hood Lacrosse games having the following…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average…
A: Find the given details below: Given details: Week Demand 1 300 2 360 3 410 4 289 5…
Q: Using exponential smoothing with a weight ex of 0.6 on actual values: (a) if sales are $45,000 and…
A: Therefore, the forecast in 2012 is $48,000.
Q: Given below are the demands of a certain product over the past 10 weeks. Week | 1 | 2 | 3| 4 | 5 6 |…
A: Since you have submitted multiple questions with multiple subparts as per guidelines I have answered…
Q: a) Calculate the three-period moving-average forecast for periods 7 through 10. Three-period Period…
A: Given data is
Q: Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14 15 11 18 13 Using the…
A: Given information, Week Value 1 18 2 14 3 15 4 11 5 18 6 13 Total week = 6
Q: A) Forecast the number of kilometers for years 3-6 using an exponential smoothing method (a = 0.1).…
A: Below is the solution
Q: a) Forecast demand for each week, including week 10, using exponential smoothing with a 5 .5…
A: Below is the solution:-
Q: 6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing…
A: Error = Real demand - Forecast Absolute Error = Positive value of Error Error Square = square of…
Q: hundred bolts. Workers can be assigned to other jobs if production is less than regular. The…
A: given,
Q: a. Compute a weighted average forecast using a weight of 0.4 for the most recent period, 0.3 for the…
A: A weighted moving average forecast is a forecast of future values based on past values. A weighted…
Q: The last four weekly values of sales were 120, 90, 100, 80 and 85 units. The last four forecasts for…
A:
Q: The Handy-Dandy Department Store had forecast sales of $110,000 for the previous week. The actual…
A: At=αDt+ 1-αAt-1=0.1130,000+1-0.1110,000=13,000+99,000=112,000 Hence, the forecast for the week is…
Q: Given the actual demand of 300, the previous forecast of 300, and an alpha of 0.048 , which one of…
A: The actual demand =300 The previous forecast = 300 Alpha = 0.048
Q: a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in…
A: Below is the solution:-
Q: Interpret the MAD of the most accurate among the forecasting models below. A. Naïve approach; B.…
A: Find the Given details below: Given Details: Month Demand (100 Liters) 1 39 2 47 3 39 4…
Q: Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Use a…
A: Given data; Three months actual demands are 200,350,287. Fourth month actual demand = 300
Q: 9. For a specific model of a shoe brand, Carrefour (NIZWA) experienced a sales of 1000 units, 1100…
A: Formulas used: Weighted moving average = ∑widi where w is the weight. d is the actual demand/sales i…
Q: Forecast based on averages. Given the following data: Period Number of Complaints 1 70 2 75 3…
A: Forecast for Period 6 using weighted average = 0.5*Demand of Period 5 + 0.3*Demand of Period 4 +…
Q: Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003…
A: given,
Q: 1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows.…
A: Find the Given details below: Given details: Week Auto Demand Weights 1 9 0.1 2 11 0.3 3…
a. Compute a three-week moving average
Week Patient Arrivals
1 400
2 380
3 411
b. If the actual number of patient arrivals in week 4 is 415, what is the forecast error for week 4?
c. What is the forecast for week 5?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- Under what conditions might a firm use multiple forecasting methods?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. 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.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?
- 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?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
- 1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…4 Trinity General Hospital had the following number of patient admissions during the past 8 weeksWeek Patient Admissions1 1202 1453 954 1125 1306 1107 1008 140 a. Develop a 3-week weighted average forecast forWeek 4 through 9 with weightsW1 = 0.2W2 = 0.3W3 = 0.5 b. Forecast patient admissions for week 9 using simpleexponential smoothing with α = 0.2. Assume that the forecast for Week 2 (F2) is the naïve forecast.Using naïve method to make a forecast involving data with trend, the forecasted sales volume for week 4 must be ________ units if the actual sales are 500, 510, and 508 in weeks 1, 2, & 3, respectively: * o 506 o 508 o 510 o 500
- The Hartley-Davis motorcycle dealer in the Minneapolis– St. Paul area wants to be able to forecast accurately the de-mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated thedata in the following table for the past year. a. Compute a three-month moving average forecast ofdemand for April through January (of the next year).b. Compute a five-month moving average forecast forJune through January.c. Compare the two forecasts computed in parts (a) and(b) using MAD. Which one should the dealer use forJanuary of the next year? Month Motorcycle SalesJanuary 9February 7March 10April 8May 7June 12July 10August 11September 12October 10November 14December 1610 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 What is the forecast for day 4 using a 3-period moving average model? (1 mark) (Round to two decimal places). 11 What is the forecast for day 5 using a 3-period moving average model? (Round to two decimal places). 12 What is the forecast for day 6 using a 3-period moving average model? (1 mark) (Round to two decimal places). 134 Trinity General Hospital had the following number of patient admissions during the past 8 weeks Patient Week Admissions 1 120 145 3 95 4 112 5 130 6. 110 7 100 140 Develop a 3-weck weighted average forecast for Week 4 through 9 with weights a W1 = 0.2 W2 = 0.3 W3 = 0.5 Forecast patient admissions for week 9 using simple | exponential smoothing with a = 0.2. Assume that the forecast for Week 2 (F2) is the naïve forecast.