To prepare for buying using analysis tools and data.

Complete the assignment in Excel to review the process buyers use and review to complete to their plans and final seasonal outcome. Six-month merchandising plan using last year results as a basis to plan Assortment plans using past selling history Completion of an operating statement Refer to methods discussed in Modules 8, 9, and 13. Think about how the worksheets are set up as a tool for the buyer to complete the planning, purchasing, and review of final results of a season's business. Submit your assignment using the Excel spreadsheet supplied. Note, each spreadsheet (3) is shown as a tab at the bottom of the worksheet. All formats and formulas must be set up and shown to get full credit.