Questions from Business Analytics


Q: Implement the linear optimization model that you developed for Burger Office Equipment

Implement the linear optimization model that you developed for Burger Office Equipment on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the bin...

See Answer

Q: Use PivotTables to find the number of loans by different purposes,

Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data (Base Data worksheet).

See Answer

Q: Dion’s Décor shop has three bestseller products. Dion has a budget

Dion’s Décor shop has three bestseller products. Dion has a budget of $2,500 to purchase these products from an outstation wholesale warehouse. The cost and the profits...

See Answer

Q: Implement the linear optimization model that you developed for Bangs Leisure Chairs

Implement the linear optimization model that you developed for Bangs Leisure Chairs on a spreadsheet and use Solver to find an optimal solution. a. Interpret the Solver Answer Report, identify the bin...

See Answer

Q: Implement the linear optimization model that you developed for the Flower Aurora

Implement the linear optimization model that you developed for the Flower Aurora shop on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report and identify the b...

See Answer

Q: A farmer plans to plant both corn and carrot on a 100

A farmer plans to plant both corn and carrot on a 100-hectare land. To meet his requirements, he must plant at least 20 hectares with corn and 35 hectares with carrot. In order to maximize his profit,...

See Answer

Q: For the Valencia Products model, graph the constraints and identify the

For the Valencia Products model, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the opt...

See Answer

Q: For the ColPal model, graph the constraints and identify the feasible

For the ColPal model, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal soluti...

See Answer

Q: Classify the following descriptions of constraints as bounds, limitations, requirements

Classify the following descriptions of constraints as bounds, limitations, requirements, proportional relationships, or balance constraints: a. A production line is sufficiently meeting its customers’...

See Answer

Q: For the investment situation, apply the same logic as we did

For the investment situation, apply the same logic as we did for the Crebo Manufacturing model in the text to find the optimal solution. Compare your answer with the Solver solution.

See Answer