Questions from Spreadsheet Modeling


Q: Hamilton & Jovanovich (H&J) is a global investment

Hamilton & Jovanovich (H&J) is a global investment company, providing start-up capital to promising new ventures around the world. Due to the nature of its business, H&J holds funds in a v...

See Answer

Q: Fidelity Savings & Loans (FS&L) operates a number

Fidelity Savings & Loans (FS&L) operates a number of banking facilities throughout the Southeastern United States. The officers of FS&L wants to analyze the efficiency of the various branc...

See Answer

Q: Use Solver to create a Sensitivity Report for question 33 at the

Use Solver to create a Sensitivity Report for question 33 at the end of Chapter 3 and answer the following questions. a. Is the solution degenerate? b. Is the solution unique? c. Use a Solver Plot to...

See Answer

Q: The Embassy Lodge hotel chain wants to compare its brand efficiency to

The Embassy Lodge hotel chain wants to compare its brand efficiency to that of its major competitors using DEA. Embassy collected the following data reported in industry trade publications. Embassy vi...

See Answer

Q: Use Solver to create a Sensitivity Report for question 34 at the

Use Solver to create a Sensitivity Report for question 34 at the end of Chapter 3 and answer the following questions: a. Is the solution unique? b. If Sentry wants to increase their production capacit...

See Answer

Q: CaroliNet is a satellite TV service provider for residential customers in the

CaroliNet is a satellite TV service provider for residential customers in the state of North Carolina. The company is planning to expand and offer satellite TV service in South Carolina as well. The c...

See Answer

Q: Use Solver to create a Sensitivity Report for question 35 at the

Use Solver to create a Sensitivity Report for question 35 at the end of Chapter 3 and answer the following questions. a. Is the solution degenerate? b. Is the solution unique? c. How much should the r...

See Answer

Q: Use Solver to create a Sensitivity Report for question 37 at the

Use Solver to create a Sensitivity Report for question 37 at the end of Chapter 3 and answer the following questions. a. Is the solution degenerate? b. Is the solution unique? c. How much can the prof...

See Answer

Q: Refer to question 42 at the end of Chapter 3 and answer

Refer to question 42 at the end of Chapter 3 and answer the following questions: a. Create a Spider Plot to summarize what happens to the optimal total profit as the total storage capacity increases f...

See Answer

Q: Consider the following LP problem: MAX: 4X1 1 2X2 Subject

Consider the following LP problem: MAX: 4X1 1 2X2 Subject to: 2X1 1 4X2 # 20 3X1 1 5X2 # 15 X1, X2 $ 0 a. Use slack variables to rewrite this problem so that all its constraints are equal-to constrai...

See Answer