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/
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?
Recently Asked Questions
- I need help understanding and solving the following problem. there are duplicate "f" in the sub-questions. The questions should be lettered "a-i".
- 1. Aaron Mackay is going to the grocery store to buy some bananas and apples, both of which are sold by the pound. He wants a program that calculates
- Patents, copyrights and trademarks are examples of short term investments fixed asset longterm investments intangible assets