[solved]-Problem 1 Gadget Added Model 3 Linear Programing Tesla Motors Preparing Launch New Car Tes Q39641998

Use Excel Solver

Problem 1 gadget to be added to the Model 3. (Linear Programing) Tesla Motors is preparing to launch their new car Tesla currently has 100 manufacturing techni cians ready for the job. During the next 3 months, Tesla plans to produce the following number of new gadgets: Model 3 Gadgets Month September October 20 24 November 30 Each manufacturing technician can either be placed in manufacturing or instruct new team members. A new team member can become an apprentice in one month. The following month, that apprentice becomes a qualifiedmanufacturing technician (after 2 months from beginning the training). Each instructor can train 2 new team members. The producti on quanti ties and earnings per employee presented below are Production Rate (Gadgets/Month) Salary per Month $3,000 Employee Manufacturing 0.6 Instructor 0.3 3,300 2,600 2,200 Apprentice 0.4 0.05 New Member At the end of November, Tesla wouldlike to have no new members or apprentices but at least 140 full time workers. Formulate and solve a linear program for Tesla to accomplish this at minimum total cost. Show transcribed image text Problem 1 gadget to be added to the Model 3. (Linear Programing) Tesla Motors is preparing to launch their new car Tesla currently has 100 manufacturing techni cians ready for the job. During the next 3 months, Tesla plans to produce the following number of new gadgets: Model 3 Gadgets Month September October 20 24 November 30 Each manufacturing technician can either be placed in manufacturing or instruct new team members. A new team member can become an apprentice in one month. The following month, that apprentice becomes a qualifiedmanufacturing technician (after 2 months from beginning the training). Each instructor can train 2 new team members. The producti on quanti ties and earnings per employee presented below are Production Rate (Gadgets/Month) Salary per Month $3,000 Employee Manufacturing 0.6 Instructor 0.3 3,300 2,600 2,200 Apprentice 0.4 0.05 New Member At the end of November, Tesla wouldlike to have no new members or apprentices but at least 140 full time workers. Formulate and solve a linear program for Tesla to accomplish this at minimum total cost.

Expert Answer

---

Answer to Problem 1 gadget to be added to the Model 3. (Linear Programing) Tesla Motors is preparing to launch their new car Tesla… . . .