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