Explain how to get the answers

4 (14 points AOL) A firm has collected data on labor-hour requirements for producing its models A and B Quarter 1 Quarter 2 Quarter 3 Quarter 4 Production A (units) Production B (units) Labor-hours A Labor-hours B 1000 600 400 90 1400 850 532 153 1300 760 507 152 1500 900 615 162 a. What planning factors should be used for quarter 5! b. What are the monthly capacity requirements for labor hours in work centers 100 and 200 would you project for quarter 5 if 40% of the labor hours were worked in work center 100 and 60% were worked in work center 200? Use the monthly summaries in the following MPS Product A Product B Month 1 500 250 Month 2 500 350 Month 3 600 400 Total 1600 1000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Production A (units) Production B (units) Labor-hours A Labor-hours B 1000 600 400 90 1400 850 532 153 1300 760 507 152 1500 900 615 162 Average Labor hrs per unit A Labor hrs per unit B 0.4 0.15 0.38 0.18 0.39 0.2 0.41 0.18 0.1775 0.395 Production A (units) Production B (units) Month 1 500 250 Month 2 500 350 Month 3 600 400 Total 1600 1000 Total Labor hours needed 241.875 259.625 308 809.5 Work Center 100 200 145.125 155.775 123.2 184.8 96.75103.85 323.8 485.7