Question

In: Economics

You manage the shipping of item #A452 from your supplier. The shipments for this item are...

You manage the shipping of item #A452 from your supplier. The shipments for this item are delivered to the nearest port, and you have to transport them to the distribution center. You have two options, truck load (TL) and less than truck load (LTL).

Your company needs 5000 units of #A452 per year and it is purchased at a price of $36 per unit. Each order costs $97. Your company uses a holding charge of 0.15, a cycle service level of 90% and 365 days per year for planning purposes.

The truck load (TL) option costs $1200 per load. It takes 3 days to deliver and each truck can carry up to 1000 items.

The less than truck (LTL) load option costs $2.9 per item. It takes 5 days to deliver.

You have three options,

OPTION A: to use the TL option and deliver full truck loads,

OPTION B: to use the TL option and deliver the economic order quantity

OPTION C: to use LTL option and deliver the economic order quantity.

For all following parts, consider transportation costs as an item cost unless otherwise specified. i.e., the total variable cost of #A452 in the Full truckload is $1200/1000items + $36/item = $37.2/item.

(Option A) Full truckload

1) What is the sum of average pipeline and cycle inventory, ordering, and purchase costs for option A? Please provide your answers rounded to the closest dollar.

(Option B) Truckload with EOQ

1) What is the economic order quantity? Use the item cost without the transportation for this calculation. Please answer in whole numbers.

2) If you order the EOQ calculated earlier (rounded to a whole number), what is the sum of average pipeline, cycle inventory, ordering, and purchase costs for option B? Consider transportation costs a part of the item cost. Please provide your answers rounded to the closest dollar.

(Option C) Less than truckload

1) What is the sum of average pipeline and cycle inventory, ordering, and purchase costs for option C? Consider transportation costs as an item cost, and use the EOQ in whole numbers for calculation. Please provide your answers rounded to the closest dollar.

Solutions

Expert Solution

Annual demand, D = 5000 units

Order cost, S = $ 93

Unit cost = $ 38

Holding charge, h = 0.14

Daily demand rate, d = 5000/365 = 13.7

(Option A) Full Truckload (TL)

Truckload quantity, Q = 1400 units

Lead time, L = 5 days

Holding cost, H = 38*0.14 = $ 5.32

Pipeline inventory = d*L = 13.7*5 = 68.5

Cycle inventory = Q/2 = 1400/2 = 700

Unit cost, C = 38+1400/1400 = $ 39

Sum of average pipeline and cycle inventory, ordering, and purchase costs = (68.5+700)*5.32 + (5000/1400)*93 + 5000*39 = $ 199,421

(Option B) Truckload with EOQ

EOQ = SQRT(2DS/H) = SQRT(2*5000*93/5.32) = 418

Cycle inventory = Q/2 = 418/2 = 209

Unit cost, C = 38 + 1400/418 = $ 41.35

Holding cost, H = 41.35*0.14 = 5.79

Sum of average pipeline and cycle inventory, ordering, and purchase costs = (68.5+209)*5.79 + (5000/418)*93 + 5000*41.35 = $ 209,469

(Option C) Less Than Truckload (LTL)

Lead time, L = 7 days

Pipeline inventory = d*L = 13.7*7 = 96

Cycle inventory = Q/2 = 418/2 = 209

Unit cost, C = 38 + 2.6 = $ 40.6

Holding cost, H = 40.6*0.14 = 5.68

Sum of average pipeline and cycle inventory, ordering, and purchase costs = (96+209)*5.68 + (5000/418)*93 + 5000*40.6 = $ 205,845

Option A (Full Truckload) is the most economical one.


Related Solutions

