Company sells to local dealers throughout the southwest

Assignment Help Operation Management

Reference no: EM132148579

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: Subcontractor 1 Subcontractor 2 Subcontractor 3 Hours required to complete wood tables 50 42 30 Hours required to complete steel tables 60 48 35 Hours available 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.

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.

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?

Based on your model, what is the total cost of completing both projects?

Suppose Subcontractor 2 reduced its costs to $38 per hour. What effect would this change have on the optimal solution? Explain.

Reference no: EM132148579

Questions Cloud

Discuss the strategic networking concept : Discuss the strategic networking concept that you used in the past? Social media should only be a first step to interpersonal interaction.

Employee expectations about learning : 1) How will social learning and social networks influence employee expectations about learning, training, and development?

The different approaches to securing the latest technology : Create a list of two (2) of the most important criteria that would help an organization determine when to upgrade or make a technological investment.

Develop a presentation for communicating strategies : The final project requires you to develop a PowerPoint presentation for communicating strategies to business leaders regarding their recruitment efforts.

Company sells to local dealers throughout the southwest : California Cabinets manufactures outdoor tables the company sells to local dealers throughout the Southwest.

Classified as unreimbursed employee expenses : Taxpayer’s expenses are classified as unreimbursed employee expenses rather than expenses from self-employment?

What do you think is the most important element : What do you think is the most important element when you are about to start business with someone from a foreign company? How should you prepare?

Manpower commitment to the project and the project cost : If possible to find this information or estimates of this information, what was the manpower commitment to the project and the project cost?

Three of the company long-term objectives : Select a company and research their annual report. Summarize two or three of the company's long-term objectives.

User Account

All Pages