Maximize profit contribution
Course:- Business Management
Reference No.:- EM1339047

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Business Management

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.


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?

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Business Management) Materials
Goals and techniques that is ordinary in the work power. From this data, construct an objective attestation for the human reference administration capacity of a considerable
Leadership and management with specific examples from the text, literature, or personal example. What are some of the different leadership and management roles and what are
This question involves an explanation of ethical behavior in the workplace. Explain what it means to demonstrate positive ethical behavior in the workplace. Include examples
Justify and explain your decision to lie about having second offer, and what were consequences of your decision to lie to the buyer. Write between 750 - 1,250 words (approxim
What role will Redbox and other competitors play in the development of Netflix's strategic plans? How threatening are these competitors to Netflix's future?
Develop a guerrilla marketing strategy for your small business. Discuss the most appropriate location for a second store (an actual street address). Explain your reasoning.
illustrate what is the market predicting about the movement of future short-term interest rates? Illustrate what might the yield curve indicate about the market predictions
Hal is electrocuted however survives and files a suit against GBC for damages, alleging that GBC was negligent. A.) Will Hal be successful in his claim B.) How might GBC defen