PLEASE ANSWER USING EXCEL ONLY. Thank you! Will "Like" post if done in excel

Thiladelphia fun cycles (PFC) manufactures high end bicycles. All data required to create an aggregate plan including demand for the next half year are given below. PFC vant's to end June with an inventory of 1200 bicycles. Assume that PFC's factory is open 20 days each month for 8 hours each day. PFC is considering promoting sales of their bicydes either in February or in Ayril. PFC will drop the saies 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 40x (not inclualing forward biying) and a forward buying of 10x trom each of the two subsequent monthe. 1. What is the production plan from danuary to June without any promotions? What the expected total pront? 2. If pFC decides to promote in February what is the production plan? What is expected total profit? 3. If PFC decides to promote in April 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? Thiladelphia fun cycles (PFC) manufactures high end bicycles. All data required to create an aggregate plan including demand for the next half year are given below. PFC vant's to end June with an inventory of 1200 bicycles. Assume that PFC's factory is open 20 days each month for 8 hours each day. PFC is considering promoting sales of their bicydes either in February or in Ayril. PFC will drop the saies 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 40x (not inclualing forward biying) and a forward buying of 10x trom each of the two subsequent monthe. 1. What is the production plan from danuary to June without any promotions? What the expected total pront? 2. If pFC decides to promote in February what is the production plan? What is expected total profit? 3. If PFC decides to promote in April 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