BUS 220 Study Guide - Final Guide: Moving Average, Exponential Smoothing, Integer Programming

103 views6 pages

Document Summary

The number of cans of soft drinks sold in a machine each day for the last 12 days is recorded as follows: 5,6,4,5,4,7,4,2,3,4,2,5. Develop forecasts (a) 5-period moving average; (b) 4-period weighted moving average with weights 0. 4, 0. 3, 0. 2, and 0. 1 starting with the most recent observation having the weight 0. 4, etc. ; (c) exponential smoothing with smoothing constant alpha = 0. 7; (d) calculate mse for each of the three methods. 1. 66: weighted moving average, 4-day periods, weights: . 1, . 2, . 3, . 4 (. 1 is for the 4th period back) 1. 55: use exponential smoothing since it provides the minimal mse. Write the linear programming formulation for this transportation problem. Xij = number of units transported from source i to destination j, i=1,2,3,4; j=a,b. X1a + x2a + x3a + x4a = 250. X1b + x 2b + x3b + x4b = 250 all xij 0. A city fire department is planning to buy new fire trucks.