Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
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, yi 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

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, yi 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

Advanced Engineering Mathematics
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
See similar textbooks
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.
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
steps

Step by step

Solved in 4 steps with 16 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,
SEE MORE TEXTBOOKS