Using the chart below, I need the 3 following questions answered - I need a table/excel spreadsheet for each questiom

Activity |
Normal Time |
Normal Cost |
Crash Time |
Crash Cost |
Crash Cost/Day |

a |
5 |
$50 |
3 |
$150 |
$50 |

b |
4 |
40 |
2 |
200 |
160 |

c |
7 |
70 |
6 |
160 |
90 |

d |
2 |
20 |
1 |
50 |
30 |

e |
3 |
30 |
- |
- |
- |

f |
8 |
80 |
5 |
290 |
70 |

g |
5 |
50 |
4 |
100 |
50 |

h |
6 |
60 |
3 |
180 |
120 |

(c). Find the optimal way of getting an 18-day delivery time. What is the projected cost? You may use MS Excel (Solver) to find the optimal way of getting to an 18-day delivery time and copy/paste your table here or create a table in MS Word and enter the results in the table. Once you’ve found the solution, explain the results of your calculations.

(d). Find the optimal way of getting a 16-day delivery time. What is the project cost. You can repeat the process here for this question (Excel using Solver) or create a table and enter the results here to determine a 16-day delivery time. Explain your results.

(e). Calculate the shortest delivery time for the project. What is the cost? You can repeat the process here for this question (Excel using Solver) or create a table and enter the results here to determine the shortest delivery time. Explain your results.

Subject | Business |

Due By (Pacific Time) | 11/10/2013 6:00 PM |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |