Calculated Financial Maneuver Autojet Acquired New Manufacturing Facility Producing Small Q31744609

In a calculated financial maneuver,Autojet has acquired a new manufacturing facility for producingsmall electric motors. You have been asked to provide an answer tothe following question: How many new personnel should be hired andtrained, or laid off, over each of the next six months? The laborrequirements and monthly wage rates for trained manufacturingemployees are given in the following table.

Trainees can be hired at the beginning of each month. Oneconsideration to take into account is that workers must have onemonth of training before they can work in manufacturing. Therefore,a trainee must be hired a month before the worker is actuallyneeded. Each trainee uses 50 hours of a trained manufacturingemployee’s time, so there are 50 fewer hours available formanufacturing. Each trained employee can work up to 170 hours amonth (total time, training or in manufacturing). Management maylay off at most 15% of the trained employees at the beginning ofthe month but must pay one half of that month’s wage for severancepay. A trainee is paid 40% of regular wages for a trained employeeduring their training month. There are 48 trained employeesavailable at the beginning of January. Formulate and solve thishiring-and-training-and-layoffs model as a linear programmingspreadsheet mode