View the step-by-step solution to:

40 41 42 43 45 46 47 A0 Net Transportation Cost per Unit Location Seattle Denver St. Louis Atlanta Philadelphia You must...

This question was created from Spring 2017 - Excel Solver Template for SportStuff.com Case https://www.coursehero.com/file/20147777/Spring-2017-Excel-Solver-Template-for-SportStuffcom-Case/

20147777-198358.jpeg

When adding in net transportation costs per unit ($3/4)-(Corresponding UPS Charge/4), there are some cells that return negative values which the solver can't handle. When running the solver, it considers the profit of shipping into the calculations and opens up unnecessary warehouses and assumes they're at full capacity (because the profit made from shipping offsets the significant running costs.) Can anyone help please?

20147777-198358.jpeg

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question