MGT 330: Operations Management Mathematical Problem Marks -20 1. The Monthly demand for unit manufactured by the ABC Company has been as follows: Units 150 140 155 135 132 Month January February March April May a. Use a three-month weighted moving average to forecast the units forJuneby using weights of 50%, 30%,& 20% respectively. (2.5) b. Use exponential smoothing with a=0.4 to forecast the units forJune. (2.5) C. From exponential smoothing method, calculate the MSE. (2) 2. Dell computer stocks and sells laptops. Each time to places an order it costs the store $700 with the manufacturer for laptops. In the current year, the company has ordered laptops for the three times. Per month, carrying cost of the laptops in inventory is $13. Estimated annual demand for the laptops will be XYZ units. Determine the total minimum inventory cost, Number of orders per year and length of order cycle. (8) N.B. In order to get the XYZ value, use the last four digit of your University Student ID, e.g. University Student ID is 1621000; therefore, XYZ will be 1000 unit. if your ID is following 1620100 this order, then add 'o' digit after the last three digit of your ID, e.g. ID is 1620197, therefore, XYZ will be 1970 unit. 3. To get the Factory unit sales value, uses your University student ID for year 2021 & for year 2020 add up 165000 with your student ID 2021 2020 Your Student ID, (e.g. 1820199) 102,000 Your Student ID+165000 103,000 Factory unit sales Employment (hrs) Sales of manufactured products ($) Total manufacturing cost of sales ($) $45,363 $35,831 $27,000 $31,000