SOLVE IN EXCEL STEP BY STEP

2. Superchip, a semiconductor company, is planning the personnel and production requirements for next year. The company manufactures several microprocessors and uses dollars to measure its aggregate production. Based on customer orders and forecasts, the estimated monthly sales in dollars are shown in the next table: Das hbiles Demanda pronosticada (en $10 000) Mes Enero Febrero Marzo Abril Mayo Junio Julio Agosto Septiembre Octubre Noviembre Diciembre 22 16 21 19 23 20 24 12 19 22 20 16 340 380 220 100 490 625 375 310 175 145 120 165 3. The inventory costs are computed using an annual rate of 25%. There are 675 workers on the payroll at the end of the current year (beginning of next year), and the initial inventory is $120,000. The company wants to have at least $100,000 at the end of December next year. Each worker can produce $60,000 per year (1 year = 250 working days) and the regular time salary is $2500/month-worker. The hiring cost is $200/worker, and the layoff cost is $400/worker. If needed, the workers can work overtime but no more than 15% of the regular time. The overtime pay rate is 200% the normal salary. a. Find the minimum level workforce plan and compute its annual cost. b. Find the chase plan with the minimum number of workers. Compute the total cost