Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Use a three-month moving average to calculate a forecast for the fourth month. If the actual demand for month 4 turns out to be 300, calculate the forecast for month 5.
Q: Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using…
A: THE ANSWER IS AS BELOW:
Q: Calculate the simple 3-month moving average forecast for December - March
A: Given data is
Q: Explain the term “wrong” as it pertains to a good forecast?
A: In forecasting techniques, the word "wrong" refers to a difference between the real and forecasted…
Q: Does a correct forecast prove that your forecast method was correct? Why or why not?
A: Forecasting is important as it helps a business in setting the correct level of inventory, set the…
Q: Explain the word "false" for a successful forecast?
A: A difference between real and forecasted values is referred to as "fake" in forecasting strategies.…
Q: Calculate a two-month moving average for months two to seven. what would be your forecast for the…
A: Fn+1 = (An + An-1)/2 where F = ForecastA = Actual datan = Period
Q: a. Predict the sales for Jasmine Slush using the following forecasting methods: - naïve (use simple…
A: Forecasting is to predict the uncertain future of demand and sales. There are various methods to do…
Q: Explain in detail about Collaborative Planning, Forecasting and Replenishment (CPFR)?
A: Collaborative planning ,forecasting and replenishment - It is a process which combines several…
Q: Your manager is trying to determine what forecasting method to use. Based on the following…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Given a 3-quarter period of actual and forecast demand as shown in the table. The company ABC sets a…
A: A forecasting method is a managerial tool which help to predict the unknown future based on…
Q: (a) Compute a weighted average forecast for the data listed below using a weight of 0.40 for the…
A:
Q: QWE Inn has recorded the following number of rooms sold for the first quarter of the year:…
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
Q: A pizza chain has had sales for take-out food over the last four evenings—Monday, Tuesday,…
A: A naïve forecast uses the actual demand for the previous day as the forecast demand for the next…
Q: Although a demand forecast is usually not accurate, managers must forecast demand. In this context…
A: The answer is as below:
Q: Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing…
A:
Q: Daily high temperatures in st. Louis for the last week were as follows:…
A: Given information:Temperatures in last week is 33,33,38,36,43,23,28
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: Given data is
Q: Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, β=…
A: α = 0.5 β= 0.3 Initial trend value(I) = 12 Initial forecast (Ft) = 200
Q: Compute a 3-month weighted average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. There are…
Q: Calculate the forecast for the 4th quarter of 2016 using the Weighted average method w1-0.7, w2=0.3.…
A: Weighted average forecast uses different weights which are assigned to past data to predict the data…
Q: Short term forecast can be used for the following operation.
A: Short term forecastUp to 1 year, usually less than 3 monthsPurchasing, job planning, staff levels,…
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: Explain the forecasting term with the help of least squares ?
A: Least Squares Method The least squares technique is a type of mathematical regression analysis that…
Q: Auto sales at Carmen's Chevrolet are shown below. Using a 3-week weighted moving average (w₁-0.5,…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: ind Naïve Forecast, Moving Average and Weighted Average based on the data given at the below table.…
A: In the question, we have monthly data for the year 2018, I would apply forecasting techniques to get…
Q: Sales for a product for the past three months have been 200,350, and 287. Use a three-month moving…
A: A three-month moving average method averages the actual demand for the previous three months to…
Q: Apply different forecasting techniques to find out the demand of umbrellas in the city of Ahmadabad…
A: Forecasting is the process of projecting past sales demand into the future. It involves the…
Q: Given the actual demand for years 2013/14, calculate the total forecast for year 2015, as well as…
A: Below is the solution:-
Q: When a new business is started, or a patent idea needs funding, venture capitalists or investment…
A: Business Forecasting is important for both startups as well as existing businesses. The new age…
Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…
A: 3 -period moving average forecast = At-1+At-2+At-33 Where, At-1= Actual data of previous period t…
Q: What are some of the consequences of poor forecasts? Explain.
A: The Consequences of the poor forecast are:
Q: Given the following historical data, what is the moving-average forecast for period 6 based on the…
A: Determine the moving-average forecast for Period 6 based on the last three period:
Q: Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.
A: Forecasting is the process of prediction in which sales demand is estimated using historic…
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: Explain what is an accurate forecast?
A: Making is the act of selecting a course of action from a reservoir of thoughts or ideas available to…
Q: Can you either overestimate or underestimate the actual sales number for a poor forecast?
A: A forecast is a foresight of whatever will occur. While usually practiced in the circumstances of…
Q: West Indies Batting Inc is again on the rise due to the increasing sale of cricket bats throughout…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(1, 2,…
Q: what is the advantage of using double exponential smoothing over regression?
A: You can use both double exponential smoothing and regression to forecast a demand pattern with a…
Q: From the choice of simple moving average, weighted moving average, exponential smoothing, and linear…
A: Forecasting is the process of making assumptions of future events based on past and present…
Q: Apply the following forecasting techniques of the data to estimate the demand in period 13: a.…
A: In the question, There are time-series data, actual demand data are given over the past 12 quarters.…
Q: Sales for a product for the past three months have been 203, 365, and 293. Use a three-month moving…
A:
Q: A)- Explain the calculation method for the Naive Forecast model. B) If at the end of every month…
A: Forecasting the values in advance helps to reduce the cost, and increase profits by reducing wastage…
Q: Forecast sales for the 11th period. For leveling, use exponential smoothing 0.20 and moving average…
A: Use exponential formula = α×Actual demand+(1-α)×previous demand
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: The following monthly sales (in thousands of AUS dollars) of chocolate boxes have been recorded for…
A: Forecasting is a method of foretelling the future based on the outcomes of earlier data. It includes…
Q: orecast sales for the 11th period. For leveling, use exponential smoothing 0.20 and moving average 3…
A: THE ANSWER IS AS BELOW:
Q: What is the expected sales for the 7th week based on 3 period moving average. What is the forecast…
A: Forecasting is the process of predicting the future demand using previous or historic information.
Q: How can you evaluate the accuracy of a forecast model? explain in detail
A: Forecasting is the process of making assumptions of the future on the basis of past and present data…
Sales for Pandora’s Jewellery for the past three months have been 200,350, and 287. Use
a three-month moving average to calculate a
for month 4 turns out to be 300, calculate the forecast for month 5.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 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?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 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. What should Sharon do in this situation?
- Problem 18-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. Last year This year JAN 150 170 FEB MAR 170 190 190 APR MAY 235 225 175 245 270 Forecast for the third quarter JUN 250 215 SEP 175 AUG JUL 195 185 OCT 250 ▸ NOV DEC 275 295Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note: the 1st quarter is Jan, Feb, and Mar; 2nd quarter id Apr. May, Jun; 3rd quarter Jul, Aug, Sep; 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC LAST YEAR 145 165 170 210 220 245 190 180 175 245 270 295 THIS YEAR 145 170 180 235 275 225 What is the forecast for the third quarter?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.
- Forecast sales for the 7th period. For leveling, use exponential smoothing 0.20 and moving average 3 for averaging; and linear and exponential functions for trend data. Assume an initial exponential forecast of 60 units in period 2 if you decide to use it (i.e., no forecast for period 1). Period Demand 1 67 2 72 3 68 4 20 5 70 6 66 7 68Tracy is the the Director of Supply Chain at Circuits Inc. An accurate forecast at Circuits Inc. is very important because of the long lead times for raw materials. Tracy has asked you to quickly pull together forecast accuracy information over the last 5 months to share at the upcoming S & OP meeting. Month Demand Forecast 1 1,200 1,150 2 1,750 1,530 2,250 1,962 4 1,600 1,745 1,550 1,628 What is the MAD for month 5? (use 2 decimal places) O Less than or equal to 100 O Greater than 150 but less than or equal to 200 Greater than 250 O Greater than 200 but less than or equal to250The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 8 8 4 9 12 7 11 14 9 13 8 Part 2 Using exponential smoothing with α = 0.50 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). Year 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 7.0 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here