Reference no: EM131394708
Q1. 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?
Q2. In the product mix model it makes sense to change the maximum sales constraint to a "minimum sales" constraint, simply by changing the direction of the inequality. Then the input values in row 23 can be considered customer demands that must be met. Make this change and rerun Solver. What do you find? What do you find if you run Solver again, this time making the values in row 23 one-quarter of their current values?
Q3. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don't forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optimal production quantity in month 1?
Attachment:- Assignment Files.rar
|
Define the term logic and Premise
: Define the following terms: - logic - Premise - inference- argument- conclusion - proposition- statement - conclusion indicator - syllogistic logic.
|
|
What structure would you give to the training
: What structure would you give to the training and how would you know it works? None of the research you list was included in the essay. Why not? What peer reviewed ideas can support the answers to my questions?
|
|
Find the correlation of flights with year
: The number of flights by U.S. Airlines has grown rapidly. Here are the number of flights flown in each year from 1995 to 2005.- Find the correlation of Flights with Year.- Make a scatterplot and describe the trend.
|
|
Design and discuss how the costume designer achieved
: Please select a movie or play that embodies these qualities of costume design and discuss how the costume designer achieved these qualities by using specific examples from the movie or play
|
|
Modify the spreadsheet model to include new product
: 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. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix
|
|
Differences between ip addresses and mac addresses
: Explain the difference between packet switching and circuit switching. Describe the differences between IP addresses and MAC addresses. Diagram the route of data over an Ethernet and discuss how collisions are detected and/or avoided.
|
|
What subjective factors would affect the investment decision
: What subjective factors would affect the investment decision? Compute the before-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment.
|
|
Create a risk assessment on sangrafix
: Create a Risk Assessment on SanGrafix, a video game design company - Risk Assessment can be as simple as noting an unlocked door or a password written on a note, or it can be a complex process requiring several team members and months to complete.
|
|
Difference between an analog and digital signal
: Explain the difference between an analog signal and a digital signal. Explain why most modern communications systems use digital signals.
|