Question: PLEASE ANSWER WITH EXCEL FORMULA'S AND SHEET G and P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major

PLEASE ANSWER WITH EXCEL FORMULA'S AND SHEET

G and P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are indistinguishable from one another; their cost difference is due to a different production sequence. The time in hours required for each model in each production area is tabled here, along with the labor cost.

Model 1

Model 2

Area A

15

3

Area B

4

10

Area C

4

8

Cost

80

65

Currently labor assignments provide for 10,000 hours in each of Areas A and B and 18000 hours in Area C. If 2000 hours are available to be transferred from area B to Area A, 3000 hours are available to be transferred from area C to either Areas A or B, develop the linear programming model whose solution would tell G&P how many of each model to produce and how to allocate the workforce.

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!

Q:

G and P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

G and P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

G and P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

G&P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

G&P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

G&P Manufacturing would like to minimize the labor cost of producing dishwasher motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

X and Y Manufacturing would like to minimize the human power cost of producing machine motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

X and Y Manufacturing would like to minimize the human power cost of producing machine motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

X and Y Manufacturing would like to minimize the human power cost of producing machine motors for a major appliance manufacturer. Although two models of motors exist, the finished models are...

Q:

QUESTION 3: Linear Programming (12 POINTS) X and Y Manufacturing would like to minimize the human power cost of producing machine motors for a major appliance manufacturer. Although two models of...

Q:

Machine C was purchased five years ago for $200,000 and produces an annual real cash flow of $80,000. It has no salvage value but is expected to last another five years. The company can replace...

Q:

The balance of the cash book is an overdraft of $765. The bookkeeper has identified an error whereby a customer receipt of $78 was recorded twice. In addition, uncleared lodgements of $347 have been...

Q:

Question 5 Investor constraints include all the following EXCEPT tiquidity needs. time horizon. level of debt. tax obligations. legal requirements.

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...