Question: How can I calculate the quantity ( 6.7, 41.3,9.2 )and hour used (105,240,320,665) ? I don't know the calculation of this two, even if you

How can I calculate the quantity ( 6.7, 41.3,9.2 )and hour used (105,240,320,665) ? I don't know the calculation of this two, even if you give me the excel explain... is not helping. Please give me the Math calculation .
How can I calculate the quantity ( 6.7, 41.3,9.2
How can I calculate the quantity ( 6.7, 41.3,9.2
16. Incline Electronics produces three ditterent products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines Product 1 Product 2 Product 3 Machine 1 2 1 Machine 2 3 4 6 Machine 3 Each machine must be run by one of 19 cross-trained workers who are each availa- ble 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available, and 8 type 3 machines available. Products 1, 2, and 3 contribute $90, $120, and $150, respectively, in marginal profit per unit produced. a. Formulate an LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution? d. How many workers should be assigned to each type of machine? Let x. - product Xa aproduct Xy; prochet 3. - products 1,2,3 contribute 890, $20, $150 repertunty. Max 90x + 120 X + 150 Xs. Haslo type I machines, 6 2 meches & type & rafines, wattle Open 40 hores (weak machine 140x10=400 machine 2=40x6 2240, nechine 3, 4x8=320 hours/week. 7. machine I = 22, + 2X + X 4400 machine 2-3x, +4x2+61 240 nachine 4x +6x2 + 4x3 120 X.X.X; 20. wurkers 9x.+ IX. tnx $\66) excel on the next page. optimal solution - 1.7 * 90 * 41.3 ne +9.1x 190 2 6521 traclone 1 los houm & 35. 3 workers Machine 2 240 hours 15 +6.9 workers a7 norten d 20 hours 159.14 woolen ~ lonkers. product 1 product 2 product 3 Quantity 6.7 41.3 9.2 unit profit 90.0 120.0 150.0 total profit b 6925.0 2.0 3.0 machine 1 machine 2 machine 3 total labor 2.0 4.0 6.0 12.0 1.0 6.0 5.0 hours usec hours available 105.0 400.0 240.0 240.0 320.0 320.0 665.0 665.0 4.0 9.0 12.0 Maximize: F3 By changing: B2:D2 Subject To: E6:59

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!