Purchase Solution

Solving a Production Mix using Excel

Not what you're looking for?

Ask Custom Question

The Anderson Tub Company manufactures two line of bathtubs, called the model A and B. Every tub requires a certain amount of steel and zinc, the company has available a total of 25,000 pounds of steel and 6,000 pounds of zinc. Each model A bathtub requires a total of 125 pounds of steel and 209 pounds of zinc, and each yields a profit of $90. Each model B bathtub can be sold for a profit of $70; it in turn requires 100 pounds of steel and 30 pounds of zinc. Find the best production mix of bathtubs. Solve using QM for windows, or Excel

Purchase this Solution
Solution Summary

This solution provides a sample computation of the given problem in Excel.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • A refinery blends four petroleum components into three grade

    Profit = Revenue - Production cost b. I have done it in Excel using the Tools - Solver function.

  • Excel Solver Product Mix Maximizes Revenues

    Excel and the Excel Solver: (a) What product mix maximizes daily net revenue, and what is daily net revenue?

  • Product mix linear optimization

    447331 Product mix linear optimization Three products a,b,c. Net profit ten dollars for each a, 7.50 each b. 4 for each c. Each a needs 5 hrs production time one hour packing time.

  • Product-Mix Decision Model-Professor Tillerman's Tonic Tea

    This problem builds and solves a quantitative decision model using Excel Solver add-in "Product-Mix Decisions Model" for Professor Tillerman's Tonic Tea. Would help students to build modeling skills in Excel.

  • Inventory Managment: Cost Accounting

    Do the following: a. Formulate the problem as a linear programming problem. b. Determine the optimal mix using a graph. c. Compute the maximum contribution margin given the optimal mix. Please see the attached files. 1.

  • Optimal mix of processes zone; BC Petrol daily demands

    This post addresses how to determine the optimal mix of processes zone, to minimize costs and meet BC Petrol daily demands by using Excel solver

  • Quality Control Charts

    Every hour over the course of 20 hours, we pull a random scoop of trail mix out of the production process. We want to see if we are putting the proper proportion of raisins compared to other ingredients (peanuts, almonds, M&Ms) in our trail mix.

  • Linear programming

    The company wants to determine the blend mix that will meet customer requirements and maximize profits. On the computer, formulate a linear programming model for this problem using excel solver.

  • Dropinsky Company: Drop a product line or division?

    Your tutorial is in Excel (attached). Click in cells to see computations. This gives you a template for solving similar problems.

View More Related Solutions