Questions from Business Analytics

Q: Experiment with the portfolio allocation model to attempt to find the best

Experiment with the portfolio allocation model to attempt to find the best solution that maximizes the expected annual return and meets the total weighted risk constraint.

Q: The Bose Theater, a community playhouse, needs to determine the

The Bose Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming show. Specifically, they have to determine which set pieces to construct and which, if any...

Q: A franchise of a chain of Mexican restaurants wants to determine the

A franchise of a chain of Mexican restaurants wants to determine the best location to attract customers from three suburban neighborhoods. The coordinates of the three suburban neighborhoods are as fo...

Q: ElectroMart wants to identify a location for a warehouse that will ship

ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given here. Develop a model to find the best location...

Q: The demand for organic chicken meat is quite sensitive to price.

The demand for organic chicken meat is quite sensitive to price. Typically, there is an inverse relationship between its demand and price—when price decreases, demand increases and vice versa. The pri...

Q: Use the CHOOSE function to develop a database query for the Time

Use the CHOOSE function to develop a database query for the Time Spent data that will complete the following table for any individual specified in the top left corner: Each empty cell should contain o...

Q: An IT support group at Thomson State College has seven projects to

An IT support group at Thomson State College has seven projects to complete. The time and project deadlines (both in days) are shown next. a. Develop a spreadsheet model for this situation. b. Use a s...

Q: Implement the model you developed in Problem 1 on a spreadsheet and

Implement the model you developed in Problem 1 on a spreadsheet and construct a one-way data table to estimate the price for which profit is maximized.

Q: For the Schoch Museum, use data tables to investigate the impacts

For the Schoch Museum, use data tables to investigate the impacts of the percentage assumptions used in the model on the cumulative funds raised by the fifth year.

Q: A local supermarket orders 27 copies of a monthly magazine. Depending

A local supermarket orders 27 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The supermarket purchases the magazines for $1.73 and sells them for $4.03. An...