Questions from Business Analytics

Q: In the Credit Risk Data file, use database functions to find

In the Credit Risk Data file, use database functions to find the average amount of savings for each of the situations listed in Problem 16. Data from Problem 16: Apply the Advanced Filter to the Cred...

Q: For the Burger Office Equipment scenario, use the spreadsheet model to

For the Burger Office Equipment scenario, use the spreadsheet model to answer the following questions by changing the parameters and re-solving the model. Answer each question independently relative t...

Q: Jordan owns a magazine stall and he has 150 old magazines in

Jordan owns a magazine stall and he has 150 old magazines in storage. He is planning to sell some of his magazines with the highest price to gain a profit of $8.00 and some with the lowest price to ga...

Q: Analyze the sensitivity of the optimal solution for the local university as

Analyze the sensitivity of the optimal solution for the local university as the total cost and available lecturers are varied. Write a short summary memo to the university management in which you outl...

Q: Construct a what-if analysis for Foodpanda as the delivering goal

Construct a what-if analysis for Foodpanda as the delivering goal varies from 15 to 35 minutes in increments of 5 minutes.

Q: Use Excel charts to visualize the solution for WoodFurni. Use the

Use Excel charts to visualize the solution for WoodFurni. Use the Solver Answer Report and the Sensitivity Report to facilitate your analysis.

Q: Use Excel charts to visualize the solution for the J&M

Use Excel charts to visualize the solution for the J&M Manufacturing problem using the Solver Sensitivity Report with auxiliary variables.

Q: Obtain the Answer and Sensitivity Reports for Dara’s investment scenario. Develop

Obtain the Answer and Sensitivity Reports for Dara’s investment scenario. Develop a set of charts that visualize the key information in these reports.

Q: The Body Shop has recently launched two new hand cream varieties:

The Body Shop has recently launched two new hand cream varieties: Rose and Lotus. It costs $2.75 to purchase the fragrance needed for each tube of Rose hand cream and $1.56 for each tube of Lotus hand...

Q: Suppose that Sue is considering three stocks in which to invest.

Suppose that Sue is considering three stocks in which to invest. She has $20,000 to invest, and so she decides to equally invest in all the three stocks. The expected return is 20% for stock A, 10% fo...