Please submit your answer in an Excel format and include text boxes providing a verbal summary of any main conclusions. ----- A post office requires sufficient full and part time people to satisfy the following daily needs for employee hours:
Day M T W R F Sa Su
Hrs.Needed 136 104 120 152 112 128 88
A full time employee works 8 hours a day for five straight days. A part time employee works 4 hours a day for five straight days. Full or part time employees can be hired to begin their five straight days on any day that the post office chooses. Full time employees earn $20/ hour while part time employees earn $15/hour. A union agreement limits the number of part time employees to no more than 25% of the total number of employees. Determine how many full and part time workers should begin their work on each day of the week to satisfy the manpower requirements at minimum cost. Ignore lunch and other breaks. Produce a two way SolverTable to show the minimum cost as the part time wage varies from $10/hour to $20/ hour in increments of $5/hour while the full time wage varies from $15/hour to $25/hour in increments of $5/hour. ---- Please provide a detailed step-by-step description of your proposed solution. please solve this using excel solver.