Excel practice session-April-2

.xls
Planning and Authorization Buyer_____________________ Merchandise Manager___________________ This year's sales = 6% increase Date Authorized________________ Six-Month Merchandise Plan Six-Month Merchandise Plan Spring February March April May June July Total Department Name___________ Fall August September October November December January Avg. Stock From: February 1 $86,000 $243,555 $500,890 $25,000 $41,000 $320,000 $1,216,445 Monthly Sales% To: July 31 TY Plan $0 $0 Department Financial Data Actual LY TY Plan Stock/Sales Ratio 4.00 3.30 2.70 2.50 3.50 3.00 Initial MU% TY Plan $0 $0 Markdown% 15.0% Actual Shrinkage% (Workroom Cost) (Cash Discount) (Gross Margin) Average Stock $403,810 Turnover Rate 2.10 LY Sales$ LY BOM$ A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Uploaded by ChiefHeat11719 on coursehero.com