•Table consists of 2 LARGE and 2 SMALL LEGO’s •Chair consists of 1 LARGE and 2...
•Table consists of 2 LARGE and 2 SMALL LEGO’s
•Chair consists of 1 LARGE and 2 SMALL LEGO’s
•Have available 15 LARGE and 22 SMALL LEGO’s for production
–Can use less, but no more than limit
•There is also capacity restrictions (cubic units)
– each Table takes up 6 units, each Chair 4 units
– with no more space than 48 available.
•Table per unit profit of $16, Chair per unit profit of $9
•Determine production of furniture to maximize profit?
•(Assume it is okay to make fractional Tables and Chairs … for now.)
Homework Answers
Formula: D2 =SUMPRODUCT(B2:C2,$B$7:$C$7) copy to D2:D5
Result: Number of Tables to be produced = 6
Number of Chairs to be produced = 3
Total Profit = $ 123
Add Answer to:
•Table consists of 2 LARGE and 2 SMALL LEGO’s
•Chair consists of 1 LARGE and 2...
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...
A small company manufactures three different electronic components for computers. Component A req...
A small company manufactures three different electronic components for computers. Component A requires 2 hours of fabrication and 1 hour of assembly; component B requires 3 hours of fabrication and 1 hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has up to 950 labor-hours of fabrication time and 700 labor-hours of assembly time available per week. The profit on each component, A, B, and C, is $7, $8, and $10,...
A B C /D 25. LINEAR PROGRAMMING: The LEGOS were used to demonstrate Linear Programming principles....
A B C /D 25. LINEAR PROGRAMMING: The LEGOS were used to demonstrate Linear Programming principles. You used up all of the large and small pieces in making furniture (i.e., they were scarce), but had additional hours of labor available (i.e.. they were in surplus). What did the Dual Value of 20 for a large piece mean as it pertains to the Legos? A. Producing one more table / chair costs $20 if a large piece is added or removed....
40. Furniture. A furniture manufacturing company manufac- tures dining-room tables and chairs. The relevant manufactur- ing...
40. Furniture. A furniture manufacturing company manufac- tures dining-room tables and chairs. The relevant manufactur- ing data are given in the table below. oitoon Labor-Hours per Unit Maximum Labor-Hours Table Chair Available per Day 8 2 400 Department Assembly Finishing Profit per unit 1200 $25 (A) How many tables and chairs should be manufactured each day to realize a maximum profit? What is the maximum profit? (B) Discuss the effect on the production schedule and the maximum profit if the...
Please solve using solver in excel, screenshots appreciated!! Product Mix Homework Problem Furnco manufactures desks an...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks! Product Mix Homework Problem Furnco manufactures desks and chairs. Each des...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
In the furniture store that sells tables and chairs, business is good and so the demand...
In the furniture store that sells tables and chairs, business is good and so the demand for tables is up to 500 pieces per week and for chairs up to 300 pieces. The production has a weekly capacity of 1200 hours, with a table taking 40 minutes to produce and a chair 80 minutes. Each table nets a profit of $7/piece but a chair’s profit is now $10. The manager’s goals are to attain a profit of $10,000; to avoid...
ables from two resources-laborat h Solve LDS TUT The Pinewood Furniture Company produces chairs and tables...
ables from two resources-laborat h Solve LDS TUT The Pinewood Furniture Company produces chairs and tables from two mnany has 80 hours of labor and 36 board-ft. of wood available each do for chairs is limited to 6 per day. Each chair requires 8 hours of labor and 2 board. whereas a table requires 10 hours of labor and 6 board-ft. of wood. The profit derived from chair is $400 and from each table, $100. The company wants to determine...
A Furniture Company produces chairs and tables from two resources- labor and wood. The company has 125 hours of labor an...
A Furniture Company produces chairs and tables from two resources- labor and wood. The company has 125 hours of labor and 45 board-ft. of wood available each day. Demand for chairs is limited to 5 per day. Each chair requires 7 hours of labor and 3.5 board-ft. of wood, whereas a table requires 14 hours of labor and 7 board-ft. of wood. The profit derived from each chair is $325 and from each table, $120. The company wants to determine...
InfoAssume thatit takes the US 150 units of labor to produce a table and 30 units...
InfoAssume thatit takes the US 150 units of labor to produce a table and 30 units of labor to produce a chair Assume it takes the Netherlands 100 units of labor to produce a table and 10 units of labor to produce a chair that each country has 4800 units of labor and before trade, each splits their labor evenly between chair and table production Assume that when the countries decide to trade, the country specializing in production specializes in...
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...
A small company manufactures three different electronic components for computers. Component A requires 2 hours of fabrication and 1 hour of assembly; component B requires 3 hours of fabrication and 1 hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has up to 950 labor-hours of fabrication time and 700 labor-hours of assembly time available per week. The profit on each component, A, B, and C, is $7, $8, and $10,...
A B C /D 25. LINEAR PROGRAMMING: The LEGOS were used to demonstrate Linear Programming principles. You used up all of the large and small pieces in making furniture (i.e., they were scarce), but had additional hours of labor available (i.e.. they were in surplus). What did the Dual Value of 20 for a large piece mean as it pertains to the Legos? A. Producing one more table / chair costs $20 if a large piece is added or removed....
40. Furniture. A furniture manufacturing company manufac- tures dining-room tables and chairs. The relevant manufactur- ing data are given in the table below. oitoon Labor-Hours per Unit Maximum Labor-Hours Table Chair Available per Day 8 2 400 Department Assembly Finishing Profit per unit 1200 $25 (A) How many tables and chairs should be manufactured each day to realize a maximum profit? What is the maximum profit? (B) Discuss the effect on the production schedule and the maximum profit if the...
Please solve using solver in excel, screenshots
appreciated!!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to...
Please solve using solver in excel, thanks!
Product Mix Homework Problem Furnco manufactures desks and chairs. Each desk used 4 units of wood, and each chair used 3 units of A desk contributes $40 to profit, and each chair contributes $25 to profit. Marketing restrictions that the number of chairs produced be at least twice the number of desks produced. There are 20 ts of wood available. Determine the mix of desks and chairs to produce in order to maximize...
ables from two resources-laborat h Solve LDS TUT The Pinewood Furniture Company produces chairs and tables from two mnany has 80 hours of labor and 36 board-ft. of wood available each do for chairs is limited to 6 per day. Each chair requires 8 hours of labor and 2 board. whereas a table requires 10 hours of labor and 6 board-ft. of wood. The profit derived from chair is $400 and from each table, $100. The company wants to determine...
InfoAssume thatit takes the US 150 units of labor to produce a table and 30 units of labor to produce a chair Assume it takes the Netherlands 100 units of labor to produce a table and 10 units of labor to produce a chair that each country has 4800 units of labor and before trade, each splits their labor evenly between chair and table production Assume that when the countries decide to trade, the country specializing in production specializes in...
Most questions answered within 3 hours.
-
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 21 minutes ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 52 minutes ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 2 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 2 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 3 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 5 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 5 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 5 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 5 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 5 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 5 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 5 hours ago