need help on #5 & #7. not just answers. but help understanding. i have five filled out but font thinknit is correct. please explain

A B D E F LIL Week 1 2 3 4 1 Problem 4 2 3 Standard Corkscrew 4 Forecast 5 Proj. Available 6 MPS 7 Lot size: 8 3,000 3,000 4,000 2,000 3,500 1,500 2,000 5,000 500 4,000 500 4,000 4,000 2,000 4 9 10 Deluxe Corkscrew 11 Forecast 12 Proj. Available 13 MPS 14 Lot size: 15 1 2,000 1,000 1,000 Week 2 3 1,500 1,000 2,500 2,500 3,000 1,000 2,000 3,000 500 1,000 1,000 16 17 5,000 corkscrews per week? YES YES YES YES Use the spreadsheet to do some trial and or 10 Problem 5 0.10 0.30 Direct labor Standard corkscrew Deluxe corkscrew Machine time Standard corkscrew Deluxe corkscrew 0.20 0.40 4 1 700 1200 Direct labor Machine time 2 1100 1600 3 700 700 1200 Totals 3200 5200 1200 WAI uses two resources for each product that it builds: direct labor and machine time. From historical records, WAI calculates the following planning factors: Direct labor for standard corkscrew is 0.10 hour. Direct labor for deluxe corkscrew is 0.30 hour. Machine time for standard corkscrew is 0.20 hour. Machine time for deluxe corkscrew is 0.40 hour. WAI knows from historical records that approximately 40 percent of its labor is used in Department 101 and 60 percent is used in Department 102. The reverse is true of machine time, 60 percent is used in Department 101 and 40 percent is used in Department 40% 60% Direct labor Dept 101 Dept 102 Machine time Dept 101 Dept 102 60% 40% 1 2 3 4 Department 101 Direct labor Machine time Totals 0 0 Calculate the brand machine hours needed in Department 101 for each period of the MPS developed in Problem 2 3 Total Department 102 Direct labor Machine time Calculate the bord needed in the of the ho