Use the information provided below to create a spreadsheet to analyze the replacement tube cost structure for

Question:

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?