Question: Please Explain Ikea produces four types of frames. Each type requires a certain amount of skilled labor, metal, and glass as shown in the table

Please Explain

Ikea produces four types of frames. Each type requires a certain amount of skilled labor, metal, and glass as shown in the table below. The unit selling price of each type is also shown in the table. During the coming week, the company can purchase up to 4,000 hours of skilled labor, 6,000 ounces of metal, and 10,000 ounces of glass. The unit costs are $8 per labor hour, $0.5 per ounce of metal, $0.75 per ounce of glass. Also, market constraints are such that it is impossible to sell more than 1000 type 1 frames, 2000 type 2 frames, 500 type 3 frames, and 1000 type 4 frames.

a) Formulate a linear programming model that maximizes the companys weekly profit and put it in standard format. Clearly define any decision variables and constraints.

b) Solve the problem using Excel solver to find the optimal solution.

c) Based on your solution and analysis, if you need to drop one of the products, which one would it be and why?

d) Based on your solution and analysis, what is the most valuable resource and why?

Please Explain Ikea produces four types of

Skilled Labor Metal Glass Frame 1 Frame 2 Frame 3 Frame 4 INWN INNER Selling Price $28.5 $12.5 $29.25 $21.50

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!

Wayfair produces four types of frames. Each type requires a certain amount of skilled labor, metal, and glass, as shown in the table below. The unit selling price of each type is also shown in the...

Product mix model Input data Hourly wage rate $8.00 Cost per oz of metal $0.50 Cost per oz of glass $0.75 Frame type Frame 1 Frame 2 Frame 3 Frame 4 Labor hours per frame 2 1 3 2 Metal (oz.) per...

use Excel SOLVER B C F G H J K M N 0 10. The Monet company produces four types of picture frames, which we label 1, 2, 3, and 4. the four types of frames differ with respect to size, shape, and...

use Excel : SOLVER The Xentec Company produces four types of picture frames, which we label 1, 2, 3, and 4. the four types of frames differ with respect to size, shape, and materials used. Each type...

* The Monet Company produces four types of picture frames, which we label 1,2, 3, 4. ' The four types of frames differ with respect to size, shape and materials used. ' Each type requires a certain...

. The Rembrandt Frame Company manufactures three types of frames for fine art installation (well call them F1, F2 and F3). The frames have different dimensions and materials used. Each type requires...

Solve using Wthe problem. Producing Frames at Monet (3.1) In a Word document, include screenshots of implementation of the problems using OPL-CPLEX and the solution yielded by the software....

The Monet Company produces four types of picture frames, which are labeled types 1, 2, 3, and 4. The four types of frames differ in size, shape, and materials used. Each type requires a certain...

Let L: R3 R3 be defined by (a) Prove that L is invertible. (b) Find 011 0-0-1 1 123

Column (a) in Table 13.1 shows the monthly return on the British FTSE 100 index from August 1999 through July 2001. Columns (b) and (c) show the returns on the stocks of two firms. Both announced...

1. In the figure below, XY is a chord of the circle with centre O. Point Plies on XY such that OP is perpendicular to XY. Given that XY = 8 cm and op = 3 cm, find the radius of the circle. X 8 cm P 3...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...