Dont use Excel

Dr. M's Sport Instruments wants to develop an aggregate plan for the production of Basketballs for 2019. The demand for the next 4 quarters are given as follows: 150, 130, 250, and 530. During a 12 day period when there were 20 workers hired, they created 300 Basketballs. The cost of hiring a worker is $500 and the cost of firing a worker is $1000. Each worker works 8 hours a day and get paid $15/hour. It costs $20 to store the Basketball in inventory each quarter. Let's assume that each Basketball can also be subcontracted for $75. Assume each quarter has 60 days of work. At the end of the last quarter of 2018 there are 40 Basketball and 5 employees hired. Based on a constant workforce plan with subcontracting allowed where hiring or firing is only allowed in the first month Find Number of workers M [Select ] Aggregate Planning Table W=M Pi Pi+ Si - Di+ li_1 Hi Fi Si i a b 2019 Q1 2019 Q2 2019 Q3 2019 Q4 Total a [ Select ] b [Select ] [ Select ] Cost Table Cost Table , CH , TC CF CS: . d 2015 Q1 2015 Q2 e 2015 Q3 2015 Q4 B Total