1 Assignment 6.1 2 3 Complete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. 4 Financial Plan 7 Stock at Retail (Shown in Millions) 01 02 03 04 05 Feb Apr 9 BOS/BOM STOCK 10 SALES (-) 11 RECEIPTS (+) 12 MARKDOWNS (-) 13 EOM/EOS STOCK Mar $15,874.00 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $5,783.80 $5,875.40 $5,521.70 $5,978.40 $6,187.30 $6,413.80 $6,247.60 $7,743.40 $7,438.90 $8,147.80 $6,889.50 $6,987.30 $821.90 $974.60 $876.40 $707.20 $698.40 $1,287.60 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $18.202.00 May Jun 82 06 Jul Total $35,760.40 $43,454.50 $5,366.10 AVG SALES AVG STOCK TURNOVER $5,960.07 $20,213.28 1.77 14 15 Margin % 16 Cost Complement 57.31% 42.69% 53.13% 46.87% 59.36% 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 21 SALES (-) 22 RECEIPTS() $2,469.10 $2,753.80 $2,667.10 $2,244.02 $3,023.17 $7,674.55 $7,986.66 $2,629.30 $3,583.40 $8,254.99 COGS $2,612.90 $2,798.98 ACI $2,909.44 $3,049.26 GMS 23 MARKDOWNS (-) $350.87 $456.80 24 EOM/EOS STOCK $356.17 $7,091.72 $311.03 $8,317.63 $294.93 $561.91 GM% $7.988.27 $7.943.35 GMRO 25