Optimization and Process Analytics Spread Sheet Modeling – Excel and pivot tables.

1. (Chapter 3 in Edition 4-Question 2: Production problem) In PC Tech?s product mix problem,assume there is another PC model, the VXP, that the company can produce in addition to Basicsand XPs. Each VXP requires 8 hours for assembling, 3 hours for testing, $275 for componentparts, 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 theoptimal product mix.[b] You should find that the optimal solution is not integer-valued. If you round the valuesin 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?2. (Chapter 3 in Edition 4-Question 34: Environment Problem) There are 3 factories on theMomiss River. Each emits 2 types of pollutants, labeled P1 and P2, into the river. If thewaste from each factory is processed, the pollution in the river can be reduced. It costs $1500to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0:10ton and the amount of P2 by 0:45 ton. It costs $1000 to process a ton of factory 2 waste, andeach ton processed reduces the amount of P1 by 0:20 ton and the amount of P2 by 0:25 ton. Itcosts $2000 to process a ton of factory 3 waste, and each ton processed reduces the amount ofP1 by 0:40 ton and the amount of P2 by 0:30 ton. The state wants to reduce the amount of P1in the river by at least 30 tons and the amount of P2 by at least 40 tons.a. Use Solver to determine how to minimize the cost of reducing pollution by the desiredamounts. Are the LP assumptions (proportionality, additivity, divisibility) reasonable inthis problem?b. Use SolverTable to investigate the effects of increases in the minimal reductions requiredby the state. Specifically, see what happens to the amounts of waste processed at the threefactories and the total cost if both requirements (currently 30 and 40 tons, respectively)are increased by the same percentage. Revise your model so that you can use SolverTableto investigate these changes when the percentage increase varies from 10% to 100% inincrements of 10%. Do the amounts processed at the three factories and the total costchange in a linear manner?

Don't use plagiarized sources. Get Your Custom Essay on
Optimization and Process Analytics Spread Sheet Modeling – Excel and pivot tables.
Just from $13/Page
Order Essay
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages

Order your essay today and save 15% with the discount code ESSAYHELP