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

mplete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells