Question

In: Accounting

Company XYZ a baby ware makes company servers three regions near Iowa and maintains consignment inventory...

Company XYZ a baby ware makes company servers three regions near Iowa and maintains consignment inventory (owned by ZZY) at each location. Currently. ZZy uses refrigerated TL transportation to deliver separately to each customer. Each truck costs $700 plus $150 per stop. KAR Food is considering aggregating deliveries to Iowa on a single truck. A careful study of the sales regions revealed three large customers, three medium-sized customers, and ten small customers. Demand at the large customer is 60 tons a year, demand at the medium customer is 24 tons per year, and demand at the small customer is 8 tons per year. Product cost for ZZZY Company is $10,000 per ton, and it uses an annual holding cost of 25 percent. Truck capacity is 12 tons.

a. What is the annual transportation and holding cost if ZZY ships a full truckload to each customer when they are running out of stock?

b. What is the optimal delivery policy to each customer if ZZY Company ships separately to each of them? What is the annual transportation and holding cost?

c. What is the optimal delivery policy to each customer if ZZY Company aggregates shipments to each of the three customers on every truck that goes to Iowa? What is the annual transportation and holding cost?

d. Can you come up with a tailored policy that has lower costs than the policies in (b) or (c)? What are the costs and inventories for your suggested policy?

Solutions

Expert Solution

What is the annual transportation and holding cost if ZZY ships a full truckload to each customer when they are running out of stock?

large Medium Small
No of customers 3 3 10
Annual demand 60 24 8
If all 16 customers are fed , by separate vehicle
it will cost
700 x 16 11200
Holding Cost = $ 10000 * 25% 2500
Total 13700
Assume : We assume that we have been asked to provide the cost of transportation
and carrying cost , if each customer has been taken a unit

What is the optimal delivery policy to each customer if ZZY Company ships separately to each of them? What is the annual transportation and holding cost?

Answer B ) Optimal delivery policy shall be to feed all customers, with maximizing the deliveries , at a time

Working attached herein below

large Medium Small Total
No of customers 3 3 10
Annual demand 60 24 8
5 2 0.666667
Per truck $ 700
3500 1400 700 5600
Holding Cost = $ 10000 * 25% 2500
Total 8100

What is the optimal delivery policy to each customer if ZZY Company aggregates shipments to each of the three customers on every truck that goes to Iowa? What is the annual transportation and holding cost?

Answer C )

Large Medium Small Total Truck cost Shipping Total
Customers Req Total Customers Req Total Customers Req Total
1 20 1 1 8 8 1 0.8 0.8
2 20 2 2 8 8 2 0.8 0.8
3 20 3 3 8 8 3 0.8 0.8
4 0.8 0.8
5 0.8 0.8
6 0.8 0.8
7 0.8 0.8
8 0.8 0.8
9 0.8 0.8
10 0.8 0.8
Total 60 24 8 60
Capacity
Truck 1 12 12 700 700
Truck 2 8 4 12 700 150 850
Truck 3 8 4 12 700 150 850
Truck 4 8 4 12 700 150 850
Truck 5 8 4 12 700 150 850
Truck 6 8 4 12 700 150 850
Truck 7 8 4 12 700 150 850
Truck 8 8 0 8 700 0 700
Total 60 24 8 92 5600 900 6500
Annual Carrying Cost is 25% of $ 10000 2500
Annual Transportation and holding cost if Zzy ships a full truckload to each customer Total

9000

Answer d ) We can minimize the cost by following method

We can reduce the number of deliveries and reduce the cost

as mentioned below

Total 60 24 8 60
Capacity
Truck 1 12 12 700 700
Truck 2 12 12 700 700
Truck 3 12 12 700 700
Truck 4 12 12 700 700
Truck 5 12 12 700 700
Truck 6 8 4 12 700 150 850
Truck 7 8 4 12 700 150 850
Truck 8 8 0 8 700 0 700
Total 60 24 8 92 5600 300 5900
Annual Carrying Cost is 25% of $ 10000 2500
Annual Transportation and holding cost if Zzy ships a full truckload to each customer Total 8400

