Question: (Product mix) Electrocomp's management realizes that it forgot to include two critical constraints (see Problem 2-28). In particular, management decides that to ensure an adequate

(Product mix) Electrocomp's management realizes that it forgot to include two critical constraints (see Problem 2-28). In particular, management decides that to ensure an adequate supply of air conditioners for a contract, at least 50 air conditioners should be manufactured. Because Electrocomp incurred an oversupply of fans in the preceding period, management also insists that no more than 30 fans be produced during this production period. Resolve Electrocomp's problem to find the new optimal solution. Problem 2-28: (Product mix) 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, drilling, and assembly. Each air conditioner takes 3 hours of wiring, 2 hours of drilling, and 1.5 hours of assembly. Each fan must go through 2 hours of wiring, 1 hour of drilling, and 0.5 hours of assembly. During the next production period, 240 hours of wiring time, 140 hours of drilling time, and 100 hours of assembly time are available. Each air conditioner sold yields a profit of $25. Each fan assembled can be sold for a $15 profit. Formulate and solve Electrocomp's problem to find the best combination of air conditioners and fans that yields the highest profit. (Product mix)) Belle Cuisine Kitchen Renovations, located in Qucbec, manufactures custom designed kitchen cabinets in oak or maple. Manufacturing requires cach type of cabjnet to go through three processes: carpentry, staining. and French polishing. The table below shows production times required for ench type of cabinet, available labour hours per day for each of the three processes, and profit per cabinet. The manufacturing plant operates five days a week. Belle Cuisine has a contract with a home renovation firm in Ontario to supply a minimum of 300 of cach type of cabinet per weck. The company wants to determine a production schedule to maximize weckly profit. (a) Formulate as an LP problem. (b) Solve using Excel. Note: Solve using Excel means using SOLVER

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!

=7-15 Electrocomps management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air...

7-14 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...

7 ( Product mix ) Electrocomp's management realizes that it forgot to include two critical constraints ( see Problem 2 - 2 8 ) , In particular, management decides that to ensure an adequate supply of...

objective function and the constraint. 1:The Flair Furniture Company produces inexpensive tables and chairs. The production process for each is similar in that both requires a certain number of hours...

7-14 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...

Electrocomps management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air conditioners...

Electrocomps management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that to ensure an adequate supply of air conditioners for a...

1.Electrocomp's management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that to ensure an adequate supply of air conditioners for...

Do not do this question: 7-14 The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a...

For the data given below plot and provide the requested answers. Make predictions ranges at a temperature of 190 of both an individual value and of averages of groups of 3 values. Are there any...

Define heart

The addition of a risky security to a fully diversified portfollo: Multiple Choice may or may not affect the portfolio beta. will increase the unsystematic risk of the portifilio. must increase the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...