Answer all the questions

numerical analysis multi-part question and need an explanation and answer to help me learn.

Using the excel template provided 1. Streets in Bellevue are maintained by Public Works Division; ″Street Maintenance.″ Public Works administrators are planning the workforce of this division for next year. Labor hour requirements for the next year are 8,000, 14,000, 29,000, and 18,000, for quarters 1 to 4 respectively. Each of the current 15 workers in the workforce can contribute 500 hours per quarter. Overtime is limited to 20 percent of the regular-time capacity in any quarter. Subcontracting is not permitted. Payroll costs are $7,000 in wages per worker for regular time worked up to 500 hours, with an overtime pay rate of $21 for each overtime hour. Although unused overtime capacity has no cost, unused regular time is paid at $14 per hour. The cost of hiring a worker is $3,500, and the cost of laying off a worker is $2,800.a. Find a level workforce plan that uses overtime and the minimum amount of undertime (idle time for workers) possible. Overtime can be used to its limits

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount