Make sure you show how many of each of the types of cabinets should be produced. It should be done using Excel Solver. Thanks
Homework Answers
Let Assume Xij represent the number of cabinets for each type where i = 1,2 and represent the Cabinet A & B and j = 1,2,3 and represent the type of woods.
And simultaneously Yij represent the revenue per unit and Zj represent the cost per unit
X11 = Cabinet A with Maple
X12 = Cabinet A with Pine
X13 = Cabinet A with Walnut
X21 = Cabinet B with Maple
X22 = Cabinet B with Pine
X23 = Cabinet B with Walnut
Objective -
Max Z = Sum of (Xij*Yij) - (X11+X21)*Z1 - (X12+X22)*Z2 - (X13+X23)*Z3
Constraints -
X11 + X21 <= 400
X12 + X22 <= 600
X13 + X23 <= 200
X11 + X12 + X13 >= 400
X21 + X22 + X23 >= 600
Xij >= 0
Below is the screenshot of the LP table in excel -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the result obtained -
Add Answer to:
Make sure you show how many of each of the types of cabinets should be produced....
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a...
1) 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 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...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the...
(Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and...
(Production problem) 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...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the...
Please make sure you label each part of the question, and please make sure to show...
Please make sure you label each part of the question,
and please make sure to show ALL of your math work! Please make
sure your handwriting is clear and easy to read. Thank
you!
2. Suppose labor (L) and capital (K) are fixed proportion inputs, and that each unit of output must be produced with exactly 5 units of labor and 2 unit of capital. The price of a unit of labor is w, and the price of a unit...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments include Cutting and Assembly. The Janitorial and Security departments support the Cutting and Assembly departments. The Assembly Department spans about 51,200 square feet and holds assets valued at about $67,840. The Cutting Department spans about 28,800 square feet and holds assets valued at about $144,160. Charlie's Wood Works allocates support department costs using the direct method. If costs from the Janitorial Department are allocated...
Chicago Corporation manufactures filing cabinets in two operations machining and finishing. It provides the following information...
Chicago Corporation manufactures filing cabinets in two operations machining and finishing. It provides the following information Click the icon to view the department information) h cabinet sells for $65 and has direct material costs of $30 incurred at the start of the machining operation. Chicago has no other variable costs. Chicago can sell whatever output connection between the requirements X Requirements i Data Table 1. Chicago is considering using some modern jigs and tools in the finishing operation that would...
A furniture firm makes three types of tables: coffee table, side table and dining room table,...
A furniture firm makes three types of tables: coffee table, side
table and dining room table, and two types of chairs : arm chair
and side chair. A coffee table requires 35 unit s of wood, a side
table needs 45 units of wood, and a dining room table requires 95
units of wood. In addition, an arm chair requires 40 units of wood
and a side chair needs 30 units of wood. There are at most 9800
units of...
**Please Show Steps in Excel** Each coffee table produced by Home Woods nets the firm a...
**Please Show Steps in Excel** Each coffee table produced by Home Woods nets the firm a profit of $15. Each bookcase yields a $20 profit. Home Wood’s firm is small and its resources limited. During any given production period (of 1 week), 20 gallons of varnish and 15 lengths of high quality redwood are available. Each coffee table requires approximately 2 gallon of varnish and 1 length of redwood. Each bookcase takes 1 gallon of varnish and 2 lengths of...
Using Linear Programing to solve Make or Buy problem. The Carson Stapler Manufacturing Company forecasts a...
Using Linear Programing to solve Make or Buy problem. The Carson Stapler Manufacturing Company forecasts a 5000-unit demand for its Sure-Hold model during the next quarter. This stapler is assembled from three major components: base, staple cartridges, and handle. Until now Carson has manufactured all three components. However, the forecast of 5000 units is a new high in sales volume, and it is doubtful that the firm will have sufficient production capacity to make all the components. The company is...
1) 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 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...
Please make sure you label each part of the question,
and please make sure to show ALL of your math work! Please make
sure your handwriting is clear and easy to read. Thank
you!
2. Suppose labor (L) and capital (K) are fixed proportion inputs, and that each unit of output must be produced with exactly 5 units of labor and 2 unit of capital. The price of a unit of labor is w, and the price of a unit...
Charlie's Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments include Cutting and Assembly. The Janitorial and Security departments support the Cutting and Assembly departments. The Assembly Department spans about 51,200 square feet and holds assets valued at about $67,840. The Cutting Department spans about 28,800 square feet and holds assets valued at about $144,160. Charlie's Wood Works allocates support department costs using the direct method. If costs from the Janitorial Department are allocated...
Chicago Corporation manufactures filing cabinets in two operations machining and finishing. It provides the following information Click the icon to view the department information) h cabinet sells for $65 and has direct material costs of $30 incurred at the start of the machining operation. Chicago has no other variable costs. Chicago can sell whatever output connection between the requirements X Requirements i Data Table 1. Chicago is considering using some modern jigs and tools in the finishing operation that would...
A furniture firm makes three types of tables: coffee table, side
table and dining room table, and two types of chairs : arm chair
and side chair. A coffee table requires 35 unit s of wood, a side
table needs 45 units of wood, and a dining room table requires 95
units of wood. In addition, an arm chair requires 40 units of wood
and a side chair needs 30 units of wood. There are at most 9800
units of...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago