The demand for a product of a company in each of the last twelve months is shown in the table below; Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Demand 37 40 41 37 45 50 43 47 56 52 55 54

The demand for a product of a company in each of the last twelve months is shown in the table below; Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Demand 37 40 41 37 45 50 43 47 56 52 55 54

Name: solve without using excel and write down all calculations and formular
Uploaded: 2024-03-20T06:46:03.000Z
Channel: Bartleby
Description: solve without using excel and write down all calculations and formular used. The demand for a product of a company in each of the last twelve months isshown in the table below;MonthJanFebMarAprMayJunJulAugSepOctNovDecJanDemand 37404137455043475652555

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints UsedAugust 31 360September 7 389September 14 410September 21 378September 28 368October 5 374 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = ? pints (round your response to two decimal places and remember to use the weights in appropriate order — the largest weight applies to most recent period and smallest weight applies to oldest period.)
These data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (a) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) (b) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 10.22. - Three weeks appears to be best, because the three-week moving average provides the smallest MSE. - Three weeks appears to be best, because the three-week moving average provides the largest MSE. - Four weeks appears to be best, because the four-week moving average provides the smallest MSE. - Five weeks appears to be best, because the five-week…
The customer demand for a particular smart phone during Year 0 to Year 5 is given as 1,056,000, 1,032,000, 1,093,000, 1,024,000, 1,066,000, and 1,072,000. Using the Holt forecasting model with trend, what is the forecasted demand in year 10, where w = 0.4 and v = 0.5?a) 1,071,874b) 1,075,573c) 1,077,488d) 1,083,816
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 18 2 21 3 20 4 24 5 19 6 16 7 20 8 18 9 22 10 21 11 15 12 23 (a) Compute four-week and five-week moving averages for the time series.4-week moving average forecast & 5 week moving average forecast (b) Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? MSE for the three-week moving average is 12.22. Three weeks appears to be best, because the three-week moving average provides the smallest MSE .Three weeks appears to be best, because the three-week moving average provides the largest MSE. Four weeks appears…
Observations of the demand for a certain part stocked at a parts supply depot during the calendaryear 2013 were: Month Demand Month Demand Jan 89 july 223 Feb 57 august 286 mar 144 sept 212 april 221 oct 275 may 177 nov 188 june 280 dec 312 a) Using a four-month moving average, determine the one-step-ahead forecast for Julythrough December 2013.b) Using a four-month moving average, determine the two-step-ahead forecast for Julythrough December 2013.c) Obtain the MAD for the forecasts obtained in the above sections. Which method gavebetter results? Based on forecasting theory, which method should have given betterresults?
The Monthly demand for unit manufactured by the ABC Company has been as follows: Units 250 290 240 280 300 270 290 Month January February March April May June July a.use a four-week weighted moving average to forecast the units of month august by using weights of 40%, 30%, 20% & 10% respectively. b. use exponential smoothing with α=0.3 to forecast the units of month august. c. calculate the mad & mse (use exponential smoothing method).
Calculate Karl Pearson's coeffcient of skewness from the following data:Weekly Sales (Ksh) 10-12 12-14 14-16 16-18 18-20 20-22 22-24 24-26Number of Companies 12 18 35 42 50 30 8 4
Price information for selected foods for 2010 and 2018 is given in the table. Price Quantity Item 2010 2018 2010 2018 Cabbage (pound) $ 0.06 $ 0.05 2,000 1,500 Carrots (bunch) 0.10 0.12 200 200 Peas (quart) 0.20 0.18 400 500 Endive (bunch) 0.15 0.15 100 200 Compute a simple price index for each of the four items. Use 2010 as the base period. (Round your answers to 2 decimal places.)
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 18 2 22 3 20 4 24 5 19 6 17 7 22 8 20 9 24 10 22 11 17 12 24 (a) Using a weight of 1 2 for the most recent observation, 1 3 for the second most recent observation, and 1 6 for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Week Time SeriesValue Weighted MovingAverage Forecast 1 18 2 22 3 20 4 24 5 19 6 17 7 22 8 20 9 24 10 22 11 17 12 24 (b) Compute the MSE for the weighted moving average in part (a). MSE = Do you prefer this weighted moving average to the unweighted moving average? The MSE for the unweighted moving average is 10.91. The unweighted moving average is preferred because it has a larger…
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 17 2 23 3 14 4 25 5 17 6 16 7 22 8 19 9 21 10 19 11 17 12 23 (a) Compute four-week and five-week moving averages for the time series. Do not round intermediate calculations. If required, round your answers to two decimal places. Week Sales 4-WeekMovingAverage 5-WeekMovingAverage 1 17 2 23 3 14 4 25 5 17 6 16 7 22 8 19 9 21 10 19 11 17 12 23 (b) Compute the MSE for the four-week and five-week moving average forecasts. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = (c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Consider that the MSE for the…
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. WEEK NO. OF PATIENTS 1 105 2 119 3 122 4 128 5 117 6 136 7 141 8 126 9 143 10 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. b) What are the MAD, MSE and the MPE for this method? c) If the company decided to forecast using exponential smoothing with value of alpha =.3, what is the forecast in month 11? (use 2 decimal places)
Table 1 HPF Demand in the last 12 periods Period Month Demand in '000 Period Month Demand in '000 1 January 37 7 July 43 2 February 40 8 August 47 3 March 41 9 September 56 4 April 37 10 October 52 5 May 45 11 November 55 6 June 50 12 December 54 The manager of the company wants to be certain enough OFC01 are available to complete orders promptly and they have adequate inventory in stock. During the last meeting, a number of forecast techniques have been discussed: Simple moving average n = 4 Weighted moving average with n=4 with the following weights from most recent periods: 0.4, 0.3, 0.2, 0.1 Exponential Smoothing with alpha = 0.2 Linear trend The manager would like to ascertain the best tools that he and his team can effectively manage the production processes. Among the above forecasting methods, which method should be used to forecast the demand for this product? Why? The…