0 2. Use ZCK11 to get Product Cost Planning report. Input the capacity per day (@24,000 in extended game) and the productivity you get in Question 1 and click Recalculate. Capture the screenshot and replace the example below. Product Cost Planning Fixed Costs (Daily) Total Fixed Costs 27, 817.20 Production Capacity 24, 000 4, 000.00 Labor Productivity (%) 71 3, 000.00 Manufacturing Overhead Allocation Basis 17, 040 / 10, 000.00 Depreciation-Equipment Alocated Fixed Costs per Unit 1. 63 EUR 250.00 Depreciation-Building Recalculate 8, 000.00 Sales, General & Administrative NOTE: The allocation of fixed costs is entirely dependant on your 2, 567.20 Loan Interest productivity assumption. The cost analysis here does NOT include marketing, warehousing or any other expe ses. Recalculate only takes nto account a change ged productivity assumption, and is not a full refresh. Profitability Analysis Material Description Variable Variable + Fixed 1-FO1 500g Nut Muesli 0.90 2.53 1-F02 500g Blueberry Muesli 1.23 2.86 1-F03 500g Strawberry Muesli 1.23 2.86 LL-F04 500g Raisin Muesli 0.79 2.42 LL-F05 500g Original Muesli 0.77 2.40 LL-F06 500g Mixed Fruit Muesli 1.13 2.76 LL-F11 1kg Nut Muesli 1.61 3.24 1-F12 1kg Blueberry Muesi 2.26 3.89 LL-F13 1kg Strawberry Muesli 2.27 3.90 LL-F14 1kg Raisin Muesli 1.38 3.01 LL-F15 1kg Original Muesli 1.35 2.98 LL-F16 1kg Mixed Fruit Muesli 2.06 3.69 Variable: The cost of raw materials to manufacture the product, based on average historical purchase price. Variable + Fixed: Variable cost, plus the allocated fixed costs per unit. Discuss the strategy to reduce total unit cost (Variable+Fixed). 3. Use ZVA05 and Excel pivot table to get average price and sales volume of each product in each channel. Then, use the unit cost ( variable + fixed) you got from Question 2) and calculate the gross margin per unit of each product in each channel. What are your findings? Do you find any cash cow products which have high gross margin and high sales quantity? Which products have the lowest gross margin? A B C D E 1 Round UN . 3 Row Labels * Average of Price Sum of Qty Unit Cost Gross Margin 4 010 4.61 10344 LL-F11 4.61 10344 2.27 2.34 6 812 4.4776 161784 1.38 7 LL-F01 3.9 32428 1.35 3.26 8 LL-F02 4.23 20058 2.06 2.55 9 LL-F03 4.23 13214 4.61 10 LL-F04 3.79 11030 1.23 3.38 11 LL-F05 3.77 3653 0.79 3.82 12 LL-F06 4.13 21062 0.77 3.84 13 LL-F11 4.61 20339 1.61 3 14 LL-F12 5.26 40000 2.27 2.34 15 014 4.077142857 99258 1.38 16 LL-F01 3.9 7572 1.35 3.26 17 LL-F02 4.23 19942 2.06 2.55 18 LL-F03 4.23 26501 4.61 19 LL-F04 3.79 19091 0.79 3.82 20 LL-F05 3.77 082 0.77 3.84 21 LL-F06 4.13 18070 1.13 3.48 22 Grand Total 4.344074074 271386 23