Executive Summary

Your goal is to build a DSS that can be used for calculating costs and revenues associated with daily bus dispatching for Saint Bernard Bus Lines (see Case 8, p. 185). After you build the DSS, you will use Excel Solver to maximize gross profit for the company. Please make sure you include revenues from additional cargo in your calculations. Also, please don’t forget to include constraints for your DSS model when you run the Solver.

Deliverables

1. Please submit an Excel work sheet with the following tabs:
a. Tab 1 named “Bus Dispatching”. This tab should contain the DSS with an optimal combination of buses for each route so that gross profit is minimized. In addition to that, the tab needs to have a short interpretation of results. Make sure the results contain specific insights and/or recommendations for management.
b. Tab 2 named “Answer Report”. You can generate this tab automatically to contain details about the Solver’s solution to your optimization problem.

p(1)

Place your order now to enjoy great discounts on this or a similar topic.

People choose us because we provide:

Essays written from scratch, 100% original,

Delivery within deadlines,

Competitive prices and excellent quality,

24/7 customer support,

Priority on their privacy,

Unlimited free revisions upon request, and

Plagiarism free work,

 

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper
Academic level
Subject area
Number of pages
Paper urgency
Cost per page
Currency
Total