This Excel sheet is an example of a six-month buying plan with formulas that that project the following months planned sales, stock to sales ration, BOM stock, markdowns, purchases at retail and purchases at cost based on the previous year’s performance and market analysis.