Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This assignment is to practice for a test I need help with the bottom half with formula explanations all yellow needs filled out. I got

This assignment is to practice for a test I need help with the bottom half with formula explanations all yellow needs filled out. I got the top half but the bottom is confusing me. image text in transcribed

B (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK Formula Bar C D E F G K Feb Mar Apr May Jun Jul Total $15,874.00 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $103,077.70 $5,783.80 $5,875.40 $5,521.70 $5,978.40 $6,187.30 $6,413.80 $35,760.40 AVG SALES $5,960.07 $6,247.60 $7,743.40 $7,438.90 $8,147.80 $6,889.50 $6,987.30 $43,454.50 AVG STOCK $17,325.67 $821.90 $974.60 $876.40 $707.20 $698.40 $1,287.60 $5,366.10 TURNOVER 2.06 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $18,202.00 $105,405.70 57.31% 53.13% 56.02% 57.77% 56.36% Margin % Cost Complement 46.87% 40.64% 43.98% 42.23% 43.64% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $7,272.30 $6,668.74 $7,674.55 $ 7,986.66 $8,254.99 $37,857.25 COGS $2,469.10 $2,753.80 $2,244.00 $2,629.30 $2,612.90 $2,798.98 $15,508.08 ACI $2,667.10 $2,607.04 $3,023.17 $3,583.40 $2,909.44 $3,049.26 $17,839.41 GMS $350.87 $ 456.80 $ 356.17 $311.03 $294.93 $561.91 $2,331.70 GM% $7,272.30 $6,668.74 $7,091.72 $7.986.66 $8.254.99 $7.943.36 $45,217.77 GMRON B (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK Formula Bar C D E F G K Feb Mar Apr May Jun Jul Total $15,874.00 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $103,077.70 $5,783.80 $5,875.40 $5,521.70 $5,978.40 $6,187.30 $6,413.80 $35,760.40 AVG SALES $5,960.07 $6,247.60 $7,743.40 $7,438.90 $8,147.80 $6,889.50 $6,987.30 $43,454.50 AVG STOCK $17,325.67 $821.90 $974.60 $876.40 $707.20 $698.40 $1,287.60 $5,366.10 TURNOVER 2.06 $15,515.90 $16,409.30 $17,450.10 $18,912.30 $18,916.10 $18,202.00 $105,405.70 57.31% 53.13% 56.02% 57.77% 56.36% Margin % Cost Complement 46.87% 40.64% 43.98% 42.23% 43.64% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) EOM/EOS STOCK $7,272.30 $6,668.74 $7,674.55 $ 7,986.66 $8,254.99 $37,857.25 COGS $2,469.10 $2,753.80 $2,244.00 $2,629.30 $2,612.90 $2,798.98 $15,508.08 ACI $2,667.10 $2,607.04 $3,023.17 $3,583.40 $2,909.44 $3,049.26 $17,839.41 GMS $350.87 $ 456.80 $ 356.17 $311.03 $294.93 $561.91 $2,331.70 GM% $7,272.30 $6,668.74 $7,091.72 $7.986.66 $8.254.99 $7.943.36 $45,217.77 GMRON

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Accounting

Authors: Frederick D. S. Choi, Gary K. Meek

7th Edition

0136111475, 9780136111474

More Books

Students also viewed these Accounting questions