Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tony Manufacturing makes two products: rockers and chairs. Each product produced goes through the following 3 manufacturing processes: Cutting Sanding Finishing Each rocker produced requires

Tony Manufacturing makes two products: rockers and chairs. Each product produced goes through the following 3 manufacturing processes:

  1. Cutting
  2. Sanding
  3. Finishing

Each rocker produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing. Each chair requires 30 minutes in cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week, Tony manufacturing has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume all rockers produced can be sold for a profit $500 each, while each chair can be sold for a profit of $400 each. ABC manufacturing would like to determine the optimal production mix of rockers and chairs in order to maximize its weekly profit.

a. Formulate this problem as a linear programming problem. That is, make sure to specify what the decision variables are, what the objective function is, and what the relevant constraints are.

b. Set up the problem in a spreadsheet and solve it using Solver.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Techniques in Business and Economics

Authors: Douglas A. Lind, William G Marchal

17th edition

1259666360, 978-1259666360

More Books

Students also viewed these Mathematics questions

Question

Explain the strength of acid and alkali solutions with examples

Answered: 1 week ago

Question

Introduce and define metals and nonmetals and explain with examples

Answered: 1 week ago