Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm looking for help with 3 optimization problems for school. The assignment is not due until Tuesday at midnight. Is there someone available to help

I'm looking for help with 3 optimization problems for school. The assignment is not due until Tuesday at midnight. Is there someone available to help tutor me with this and possibly help later in the future to help me prepare for the mid term and final?

Stuck on problem 3.

2. In PC Tech's product mix problem, assume there isanother PC model, the VXP, that the company canproduce in addition to Basics and XPs. Each VXPrequires eight hours for assembling, three hours fortesting, $275 for component parts, and sells for $560.At most 50 VXPs can be sold.a. Modify the spreadsheet model to include this newproduct, and use Solver to find the optimal productmix.b. You should find that the optimal solution is notinteger-valued. If you round the values in the decision variable cells to the nearest integers, is theresulting solution still feasible? If not, how mightyou obtain a feasible solution that is at least closeto optimal?3. Continuing the previous problem, perform a sensitivity analysis on the selling price of VXPs. Let thisprice vary from $500 to $650 in increments of$10, and keep track of the values in the decisionvariable cells and the objective cell. Discuss yourfindings.

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

Applied Linear Algebra

Authors: Peter J. Olver, Cheri Shakiban

1st edition

131473824, 978-0131473829

More Books

Students also viewed these Mathematics questions

Question

Who heads the council of ministers?

Answered: 1 week ago

Question

Who Coined and used the ward non aligned first?

Answered: 1 week ago

Question

Formation of forward bloc by subha bose was .....?

Answered: 1 week ago

Question

The S.I. unit of change is........?

Answered: 1 week ago