Given the information presented, create a spreadsheet for the vendor that determines what product (A, B, or C) should be sold at the Expo based on expected profits, and how many units the vendor should order from the manufacturer. Clearly organize and label the spreadsheet so that the vendor can see inputs and results (i.e., the vendor may wish to modify inputs later as more information becomes available). Vary the annual holding cost percentage and show how the expected profits change for a range of holding rates from 10% to 40% (vary in increments of 5%). Show these results in tabular format.

Answer rating: 100% (QA)

To create a spreadsheet that determines the product to be sold at the Expo and the quantity to order from the manufacturer based on expected profits w... View the full answer