Find the optimal product mix using solver

Assignment Help Mathematics
Reference no: EM131644074

Question: In PC Tech's product mix problem, assume there is another PC model, the VXP, that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for component parts, and sells for $560. At most 50 VXPs can be sold.

a. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix.

b. You should find that the optimal solution is not integer-valued. If you round the values in the changing cells to the nearest integers, is the resulting solution still feasible? If not, how might you obtain a feasible solution that is at least close to optimal?

Reference no: EM131644074

Questions Cloud

Investigate the effects of the minimal reductions : Use Solver Table to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what happens to the amounts.
Solving problem related to the two types of trucks : A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted.
Discuss the changes in the selling prices of models : Discuss the changes in the selling prices of either or both models that would be necessary to make this corner point optimal.
Compare the optimal integer solution to noninteger solution : How does the optimal integer solution compare to the optimal noninteger solution in given problem? Are the changing cell values rounded versions.
Find the optimal product mix using solver : Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix.
Perform each given statement using solver table : Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following.
Create a two-way solver table for the product mix model : Create a two-way Solver Table for the product mix model, where total profit is the only output and the two inputs are the testing line 1 hours and testing line.
Find the selling price required for the given model : Model 8 has fairly high profit margins, but it isn't included at all in the optimal mix. Use Solver Table, along with some experimentation on the correct range.
How companies can use information systems : Conduct some research and provide specific examples including what companies have focused on in these areas and examples of types of information systems

Reviews

Write a Review

Mathematics Questions & Answers

  List the simple events associated with each experiment

A card is selected at random from a standard 52-card deck, and its suit-hearts (h), diamonds (d), spades (s), or clubs (c)-is recorded.

  How many radios had both digital tuners and cd players

Of 100 clock radios with digital tuners and/or CD players sold recently in a department store, 70 had digital tuners and 90 had CD players.

  The front wheel is 25 inches in diameter and back wheel is

a new type of bicycle has a small front wheel and a large back wheel. the front wheel is 25 inches in diameter and the

  Factoring out the greatest common factor

1. Write factored form by factoring out the greatest common factor or a negative common factor if the coefficient of the term of greatest degree is negative -28x^5-4x^4

  Which of the following is not an ethical concern

Which of the following is not an ethical concern for the statistical researcher?

  Find the tension in the rope

A uniform boom AC, 4m long and weighing 50 N is smoothly hinged at C and is supported at A by a rope AB. Find the tension in the rope and the size and direction of the reaction at C.

  How many tennis rackets of each type should csd manufacture

How many tennis rackets of each type should CSD manufacture over the next two weeks to maximize the total profit contribution? Assume that because of the unique nature of their products, CSD can sell as many rackets as they can produce.

  Change in price when the quantity supplied is increased

Use differentials to approximate the change in price when the quantity supplied is increased from 10000 units to 10500.

  Cnsider quadrilateral abcd with a -34 b 26 c 2-1 and d

question consider quadrilateral abcd with a -34 b 26 c 2-1 and d -3-3. find the area and perimeter of abcd. please

  Ethical commponets of the rights and duties approach

Evaluate the ethical commponets of the rights and duties approach. Consider the impact of truth-telling and lying and your responsibility to your employees and the organization as a manager in this situation.

  A square and a rectangle have the same area of 36cm2 what

question a square and a rectangle have the same area of 36cm2. what is thelength of the side of the square? if the

  Matrix representation of r

Let A = {1, 2, 3, 4, 5, 6} = B. Define a relation R as a R b if and only if a + b

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd