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,

 

Order Similar Assignment Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered within 4 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:
 Total: