Plastics department and completion department respectively

Assignment Help Operation Management

Reference no: EM132163114

Solve the following LP problem using the Solver in MS Excel.

A company which manufactures canoes employs 120 employees, each of whom working 30 hours per week. Half of them work in the carpenter department, 20 persons in the plastics department, and the rest of them at the completion department. The company manufactures the simple canoes with net unit profit € 7 and the luxury canoes with corresponding profit € 10. A simple canoe requires 4.5 hours in the carpenter department and two hours in each of the other two departments. The working hours for each luxury canoe are 5, 1 and 4 at the carpenter department, plastics department and completion department respectively. Marketing calculations have shown that not less than 1/3 and not more than 2/3 of the total number of the canoes should be luxurious. How will the company maximize its overall net profit?

Reference no: EM132163114

Questions Cloud

Studying traffic patterns on one of the busiest highways : The state highway department is studying traffic patterns on one of the busiest highways in the state. Compute the 99% confidence interval for the mean ?

How their role helps in some way towards larger goal : What is the benefit to having every employee understand this from their perspective in how their role helps in some way towards a larger goal,

Disaster planning is planning for the mitigation : Disaster planning is planning for the mitigation of the most likely, or most destructive, events based on some rational thought process

Minimum chemical requirements at minimal cost : How many cubic yards of each food should the farmer blend to meet the minimum chemical requirements at a minimal cost? What is this cost?

Plastics department and completion department respectively : The working hours for each luxury canoe are 5, 1 and 4 at the carpenter department, plastics department and completion department respectively.

What has been your source of that belief system : What have you always believed about God’s valuing of human life and what has been your source of that belief system?

Explain the burden of proof as it relates to bailments : Discuss the probable success of this claim and explain whether bailment occurred. Explain the burden of proof as it relates to bailments.

Favoring no-fault personal injury protection coverage : Which one of the following is not an argument favoring no-fault personal injury protection (PIP) coverage?

Article is connected to building competitive advantage : How your article is connected to building a competitive advantage and five forces model assumptions, what other businesses,

User Account

All Pages