Advanced Engineering Mathematics
Advanced Engineering Mathematics
10th Edition
ISBN: 9780470458365
Author: Erwin Kreyszig
Publisher: Wiley, John & Sons, Incorporated
Bartleby Related Questions Icon

Related questions

Question

Please help. Do not need EXCEL solver just the LP equation.

Problem 3 Radio Production and Workforce Management. Another electronics company needs
to produce at least 20,000 radios in a four week period. The revenue per unit sold in each week
is given below: The company initially has 40 workers which each produce 50 radios per week.
Table 1: Add caption
Week
1 2 3 4
Revenue (Euro) 20 18 16 14
It is possible to hire apprentice workers who will need to be trained. For training, up to three
apprentices are assigned to a single worker for one week. During this week, the worker produces
no radios. After the week all of the apprentices graduate to workers and begin to produce radios.
There is no limit to the number of apprentices to hire aside that every group of three apprentices
require an additional worker to train them.
A worker costs 200 euros per week while an apprentice costs only 100. Let x; be the number of
workers assigned to production of radios in week i, y; be the number of workers assigned to train
new apprentices in week i, and z; be the number of apprentices to hire in week i. Use these variables
to formulate a linear program which will maximize profit over the four weeks in question. Solve
the LP using Excel-solver and report both your LP and its optimal solution in your submission.
expand button
Transcribed Image Text:Problem 3 Radio Production and Workforce Management. Another electronics company needs to produce at least 20,000 radios in a four week period. The revenue per unit sold in each week is given below: The company initially has 40 workers which each produce 50 radios per week. Table 1: Add caption Week 1 2 3 4 Revenue (Euro) 20 18 16 14 It is possible to hire apprentice workers who will need to be trained. For training, up to three apprentices are assigned to a single worker for one week. During this week, the worker produces no radios. After the week all of the apprentices graduate to workers and begin to produce radios. There is no limit to the number of apprentices to hire aside that every group of three apprentices require an additional worker to train them. A worker costs 200 euros per week while an apprentice costs only 100. Let x; be the number of workers assigned to production of radios in week i, y; be the number of workers assigned to train new apprentices in week i, and z; be the number of apprentices to hire in week i. Use these variables to formulate a linear program which will maximize profit over the four weeks in question. Solve the LP using Excel-solver and report both your LP and its optimal solution in your submission.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Advanced Engineering Mathematics
Advanced Math
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Wiley, John & Sons, Incorporated
Text book image
Numerical Methods for Engineers
Advanced Math
ISBN:9780073397924
Author:Steven C. Chapra Dr., Raymond P. Canale
Publisher:McGraw-Hill Education
Text book image
Introductory Mathematics for Engineering Applicat...
Advanced Math
ISBN:9781118141809
Author:Nathan Klingbeil
Publisher:WILEY
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
Basic Technical Mathematics
Advanced Math
ISBN:9780134437705
Author:Washington
Publisher:PEARSON
Text book image
Topology
Advanced Math
ISBN:9780134689517
Author:Munkres, James R.
Publisher:Pearson,