Introduction, USING COMPUTERIZED SPREADSHEETS. Basic Computer Operations. Input Data and Interpret Computer Output. INDIVIDUAL MARKUPS. Calculate Retail Price. Calculate Desired Cost. Calculate Individual Markup Percent. Calculate retail price, cost, and markup percentages based on cost.

INITIAL MARKUPS. Calculate initial markup percent. Calculate required sales. Calculate estimated profit. CUMULATIVE MARKUP. Calculate cumulative markup percent. Calculate markup needed on new purchases. MARKDOWNS AND MARKDOWN CANCELLATIONS.

Calculate total dollar markdowns. Calculate markdown percentage. Calculate off-retail percentage. Calculate markdown cancellations. MAINTAINED MARKUPS. Calculate maintained markups. INVENTORY PLANNING. Calculate average inventory and stock turnover.

Calculate required sales. Calculate stock-sales ratio and planned sales. PLANNING PURCHASES. Calculate planned sales. Calculate planned stock levels. Develop a six-month buying plan. PLANNING ASSORTMENTS. Calculate assortments of merchandise to be purchased.

PURCHASE ORDERS. Calculate cost and retail extensions with markup percentages. OPEN-TO-BUY. Calulate open-to-buy. OPERATING RESULTS. Calculate profit and loss. Appendix A: Glossary. Appendix B: Basic Retail Math Formulas.

Appendix C: Detailed Instructions for Using the Spreadsheet Software.