Synopses & Reviews
The recipe for profitability is presented in Merchandise Planning Workbook. Focusing on the development of a six-month merchandise plan, the text explains how to use Excel 2007 as a tool to project sales, manage inventory, calculate the amount of merchandise to purchase, and adjust the price throughout the selling season. Application Exercises throughout the chapters familiarize students with each aspect of the plan, provide practice in inputting formulas and data, and demonstrate the impact of changing variables. Seven end-of-chapter assignments, when completed in sequence, produce a merchandise plan for a selling season. By mastering this important aspect of merchandising math, students can develop a marketable competency to help launch their careers in retailing.
Synopsis
Focusing on the development of a 6-month merchandise plan, this text explains how to use Excel 2007 as a tool to project sales, manage inventory, calculate the amount of merchandise to purchase, and adjust the price throughout the selling season.
About the Author
Rosetta LaFleur is an associate professor at the University of Delaware.
Table of Contents
Introduction to Excel 2007
Excel Formulas
Planning
Sales Planning
Inventory
Planning Reductions
Planning Purchases
Planning Markup
Cost Values
Gross Margin