Exam (elaborations)
Solutions Manual for Practical Management Science 6th Edition Winston
- Course
- Business
- Institution
- Alderson-Broaddus College
Solutions Manual for Practical Management Science 6th Edition Winston
[Show more]
Content preview
SOLUTIONS MANUAL FORPRACTICAL MANAGEMENT
SCIENCE 6TH EDITION
WINSTON
, Practical Management Science 6th Edition Winston Solutions Manual
Project Selection at Ewing Natural Gas
Inputs All values in $ millions, assuming 100% involvement
Project index Functional Area (FA) Partnership % Capex Year 1 Capex Year 2 Capex Year 3
1 FA1 100% 250 100 100
2 FA1 33% 500 300 300
3 FA1Answers to the questions appear
50% in yellow.
100You can 200 400
4 FA1enter any 0/1 values in100%
the boxed-in range750 to see 500 300
5 FA1how everything updates.
75% 200 400 800
6 FA2 50% 1000 300 300
Note the tricky formulas in cells I36 and J36. These
7 FA2 100% 750 750 300
are called array formulas. When you enter each of
8 FA2 100% 800 700 600
them, you should press Ctrl+Shift+Enter, not just
9 FA2Enter. 67% 400 600 800
10 FA3 100% 100 200 400
11 FA3 50% 700 500 300
12 FA3 100% 1500 400 400
Decisions Capex for company
Project index Undertake project? Year 1 Year 2 Year 3
1 1 250 100 100
2 1 165 99 99
3 1 50 100 200
4 1 750 500 300
5 1 150 300 600
6 1 500 150 150
7 0 0 0 0
8 0 0 0 0
9 1 268 402 536
10 1 100 200 400
11 1 350 250 150
12 1 1500 400 400
Totals 10 4083 2501 2935
Number of projects undertaken in functional areas
Total Any for FA?
FA1 5 1
FA2 2 1
FA3 3 1
Limits for company capital expenditures
Year 1 Year 2 Year 3 Total
Limit 4000 4000 4000 10000
Exceeds limit? 1 0 0 0
Summary of capex for projects undertaken (useful for creating chart)
Year 1 Year 2 Year 3
Company 4083 2501 2935 4500
Visit TestBankDeal.com to get complete for all chapters
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller mentor2000. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
64450 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now