Management Science Problem
Not what you're looking for?
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?
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Operations Management
This quiz tests a student's knowledge about Operations Management
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.