3. You are using a 3 period moving average to calculate your forecast. Demand for period 1 was 90 units, and demand for period 2 was 80 units. The forecasted demand for period 4 was 90 units using a 3 period moving average. What was the ACTUAL demand in period 3?
Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10…
A: Formulae used: Exponential smoothing Forecast formula: F(t+1)= Ft+α*(At-Ft) Where,α = Smoothing…
Q: The table below comprises of demand from the last 10 months: Month Demand 1 31 2 34 3 33…
A: The answers is provide in given below. If it is useful to you, Please like it.Explanation:Step…
Q: Given the following data, use exponential smoothing (a=0.10) to develop a demand forecast. Assume…
A: Exponential smoothing is time series method which uses for forecasting univariate time series data.…
Q: Answer the following: 1. Suppose that the demand in period 1 was 7 units and the demand in period 2…
A: all of the answer is in the explanationExplanation:1. given: α=0.2Ft+1= α (At) + (1-α)Ft= 0.2 (At) +…
Q: The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 6. 7 8 10…
A:
Q: Apply the appropriate forecasting tools and techniques in predicting product demand using OM…
A: Demand forecasting is the assessment of likely future demand for an item or administration. The term…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: Given data is
Q: What will be the demand forecast for period t? (Keep one decimal place in your answer).
A: The weighted average moving forecast is a technique that is used to predict the future of a…
Q: Harlen Industries Limited has a simple forecasting model whose forecast demand has been plotted…
A: In this question, we have the table data for an 8 periods duration, for each period, we have actual…
Q: ) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Consider the following actual and forecast demand levels for Big Mac hamburgers at a local…
A: The Formula for exponential smoothing forecast is:Ft+1 = Yt + ( 1 - ) FtHere, Ft+1 is the Forecast…
Q: What should be our forecast accuracy target if there is a high degree of volatility in customer…
A: Forecasting is the process of estimating the future demand according to the historic or previous…
Q: Actual demand for a product for the past three months was: Three months ago 400 units Two months…
A: Month Actual demand3 months ago4002 months ago350Last month325
Q: Clinic administrator Marc Schniederjans wants you to forecastpatient demand at the clinic for week 7…
A: Weighted moving average=∑Weight for period nDemand for period…
Q: What are the advantages and disadvantages of aggregating demand from a forecasting view? Are there…
A: Forecasting is the process that is used by the organization for determining the uncertainties of…
Q: XYZ Chips Inc. (XCI) produces Centrino-type chips. The market has been inclining with ups and downs…
A: Forecasting Technique we are using here is Moving average forecasting Technique: A moving average is…
Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…
A: Mean Absolute Deviation (MAD) is one of the measures used to summarize historical errors in…
Q: Please do not give solution in image format thanku supose that the demand in period 1 was 7 units…
A: Formula: For Exponential Smoothing F(t+1) = alpha*D(t) + (1-alpha)*F(t) F(t+1) = Forecast in t+1…
Q: Sunrise is planning its purchases of ingredients for bread production. If bread demand had been…
A: Exponential smoothing could be a statistic statement technique for univariate information that may…
Q: Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round…
A: Find the Given details below: Given details: Month Profit ($) Jan-14 $ 15,810…
Q: Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past…
A: Find the given details below:
Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10…
A: Given, Week Demand 1 20 2 23 3 27 4 37 5 26 6 30 7 35 8 22 9 24 10 29…
Q: National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a…
A: Note: - Since we only answer up to 3 sub-parts, we’ll answer the first3. Please resubmit the…
Q: No singal forecast methodology is appropriate under all conditions: True or false?
A: Forecasting is a method that utilizes authentic information as contributions to make educated…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: Using past data as inputs, forecasting is a process that produces accurate predictions of the future…
Q: After using your forecasting model for six months, you decide to test it using MAD and a tracking…
A: Formula: Tracking Signal = RSFE / Mean Absolute Deviation (MAD) RSFE = Cumulative deviation…
Q: The forecast for Monday was derived by observing Monday's demand level and setting Monday's…
A: Forecasting can be done by various methods like moving averages, exponential smoothing, weighted…
Q: Community General Hospital finds itself treating many bicycle accident victims. Data from the last…
A: To calculate the exponentially smoothed forecast using the given data and the alpha value of 0.31,…
Q: Compute MAD for each set of forecasts. Given your results, which forecast appears to be more…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Given an actual demand this period of 90, a forecast for this period of 58, and an alpha of 0.2,…
A: Given, This period demand = 90 This period forecast = 58 Alpha value = 0.2
Q: Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what…
A: Forecasting is knowing the part of future events by making predictions and estimates based on…
Q: The following table shows the actual demand observed over the last 11 years:…
A: A 3-year moving average forecast is a simple moving forecast where weights are not considered and…
Q: The following table shows the actual demand observed over the last 11 years: 1 Year Demand 7 2 9…
A: In the Exponential smoothing forecast, a factor known as the smoothing constant is used which gives…
Q: Suppose that the demand in period 1 was 7 units and the demand in period 2 was 9 units. Assume that…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…
A: Ans) Formula:
Q: The manager of a travel agency asked you to come up with a forecasting technique that will best fit…
A: Given - Smoothing constant (α) = 0.25 Period Demand F1 F2 1 115 - - 2 176 - - 3 97 146…
3. You are using a 3 period moving average to calculate your
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- Under what conditions might a firm use multiple forecasting methods?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?
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?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 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?The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?PLEASE HELP ME WITH THIS EXERCISE SO THAT I CAN LEARN HOW TO SLOVE
- Suppose a four period weighted average is being used to forecast demand. Weights for the periods are: Wt-4 = 0.1 Wt-3 = 0.2 Wt-2 = 0.3 Wt-1 0.4 Demand observed in the previous four periods was: At-4 = 325 At-3 = 361 At-2 = 478 At-1 = 400 What will be the demand forecast for period t? (Keep one decimal place in your answer).Clinic administrator Marc Schniederjans wants you to forecastpatient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this fore-cast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two peri-ods ago, and 0.167 three periods ago. a) What is the value of your forecast? PXb) If instead the weights were 20, 15, 15, and 10, respectively, howwould the forecast change? Explain why. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respec-tively? Now what is the forecast for week 7?XYZ Chips Inc. (XCI) produces Centrino-type chips. The market has been inclining with ups and downs during the last eight years because of its new chips. The demands over the last 12 periods were 95, 115, 130, 122, 105, 125, 140, 134, 125, 142, 160, and 153 thousand pieces. Forecast the demand for the next 4 periods (periods 13 to 16) using an appropriate forecasting technique.
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)