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 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 to maximize daily revenue.

Please show how to set up in excel and how to get the answer using solver in excel

Solutions

Expert Solution


Decision variables:

X1 = No of  French Provincial cabinets produced each day

X2 = No of Danish Modern cabinets produced each day

Objective function is to maximize the Revenues

Max Z = 28 X1 + 25 X2

Constraints:

3 X1 + 2 Y2 <=360 (Carpentry hours available)

1.5 X1+X2 <= 200 (Painting hours available)

0.75X1 + 0.75X2 <= 125 ( Finishing hours available)

X1 >= 60(contract requirement on French Provincial(F.P) cabinets)

X2 >=60 (contract requirement on Danish Modern(D.M) cabinets)

X1, X2>= 0 (Non negativity constraints)

I am using excel solver to solve this problem. Below are the images for the solution




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

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

Total revenues Z = $3930


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