ZuoTi.Pro
Question

Operations Management

can someone help me to solved this problems ? 

the instruction is formulate mathematical model with using excel solver.

  1. objective function

  2. constrains


Question

The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each heater assembled may be sold for a $15 profit.

Formulate and solve this LP production-mix situation, and

find the best combination of air conditioners and heaters that yields the highest profit.


thank you :)


0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Operations Management
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • PLEASE SHOW HOW TO GRAPH ON EXCEL. I DONT KNOW HOW TO GRAPH IT. please also...

    PLEASE SHOW HOW TO GRAPH ON EXCEL. I DONT KNOW HOW TO GRAPH IT. please also solve as instructed in problem • B.5 The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of...

  • Exercise 1. Found 1 JU m b y P The Electrocomp Corporation manufactures two electrical products:...

    Exercise 1. Found 1 JU m b y P The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up...

  • Need optimal solution for x,y, and value Z The Attaran Corporation manufactures two electrical products: portable...

    Need optimal solution for x,y, and value Z The Attaran Corporation manufactures two electrical products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling During the next production period, 240 hours of wiring time are available and up...

  • .EI ot slimie Final Operations Management Similar to 7-14:0 The Electrocomp Corporation manufactures two electrical products:...

    .EI ot slimie Final Operations Management Similar to 7-14:0 The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and driling. Each air conditioner takes 6 hours of wiring and 2 hours of drilling Each fan must go through 2 hours of wiring and 1 hours of drilling, During the next production period, 240 hours of wiring time are available and up...

  • Similar to 7-14 Electrocomp Corporation manufactures two electrical product ir tu The assembly process for each...

    Similar to 7-14 Electrocomp Corporation manufactures two electrical product ir tu The assembly process for each is similar in that both require a certain amount of wiring fans. and drilling Each air conditioner takes 6 hours of wiring and 2 hours of drilling. Each fan must so through 2 hours of wiring and 1 hours of drilling. During the next production period, 240 hours of wiring time are available and up to 100 hours of drilling time may be used....

  • 1. A company manufactures two products: large fans and medium fans. Each large fan requires 3...

    1. A company manufactures two products: large fans and medium fans. Each large fan requires 3 hours of wiring and 2 hours of drilling. Each medium fan requires 2 hours of wiring and 1 hour of drilling. There are 480 hours of wiring time available and 280 hours of drilling time available. Each large fan yields a profit of $25. Each medium fan yields a profit of $18. The company wants to manufacture at least 20 large fans. The objective...

  • The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require...

    The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next...

  • The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both products require wiring and...

    The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period,...

  • business modelling

    The Sharps Electrical Electronics Corporation manufactures four highly technical products that it supplies to aerospace firms that hold BGP contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table:   The production available in each department each month, and the minimum monthly production requirement to fulfil contracts, are as follows: 5   The...

  • Problem 1 (10 pts): Construct a mathematical model (define your variables, write an objective function and...

    Problem 1 (10 pts): Construct a mathematical model (define your variables, write an objective function and constraints). Problem 2 (10 pts): Use Excel's Solver tool to determine the optimal solution that will maximize profit. Summarize your results. In the Solver toolbox, choose "Simplex LP". Problem 3 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the profit on a small table increases to $12. In the Solver toolbox, rchoose "Simplex LP". If you Copy/Paste from Problem...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT