00 B 600 400 0 Trial 1 600 800 2 Trial 2 D 300 500 1 Trial 3 9 . 1 Reorder Level 2 Reorder quantity 3 Lead time 4 Number of days when stock out 5 occurred 6 Mean closing stock level 7 Number of orders placed 8 Number of back orders 9 Total Holding cost 10 Total shortage cost 11 Total reordering cost 12 Mean of profit 13 Days company generate no prof 89 9 33 10 9 1648 429239 450 68478 3 10 9 4460 98451 390 37185 6 9 16 9 9 790 308969 390 75156 14 Based on the report generated from producing three simulation trials (shown in table 2) answer the following questions a) What is the Excel formula to calculate the following? Mean closing stock level (B6) Total reordering cost (D11) No. of days' company generate no profit (C13) . b) Which strategy the manager will adopt and why? 00 B 600 400 0 Trial 1 600 800 2 Trial 2 D 300 500 1 Trial 3 9 . 1 Reorder Level 2 Reorder quantity 3 Lead time 4 Number of days when stock out 5 occurred 6 Mean closing stock level 7 Number of orders placed 8 Number of back orders 9 Total Holding cost 10 Total shortage cost 11 Total reordering cost 12 Mean of profit 13 Days company generate no prof 89 9 33 10 9 1648 429239 450 68478 3 10 9 4460 98451 390 37185 6 9 16 9 9 790 308969 390 75156 14 Based on the report generated from producing three simulation trials (shown in table 2) answer the following questions a) What is the Excel formula to calculate the following? Mean closing stock level (B6) Total reordering cost (D11) No. of days' company generate no profit (C13) . b) Which strategy the manager will adopt and why