Please help with these homework questions.

1. [Chapter 4: 20 points] A local travel supply retailer sells and distabutes mosquito nets to tourists and travel agents. The retailer recognizes that the mosquito nets supply business is competitive, and the ability to deliver orders promptly is a key factor in getting new customers and maintaining existing ones. Travel agents typically order not when they run low on inventories, but when they completely run out. As a result, customers need their orders immediately. In the meantime, the public health restrictions have created a significant shortage of drivers and other employees at the company. The operation manager of the retailer wants to be certain that enough drivers 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 quarter. From previous orders, management has the following information for the last seven quarters. Table 4. Quarterly deliveries of Mosquito Nets Quarter 2020:Q1 2020:02 2020:09 2020:04 2021:01 2021:02 2021:03 Orders 24,000 36,000 72,000 52,800 62,400 52,800 67,200 1.1. Calculate the quarterly orders forecast for 20201:04 through 2021:Q3 using 1 wane welbod bj c) a 3 quarter weighed swing average. Use weights of 5, 3, and 2, with the heavier weights for the more recent quarters. d Exponential weaving awe . = 0.6. Assume that the initial forecast for 2020:01 was 24,000. 1.2. Compute the mean squared errors (MSI) based on your forecasts for 2020:04 through 2021:Q3 for each of the methods used. Which method would you recommend to forecast demand for 2021:Q4? Why? What would be the forecast for 2021:04 based on the preferred forecast approach? If a = 0.2 for the exponential smoothing method, would your recommendation change? Why? 2. [Chapter 12: 25 points] At the travel supply retail firm in Question 1, suppose the demand for mosquito nets is constant at 12,000 nets per month. The cost of placing an order to replenish stock is $20), and the annual cost of holding is $4 per net per year. No backorders are allowed. Assume 160 working days a year. 1) Calculate the economic order quantity and the total inventory cost for the retailer (excluding the cost of the nets). Compute the optimum number of orders per year and the optimal interval (is working day) between orders. bj The purchasing manager is currently using an order quantity of 600 nets. The operation manager of the retailer expects the company to be managed in a cost efficient manner. Would you recommend that the retailer use the economic order quantity instead of 600 net? Why? Justify your answer. In question 2 (b), for what value of ordering cost per order would an order quantity of 600 nets be optimal? Suppose the average cost per net is $15 and the supplier offers a discount of 1% if the retailer orders a minimum of 1,500 nets at a time. Should the retailer accept the deal? Why? (Note balding cost per wol per year and ordering cost per order newsin the same as in DQuestion I (al) Mosquito nets are ordered from an out of country manufacturer, lead time is normally distributed with an average of five working days and a standard deviation of 2.5 days. Calculate the daily demand, demand during the lead time, the standard deviation of demand during lead time, safety stock, and the reorder point. A 90%% service level is expected