(Answered) : Solve Show Work Using Excel Problem 1 Pigskin Company Produces Footballs Pigskin Must Deci Q28737245

Solve and show work usingexcel. Problem 1. The pigskin Company producesfootballs. Pigskin must decide how many footballs to produce eachmonth. It has decided to use a six-month planning horizon. Theforecasted demands for the next six months are 10,000, 15,000,30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet thesedemands on time, knowing that it currently has 5,000 footballs ininventory and it can use a given month’s production to help meetthe demand for that month. During each month there is enoughproduction capacity to produce up to 30,000 footballs, and there isenough storage capacity to store up to 10,000 footballs at the endof