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

Financial Plan

"Stock at Retail

$($Shown in Millions$)"010203040506$

Feb Mar Apr May Jun Jul Total

BOS$/$BOM STOCK $$15,874\mathrm{.}00$ $$17,450\mathrm{.}10$ $$18,912\mathrm{.}30$ $$17,450\mathrm{.}10$ $$18,912\mathrm{.}30$ $$18,916\mathrm{.}10$

SALES $(-)$ $$5,783\mathrm{.}80$ $$5,875\mathrm{.}40$ $$5,521\mathrm{.}70$ $$6,187\mathrm{.}30$ $$6,187\mathrm{.}30$ $$6,413\mathrm{.}80$ AVG SALES

RECEIPTS $(+)$ $$6,247\mathrm{.}60$ $$7,743\mathrm{.}40$ $$7,438\mathrm{.}90$ $$8,147\mathrm{.}80$ $$6,987\mathrm{.}30$ AVG STOCK

MARKDOWNS $(-)$ $$821\mathrm{.}90$ $$876\mathrm{.}40$ $$707\mathrm{.}20$ $$698\mathrm{.}40$ $$1,287\mathrm{.}60$ TURNOVER

EOM$/$EOS STOCK $$16,409\mathrm{.}30$ $$17,450\mathrm{.}10$ $$18,912\mathrm{.}30$

Margin $\%57\mathrm{.}31\%53\mathrm{.}13\%56\mathrm{.}02\%57\mathrm{.}77\%56\mathrm{.}36\%$

Cost Complement $46\mathrm{.}87\%40\mathrm{.}64\%43\mathrm{.}98\%42\mathrm{.}23\%43\mathrm{.}64\%$

"Stock at Cost

$($Shown in Millions$)"$

BOS$/$BOM STOCK $$7,272\mathrm{.}30$ $$6,668\mathrm{.}74$ $$7,674\mathrm{.}55$ $$7,986\mathrm{.}66$ $$8,254\mathrm{.}99$ COGS

SALES $(-)$ $$2,469\mathrm{.}10$ $$2,753\mathrm{.}80$ $$2,629\mathrm{.}30$ $$2,612\mathrm{.}90$ $$2,798\mathrm{.}98$ ACI

RECEIPTS $(+)$ $$2,667\mathrm{.}10$ $$3,023\mathrm{.}17$ $$3,583\mathrm{.}40$ $$2,909\mathrm{.}44$ $$3,049\mathrm{.}26$ GM$

MARKDOWNS $(-)$ $$350\mathrm{.}87$ $$456\mathrm{.}80$ $$356\mathrm{.}17$ $$311\mathrm{.}03$ $$294\mathrm{.}93$ $$561\mathrm{.}91$ GM$\%$

EOM$/$EOS STOCK $$7,091\mathrm{.}72$ GMROII