HW3 - SCM 414 HW#3 Due 5\/1 Submit only EXCEL file not Word file to the Dropbox folder(one submission per group Your excel file should have six

HW3 - SCM 414 HW#3 Due 5/1 Submit only EXCEL file not Word...

This preview shows page 1 - 2 out of 2 pages.

SCM 414 - HW #3 Due 5/1 Submit only EXCEL file , not Word file to the Dropbox folder ( one submission per group ). Your excel file should have six worksheets (one worksheet per question). Q1 . Flanger is an industrial distributor that sources from hundreds of suppliers. The two modes of transportation available for inbound shipping are LTL (less than truckload) and TL (truckload). LTL shipping costs $1 per unit, whereas TL shipping cost $400 per truck. Each truck can carry up to 1,000 units. Flanger wants a rule assigning products to shipping mode (TL or LTL) based on annual demand. Each unit costs $50, and Flanger uses a holding cost of 20 percent. Flanger incurs a fixed cost of $100 for each order placed with a supplier (15 points) . a) Determine a threshold for annual demand above which TL is preferred and below which LTL is preferred. b) How does the threshold change [relative to part (a)] if unit cost is $100 (instead of $50) with all other data unchanged? Which mode becomes preferable as unit cost grows? c) How does the threshold change [relative to part (a)] if the LTL cost comes down to $0.8 per unit (instead of $1 per unit)? Q2 . Steamy Speedboats has an annual demand for 1,500 speedboats. Its supplier offers quantity discounts to promote larger order quantities. The cost to place an order is $300, and the holding rate is 32 percent of the purchase cost. The purchase cost for each speedboat is based on the price schedule given below
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture