
Question 1 4 pts The actual demand for your sales merchandise is provided in the table...
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July 194 August 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) b. Using a weighted moving average, what is the forecast for September with weights...
Forecasts and actual sales of MP3 players at Just Say Musicare as follows: Month Forecast Actual Sales March 150 170 April 220 229 May 205 192 June 256 241 July 250 238 August 260 210 September 270 225 October 280 179 a. Plot the data and show the plot using Excel, Word or PowerPoint. b. Provide insights about the time series c. What is the forecast for November, using a two-period moving average? Note also that the forecast values provided are irrelevant to computing these moving average forecasts. d. What is the forecast for November, using a three-period...
Forecasts and actual sales of MP3 players at Just Say Music are as follows: Month Forecast Actual Sales March 150 170 April 220 229 May 205 192 June 256 241 July 250 238 August 260 210 September 270 225 October 280 179 Answer the following questions. a. Plot the data and provide through insights about the time series. (Use Microsoft Excel and attach the time series graph.) b. What is the forecast for November, using a two-period moving average? c....
The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...
QUESTION 32 A company's demand forecast for the next 6 months is shown in the table below as daily demand (units/day). Their average daily demand over the all 6 months is 41 units/day. If the company decides to use subcontractor to help with the production, answer the following two questions. May June July August September October 43 46 37 34 30 51 The number of units produced in house The number of units subcontracted = QUESTION 31 4 points A...
The owner of At the Beach is forecasting this month's (October's) demand for a new tanning booth based on the historical data given below. Month Number of Visits April 100 May 140 June 110 July 150 August 120 September 160 a) What is this month’s forecast using the naïve approach? b) What is this month’s forecast using a three-month simple moving average? c) What is this month's forecast using a four-month weighted moving average with weights of .4, .3, .2,...
Answer All the Question(s) a) The following information is available for XYZ Company Period 1 2 3 4 5 6 Units sold (000) 150 120 180 150 140 160 Units produced (000) 150 150 150 150 170 140 Budgeted activity is expected to average 150,000 units per period and there is no opening stock for period 1. Unit selling price is Ksh 10, Unit variable cost is Ksh 6, fixed costs per period is Ksh 300,000 while non manufacturing...
Question 29 3 pts Annual demand for an item is 13,000 units with the cost per unit at $243. The holding rate is 10% and the order cost is $12.00 per order. The standard deviation of daily demand is 3 units. Assume 260 days in the year and a lead-time of 2 days. If a service level of 97% is desired during the reorder interval, what is the safety stock required? (Note: Due to rounding and your exact choice of...
This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...
Question 1 Part A The following table shows the best forecast for a time series representing the number of people (in thousands) who have two or more jobs in the United States Date Jobs Forecast May 2013 6,487 6,788 June 2013 6,284 6,523 July 2013 6,253 6,279 August 2013 6,840 6,336 Calculate the MAD (mean absolute deviation) forecasting accuracy measurement. Take all calculations to three decimal places. Part B Based on the actual and forecasted returns shown below, calculate the...