Question

In: Accounting

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 of 90% and 365 days per year for planning purposes.

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

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

You have three options,

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

OPTION B: to use the TL option and delivery 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/1300items + $36/item = $36.9230769231/item.

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. (Please note that the answer is 184828, or near, is just i do not know how to compute it. Please kindly show your working here.)

Solutions

Expert Solution

Only the option A is calculated as asked in the question
Innventory holding charge of 0.1 given which is 10% of value of the product (36 $).
Inventory cost per unit per year = 10% * 36 =3 .6 $
EOQ = sqrt (2 * D * K / h) where
D = Annual Demand
K = Fixed cost per order (ordering cost)
h = annual holding cost per unit
EOQ = sqrt (2 * 5000 * 90 / 3.6)
500
1 A) Option A = Full Truck load Delivery
Annual Demand = 5000
Daily demand = 5000/365 = ~ 14
Purchase cost per item = Item cost = $1200/1300items + $36/item = $36.9230769231/item.
Cycle Inventory = FTL = 1200 units
Average Pipeline = Cycle inventory/2 = 1200/2 = 600
No of orders required annually = roof value (5000 / 1200) = 4.17
Annual Ordering cost = 4.17 * 90 = 375.3 $
Therefore the full average pipeline and cycle inventory cost of ordering and purchase cost
Total Purchase cost
5000*36.9230769231
$184,615
Ordering Cost
$375.30
Total Cost                                                                                                                                                              $184990.3

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 $97. Your company uses a holding charge of 0.15, 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