Reference no: EM131301347
Speedy Delivery provides two-day delivery service of large parcels across the United States. Each morning at each collection center, the parcels that have arrived overnight are loaded several trucks for delivery throughout the area. Since the competitive battlefield in this business is speed of delivery, the parcels are divided among the trucks according to their graphical destinations to minimize the average time needed to make the deliveries.
On this particular morning, the dispatcher for the Blue River Valley Collection Center, Sharon Lofton, is hard at work. Her three drivers will be arriving in less than an hour to make the deliveries. There are nine parcels to be delivered, all at locations many miles apart. As usual, Sharon has loaded these locations into her computer. She is using her company's special software package, a decision support system called Dispatcher. The first thing Dispatcher does is using these locations to generate a considerable number of attractive possible routes for the individual delivery trucks. These routes are shown in the following table (where the numbers in each column indicate the order of the deliveries), along with the estimated time required to traverse the route.
| Delivery |
Attractive Possible Route |
| Location |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| A |
1 |
|
|
|
1 |
|
|
|
1 |
|
| B |
|
2 |
|
1 |
|
2 |
|
|
2 |
2 |
| C |
|
|
3 |
3 |
|
|
3 |
|
3 |
|
| D |
2 |
|
|
|
|
1 |
|
1 |
|
|
| E |
|
|
2 |
2 |
|
3 |
|
|
|
|
| F |
|
1 |
|
|
2 |
|
|
|
|
|
| G |
3 |
|
|
|
|
|
1 |
2 |
|
3 |
| H |
|
|
1 |
|
3 |
|
|
|
|
1 |
| I |
|
3 |
|
4 |
|
|
2 |
|
|
|
| Time (in hours) |
6 |
4 |
7 |
5 |
4 |
6 |
5 |
3 |
7 |
6 |
Dispatcher is an interactive system that shows these routes to Sharon for her approval or modification. (For example, the computer may not know that flooding has made a particular route infeasible.) After Sharon approves these routes as attractive possibilities with reasonable time estimates, Dispatcher next formulates and solves an optimization model for selecting three routes that minimize their total time while including each delivery location on exactly one route.
Unfortunately, the Dispatcher is down and Sharon is seeking your assistance in helping her set up an Excel spreadsheet to help her determine the routes.
(Hint: You do not need to generate the answer and sensitivity reports)
|
Compute the aftertax cost of debt
: The treasurer of Riley Coal Co. is asked to compute the cost of fixed income securities for her corporation. Even before making the calculations, she assumes the aftertax cost of debt is at least 1 percent less than that for preferred stock. Compute ..
|
|
Discuss diversification among mutual funds
: Discuss diversification among mutual funds. Describe some strategies that make diversification more effective. What is a mutual fund supermarket?
|
|
Describe the identified changes to the suppliers
: Explain the identified changes to the suppliers in such a way that they will understand the standards that Apple requires in order to maintain their relationship with the company.
|
|
How many shares did she purchase
: Hope invested $9,000 in a mutual fund when the price per share was $30. The fund has a load fee of $300. How many shares did she purchase?
|
|
Determine the routes
: Unfortunately, the Dispatcher is down and Sharon is seeking your assistance in helping her set up an Excel spreadsheet to help her determine the routes.
|
|
What is the projects payback period and net present value
: Project M has a cost of $65,125, expected net cash inflows of $13,000 per year for ten years, and a cost of capital of 11%. What is the project’s payback period? What is the project's net present value?
|
|
What is the expense ratio for marks mutual fund
: Mark owns a mutual fund with a NAV of $45.00 per share and expenses of $1.45 per share. What is the expense ratio for Mark's mutual fund?
|
|
Execute the application from sdram
: Display the elapsed time in the LCD display (or seven-segment displays) and stop the time display when a player wins the game (turns out all LEDs). Adjust the shift time delay for reasonable game play. Blink all of the LEDs when a player wins. If ..
|
|
What is hunter return from selling his shares in mutual fund
: When Hunter purchased the shares, the NAV per share was $70. A year later, Hunter sold the shares at a NAV of $68 per share. What is Hunter's return from selling his shares in the mutual fund?
|