Question
The B W Harris Company is a steel fabrication company that has recently negotiated a contract to supply T. Breuner Industries with steel trusses on
The B W Harris Company is a steel fabrication company that has recently negotiated a contract to supply T. Breuner Industries with steel trusses on a monthly basis. It employs both skilled workers and apprentices. The average output of a skilled worker is three trusses per hour; apprentices average two trusses per hour. Including benefits, each skilled worker costs the BWHarris Company $3840 per month, and each apprentice costs Harris $2400 per month. The B W Harris Company is a "union shop" and has negotiated the following agreements with the union which requires that the workforce to be used for the contract with T. Breuner Industries:
At least 25 skilled workers will be used.
At least 15 more skilled workers than apprentices will be used.
The maximum budget for labor costs is $200,000.
Assume each worker works 160 hours per month and both skilled workers and apprentices can be assigned "parttime" so that fractional values are permitted.
Required: Solve this LP model by using Excel and computer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started