Use the information provided below to create a spreadsheet to analyze the replacement

tube cost structure for six potential suppliers.

Which supplier source requires the highest investment of working capital or cash for

average inventory? Which supplier source provides Ted with the highest percentage of

gross profit on the presta replacement tube?

Students should create a spreadsheet with the following assumptions:

Tubes per Day $=400$

Selling Price $=$ $$6\mathrm{.}50$

Average Inventory $=150\%$

Carrying Cost $=24\%$

Units per Year $=144,000$