A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $250 to profit, and a chair contributes $145. Marketing restrictions require that the number of chairs produced be at least four times the number of desks produced. There are 2,000 units of wood available.
Use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 1,000 to 3,000 in 100-unit increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2,000 units? How much profit would the company lose if it lost any of its current 2,000 units?
Round the answer to a whole dollar amount = $ ___
A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop was completely devoted to painting type 1 trucks, 650 per day could be painted, whereas if the painting shop was completely devoted to painting type 2 trucks, 550 per day could be painted. If the assembly shop was completely devoted to assembling truck 1 engines, 1,400 per day could be assembled, whereas if the assembly shop was completely devoted to assembling truck 2 engines, 1,000 per day could be assembled. It is possible, however, to paint both types of trucks in the painting shop. Similarly, it is possible to assemble both types in the assembly shop. Each type 1 truck contributes $2,500 to profit; each type 2 truck contributes $3,000.
Use Solver to maximize the company's profit.
Total Profit: $
A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each...
2. Priceler manufactures sedans and wagons. The number of vehicles that can be sold each of the next three months are listed to Table 1. Each sedan sells for $10000 and each wagon sells for $11000. It cost $7000 to produce a sedan and $8000 to produce a wagon. To hold a vehicle inventory for one month cost $160 per sedan and $210 per wagon. During each month, at most 1600 vehicles can be produced Production line restrictions dictate that...
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...
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...
1. Consider the following LP: Max z 5x1 X2 st. 2x1 xS6 6x1X2S 12 Plot the constraints on the graph and identify the feasible region and determine the optimal value of the objective function and the values of the decision variables. 2. Priceler manufactures sedans and wagons. The number of vehides that can be sold each of the next three months are listed to Table 1. Each sedan sells for $10000 and each wagon sells for $11000. It cost $7000...
QUESTION TWO A. Fiifi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could...
QUESTION TWO A. Fiifi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
Furniture Face Lift refinishes old wood furniture. Their process for refinishing chairs has 8 workers and 4 stations. Each chair starts at the Stripping station, then goes to Priming, then to Painting and finally to Inspection. Where there are multiple workers within a station, each worker works independently on his/her own chair. Assume inventory buffers are allowed between each station. Station Staffing Processing time (hours per chair per worker) Stripping 3 2.5 Priming 2 1.5 Painting 2 1 Inspection 1...
ii) Treehouse Furniture manufactures a variety of desks, chairs, tables and shelf units which are sold to public school systems throughout Queensland. The accountant of the company's School Desk Division is currently preparing a budget for the first quarter of 20x9. The following sales forecast has been made by the division's sales manager. January February March 5,000 desk and chair sets 6,000 desk and chair sets 7,500 desk and chair sets Each desk and chair set requires 10 metres of...
Prescott Corp. manufactures computer desks in its Rochester, New York, plant. The company uses activity-based costing to allocate all manufacturing conversion costs (direct labor and manufacturing overhead). Its activities and related data follow (Click the icon to view the activity areas and related data) Requirements 1. Compute the per-unit manufacturing product cost of Standard desks and Unpainted desks. 2. Premanufacturing activities such as product design, were assigned to the Standard desks at S6 each and to the Unpainted desks at...