Q]. The Instant Paper Clip Dice Supply Company sells and delivers ofce supplies to companies , schools , and agencies within a 50 mile radius of its warehouse . The ofce supply business is competitive , and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (0 ffices typically order not when they run low on supplies: but when they completely run out. As a result = they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock . Therefore , the manager wants to be able to forecast the demand for deliveries during the next month .From the records of previous orders .management has accumulated the following data for the past 10 months . Table l : Number of monthly orders Month Ian Feb Mar Apr M ay Jun . Jul . Aug . Sep . Oct . Orders 120 90 10CI 75 110 50 75 130 11CI 90 a) Compute the monthly demand forecast for February through November using the naive method . b) Compute the monthly demand forecast for April through November using a 3month moving average . c) Compute the monthly demand forecast for June through November using a 5month moving average . d) Compute the monthly demand forecast for April through November using a 3-month weighted moving average . Use weights of 0.5, 0.33 , and 0.17 , with the heavier weights on the more recent months . e) Compute the mean absolute deviation for June through October for each of the methods used. Which method would you use to forecast demand for November '? Q2.Aldes is a food and beverage company located in the Republic of Mauritius that is specialized in the export of Tuna fish mainly sold in A'ica . The monthly exportation value of Tuna sh for the last eight months is given in Table 2. Table 2: Export value of Tuna sh (3) Sales 100000 a) Estimate the two period ahead exports of Tuna sh by using exponential smoothing method with o. = 0.2.:1: 0.25 , ct = 0.35 .What is the best value of d? b) If the company decides to promote the product through discount policy to increase the sales, how convenient it is to modify the choice of a? Is it possible to use the selected method for a 6 month ahead forecast '3