please make it simple how you get your answer.

Problems (5 points each). Please show work. Any Excel spreadsheets must be formatted so it is easy to print. Also, please make sure your name in on the sheet. 1. Acme Inc. produces widgets. Its current WIP lead time is 12 weeks. Based on last year's financial statements, the yearly CGS is estimated to be $45 million. a. What is WIP value in dollars? b. Acme has engaged in a new planning system and they expect WIP to be reduced to be 7 weeks. Current annual carrying costs of inventory is 10% of the WIP dollar level. What would be the annual savings (if any?) (Show work) 2. Acme Inc. needs to create a new production plan, using a level strategy. The current inventory is 900 units. The goal is to lower the inventory to 300 units by the end of the plan. The forecast for sales for each of the month is shown in the table below (red) a. Create a production plan with a level strategy. b. Calculate ending inventory at the end of each month? Period Forecast 1 1000 2 1100 3 900 4 800 5 1000 6 1000 7 1100 8 900