Purchase Solution

Linear Programming Manufacturing Plans

Not what you're looking for?

Ask Custom Question

Davis instruments has two manufacturing plants located in Atlanta, Georgia. Since product demand varies considerably from month to month, Davis is interested in developing an optimal workforce schedule. Recently Davis started hiring temporary workers supplied by Workforce Unlimited, a company that specializes in providing temporary employees for firms in Georgia. Workforce Unlimited offered to provide temporary employees under three contract options that differ in terms of the length of employment and the cost. The three options are summarized:

Option
Length of Employment
Cost

A
One month
$2,000

B
Two months
$4,800

C
Three months
$7,500
The longer contract periods are more expensive because Workforce Unlimited experiences greater difficulty finding temporary workers who are willing to commit to longer work assignments. Over the next six months, Davis projects the following needs for additional employees:

Month
Employees Needed

January
10

February
23

March
19

April
26

May
20

June
14
Each month, Davis can hire as many temporary employees as needed under each of the three options. For instance, if Davis hires five employees in January under Option 2, Workforce Unlimited will supply Davis with five temporary workers who will work two months: January and February. For these workers, Davis will have to pay 5* ($4800) = $24,000. Because of some merger negotiations under way, Davis does not want to commit to any contractual obligations for temporary employees that extend beyond June. Davis's quality control program requires each temporary employee to receive training at the time of hire. The training program is required even if the person worked for Davis in the past. Davis estimates that the cost of training is $875 each time a temporary employee is hired. Thus, if a temporary employee is hired for one month, Davis will incur a training cost of $875, but will incur no additional training cost if the employee is on a two- or three-month contract.
Develop a LP/ILP model that can be used to determine the number of temporary employees Davis should hire each month under each contract plan in order to meet the projected needs at a minimum total cost.

A. Provide a schedule that shows the number of temporary employees that Davis should hire each month for each contract option.

B. Prepare a summary table that shows the number of temporary employees that national should hire under each contract option, the associated contract costs, and total training costs.

C. If the cost to train each temporary employee could be reduced to $700 per month, what effect would this change have on the hiring plan? Explain. How much of a reduction in training costs would be required to change the hiring plan based on a training cost of $875 per temporary employee?

D. Suppose that Davis hired 10 full-time employees at the beginning of January in order to satisfy part of the labor requirements over the next six months. If Davis can hire full-time employees for $16.50 per hour, including fringe benefits, what effect would it have on total labor and training costs over the six-month period as compared to hiring only temporary employees? Assume that full-time and temporary employees both work approximately 160 hours per month.

Attachments
Purchase this Solution

Solution Summary

Linear programming manufacturing plans are examined.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.