A Cost of Goods Sold Analysis Model by Richard Rose. Excel file. For calculating total direct cost of goods of a product, including packaging, shipping, box, gross profit margins, suggested retail prices, etc. The values are useless to you, as the formulas are where the magic happens. Just add your products and data. FREE, $999 value.