4. Based on the sales volume and gross margin you got from Question 3, Have you found any cash cow products (high profit and high demand)? If not, you need to explore other cash cow products to generate more profits. If yes, you could spare more production capacity and keep higher inventory levels for cash-cow product so you can exploit more profit from them. Given your observation, what is your strategy to maximize profit in next round? 5. Use Excel Pivot Table to summarize the average price and total quantity for all products in the market. Analyze the market and explore potential cash cows. Capture the screenshot and replace the example below. Average of Price Sum of Qty 1kg Blueberry Muesli 5.15 240000 1kg Nut Muesli 4.82 240000 1kg Raisin Muesli 4.52 240000 1kg Strawberry Muesli 5.19 240000 500g Blueberry Muesli 4.49 240000 500g Nut Muesli 3.96 240000 500g Raisin Muesli 4.12 240000 500g Strawberry Muesl 5.02 240000 Through the zmarket report, do you find any cash-cow product you want to offer in the next round? End of Round 2 6. Again, use ZCOOIS and Capture the screenshot of the Production Schedule Report at the end of Round 2. Production Schedule Report Production Schedule Report: Round 3 Day 01 r Material description "Start "Finish Setup Released Target Confirmed Unit Cost 1000393 500g Nut Muesi 03/07 03/08 02/10 16,000 0.00 1000382 500g Nut Muest 03/05 03/07 02/09 48,000 0.00 1000381 500g Nut Muesi 03/03 03/05 48,000 0.00 1000380 500g Nut Muesi 03/01 03/03 7.00 48,000 0.00 1000379 500g Raisin Muesli 02/20 03/01 16,000 5,000 0.00 1000359 500g Raisin Muesli 02/18 02/20 02/08 48,000 48,000 0.00 1000356 500g Raisin Muesli 02/16 02/18 48,000 48,000 0.00 1000358 500g Raisin Muesli 02/14 02/16 7.00 48,000 48,00 0.00 1000353 500g Original Muesli 02/13 02/14 02/07 16,000 16,000 0.00 1000352 500g Original Muesli 02/11 02/13 8,000 48,000 0.00 1000351 500g Original Muesli 02/09 02/11 8,000 48,000 0.00 1000347 500g Original Muesli 02/09 7.00 48,000 18,000 0.00 1000284 1kg Original Mues 02/05 02/07 7.00 01/04 40,000 40,000 0.00 1000282 1kg Raisin Muesi 02/03 02/05 7.00 40,000 40.000 0.00 1000283 1kg Mixed Fruit Muesli 02/01 02/03 7.00 40,000 40.000 0.00 1000281 1kg Strawberry Muesli 01/20 02/01 8.00 40,000 40.000 0.00 1000279 1kg Nut Muesli 01/18 01/19 8.00 40,000 40,000 0.00 1000280 1kg Blueberry Muesli 01/16 01/17 8.00 40,000 40.000 0.00 1000278 500g Mixed Fruit Muesli 01/14 01/15 8.00 10,000 40,00 0.00 1000276 500g Raisin Muesli 01/12 01/13 8.00 0,000 40,000 0.00 1000277 500g Original Muesli 01/10 01/11 8 40,000 40,000 0.00 1000275 500g Strawberry Muesli 01/08 01/09 8 40,000 40,000 0.00 1000274 500g Blueberry Muesi 01/06 01/07 8.00 40,000 40.000 0.00 1000273 500g Nut Muesi 01/04 01/05 40,000 40,000 0.00 Export the data to Excel and calculate productivity % for Round 2 only. Have you achieved the goal of productivity %? If yes, what did you do correctly in round 2? If not, how will you improve in next round
