excel spreadsheet expert required

profileIncognito
EXERCISESLSPLANANDOTBJUNE2022.xlsx
Home>Computer Science homework help>excel spreadsheet expert required

sls plan

Sales Plan Forecast REGION:Europe
VALUE IN KEURO ACTUAL 2021 2,021
ACTUAL LY JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC PLAN 2021 ACT VAR%
FP SALES 790 500 652 574 739 1,260 1,020 422 1,378 615 630 1,113 FP SALES 8,263
SALES% ON TOTAL MKD 1,120
MKD 256 145 274 168 134 Total 8,570
MKD% ON TOTAL
BOM 1,591
EOM 1,335
RECEIPT 665 601 402 387 1,256 1,323 678 897 389 467 1,284 879
SALES TREND
MKD= markdown
BOM (Beginning of Month Stock)=EOM
EOM (End of Month Stock)= (BOM+Receipt)-(sales+MKD)
2023
PLAN TY 2023 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC LY PLAN VAR%
FP SALES FP SALES
SALES% ON TOTAL MKD
MKD Total
MKD% ON TOTAL
BOM
EOM
RECEIPT
SALES TREND
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
SALES TREND

OTB EX

VALUE IN K-EURO
ACTUAL SS21 8000K
AVG PRICE +5%
SS21 Handbags 2,546 63%
PERMANENT CARRY OVER SEASONAL STILL VALID TOTAL SMLG 987 25%
category sub-cat sales %share sales %share sales %share sales %share sales %share Belts 478 12%
LEATHER GOODS Handbags 1,040 20% 1,300 25% 2,340 45% 520 10% 5,200 65% 4,011 100%
SMLG 260 13% 440 22% 1,000 50% 300 15% 2,000 25%
Belts 144 18% 256 32% 240 30% 160 20% 800 10%
TOTAL 1,444 18% 1,996 25% 3,580 45% 980 12% 8,000 100% 3,866
FW21 SS22 SS22 vs FW21 FW22
VALUE IN K-EURO REG SALES MKD -30% OUTLET -15% FULL PRICE SALES PLAN MKD -30% OUTLET -15% VAR% REG SALES
SEASONAL INITIAL STK SALES ST% STOCK STK SLS ST% STK SLS PLAN OTB TGT ST% STOCK STK SALES ST% STOCK LEFT STK STK FP SLS ST% FP SALES TGT ST 65% OTB
LEATHER GOODS Handbags 4,567 2,695 0 65% 0
SMLG 1,875 1,024 0 65% 0
Belts 987 465 0 65% 0
TOTAL 7,429 4,011 0 0

OTB EX (2)

SS21 FW21
CARRY OVER SLS LAST 2 MTHS ACT STK WK AV SLS WOS REM WKS SLS 4 EOS BOS WK AV SLS WOS 2 MS SLS STK NEEDED ST 70% OTB
LEATHER GOODS Handbags 896 256
SMLG 1230 2413
Belts 348 395
PERMANENT JAN FEB MAR APR MAY JUN JULY AUG SEPT OCT NOV DEC TOT
HANDBAGS LY SALES 57 48 52 45 62 75 85 25 90 65 55 80 709
TY SALES 0 flat
VAR%
SLS TREND
ACT STOCK