Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of an increase in demand for its products, California Cabinets

image text in transcribed

California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of an increase in demand for its products, California Cabinets is considering hiring subcontractors to complete its current backlog of orders. The following information is available for each subcontractor: For example, Subcontractor 1 estimates it will take 50 hours to finish all wood tables and 60 hours to finish all steel tables. However, Subcontractor 1 only has 40 hours available. Therefore, Subcontractor 1 can only complete 40/50 = .80 or 80% of the wood tables if the company worked only on the wood tables or 40/60 = .67 or 67% if it worked only on the steel tables.

  1. Formulate a linear programming model you can use to determine the percentage of wood tables and the percentage of steel tables that should be assigned to each of the three subcontractors to minimize the total cost of completing both projects.
  2. Solve the model from Part 1. What percentage of the wood tables and what percentage of the steel tables should be assigned to each subcontractor?
  3. Based on your model, what is the total cost of completing both projects?
  4. Suppose Subcontractor 2 reduced its costs to $38 per hour. What effect would this change have on the optimal solution? Explain.
image text in transcribed Scenario California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest. Because of an increase in demand for its products, California Cabinets is considering hiring subcontractors to complete its current backlog of orders. The following information is available for each subcontractor: Subcontracto r1 Subcontracto r2 Subcontracto r3 Hours required to complet e wood tables 50 42 30 Hours required to complet e steel tables 60 48 35 Hours availabl e 40 30 35 Cost per hour $36 $42 $55 For example, Subcontractor 1 estimates it will take 50 hours to complete all wood tables and 60 hours to complete all steel tables. However, Subcontractor 1 only has 40 hours available. Therefore, Subcontractor 1 can only complete 40/50 = .80 or 80% of the wood tables if the company worked only on the wood tables or 40/60 = .67 or 67% if it worked only on the steel tables. Essay Questions 1. Formulate a linear programming model you can use to determine the percentage of wood tables and the percentage of steel tables that should be assigned to each of the three subcontractors to minimize the total cost of completing both projects. 2. Solve the model from Part 1. What percentage of the wood tables and what percentage of the steel tables should be assigned to each subcontractor? 3. Based on your model, what is the total cost of completing both projects? 4. Suppose Subcontractor 2 reduced its costs to $38 per hour. What effect would this change have on the optimal solution? Explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Building Your Future

Authors: Robert B. Walker, Kristy P. Walker

1st edition

9780077861728, 978-0073530659

More Books

Students also viewed these Finance questions

Question

What is the primary goal of unit testing?

Answered: 1 week ago