The completed project must be uploaded by midnight to the Group-Project Container on the MGMT2021 course page in OurVLE, by Friday, March 26, 2021. Only one version of the group project must be uploaded. Any other upload of the same project will be ignored. Please pay attention to the following instructions. Any instruction not followed could lead to deductions of marks. Complete the sheet named INFORMATION with the relevant data. Complete the Peer-Evaluation, the project is incomplete otherwise. Group Project We Clean ALL You group has been contracted to work on a project for a US-based company, operating in the Caribbean. The name of the company is We Clean ALL, a leading manufacturer of bathroom and other cleaning products. Representatives of the management team met with you and provided a brief on the project. From the brief, you learnt that the company has been trying to put systems, processes and procedures in place to control inventory costs and to maximise capacity. Other areas covered in the brief include the following: The weekly cost to hold a unit of cleaning product in inventory is of holding one unit (made up of 2000 cases) of soap in inventory is $60. Based on the most current forecast, the expected weekly demand is 240 units with a standard deviation of 25. Management is of the view that demand for the cleaning products can be modelled by the normal distribution. However, a member of the management team believes that demand can also be modelled as a general discrete distribution (see Table 1 below). As per company rule, backorder is not accommodated, therefore, if demand exceeds cleaning products in stock, then sales are lost. You were also told that weekly production (in units) can be one of the following three options: 220, 240, or 260. However, the production process is of such that there has to be change-over -- from one production level to the next, because of the configuration, this at a cost of $3000 per week. The record shows that We Clean ALL produced at a level of 240 units last week, and currently has an on hand inventory of 120 units. The company wants to do an evaluation of different production policy scenarios: a) If the current inventory is less than 80 units (CL = 80 units), the company will produce 260 units during the week that follows (next week). b) If the current inventory is more than 150 units (CU = 150 units), the company will produce 220 units during the week that follows (next week). c) If neither scenario (a) nor (b) applies, the company plans to maintain the previous weeks level of production. Table 1 Demand of Cleaning Products Demand (D) P(D) 210 0.16 220 0.18 230 0.30 240 0.24 250 0.12Required Using the attached Excel file (Cleanin:g_Product_Template), do the following 1. Develop a simulation model covering 50 weeks of operation for We Clean ALL, under the following assumptions and compute the total costs (inventory + production change-over costs) for the 50 weeks of operation for both (i) & (ii). i. Demand is approximated by the general discrete probability distribution, as per Table 1 (3 Marks) ii. Demand is approximated by the normal probability distribution, with the parameters as given above (3 Marks) 2. Generate 1000 replications of the simulation developed in (1), under the general discrete probability only, for the total costs. (1 Mark) 3. From (2), compute the following: i. Average cost and standard deviation cost (1 Mark) ii. A 98% Confidence Interval of the average cost (2 Marks) iii. The probability that total cost will exceed $420,000 (1 Mark)

4. Conduct a sensitivity analysis of the total costs for CU between 90 and 130, inclusive, in increment of 10, keeping CL = 80 constant for 1000 replications for the total costs, based on the simulation in Q1(ii) (That is, based on the normal probability distribution). (3 Marks) i. Generate an automatic highlight of the value of CU that generates the maximum standard deviation cost (only the value that gives the maximum standard deviation must be highlighted when the simulation is refreshed). (2 Mark

THE ONLY QUESTION I NEED HELP WITH IS NUMBER 4, Please provide instructions