4 5 6 3 Complete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. Financial Plan 7 8 Stock at Retail (Shown in Millions) 01 02 03 9 BOS/BOM STOCK Feb $15,874.00 Mar Apr 05 Jun 10 SALES (-) 11 RECEIPTS (+) 12 MARKDOWNS (-) $821.90 13 EOM/EOS STOCK $5,783.80 $5,875.40 $5,521.70 $6,247.60 $7,743.40 $7,438.90 $8,147.80 $876.40 $707.20 $16,409.30 $17,450.10 $18,912.30 04 May Jul $17,450.10 $18,912.30 $18,916.10 $6,187.30 $6,413.80 $6,987.30 $698.40 $1,287.60 06 Total AVG SALES AVG STOCK TURNOVER 14 15 Margin % 57.31% 16 Cost Complement 53.13% 46.87% 40.64% 56.02% 43.98% 57.77% 42.23% 56.36% 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.99 COGS 21 SALES (-) $2,469.10 $2,753.80 $2,629.30 $2,612.90 $2,798.98 ACI 22 RECEIPTS (+) $2,667.10 23 MARKDOWNS (-) $350.87 $456.80 24 EOM/EOS STOCK $3,023.17 $356.17 $7,091.72 $3,583.40 $311.03 $2,909.44 $3,049.26 $294.93 $561.91 GM$ GM% GMROII 25