EXCEL PROBLEMS Management Science 430

An Expert is ready to work on your Paper Now!

EXCEL PROBLEMS Management Science 430

Alabama Atlantic is a lumber company that has three sources of wood and five markets to be supplied. The annual availability of wood at sources 1, 2, and 3 is 15, 20, and 15 million board feet, respectively. The amount that can be sold annually at markets 1, 2, 3, 4, and 5 is 11, 12, 9, 10, and 8 million board feet, respectively.
In the past, the company has shipped the wood by train. However, because shipping costs have been increasing, the alternative of using ships to make some of the deliveries is being investigated. This alternative would require the company to invest in some ships. Except for these investment costs, the shipping costs in thousands of dollars per million board feet by rail and by water (when feasible) is given by the above table for each route.
Data attached below.

Questions and solution is attached below as well.

The capital investment (in thousands of dollars) in ships required for each million board feet to be transported annually by ship along each route is given next.

Considering the expected useful life of the ships and the time value of money, the equivalent uniform annual cost of these investments is one-tenth the amount given in the table. The objective is to determine the overall shipping plan that minimizes the total equivalent uniform annual cost (including shipping costs).
You are the head of the management science team that has been assigned the task of determining this shipping plan for each of the three options listed next.
Option 1: Continue shipping exclusively by rail.
Option 2: Switch to shipping exclusively by water (except where only rail is feasible).
Option 3: Ship by either rail or water, depending on which is less expensive for the particular route.
Present your results for each option. Compare.
Finally, consider the fact that these results are based on current shipping and investment costs, so that the decision on the option to adopt now should take into account management’s projection of how these costs are likely to change in the future. For each option, describe a scenario of future cost changes that would justify adopting that option now.

Get your expert answer on More Essays

More Assignments

Our Benefits

  • On-Time delivery
  • High-Quality papers
  • Weekly Discounts
  • Free Revisions
  • 24/7 LiveChat support
  • User-Friendly Ordering System
  • Referral Bonuses
  • Lifetime discount Codes

Answers to Your Questions

Where are your writers from?

Our writers are from across the globe. they are trained and evaluated to ensure that they provide the best for you. There are experts in different academic fields. 

How long does an assignment take?

The time taken per assignment depends on the questions, subject area and deadline. kindly talk to support to get a clear answer. 

What if my paper fails? 

In the unlikely event that your paper fails, we offer free revisions and refunds if the paper cannot be revised. 

Do you offer discounts?

Yes. On your dashboard, you get daily, weekly, monthly and even lifetime discounts as a client.  You can also negotiate the price of your order by talking to one of our agents on our live chat page. 

How do I pay for the assignment?

PayPal, Mastercard, Visa, Flutterwave etc.