You manage the shipping of item #A452 from your supplier. The shipments for this item are...
You manage the shipping of item #A452 from your supplier. The shipments for this item are delivered to the nearest port, and you have to transport them to the distribution center. You have two options, truck load (TL) and less than truck load (LTL). Your company needs 5000 units of #A452 per year and it is purchased at a price of $36 per unit. Each order costs $90. Your company uses a holding charge of 0.1, a cycle service level...
You manage the shipping of item #A452 from your supplier. The shipments for this item are...
You manage the shipping of item #A452 from your supplier. The shipments for this item are delivered to the nearest port, and you have to transport them to the distribution center. You have two options, truck load (TL) and less than truck load (LTL). Your company needs 5000 units of #A452 per year and it is purchased at a price of $36 per unit. Each order costs $92. Your company uses a holding charge of 0.13, a cycle service level...
Problem 8 A company that manufactures bicycles receives steel rods in large shipments from a supplier....
Problem 8 A company that manufactures bicycles receives steel rods in large shipments from a supplier. From past experience, the manager knows that the lengths are approximately normally distributed. He takes a random sample of 14 rods. The lengths of the sampled rods are as follows: 12.75 12.12 11.90 11.94 12.05 11.97 12.01 12.08 13.05 12.12 12.14 12.12 12.14 13.28 The company needs rods with a length of 12 inches in order to assemble the bikes properly. Because too-large and...
1. Ordering cost only consists of the shipping cost from supplier to customer. True or False...
1. Ordering cost only consists of the shipping cost from supplier to customer. True or False 2. Ordering cost is which type of cost? Multiple Choice Fixed Variable Overhead 3. Which of the following would be considered part of Ordering Cost? (choose all that apply) Check All That Apply Minimum shipping chargeMinimum shipping charge Postage to mail the order to a supplier (who still lives in the early 20th century)Postage to mail the order to a supplier (who still lives...
You are a Supplier: A retailer requests to purchase supplies on credit from your company. You...
You are a Supplier: A retailer requests to purchase supplies on credit from your company. You have no prior experience with this retailer. The retailer’s current ratio is 2.1, its acid-test ratio is 0.5, and inventory makes up most of its current assets. Do you extend credit? You are the Financial Officer: Your company has a 36% gross margin ratio and a 17% net profit margin ratio. Industry averages are 44% for gross margin and 16% for net profit margin....
Your company purchases an expensive component from a supplier. You know that the population of the...
Your company purchases an expensive component from a supplier. You know that the population of the components is normally distributed with a mean ( μ) of 60 months and a standard deviation (σ) of 2 months. Using this information determine: the probability of a component lasting longer than 68 months. the probability of a component lasting less than 63 months. the probability that a component will last between 58 and 65 months. Using the information in the problem above, what...
You are the treasurer for ABC corporation.  You just received a bill from your Italian supplier of...
You are the treasurer for ABC corporation.  You just received a bill from your Italian supplier of Genoa salami for Eur 500,000. The Euros are due in three months. 1- What would you do to hedge this exposure? ( What hedge would you put on) 2- If you hedged the underlying position properly, what would you expect the net gain or loss to be when you combine the underlying position with the hedge mark-to-market?
You have just received a batch of goods from your supplier. You plan to sample the...
You have just received a batch of goods from your supplier. You plan to sample the batch in order to determine whether you will accept it or not. For this product, your contract with the supplier specifies that 3.0% is an acceptable quality level and the LTPD is 18.0%. The contract further specifies that the buyer’s risk should be 2.5% and the seller’s risk should be 1.0%. Given these parameters for your sampling plan, what is the least number of...
Imagine you are writing a program to manage a shopping list. Each shopping list item is...
Imagine you are writing a program to manage a shopping list. Each shopping list item is represented by a string stored in a container. Your design requires a print function that prints out the contents of the shopping list. Using a vector to hold the shopping list items, write a print function to print out the contents of a vector of strings. Test your print function with a main program that does the following: Create an empty vector. Append the...
Exercise 6-47 (Algorithmic) Recording Purchases and Shipping Terms On May 12, Digital Distributors received three shipments...
Exercise 6-47 (Algorithmic) Recording Purchases and Shipping Terms On May 12, Digital Distributors received three shipments of merchandise. The first was shipped F.O.B. shipping point, had a total invoice price of $150,000, and was delivered by a trucking company that charged an additional $12,000 for transportation charges from Digital Distributors. The second was shipped F.O.B. shipping point and had a total invoice price of $89,000, including transportation charges of $6,200 that were prepaid by the seller. The third shipment was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT