Question

In: Advanced Math

Winkler Furniture manufactures two different types of china cabinets: a French provincial model and a Danish...

Winkler Furniture manufactures two different types of china cabinets: a French provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob Winkler would like to determine a product mix to maximize his daily revenue.

Formulate as an LP problem and obtain the revenue      

Bob Winkler wants to add this requirment to his production policy: To produce at least as many French Provencial cabinets as Danish Modern.  
How many French Provencial and Danish Modern Cabinets should Bob produce?
What is the impact on revenue of the solution in part d compared to the result in part c?

               

Cabinet Style Carpentry (hours/cabinet) Painting (hours/cabinet) Finishing (hours/cabinet) Net revenue/cabinet ($)
French Provincial 3 1.5 0.75 28
Danish Modern 2 1 0.75 25
Department Capacity (hours) 360 200 125

Solutions

Expert Solution

Let X1 = the number of French Provincial cabinets produced each day

Let X2 = the number of Danish Modern cabinets produced each day

Formulating LP problem:

Maximize 28X1 + 25X2 (maximize revenue)

Subject to: 3X1 + 2X2 ≤360 (carpentry hours available)

1.5X1 + X2 ≤200 (painting hours available)

0.75X1 + 0.75X2 ≤125 (finishing hours available)

X1 ≥60 (contract requirement on F.P. cabinets)

X2 ≥60 (contract requirement on D.M. cabinets)

X1≥90 (produce at least as many F.P. cabinets as D.M. cabinets)

X1, X2 ≥0 (non-negativity constraints)

Optimal Solution:

X1 = 90 X2 = 45

Revenue

Revenue =28*90+25*45= $3,645

But this solution is not feasible
because the final solution violates the  constraint X2≥60 .

How many French Provencial and Danish Modern Cabinets should Bob produce?

90 number of French Provincial cabinets produced each day.

45 number of Danish Modern cabinets produced each day.

What is the impact on revenue of the solution in part d compared to the result in part c?

Revenue is decreased in part d) as compared to result in part c). But part d solution is infeasible because the constraint of X2> 60 doesn't get satisfied.


Related Solutions

Winkler Furniture manufactures two different types of china cabinets A French Provincial model and a Danish...
Winkler Furniture manufactures two different types of china cabinets A French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: Carpentry, Painting and Finishing. The table provided gives all of the production times per cabinet produced and production capacities for each operation per day along with net revenue per unit prodced. The firm has a contract to produce a minimum of 60 cabinets per day. How many of each cabinet should the manufacturer make...
Olomana furniture manufactures file cabinets that are purchased by local businesses. Cabinets are produced in two...
Olomana furniture manufactures file cabinets that are purchased by local businesses. Cabinets are produced in two processing departments, fabricating and assembly. In the fabricating department, all the direct materials are added at the beginning of the process, overhead is applied evenly throughout the entire process and labor is added evenly only during the last 50% of the process. In the assembly department, materials and labor are added evenly throughout the first half of the process, while overhead is applied evenly...
M3_IND1. A furniture cabinet maker produces two types of cabinets, Classic and Modern, that house and...
M3_IND1. A furniture cabinet maker produces two types of cabinets, Classic and Modern, that house and hide LCD TVs. The resource requirements and profit for the two types of cabinets are shown below. Resource Requirements and Profitability Model Materials ($/unit) Labor (hrs./unit) Profit ($/unit)    material($units)    labor(Hours/units)    profits($/units) Classic 800 12    350 Modern 600    4    250 The firm has a budget of $185,000 to spend on materials. The firm has 2,000 labor hours are available...
  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 company manufactures two different types of gloves: a regular model and a catcher’s mitt. The...
A company manufactures two different types of gloves: a regular model and a catcher’s mitt. The table below gives the basic information. Write the objective function, along with the constraints. All times are in hours. Model Cutting and Sewing Finishing Packing and Shipping Profit/Glove Regular 1 ½ 1/8 $5 Catcher 1/2 1/3 1/4 $8 Total Time 900 300 100
Module 3 Individual Problems M3_IND1. A furniture cabinet maker produces two types of cabinets, Classic and...
Module 3 Individual Problems M3_IND1. A furniture cabinet maker produces two types of cabinets, Classic and Modern, that house and hide LCD TVs. The resource requirements and profit for the two types of cabinets are shown below. 800 12 350 The firm has a budget of $185,000 to spend on materials. The firm has 2,000 labor hours are available for use. What is the best combination of furniture cabinets to be made? Solve this two decision variable problem using the...
Chen is president of Chen cabinets Inc., a firm that manufactures two types of metal file...
Chen is president of Chen cabinets Inc., a firm that manufactures two types of metal file cabinets.  Chen has a weekly labor capacity of 1,300 hours, with each smaller cabinet taking 1 hour to produce and the larger cabinet requiring 2 hours each. One wooden plank is used for each smaller cabinet and 1.5 planks are used for each larger cabinet.  Chen can get a supply of a maximum of 1000 planks each week.  Each two-drawer model sold yields a $10 profit, and...
Metal Cabinet, Inc. produces two types of filing cabinets. Material costs for the two drawer model...
Metal Cabinet, Inc. produces two types of filing cabinets. Material costs for the two drawer model are $75. The four-drawer model contains $130 of material. Their estimated monthly conversion costs follow: Costs Sheet Metal Cutting Assembly Painting Labor Costs $40,000 $28,000 $42,000 Handling Costs $10,000 $14,000 $5,000 Maintenance Costs $5,000 $2,000 $5,000 Power Costs $2,000 $2,000 $3,000 Depreciation Expenses $4,000 $2,000 $8,000 General Expenses $3,000 $2,000 $2,000 - - - - Total Hours During the Period 3,200 1,000 5,000 -...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead to all units at the rate of $136 per machine hour. Production information follows. Type A Type B Anticipated volume (units) 27,200 51,000 Direct-material cost per unit $ 36 $ 54 Direct-labor cost per unit 41 41 The controller, who is studying the use of activity-based costing, has determined that the firm’s overhead can be identified with three activities: manufacturing setups, machine processing, and...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead to all units at the rate of $80 per machine hour. Production information follows. Type A Type B Anticipated volume (units) 8,000 15,000 Direct-material cost per unit $ 35 $ 60 Direct-labor cost per unit 20 20 The controller, who is studying the use of activity-based costing, has determined that the firm’s overhead can be identified with three activities: manufacturing setups, machine processing, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT