Page 2 of 4 AMM 2500 Fashion Retail Buying 1 (Dr. Yishuang Li, 2020 Spring) (15 points) A sportswear buyer sets up the following assortment plan for this Fall season. Fill in the empty cells (green shaded) with appropriate formulas using cell references. (0.5 pts each cell) VSA 15) totoo Soat 1 8) Blazers 4 Assortment Factors Item #Style #Color #Size Variety Volume OTBS@R ARP Classification (SKU) Units Jeans $26.287 348 50 Hoodies $13.578 S43.80 Graphic TS 17 S10,732 S19.80 Sweaters s20.824 S41.40 Polos 58,215 $26.50 Outerwear 598.00 Pants 550.70 Skirts 242 1.44 1 547.40 Shirts $9.6989) 1.60 54.524 TOTAL 104 1.570 3.871 $176,144 545.50 Calculation Instruction: Cells in the above chart are numbered I) through 9) according to their formulas. In other words, all 1)'s use the same formula, all 2)'s use the same formula,...ctc.. according to the instructions below. 1) Variety for an item class=#SKU's for the item class = multiply # of cach assortment factor for the item class In this problem, assortment factors include style, color, and size Therefore, Variety = SKUS = #style x color x size formula 1) 2) Style for an item class can be derived from formula / when #SKUs, color, and size for the item class are known. 3) Color for an item class can also be derived from formula / when #SKUS, #style, and #size for the item class are known. 4) WSize for an item class can also be derived from formula / when ISKUS, style, and #color for the item class are known. 5) Volume for an item class= Units for the item class When Open Tn.Ruy (OTRIS hutt Retail for the item class is known along with average retail price (ARP) for the item class, use the top-down calculation for volume, given below Volume = #Units = OTBS at Retail / ARP. (formula 2) ) VSA (Volume per SKU in Assortment) = Volume (unit) per SKU Page 3 of 4 AMM 2500 Fashion Retail Buying (Dr. Yishuang Li, 2020 Spring) VSA -Volume /Variety #Units / NSKU's, formula 3) 7) Formula for obtaining Volume(Units) when VSA and Variety (ENSKU) are known can be derived from above formula 3. Note that this is the bottom-up approach of calculating assortment volume. 8) When Volume (= #units) and average unit retail price are known for an item class, OTBS at Retail for the item class can be calculated by: OTB(S) R = Volume (#units) ARP. Formula 1) 9) Formula for ARP (average retail price) for each item class, when OTB (S) R and Volume (units) for the item class are known, can be derived from above formula 4