1. Creating a view using the BUPP,Pre-Season, Sales Planning spreadsheet with PRODUCT in the slice dimension. This will be for Season 2014, Dept. 01 - DENIM (Keep All Slices Available - see #2)

The across dimensions will have LOCATION (ORG) in the first (top) row, TIME in the second row. The up and down dimensions will be VARIABLES and VERSIONS only. The new view will only include SALES UNITS, SALES DOLLARS, BEGINNING INVENTORY $, ENDING INVENTORY $, WP, LY, WP/LY VARIANCE.

(DO NOT CLOSEOUT VIEW UNTIL COMPLETING PART #2 below)

Print the DEPARTMENT spreadsheet in LANDSCAPE mode. -Fit on one page if nec.

Take Screen Grab.

2. From EP (views from #1), import the data on into Excel. The Excel report should include the DEPARTMENT and Denim on one sheet; formatted as if you are submitting this information to your DMM. Print the report and submit.

3. Using the BUPP, Sales and Gross Margin spreadsheet, Dept 1, year 2014 Casual Class, insert a percentage participation column, illustrating the penetration of each month to the total season.

Print and submit the DEPARTMENT sheet only. Take Screen Grab.

4. Open the BUPP, Inventory Planning spreadsheet Dept. 01, 2014 Skirts, Spring Season. Please note the WP STOCKTURN and enter below. Revise the SALES DOLLAR WP/LY VARIANCE to 18% increase over last year for the months in 1st Quarter and 12% increase over last year for the months in 2nd Quarter. Change the Total Season MARKDOWN RATE to 18%.

You will not revise RECEIPTs at this time. Format as standard 6 month Inventory plan

i.e.BOM, Sales, MD$, MD%, Receipts, EOM, Stock Turn

a) Working Plan Stock Turn ________ b) What is the revised working plan stock turn? __________

5. Using the SALES DOLLARS variable from part #4 (above), create a bar chart showing DEPARTMENT 1 only; comparing Working Plan SALES DOLLARS to Last Year SALES DOLLARS for each month in the season.