C20 v x v fx A B C D E Assignment 6.1 H Complete the following retail mathematics spreadsheet using the data provided. Enter the corre Financial Plan Stock at Retail 01 02 03 04 05 06 LO DO (Shown in Millions) Feb Mar Apr May Jun Jul BOS/BOM STOCK $15,874.00 $15,515.90 $16,409.30 $17,450.10| $18,912.30| $18,916.10 10 SALES (-) $5,783.80 $5,875.40 $5,521.70 $6,187.30 $6,413.80 11 RECEIPTS (+) $6,247.60 $7,743.40 $7,438.90 $8,147.80 $6,987.30 12 MARKDOWNS (-) $821.90 $876.40 $707.20 $698.40 $1,287.60 13 COM/EOS STOCK 15,874.00-5, $16,409.30 $17,450.10|$18,912.30 14 15 Margin % 57.31% 53.13% 56.02% 57.77% 56.36% 16 Cost Complement 100%-57.319 46.87% 40.64% 43.98% 42.23% 43.64% 17 18 Stock at Cost 19 (Shown in Millions) 20 BOS/BOM STOCK $7,272.30 $6,668.74 $7,674.55 $7,986.66 $8,254.95 21 SALES (-) $2,469.10 $2,753.80 $2,629.30 $2,612.90 $2, 798.98 22 RECEIPTS (+) $2,667.10 $3,023.17 $3,583.40 $2,909.44 $3,049.26 23 MARKDOWNS (-) $350.87 $456.80 $356.17 $311.03 $294.93 $561.91 24 EOM/EOS STOCK $7,091.72 25 26 27 28 29 30 31 32 33 34 35 6.1 + Ready x Accessibility: Investigate 51 F Cloudy