Question

In: Accounting

Inventory Explanation: Catco purchases parts, such as tires, engines, seats, and axles for construction equipment (such...

Inventory

Explanation: Catco purchases parts, such as tires, engines, seats, and axles for construction equipment (such as a bulldozer). Catco is concerned with how much inventory is in the supply chain for several important reasons. When Catco purchases the parts (sends a purchase order (PO) to a supplier), Catco is now responsible to pay for the parts, which they do with cash (financial term, not really $20 bills). Cash must be financed through debt or equity (think interest rate on your credit card). This interest rate (weighted average cost of capital) is usually between 6-12% depending on the credit worthiness of the company. In addition, Catco needs to use warehouse space to store the parts when they arrive, they need to insure the parts, some get damaged, and possibly some will become obsolete (they will move to a new model of construction equipment that does not use the same part so it is no longer useful and they need to dispose of it). These costs added together make up an inventory “holding cost” which is typically between 12-24% of the value of the item.

Sample Calculation: Catco produces about 120 bulldozers per week and works four (Mon-Thurs) 10-hour shifts. They need 4 tires per bulldozer and 480 tires can fit on a single truck. Catco orders once a week (assume they pay when they order). Transportation takes one week. They hold 2 weeks worth of tires in safety stock. Map out the inventory in the supply chain. How much do they have at any given time (how much at the beginning of the week vs. the end of the week)? If the tires cost $50 each and the annual inventory holding cost is 18%: Note: assume 52 weeks in a year

1. What is the annual holding cost of transportation inventory?

2. What is the annual holding cost of safety stock inventory?

3. What is the cost per tire for transportation inventory and safety stock inventory?

Solutions

Expert Solution

Answer :

Data Given ,

Assuming no. of weeks in a year = 52 weeks

Annual Bulldozer production = Production of bulldozer per week * No.of week

= 120*52

= 6240 Annually

1 Bulldozer requires 4 tires

Annual Demand of tire = 6240*4 = 24960 (D)

lead time for tire = 1 week

Safety stock = 2 weeks of demand

=2*480

=960 tires

Weekly order size of tire = 6240*4 / 52 = 480 tires

Order size = 480 tires

Hence inventory at the beginning of the week

= Safety stock + order size

= 960 + 480

1440 At the beginning

Inventory at the end of the week

= Safety stock

= 96 At the end

Cost of tire c = $50

Annual inventory holding cost = 18%

(1). Annual holding cost of transportation inventory

Annual holding cost = DTCH /52

Where,

D = Annual demand of tire = 24960

T = lead time in week = 1

C = cost of tire = $50

H = Holding cost = 18%

Annual holding cost = 24960*1*50*0.18/52 = $4320

Annual holding cost of transportation inventory is $4320

(2) Annual holding cost of safety stock

= Safety stock * cost/tire * annual holding cost

= 960*50*0.18

= $8640

Annual holding cost of safety stock is $8640

(3)

Total cost per tire for transportation inventory = Cost per tire + Annual holding cost per tire

= 50 + Annual holding cost or transportation inventory / annual demand

= 50 + 4320/24960

= 50 + 0.1730

Total cost per tire for transportation inventory = $50.173

Total cost per tire for safety stock = cost per tire + annual holding cost per tire of safety stock

= 50 + Annual holding cost of safety stock / Total safety stock

= 50 + 8640/960

= 50 + 9

Total cost per tire per safety stock $59.


Related Solutions

Silkworm Inc is a manufacturer of construction equipment, machinery and engines. It also sells financial services....
Silkworm Inc is a manufacturer of construction equipment, machinery and engines. It also sells financial services. You anticipate a substantial increase in its machinery sales. You have the following data. US $'000 2018 2019 Net sales 39,867 57,392 COGS 30,367 43,578 SG&A 4,248 5,203 and thus in percentage terms: % of sales 2018 2019 Net sales 100 100 COGS 76.2 75.9 SG&A 10.7 9.1 a) Estimate the fixed and variable components of COGS and SG&A in 2019. What would be...
Miller, Inc. manufactures construction equipment and farm machinery tires. For the month of June, year 1,...
Miller, Inc. manufactures construction equipment and farm machinery tires. For the month of June, year 1, Miller expects to produce 2,500 tires and sell the same number at $1,000 per tire. Budgeted selling and administrative costs for the tires (all fixed) are expected to equal to $50,000. The standard costs per tire are as follows: Direct materials 100 pounds @ $2/pound $200 Direct labor 20 DLH @ $9/DLH 180 Variable overhead 4.5 MH @$10/MH 45 Fixed overhead 4.5 MH @$50/MH...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors.
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $35 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally:Per Unit15,400 UnitsPer YearDirect materials$9$138,600Direct labor11169,400Variable...
9. Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and...
9. Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales during the past year: Jan. 1 Beginning inventory 125 cases @ $23 $ 2,875 Feb. 25 Purchase 100 cases @ $26 2,600 June 15 Purchase 200 cases @ $28 5,600 Oct. 15 Purchase 150 cases @ $28 4,200 Dec. 15 Purchase 100 cases @ $30 3,000 Goods available for sale 675 $18,275 Total sales 500 cases Dec. 31 Ending inventory 175 cases Assume...
Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales...
Periodic Inventory System and Inventory Costing Methods Portia's Parts Shop recorded the following purchases and sales during the past year: Jan. 1 Beginning inventory 125 cases @ $23 $ 2,875 Feb. 25 Purchase 100 cases @ $26 2,600 June 15 Purchase 200 cases @ $28 5,600 Oct. 15 Purchase 150 cases @ $28 4,200 Dec. 15 Purchase 100 cases @ $30 3,000 Goods available for sale 675 $18,275 Total sales 500 cases Dec. 31 Ending inventory 175 cases Assume for...
On July 1, Hartford Construction purchases a bulldozer for $228,000. The equipment has a 9-year life...
On July 1, Hartford Construction purchases a bulldozer for $228,000. The equipment has a 9-year life with a residual value of $16,000. Hartford uses the units-of-output method depreciation, and the bulldozer is expected to yield 26,500 operating hours. Required: (a) Calculate the depreciation expense per hour of operation. (b) The bulldozer is operated 1,250 hours in the first year, 2,755 hours in the second year, and 1,225 hours in the third year of operations. Journalize the depreciation expense for each...
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods...
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods Sold Inventory Event Unit Cost Total Cost Unit Cost Total Cost Total Cost QTY Bought Qty sold Qty Unit Cost Beginning Inventory 150 755 First Sale 120 First Purchase 400 785 Second Sale 200 Second Purchase 300 805 Sale 290 The firm uses the perpetual inventory system and there are 240 units of the item on hand at the end of the year A....
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $35 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 22,000 Units per...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $39 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: Per Unit 21,000 Units Per...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has...
Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $36 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the carburetor internally: * 1/3 supervisory salaries; 2/3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT