***PLEASE USE EXCEL TO ANSWER THE QUESTION. CAN NOT BE COMPLETED WITHOUT EXCEL. THANK YOU!!!*

Philadelphia fun cycles (PFC) manufactures bicycles. All data required to create an aggregate plan including demand for the next year are given below. PFC want's to end the year with an inventory of 1000 bicycles. Assume that PFC's factory is open 20 days each month for 8 hours each day. PFC is considering promoting sales of their bicycles either in February or in September. PFC will drop the sales price of the bicycle from $200 to $190 during the month of promotion. The expected outcome of this action is that PFC will see the consumption in the month increase by 40% (not including forward buying) and a forward buying of 10% from each of the two subsequent months. 1. What is PFC's production plan for the coming year without any sales promotions? What the expected total profit? 2. If we promote in February what is the production plan? What is expected total profit? 3. If we promote in September what is the production plan? What is expected total profit? 4. Should PFC go through with sales promotions? If yes, in which month should PFC promote sales? Philadelphia fun cycles (PFC) manufactures bicycles. All data required to create an aggregate plan including demand for the next year are given below. PFC want's to end the year with an inventory of 1000 bicycles. Assume that PFC's factory is open 20 days each month for 8 hours each day. PFC is considering promoting sales of their bicycles either in February or in September. PFC will drop the sales price of the bicycle from $200 to $190 during the month of promotion. The expected outcome of this action is that PFC will see the consumption in the month increase by 40% (not including forward buying) and a forward buying of 10% from each of the two subsequent months. 1. What is PFC's production plan for the coming year without any sales promotions? What the expected total profit? 2. If we promote in February what is the production plan? What is expected total profit? 3. If we promote in September what is the production plan? What is expected total profit? 4. Should PFC go through with sales promotions? If yes, in which month should PFC promote sales