Question

In: Operations Management

A furniture factory produces two types of desks. Type I and type II, in the cutting...

A furniture factory produces two types of desks. Type I and type II, in the cutting and assembly departments. the number of hours available in each department is: in department A 624 hours and in department B it is a third (1/3) more hours than in department A. To manufacture a type I desk unit it takes 3 hours in department A and 8 hours in department B. To manufacture a type II desk unit, 10 hours are required in department A and 5 hours in department B. If the utility for each type II desktop is $ 500,000.00 and the utility of the desk Type I is 20% less than Type II. How many units of each type of desk should be manufactured to MAXIMIZE utility? Find the feasibility intervals for R1 and R2

Solutions

Expert Solution

HI,

Please find the answer as below.

I have used excel solver to solve the problem. I have attached the screenshot of Input Data, Formulas and Constraints used along with the optimal solution, sensitivity report.

Furniture factory need to produce 78 units of Type I desks and 39 units of Type II desks which will give maximum utlity of $ 5,07,00,000.

1. Snapshot of Input Data

2. Snapshot of Formulas Used

3. Snapshot of Constraints Used

4. Snapshot of Optimal Solution

5. Snapshot of Sensitivity report and Limit Report

To get the sensitivity report, we need to remove the integer constraint.

For Coefficients

Feasibility interval for R1 is - (4,00,000-250000) to ( 400000+400000) which is 150000 to 800000.

Feasibility interval for R2 is - (5,00,000-250000) to ( 400000+833333.33) which is 250000 to 1233333.33.

For Constraints

Feasibility interval for C1 is - (624-312) to ( 624 + 1040 ) which is 312 to 1664.

Feasibility interval for C2 is - (832-520) to ( 832+832) which is 312 to 1664.

Limit Report


Related Solutions

A furniture factory produces two types of desks. Type I and type II, in the cutting...
A furniture factory produces two types of desks. Type I and type II, in the cutting and assembly departments. the number of hours available in each department is: in department A 624 hours and in department B it is a third (1/3) more hours than in department A. To manufacture a type I desk unit it takes 3 hours in department A and 8 hours in department B. To manufacture a type II desk unit, 10 hours are required in...
A furniture factory produces two types of desks. Type I and type II, in the cutting...
A furniture factory produces two types of desks. Type I and type II, in the cutting and assembly departments. the number of hours available in each department is: in department A 624 hours and in department B it is a third (1/3) more hours than in department A. To manufacture a type I desk unit it takes 3 hours in department A and 8 hours in department B. To manufacture a type II desk unit, 10 hours are required in...
  A furniture manufacturer produces two types of display cabinets Type A and Type B Each month...
  A furniture manufacturer produces two types of display cabinets Type A and Type B Each month x of type A and y of type B are produced. Profit on type A is 300SR and profit on type B is 150SR. The following constraints control monthly production : (i)              Not more than 50 display cabinets of type A and 40 display cabinets of type B can be made (ii)            To show a profit at least 60 display cabinets in all must...
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 54 type I ovens has a mean repair cost of $80.93. The population standard deviation for the repair of type I ovens is known to be $16.07. A sample of 35 type II ovens has a mean repair cost of $74.68....
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 59 type I ovens has a mean repair cost of $71.68, with a standard deviation of $15.08. A sample of 48 type II ovens has a mean repair cost of $66.21, with a standard deviation of $10.25. Conduct a hypothesis test...
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 40 type I ovens has a mean repair cost of $83.73, with a standard deviation of $10.60. A sample of 31 type II ovens has a mean repair cost of $77.38, with a standard deviation of $17.35. Conduct a hypothesis test...
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 56 type I ovens has a mean repair cost of $⁢76.66, with a standard deviation of $⁢18.63. A sample of 75 type II ovens has a mean repair cost of $⁢72.66, with a standard deviation of $⁢22.09. Conduct a hypothesis test...
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 34 type I ovens has a mean repair cost of $70.86. The population standard deviation for the repair of type I ovens is known to be $12.35. A sample of 48 type II ovens has a mean repair cost of $67.84....
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 6060 type I ovens has a mean repair cost of $74.85$⁢74.85, with a standard deviation of $21.44$⁢21.44. A sample of 4747 type II ovens has a mean repair cost of $72.23$⁢72.23, with a standard deviation of $21.18$⁢21.18. Conduct a hypothesis test...
A technician compares repair costs for two types of microwave ovens (type I and type II)....
A technician compares repair costs for two types of microwave ovens (type I and type II). He believes that the repair cost for type I ovens is greater than the repair cost for type II ovens. A sample of 34 type I ovens has a mean repair cost of $71.37, with a standard deviation of $18.58. A sample of 31 type II ovens has a mean repair cost of $66.93, with a standard deviation of $24.60. Conduct a hypothesis test...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT