Related questions
Concept explainers
12 The fictitious Haskins & Collins Ice Cream Store needs
an 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 owner
gathered the following quarterly ice cream sales data in
gallons for the past 4 years:
Quarter Year
1 2 3 4
January - March 370 380 470 530
April - June 550 500 620 700
July - September 770 820 980 990
October - December 420 440 510 530
Given this information:
a Compute the quarterly seasonal indices for ice cream
sales using the simple average method.
b Compute the quarterly seasonal indices for ice cream
sales using the centered moving average method.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images
- 1. The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Part 2 Week Of Pints Used August 31 350 September 7 372 September 14 412 September 21 381 September 28 366 October 5 378 Part 3 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = _____________pints (round your response to two decimal places).arrow_forwardIn January a battery dealer pridicts February demand of 2000 2 charger battery whereas the actual demand was 1756 unit of batteries , using a smoothing constant of alpha 0.34, the dealer wishes to forecast the march demand using the exponential smoothing model ?arrow_forwardThe following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER 1 2 5678AWN 3 4 8 SALES 219 237 208 171 169 Quarter 9 10 11 12 192 157 132 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to the nearest whole number. Forecastarrow_forwardPlease do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30arrow_forwardBradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with a = 0.4. Forecast the number of calls for week 6, which is next week. Week Actual Service Calls 26 2 34 38 4 27 5 35 The forecast for week 6 is service calls. (Enter your response rounded to two decimal places.)arrow_forward
- Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardAarthi Medicals, a fictitious company, has been monitoringthe sales of the health drink for diabetics. As the demand for the health drink has been steadily increasing, theowner of the store, Nicole Carter, wants to develop goodforecasts for this product to determine how many casesof this drink to order every week form the manufacturer.Nicole has compiled the demand data shown in theaccompanying table for the past 12 weeks. Nicole wantsto evaluate forecasts using the exponential smoothing method using smoothing constants values of α1 = 0.2and α2 = 0.40.Week Demandin Cases1 482 523 494 355 476 537 488 469 5510 5411 5812 5713a Assuming a forecast for Week 2 of 48 cases(f2 = 48), generate forecasts for Weeks 13 usingexponential smoothing for both values of the smoothing constant (α1 = 0.20 and α2 = 0.40).b Compute the forecast error measures of MAD and MSEand determine which value of the smoothing constant provides more accurate forecasts.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education 
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.