Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Generating Station in the Ottawa/St. Lawrence area. Its personnel department has been directed to determine how many technicians need to be hired and trained for

image text in transcribed
Generating Station in the Ottawa/St. Lawrence area. Its personnel department has been directed to determine how many technicians need to be hired and trained for the November - February period. The station currently employs 250 fully trained technicians and projects the following personnel needs: By Ontario regulations, a technician can actually work no more than 130 hours per month. Negotiated policy at Power Generation Inc. also dictates that layoffs are not acceptable in the months when the station is overstaffed. So, if more trained employees are available than are needed in any month, each worker is still fully paid, even though the trainee is not required to work the 130 hours. Training new employees is an important and costly procedure. It takes one month of one-on-one classroom instruction before a new technician is permitted to work alone in the facility. Therefore, Power Generation Inc. must hire trainees one month before they are actually needed. Each trainee teams up with a skilled technician and requires 70 hours of that employee's time, meaning that 70 hours less of the technician's time are available that month for actual work. Personnel department records indicate a turnover rate of trained technicians at 6% per month. In other words, about 6% of the skilled employees at the start of any month resign by the end of that month. A frained technician earns an average monthly salary of $5,000 (regardless of the number of hours worked, as noted earlier). Trainees are paid $3,000 during their one month of instruction. Power Generation Inc. wants to find the best staffing schedule for the four-month period while minimizing the total labour cost incurred. a. Formulate algebraically the Linear Programming (LP) model for this problem. (16 points) b. Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding "Excel Spreadsheet" and the "Answer Report"). Include "managerial statements" that communicate the results of the analyses. (i.e., describe verballyarratively the results). N.B.: it is OK to have decimal solutions. (13 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions