Can you explain how the yellow fields were calculated? Financial Plan Stock at Retail 01 02 03

Can you explain how the yellow fields were calculated?

Transcribed Image Text:

Financial Plan Stock at Retail 01 02 03 04 05 06 (Shown in Millions) Feb Mar Apr May Jun Jul Total BOS/BOM STOCK SALES (-) $5,783.80 RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $15,874.00 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $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.30 $35,760.40 AVG SALES $43,454.50 AVG STOCK $5,366.10 TURNOVER $5,960.00 $17,325.71 2.06 Margin % 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% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $6,776.61 $7,272.30 $6,668.74 $7,674.55 $2,469.10 $2,753.80 $2,244.02 $2,629.30 $2,667.10 $3,629.33 $3,023.17 $3,583.40 $350.87 $456.80 $356.17 $311.03 $6,623.74 $7,691.03 $7,091.72 $8,317.62 $7,986.66 $8,254.99 $2,612.90 $2,798.98 COGS $17,694.95 ACI $7,490.34 $294.93 $7,988.27 $2,909.44 $3,049.26 $18,861.70 GM$ $561.91 $18,065.45 GM% 50.52% $7,943.36 GMROII $1.42 Financial Plan Stock at Retail 01 02 03 04 05 06 (Shown in Millions) Feb Mar Apr May Jun Jul Total BOS/BOM STOCK SALES (-) $5,783.80 RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $15,874.00 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $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.30 $35,760.40 AVG SALES $43,454.50 AVG STOCK $5,366.10 TURNOVER $5,960.00 $17,325.71 2.06 Margin % 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% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $6,776.61 $7,272.30 $6,668.74 $7,674.55 $2,469.10 $2,753.80 $2,244.02 $2,629.30 $2,667.10 $3,629.33 $3,023.17 $3,583.40 $350.87 $456.80 $356.17 $311.03 $6,623.74 $7,691.03 $7,091.72 $8,317.62 $7,986.66 $8,254.99 $2,612.90 $2,798.98 COGS $17,694.95 ACI $7,490.34 $294.93 $7,988.27 $2,909.44 $3,049.26 $18,861.70 GM$ $561.91 $18,065.45 GM% 50.52% $7,943.36 GMROII $1.42