Related Solutions

Select a company in your pathway that maintains an inventory. Don't use a company that someone...
Select a company in your pathway that maintains an inventory. Don't use a company that someone has already used. Please put the company's name as the subject of your post. (No posting the company name only to hold it. You must make a full post or I will delete it.) Access a recent (less than 12 months) annual 10-K report for the company using the SEC Edgar search tool or Yahoo or Google finance. Review the report and in and...
I have a client: XYZ company. XYZ makes bicycles in the high side of the market,...
I have a client: XYZ company. XYZ makes bicycles in the high side of the market, $2,500 and above. In many ways they are used by the top riders in competitive races in the World. The variable cost to manufacturer is $1,000. The fixed cost are $500 per bicycle. Profit is $1,000. The manufacturing of the bicycles are in the same plant as the manufacturer of a very plain generic bicycle sold through COSTCO. The plain bicycle sells for $250...
Select a company in your pathway that maintains inventory. Don't use a company that someone has...
Select a company in your pathway that maintains inventory. Don't use a company that someone has already used. Please put the company's name as the subject of your post. (No posting the company name only to hold it. You must make a full post or I will delete it.) Access a recent (less than 12 months) annual 10-K report for the company at the EDGAR filings at SEC Edgar search tool or Yahoo or Google finance. Review the report and...
Select a company in your pathway that maintains inventory. Don't use a company that someone has...
Select a company in your pathway that maintains inventory. Don't use a company that someone has already used. Please put the company's name as the subject of your post. (No posting the company name only to hold it. You must make a full post or I will delete it.) Access a recent (less than 12 months) annual 10-K report for the company at the EDGAR filings at SEC Edgar searh tool or Yahoo or Google finance. Review the report and...
Select a company in your pathway that maintains inventory. Don't use a company that someone has...
Select a company in your pathway that maintains inventory. Don't use a company that someone has already used. Please put the company's name as the subject of your post. (No posting the company name only to hold it. You must make a full post or I will delete it.) Access a recent (less than 12 months) annual 10-K report for the company at the EDGAR filings at SEC Edgar search tool or Yahoo or Google finance. Review the report and...
Select a company that maintains an inventory. Don't use a company that someone has already used....
Select a company that maintains an inventory. Don't use a company that someone has already used. Please put the company name as the subject of your post. (No posting the company name only to hold it. You must make a full post or I will delete it.) Access a recent annual 10-K report for the company at the EDGAR filings atwww.SEC.gov or Yahoo or Google finance. Review the report and tell us the following: 1. When the report was filed...
Eastland Company maintains a perpetual inventory system. On June 5, Eastland purchased 1,000 inventory units at...
Eastland Company maintains a perpetual inventory system. On June 5, Eastland purchased 1,000 inventory units at $3 each, on account. On June 9, Eastland sold 500 units for $7 each, on account. Eastland's inventory method assessed the cost of units sold as $4 each. What is the proper journal entry for Eastland on June 9?
XYZ firm makes three products - M1, M2 and B -- in a joint setting. The...
XYZ firm makes three products - M1, M2 and B -- in a joint setting. The NRV of the three products at the splitoff point are $1,500, $2,500 and $250 respectively. The firm incurs joint costs of $3,200, and sold $200 worth of product B. What is the joint cost allocated to M1, under the NRV method, if B is a by product accounted for under the sales method?
Question 8Generous Dynamics maintains an inventory of 4000 ounces of gold.The company is interested...
Question 8Generous Dynamics maintains an inventory of 4000 ounces of gold. The company is interested in protecting the inventory against daily price changes. The correlation of the daily change in the spot and futures price is 0.4, the standard deviation of the daily spot price change is 26 percent, and the standard deviation of the daily change in the futures price is 14 percent. The futures contract size is 1000 ounces. How many contracts should GD buy or sell to...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements and presents the following data for one department for February 2020. Present a schedule that shows the ending inventory at cost and highlight that cell with color and a thick outside border. Label each column and row clearly so your workpaper can be used by other people in Marquette's accounting department. Present the cost to retail percentage as a percentage with two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT