Formulate a linear programming model that maximizes profit

Assignment Help Business Management

Reference no: EM133657541

Problem

Wayfair produces four types of frames. Each type requires a certain amount of skilled labor, metal, and glass, as shown in the table below. The unit selling price of each type is also shown in the table. During the coming week, the company can purchase up to 4,000 hours of skilled labor, 6,000 ounces of metal, and 10,000 ounces of glass. The unit costs are $8 per labor hour, $0.5 per ounce of metal, $0.75 per ounce of glass. Also, market constraints are such that it is impossible to sell more than 1000 type 1 frames, 2000 type 2 frames, 500 type 3 frames, and 1000 type 4 frames.

1. Formulate a linear programming model that maximizes the company's weekly profit and put it in a standard format. Clearly define any decision variables and constraints.

2. Solve the problem using Excel solver to find the optimal solution.

Reference no: EM133657541

Questions Cloud

Disease must you report it to the arkansas department : For each disease that is reportable, how soon after you are made aware that a patient has the disease must you report it to the Arkansas Department of health

Discuss benefit of embracing dei such as better market reach : Discuss the benefits of embracing DEI, such as better market reach, equal opportunities, and fostering a sense of belonging and psychological safety.

What are the appropriate treatment targets for this patient : What are the appropriate treatment targets for this patient's blood pressure? If Mr. So had diabetes, what would be his target blood pressure?

Discuss about the future implications of technology : Like what if we have taken technology too far and write a cautionary narrative that shows future implication.

Formulate a linear programming model that maximizes profit : Formulate a linear programming model that maximizes the company's weekly profit and put it in a standard format.

Define patient compliance and explain its importance : Define patient compliance and explain its importance in outpatient and inpatient surgery departments at the hospital. Identify the health care professional

What is one thing you could adopt from the advice : Find 1 point that resonates with you, and share your thoughts. What do you take away from this article? What is 1 thing you could adopt from this advice?

Research paper on the leo frank trial being unjust : Can I get help writing a thesis for a research paper on the Leo Frank Trial being unjust?

Describe the importance of getting consistent data : Describe the importance of getting consistent data from different remote sensors and analyze them for accuracy and reliability based on the assigned reading in

User Account

All Pages