Purchase Solution

Using Solver to Create Sensitivity Reports

Not what you're looking for?

Ask Custom Question

See attached file.

A furniture manufacturer produces two types of tables (country and contemporary) using three types of machines. The time required to produce the tables on each machine is: router 1.5 country, 2.0 contmeporary, 1000 hours available per week; sander 3.0 country, 4.5 contemporary, 2000 hours available per week; polisher 2.5 country, 1.5 contemporary, 1500 hours available per week. Country tables sell for $350 and contemporary tables sell for $450. Management has determined that at least 20% of the tables made should be country and at least 30% should be contemporary. How many of each type of table should the company produce if it wants to maximize its revenue?

Use Solver to create a sensitivity report and answer the following questions:

a. If the company could get 50 more units of routing capacity, should they do it? If so, how much should they be willing to pay for it?
b. If the company could get 50 more units of sanding capacity, should they do it? If so, how much should they be willing to pay for it?
c. Suppose the polishing time on country tables could be reduced from 2.5 to 2 units per table. How much should the company be willing to pay to achieve this improvement in efficiency?
d. Contemporary tables sell for $450. By how much would the selling price have to decrease before we would no longer be willing to produce contemporary tables?

Attachments
Purchase this Solution
Solution Summary

The following posting uses solver to create sensitivity reports and answers various related problems.

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

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.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Programming/Excel Solver/Sensitivity Report

    505250 Linear Programming using Excel Solver and a Sensitivity Report 1) An auto parts manufacturer produces three different parts: Model A, Model B, and Model C.

  • Excel 2003 Multiple Choice

    Once you find an acceptable solution, Solver lets you create all of the following summary reports except: a. Answer b. Sensitivity c. Demo d. Limits e. all of these reports can be created Save Answer 7.

  • A plant can manufacture four different products

    A sensitivity report obtained using a solver is determined.

  • LP solved in Excel Solver with Sensitivity Report

    Use Solver to create a Sensitivity Report. Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report.

  • Linear Programming Problem: Mobile Chair Company

    Then we can use the original linear programming method by changing the constraint of production from 10000 to 10100.(0ther things being equal) Running SOLVER again, we can get the new report, including limits and sensitivity reports, etc.

  • Steel mill production planning

    Solver solution along with help on how to solve it using Solver 3. Answer and sensitivity reports to generate further insights How to identify binding constraints and how to analyze shadow prices. Hope this helps you.

  • Linear Optimization Model Problem

    Formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the production manager explaining the sensitivity information. b.

  • 3 Tea Blends: Operations Research for current product mix and optimal mix

    If you want to have a look at the solver output it is there in the output file. Using Excel solver, the solution presents the sensitivity table layout for the optimal mix.

  • Linear programming model

    459776 Burger Doodle restaurant - using excel solver Solve the linear programming model developed in Problem 22 for the Burger Doodle restaurant by using the computer. a.

View More Related Solutions