Worksheet_2

Worksheet_2 - 51.5 134.0 64.0 450.0 Plan 25.0 - 23.0 164.0...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
SIX-MONTH DOLLAR PLAN DEPT. NAME Children's Wear DEPT. # BUYER FALL AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY SALES $ Last Year $225.0 300.0 210.0 255.0 390.0 120.0 1,500.0 Plan 250.0 330.0 230.0 410.0 425.0 115.0 1,760.0 % Inc/Dec 11.1% 10.0% 9.5% 60.8% 9.0% -4.2% 17.3% Revised Actual STOCK/SALES Last Year 3.9 3.0 4.1 3.6 2.5 6.3 5.7 RATIO Plan 4.1 3.4 4.2 3.8 3.1 6.0 BOM STOCK $ Last Year $877.5 900.0 861.0 918.0 975.0 756.0 850.0 876.8 avg. (Retail) Plan 1,025.0 1,122.0 966.0 1,102.0 1,317.5 690.0 115.0 905.4 Revised Actual MARKDOWNS $ Last Year $89.5 45.0 66.0
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 51.5 134.0 64.0 450.0 Plan 25.0 - 23.0 164.0 85.0 23.0 320.0 % to Sales 10.0% 0.0% 10.0% 40.0% 20.0% 20.0% 18.2% % by Month 7.8% 0.0% 7.2% 51.3% 26.6% 7.2% 100.0% Revised Actual PURCHASES $ Last Year $337.0 306.0 333.0 363.5 305.0 278.0 1,922.5 (Retail) Plan 235.0 260.0 2,203.0 254.0 1,580.0 138.0 4,670.0 Revised Actual SEASON TOT. LAST YEAR PLAN ACTUAL Sales $1,500.00 1760.0 Markup % 55% Markdown % 30% Gross Margin % 41.5% Average Stock 876.8 905.4 Turnover 1.71 1.94 NOTES: SEASON TOTAL...
View Full Document

This note was uploaded on 02/14/2012 for the course HUEC 3043 taught by Professor Freeman during the Fall '10 term at LSU.

Ask a homework question - tutors are online