Maximize profit contribution

Assignment Help Business Management

Reference no: EM1339047

Please work the following problem on an EXCEL spreadsheet. An elegant solution is not required, Just provide all the steps so I will understand the concept and be able to replicate it for similar problems. Also, provide a written description leading me through the solution.

PROBLEM:

A Company must make decisions on weekly production. The Company makes two products; Patio bars and barstools. Each bar contributes $20 and each barstool contributes $8 toward profit. The Company can sell all the products it makes but market demand requires that they must make at least two barstools for each bar that they produce.

There are constraints on production. The Company will have available only 24,000 units of raw materials, 12,000 labor hours, and $20,000 for supplies. Each bar requires 6 units of raw materials, 2 hours of labor, and $3 in supplies. Each barstool requires 3 units of raw material, 4 hours of labor, $3 in supplies. According to the union contract, the Company must produce 4,000 items each week.

The Company plans to maximize profit contribution for the weekly production. How many bars and how many barstools should the Company produce each week?

Reference no: EM1339047

Questions Cloud

Computing the coefficients of variation of project : Which of the following four projects should Mountain Ski Corp. choose? Compute the coefficients of variation to help you make your decision.

Explain how can a company focus on the needs : Explain How can a company focus on the needs of its stakeholders without neglecting its shareholder obligations

Give suggestion an explantion for this observation : A major difficulty in investigating the properties of pancreatic serine proteases is that these enzymes, being proteins, are self digesting. The problem is less severe for solutions of chymotrypsinthan than for solutions of elastase or trypsin.giv..

Describe the effects of a price ceiling also a price floor : Describe the effects of a price ceiling also a price floor on a market. As for what happens with pricing is different than equilibrium, a price Floor is Minimum wage.

Maximize profit contribution : The Company plans to maximize profit contribution for the weekly production. How many bars and how many barstools should the Company produce each week?

Contrasting major differences in musical styles : You are planning to have a variety of live entertainment during the festival. There will be continuous live entertainment on stage.

Estimating cost for the house : What is the estimated cost for the Tolstoy's house if they use contractors to complete all of the house?

Explain filing a personal injury claim : Explain Filing a personal injury claim and Fred Flowers works for Alabama Electric and is a resident of the State of Florida

Discussion on the feasibility of using methylation analysis : make a discussion on the feasibility of using methylation analysis

User Account

All Pages