gnment 1.d Xment%202.pdf.xlsxHP Work & Supply Chain MarakaneSalesJANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDECTotal-1 / 2 -Question 1The monthly demand of a company is showed below, please use the static method to forecast thedemand for Year 6.Year 1Q Search2,0003,0003,0003,0004,0006,0007,0006,00010,00012,00014,0008,00078,000Catherine Caramp....pdfZYear 2140%3,0004,0003,0005,0005,0008,0003,0008,00012,00012,00016,00010,00089,000LDE+ @IAssignment 2Year 3Question 2Historical demand for Peeps is as displayed in the table.2,0005,0005,0003,0004,0006,0007,00010,00015,00015,00018,0008,00098,000T2202- 2022.pdf0Year 4}})5,0004,0004,0002,0005,0007,00010,00014,00016,00016,00020,00012,000115,000!Year 55,0002,0003,0002,0007,0006,0008,00010,00020,00020,00022,0008,000113,000Q☆lENUS

Forecasting is the process of predicting future values of a variable or a time series based on…

Answered: Question 1 The monthly demand of a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.6: Estimating The Relationship Between Price And Demand

Problem 11P

See similar textbooks

Similar questions

The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (a)Use ? = 0.4 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (b)Use a smoothing constant of ? = 0.6 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110
The actual demand of a product for six months are summarized in the table below: Month (t) Demand Dt 1 80 2 90 3 70 4 100 5 70 6 90 Find three months weighted moving averages by assuming the weights, W1 =1, W2 = 0.4 and W3 = 0.5 ii. Compute the mean forecast error iii. Compute the mean square error (MSE) iv. Compute the mean absolute deviation (MAD). v. Mean absolute percent error (MAPE)
1. Using MAD as the criterion, which of the following models would you use for thegiven time series data? Why?A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month.NOTE: In answering Item 1, mention the whole description of the model; i.e., not just“SMA model”, but “SMA model with n = ...”; not just “WMA model”, but “WMA modelwith weights ...”; not just “ES model”, but “ES model with α = ...”.
The table below comprises of demand from the last 10 months: Month Demand 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 Calculate the exponential smoothing with trend forecast for the second month using a alpha and delta of 0.3 each. Take the initial exponentially smoothed forecast (F1) of 30 and initial trend forecast (T1) of 1. Note: I have tried solving this question and I got 31, but unfortunately it was the wrong answer.
Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. *4802075500 Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? *225,00025,00010,0002.50250,000
Whitebridge Hardware Store Whitebridge Hardware Store has a monthly demand for lawn fertilizer listed below. The gardening season starts in early spring when people want to fertilize their lawns. Period Demand Jan 59 Feb 68 March 91 April 145 May 182 June 212 July 193 Aug 174 Sept 144 Oct 89 Nov 74 Dec 55 Answer Questions 1 – 5 below. [Be sure to watch the video on how to complete your forecasting problem, in the content module.] Everything must be typed including the graph. You need to complete this assignment in Excel. For the narrative answers, you can include them in Excel in one or more of the empty cells. If you know how to add an extra worksheet, you can add your answers on a new worksheet. Or you can type them in a Word document Please include your name somewhere. In the Assignments area, a…
12 The fictitious Haskins & Collins Ice Cream Store needsan accurate estimate of demand. The owner of the store believes that the demand for ice cream has a quarterly seasonal pattern. To analyze the pattern, the ownergathered the following quarterly ice cream sales data ingallons for the past 4 years:Quarter Year 1 2 3 4January - March 370 380 470 530April - June 550 500 620 700July - September 770 820 980…
6. A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y=4,000+0.20x, where y is the annual cost and x is the miles driven. Part 2 a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile= ___________ (enter your response as a whole number).
Given the following forecast and cost information, Regular time cost $ 40.00 per unitdetermine the total cost of a plan that uses regular time Overtime cost $ 60.00 per unitproduction output of 600 units per month, overtime is subcontracting cost $ 80.00 per unitused when needed up to a maximum of 60 units per holding cost $ 10.00 per unit per monthmonth, and subcontracting is used if additional units are needed to meet the forecast.Month Forecast1 5702 6003 6304 6505 6706 690Totals
Table 5.1: The demand forecast developed for the year ended 31 December 2022. Month Production days Demand forecast Jan 16 150 Feb 16 150 Mar 23 250 Apr 21 250 May 22 400 Jun 22 500 Jul 21 600 Aug 20 750 Sep 20 450 Oct 20 250 Nov 16 150 Dec 16 150 1. Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number). 2. Assuming that MPQ Limited had adopted a level strategy for the year ended 31 December 2022, compute the average daily demand for the year (round off to the nearest whole number).
The 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 6 8 4 10 11 9 12 12 8 13 6 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year 4 5 6 7 8 9 10 11 12 Forecast 66 7.337.33 8.338.33 1010 10.6610.66 1111 10.6610.66 1111 99 c) Using the 3-year weighted moving average with weights 0.15, 0.30, and 0.55, using 0.55 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places).
Month Demand1 452 483 434 485 496 547 478 509 4610 47Using the table above, calculate two forecasts using the following method:-i. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data iii

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS