Question: a=319 b=231 c=111 d=30 e=20 a product mix to maximize his daily revenue. Cabinet Carpentry Painting Finishing Net Revenue Style (Hours/ (Hours/ (Hours/ Cabinet) Cabinet)

a=319

b=231

c=111

d=30

e=20

a=319 b=231 c=111 d=30 e=20 a product mix to

a product mix to maximize his daily revenue. Cabinet Carpentry Painting Finishing Net Revenue Style (Hours/ (Hours/ (Hours/ Cabinet) Cabinet) Cabinet) French 3 1.5 0.75 D Provincial Danish 2 0.75 E Modern Department A B Capacity Assume that number of French Provincial cabinets and Danish Modern cabinets are integers. Based on this case a) What is the objective function? Express the objective function in mathematical terms (2 pt) b) What are the constraints given in the question? (i.e. ignore the constraints like all variables being positive, etc.) (6 constraints, 0.5 pt each, 3 pts total) c) Solve the problem using Excel's solver and determine the number of French Provincial models and Danish Modern models needed to be manufactured. (2 pt.) Values are in the next page

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!

MACTAR have a series of contracts to resur face sections of motor ways. The scale of the contract means several years work and each motor way section is regarded as a separate contract. Required:...

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

#6 Table for Problems PROFIT CABINET STYLE CARPENTRY 3.00 2.25 2.50 1360 PAINTING 1.50 1.00 1.25 700 FINISHING 0.75 0.75 0.85 565 578 Caribbean Available hours Students who are trying to raise funds...

PLEASE ANSWER ALL PARTS PART A PART B X2 200- Obiective functions Gupta Furniture manufactures two different types of china cabinets, a French provincial model and a Danish modern model. Each cabinet...

only prob 1 (Production problem) Winkler Furniture manufac- tures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each a cabinet produced must go through...

Tutorial Questions on Linear Programming Formulation Question 1 (Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish...

2-14: Solve the following LP problem by using Excel: Maximize profit = 4X + 5Y Subject to the constraints: 5X + 2Y 40 3X + 6Y 30 X 7 2X - Y 3 X, Y 0 2-18: Solve the following LP problem by using...

ing Gupta 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,...

please solve this using excel. and post the document urgently. inventory Control Flemming Accessories produces paper slicers used in offices and in art stores. The minislicer has been one of its most...

please explain thoroughly thank you :) 200- Objective function 180 yen TO E Gupta Furniture manufactures two different types of china cabinets, a French provincial model and a Danish modern model...

Please answer all parts of the following question Gupta Fumiture manufactures two different types of china cabinets, a French provincial model and a Danish modern model. Each cabinet produced must go...

Figure 34.58 shows an object and its image formed by a thin lens.(a) What is the focal length of the lens, and what type of lens (converging or diverging) is it?(b) What is the height of the image?...

Consider a bank with the following balance sheet: Calculate the banks risk-weightedassets. Assets Liabilities Required Checkable $8 million $3 million $45 million $50 million $100 million Reserves...

Equity Multiplier for 2 0 1 9 What is the equity multiplier for Pharma Biotech Corporation in 2 0 1 9 ? 2 . 1 5 2 7 times 2 . 3 0 7 7 times 2 . 5 2 3 7 times 2 . 7 5 2 7 times

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...