Reference no: EM13752594
Part - A
a. How can a manager prepare for changing conditions using sensitivity analysis?
b. What is meant by sensitivity analysis?
c. What is meant by an allowable range for a coefficient in the objective function?
d. How would you use the values in the allowable increase and allowable decrease columns in the sensitivity report provided by Solver?
Part - B
Q1: New research findings indicate that short sightedness among the aged can be cured if their diet is supplemented with three minerals; which are rare to obtain from natural sources of food and, also difficult to absorb in the human body. A company desires to produce a new vitamin tablet for treating short sightedness among aged people and discovers the ideal composition of the tablet should consist of exactly 40% Magnesium, 35% Beta-Carotene and 25% Zinc. Various sources for obtaining these minerals and their costs are given in the table below.
Food Sources
|
Mineral content
|
Broccoli
|
Carrots
|
Kale
|
Spinach
|
Beet
|
Magnesium %
|
60
|
25
|
45
|
20
|
50
|
Beta-Carotene %
|
10
|
15
|
45
|
50
|
40
|
Zinc %
|
30
|
60
|
10
|
30
|
10
|
Cost per pound
|
$22
|
$20
|
$25
|
$24
|
$27
|
The objective is to determine the proportions of these food sources that should be blended to produce the new vitamin tablet at a minimum cost.
e. Formulate and solve a LP model for the problem on a spreadsheet.
f. Identify and list the functional constraints.
g. What is the optimum solution?
h. Produce a sensitivity report and interpret the allowable increase and allowable decrease columns for your manager in a few sentences.
Q2: A new fitness club offers two types of exercise equipment for their members. The machines are the latest in the industry and produce reports of the calories burned in detail. The calories burned by using each machine are given below:
Calories Burned Every 15 Minutes
|
Machine Setting
|
Treadmill
|
Elliptical Cross Trainer
|
Medium Intensity
|
5
|
3
|
Low Intensity
|
2
|
2
|
High Intensity
|
7
|
9
|
The gym charges guests by the number of calories burned using each machine and it costs $0.60 for using the Treadmill and $ 0.50 for using the Elliptical Cross Trainer. Each guest must burn at least 60, 30 and 126 calories using the three intensity settings on both machines to complete their workout regimen.
a. Implement your model in a spreadsheet and solve it.
b. Produce a sensitivity analysis report and interpret clearly how the resulting values under the Variable Cells and Constraints tables can be used.
Q3: A company produces fork lifts in three plants and needs to ship them to their five distribution centers located across Indiana. Specialized fork lift carriers are required to transport the fork lifts. The freight cost charged by the carrier is 50 cents per mile plus $100 for toll charges per trip/destination since all carriers use the Tri-State Toll Way. Plants 1, 2 and 3 manufacture 12, 17 and 11 fork lifts per month respectively. Each distribution center must receive 10 fork lifts per month.
a) Determine how many fork lifts need to be shipped from each plant to minimize costs by implementing the model in a spreadsheet.
b) Produce a suitable report to identify all binding constraints, list and interpret them for your manager in a few sentences.
Distances from plant to distribution center
|
Plant
|
A
|
B
|
C
|
D
|
1
|
800
|
1300
|
400
|
700
|
2
|
1100
|
1400
|
600
|
1000
|
3
|
600
|
1200
|
800
|
900
|
Q4: A company installs stereo systems for three vehicles. The installation time varies depending on the type of vehicle. Since business volumes are low, the business is managed with two workers. The installation times for the three vehicles are given below:
Installation Time Requirements
|
|
Vehicle 1
|
Vehicle 2
|
Vehicle 3
|
Tom
|
0.02
|
0.03
|
0.05
|
John
|
0.05
|
0.02
|
0.04
|
Each worker is allowed to work a maximum of 40 hours per week and the profit per generated per vehicle is as follows:
Profit per vehicle
|
Vehicle 1
|
Vehicle 2
|
Vehicle 3
|
$50
|
$40
|
$30
|
a. Implement your model in a spreadsheet and solve it.
b. Perform a sensitivity analysis and compute the maximum and minimum hours Tom and John can work?
c. What does the shadow price calculated for Tom mean to you?
What are the company''s most vulnerable areas
: What must happen in order for the company to succeed. What are the company's most vulnerable areas
|
What number of workers appears to be most efficient
: What number of workers appears to be most efficient in terms of pizza product per worker - What number of workers appears to minimize the marginal cost of pizza production assuming that each pizza worker is paid $500 per week?
|
Create a powerpoint of the important events of the civil war
: Create a PowerPoint of the important events of the Civil War. Your slides should included thorough explanations of the events/battles and at least 10 photographs or graphics that represent what you are explaining in the slides.
|
Moral dilemma identify the competing rights
: 1. Describe the moral dilemma identify the competing rights and how these make it a moral dilemma (1/2 page) 2. Describe the model, from this week's reading, you will use to make a decision and why you selected it (1/4 page)
|
How can a manager prepare for changing conditions
: How can a manager prepare for changing conditions using sensitivity analysis and b. What is meant by sensitivity analysis
|
Identify proposed strategies that excellenct for pepsico
: Determine three new strategies that PepsiCo is actually pursuing. Identify three proposed strategies taht you feel would be excellenct for PepsiCo to pursue. Give a rationale for each of your proposed strategies.
|
Process of self-examination
: 1. As a process of self-examination during her senior year of college, Casey decides to develop a SWOT analysis of her prospects relative to getting a job. Casey realizes that she has a personal characteristic that suggests she is not comfortable ..
|
Skills in logistics management presentation
: completing an application of skills in logistics management presentation. You can find a grading rubric for this assignment in Doc Sharing
|
Explain governments role in intelligence
: Please consider the government's role in Intelligence during each period (i.e. Federal, State, Local) and distinguish between how HUMINT and SIGINT was utilized during each period.
|