Show the solution for this problem please.

TEXT-MS Winston Albright pat - Adobe Acrobat Pro DC (32-bit) File Edit View Sign Window. Help Home Tools ATEXT-MS Winsto.. Sign 147 / 843 200% le at becomes relatively cheaper. Is the net effect on total cost positive or negative? 40. Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the file P03_40.xlsx. Employees work three consecutive quarters and then receive one quarter off. For example, a worker might work during quarters 3 and 4 of one year and quarter 1 of the next year. During a quarter in which an employee works, he or she can produce up to 600 pairs of shoes. Each worker is paid $6000 per quarter. At the end of each quarter, a holding cost of $10 per pair of shoes is incurred. a. Determine how to minimize the cost per year (labor plus holding) of meeting the demands for shoes. To simplify the model, assume that at the end of each year, the ending inventory is 0. (You can assume that a given worker gets the same quarter off during each year.) b. Suppose the company can pay a flat fee for a train- ing program that increases the productivity of all of its workers. Use SolverTable to see how much the company would be willing to pay for a training program that increases worker productivity from 600 pairs of shoes per quarter to P pairs of shoes 2 ost a- its x air 8.27 x 11.69 in IH Type here to search TEXT-MS Winston Albright pat - Adobe Acrobat Pro DC (32-bit) File Edit View Sign Window. Help Home Tools ATEXT-MS Winsto.. Sign 147 / 843 200% le at becomes relatively cheaper. Is the net effect on total cost positive or negative? 40. Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the file P03_40.xlsx. Employees work three consecutive quarters and then receive one quarter off. For example, a worker might work during quarters 3 and 4 of one year and quarter 1 of the next year. During a quarter in which an employee works, he or she can produce up to 600 pairs of shoes. Each worker is paid $6000 per quarter. At the end of each quarter, a holding cost of $10 per pair of shoes is incurred. a. Determine how to minimize the cost per year (labor plus holding) of meeting the demands for shoes. To simplify the model, assume that at the end of each year, the ending inventory is 0. (You can assume that a given worker gets the same quarter off during each year.) b. Suppose the company can pay a flat fee for a train- ing program that increases the productivity of all of its workers. Use SolverTable to see how much the company would be willing to pay for a training program that increases worker productivity from 600 pairs of shoes per quarter to P pairs of shoes 2 ost a- its x air 8.27 x 11.69 in IH Type here to search