# Question Solved1 Answer    Tool Depot is a U.S. home improvement retailer with two stores. They currently have two suppliers for the three products that they sell: wrenches, drills, and saws. Suppliers ship product directly to the stores. Assume today is $$7 / 30 / 2015$$. Beginning 8/3/2015, Tool Depot would like to start selling hammers. Both Supplier A and Supplier B make hammers and have submitted bids to supply hammers to Tool Depot. The hammers from both suppliers will be identical. The costs provided are for the product only and Tool Depot must pay for shipping costs from the supplier to their stores. Both suppliers would ship the hammers with their existing items. For shipping, Tool Depot has two choices in carriers from each supplier. They use the cheapest carrier for a given origin-destination pair each week. - Carrier $$X$$ charges a flat rate per shipment for each origin-destination pair. - Carrier $$Y$$ charges a variable rate per pound for each origin-destination pair. - Both carriers can fit up to 44,000 pounds per shipment. Tool Depot expects that hammer orders will be the same as wrench orders. Tool Depot also expects that orders for all of its products will grow $$10 \%$$ year over year. Tool Depot must decide which supplier to choose for supplying its hammers for the next year. They would like to use the same supplier for both their stores. Which supplier should they choose? Please fill out the relevant costs in the "Summary" tab of the Excel file provided, and be prepared to discuss the problem in the debrief session at the end of this exercise.

Transcribed Image Text: Tool Depot is a U.S. home improvement retailer with two stores. They currently have two suppliers for the three products that they sell: wrenches, drills, and saws. Suppliers ship product directly to the stores. Assume today is $$7 / 30 / 2015$$. Beginning 8/3/2015, Tool Depot would like to start selling hammers. Both Supplier A and Supplier B make hammers and have submitted bids to supply hammers to Tool Depot. The hammers from both suppliers will be identical. The costs provided are for the product only and Tool Depot must pay for shipping costs from the supplier to their stores. Both suppliers would ship the hammers with their existing items. For shipping, Tool Depot has two choices in carriers from each supplier. They use the cheapest carrier for a given origin-destination pair each week. - Carrier $$X$$ charges a flat rate per shipment for each origin-destination pair. - Carrier $$Y$$ charges a variable rate per pound for each origin-destination pair. - Both carriers can fit up to 44,000 pounds per shipment. Tool Depot expects that hammer orders will be the same as wrench orders. Tool Depot also expects that orders for all of its products will grow $$10 \%$$ year over year. Tool Depot must decide which supplier to choose for supplying its hammers for the next year. They would like to use the same supplier for both their stores. Which supplier should they choose? Please fill out the relevant costs in the "Summary" tab of the Excel file provided, and be prepared to discuss the problem in the debrief session at the end of this exercise.
More
Transcribed Image Text: Tool Depot is a U.S. home improvement retailer with two stores. They currently have two suppliers for the three products that they sell: wrenches, drills, and saws. Suppliers ship product directly to the stores. Assume today is $$7 / 30 / 2015$$. Beginning 8/3/2015, Tool Depot would like to start selling hammers. Both Supplier A and Supplier B make hammers and have submitted bids to supply hammers to Tool Depot. The hammers from both suppliers will be identical. The costs provided are for the product only and Tool Depot must pay for shipping costs from the supplier to their stores. Both suppliers would ship the hammers with their existing items. For shipping, Tool Depot has two choices in carriers from each supplier. They use the cheapest carrier for a given origin-destination pair each week. - Carrier $$X$$ charges a flat rate per shipment for each origin-destination pair. - Carrier $$Y$$ charges a variable rate per pound for each origin-destination pair. - Both carriers can fit up to 44,000 pounds per shipment. Tool Depot expects that hammer orders will be the same as wrench orders. Tool Depot also expects that orders for all of its products will grow $$10 \%$$ year over year. Tool Depot must decide which supplier to choose for supplying its hammers for the next year. They would like to use the same supplier for both their stores. Which supplier should they choose? Please fill out the relevant costs in the "Summary" tab of the Excel file provided, and be prepared to discuss the problem in the debrief session at the end of this exercise.
Step1/1.gkwtCW{margin:0;font-family:"Aspira Webfont","Helvetica","Arial",sans-serif;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-direction:column;-ms-flex-direction:column;flex-direction:column;gap:16px;}/*!sc*/data-styled.g367[id="sc-z3f5s1-0"]{content:"gkwtCW,"}/*!sc*/.iIwMoS{white-space:pre-wrap;}/*!sc*/data-styled.g369[id="sc-1aslxm9-0"]{content:"iIwMoS,"}/*!sc*/.fzJtOB{text-align:start;}/*!sc*/data-styled.g371[id="sc-1aslxm9-2"]{content:"fzJtOB,"}/*!sc*/.hOZehF{margin:0;font-family:"Aspira Webfont","Helvetica","Arial",sans-serif;}/*!sc*/data-styled.g398[id="sc-9wsboo-0"]{content:"hOZehF,"}/*!sc*/.lhIoTe{margin:0;font-size:1rem;}/*!sc*/data-styled.g400[id="sc-1swtczx-0"]{content:"lhIoTe,"}/*!sc*/.iHelzO{margin:0;font-family:"Aspira Webfont","Helvetica","Arial",sans-serif;line-height:normal;}/*!sc*/data-styled.g431[id="sc-1sugbjn-0"]{content:"iHelzO,"}/*!sc*/The question is incomplete since the number of orders for each product currently is not given. That must have been provided in the historical data sheet which is not shared in the question.However to explain the apporach, let us assume currently 100 units of Hammer are required to be shipped. ( the calculations and decision making will change with change in units but the approach should be the same)so, Hammer prod cost for Supplier A= 0.8*100= $80and for B it is 0.82*100=$82From Product Info table, total weight of 100 Hammers=2*100=200 LBConsidering Supplier A,Using carrier X, cost to Store ... See the full answer