Paper has been designed such that it acquaints the students with the merchandise planning through which retailers can manage their inventory management, customer loyalty programs and accounting features.
Introduction to Excel: Toolbar, Status Bar, Themes and Style Galleries, Floating mini-formatting bar, resizable formula bar, enhanced sorting and filtering, working on a worksheet.
Excel formulas: writing a formula, simple formula, complex formulas and the order of operations, formula auditing
Retail planning: Retail organization structure, Planning levels- corporate level plans, division level plans, functional unit plans, department plans; merchandise planning,
Sales Planning: developing sales projections, planning a total season’s sales, planning distributions of a total season’s sales
Inventory Management: Stockturn, planning a beginning-of-month inventory, end-of-month inventories
Planning reductions: Markdowns, employee discounts, shrinkage, planning reductions
Planning purchases: the purpose of planning purchases, open-to-buy
Planning markups: calculation and expression of markups, using markup percent to calculate prices, types of markup
Cost Values: the retail method of inventory, calculations required for the retail method of inventory valuation, total merchandise handled, cumulative markup and cost complement, total retail reductions, ending inventory retail and cost values
Gross Margins: calculating gross margin, gross margin return on inventory investment (GMROIs), evaluating acceptable GMROIs
• Rosetta S. LaFleur, Merchandise Planning Workbook
• Martin, Hansen, Klingher & Beth, “Mastering Excel 2000”,BPB Publications, 2012
Links:
[1] https://www.management.iisuniv.ac.in/courses/subjects/computer-applications-merchandise-planning
[2] https://www.management.iisuniv.ac.in/academic-year/2018-2019