× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
w
5
a
3
j
2
a
2
t
2
u
2
r
2
j
2
j
2
l
2
d
2
y
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
bsktball509 bsktball509
wrote...
Posts: 641
Rep: 0 0
6 years ago
The model was entered into an Excel spreadsheet and the table below shows part of the sensitivity report. Calculate the expected per unit profit for the three services.
 
  Variable Cells
   Final Reduced
  Cell Name Value Gradient
  C3 P1_ 45.5694 0
  D3 P2_ 51.5 0
  E3 P3_ 58.8929 0
Read 89 times
2 Replies
Introduction to Operations and Supply Chain Management, 4e (Bozarth/Handfield)

Related Topics

Replies
wrote...
#1
6 years ago
Answer: The model provides a solution that calls for only a sale price for P1 of 45.57 - coupled with its price of 2.25 means they make 43.32 per unit of X1. For item X2, the optimal price is 51.50, less the cost of 3, means Zevon makes 48.50 per unit. Finally, X3 will sell for 58.89, less the price of 3.50 means they realize a profit of 55.39 per unit.
wrote...
#2
3 years ago
An interesting task. I get asked similar problems at the university. By the way, i never do them myself, which is what i advise students. So, if doing excel homework assignments is difficult for you, then do not suffer and let the bookwormhub.com professionals do everything for you.
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  752 People Browsing
 125 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 711
  
 367
  
 1473
Your Opinion
Do you believe in global warming?
Votes: 488
Previous poll results: Which 'study break' activity do you find most distracting?