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

College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter6: Linear Systems
Section6.8: Linear Programming
Problem 5SC: If during the following year it is predicted that each comedy skit will generate 30 thousand and...
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College
SEE MORE TEXTBOOKS