Complete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. Financial Plan Stock at Retail 01 02 03 04 05 06 Feb (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) Mar Apr May Jun Jul Total $17,450.10 $18,912.30 $18,916.10 $6,413.80 $6,987.30 $15,874.00 $5,783.80 $6,247.60 $5,875.40 $7,743.40 $5,521.70 $6,187.30 AVG SALES $7,438.90 $8,147.80 AVG STOCK TURNOVER $821.90 $876.40 $707.20 $698.40 $1,287.60 EOM/EOS STOCK $16,409.30 $17,450.10 $18,912.30 Margin % Cost Complement 57.31% 53.13% 56.02% 57.77% 56.36% 46.87% 40.64% 43.98% 42.23% 43.64% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) $7,272.30 $6,668.74 $7,674.55 $7,986.66 $2,612.90 $2,909.44 $8,254.99 $2,798.98 $3,049.26 COGS $2,469.10 $2,667.10 $2,753.80 $2,629.30 ACI $3,023.17 $3,583.40 GM$ $350.87 $456.80 $356.17 $311.03 $294.93 $561.91 GM% EOM/EOS STOCK $7,091.72 GMROII Complete the following retail mathematics spreadsheet using the data provided. Enter the correct values in the highlighted cells. Financial Plan Stock at Retail 01 02 03 04 05 06 Feb (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) Mar Apr May Jun Jul Total $17,450.10 $18,912.30 $18,916.10 $6,413.80 $6,987.30 $15,874.00 $5,783.80 $6,247.60 $5,875.40 $7,743.40 $5,521.70 $6,187.30 AVG SALES $7,438.90 $8,147.80 AVG STOCK TURNOVER $821.90 $876.40 $707.20 $698.40 $1,287.60 EOM/EOS STOCK $16,409.30 $17,450.10 $18,912.30 Margin % Cost Complement 57.31% 53.13% 56.02% 57.77% 56.36% 46.87% 40.64% 43.98% 42.23% 43.64% Stock at Cost (Shown in Millions) BOS/BOM STOCK SALES (-) RECEIPTS (+) MARKDOWNS (-) $7,272.30 $6,668.74 $7,674.55 $7,986.66 $2,612.90 $2,909.44 $8,254.99 $2,798.98 $3,049.26 COGS $2,469.10 $2,667.10 $2,753.80 $2,629.30 ACI $3,023.17 $3,583.40 GM$ $350.87 $456.80 $356.17 $311.03 $294.93 $561.91 GM% EOM/EOS STOCK $7,091.72 GMROII
Expert Answer:
Answer rating: 100% (QA)
01 02 03 04 05 06 Feb March April May June July Total Bos... View the full answer
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0078025525
4th edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date:
Students also viewed these accounting questions
-
3. 2017 2018 2019 2020 2021 + H/C + H/C + - H/C + H/C + JAN 10 15 217 15 10 206 10 15 217 15 10 212 0 10 223 FEB 9 12 214 12 9 209 12 9 220 12 11 213 0 3 220 MAR 10 14 210 14 10 213 10 14 216 12 13...
-
Total assets turnover 15 Gross profit margin on sales SalesCost of goods soldSales 25 Total liabilitiestoassets ratio 40 Quick ratio 080 Days sales outstanding based on 365day year 365 days Inventory...
-
Apr 15Declared a 40 stock dividend to stockholders of record on May 1 to be issued May 10 The current market value is 15 per common share Prepare necessary journal entries to record the events of...
-
Describe, draw, the curve with the following parametric equations in the cylindrical co-ordinate space: r = 5, z = 2,0 = t
-
Simon Weinberg and his brother were the only partners in Times Square Stationers LLP. The partners signed a 20-year lease with Tisch Leasing. After 12 years, Simon retired from the business and was...
-
Determine whether the population means number of texts sent and the population number received (for all the respondents) is different at the 0.05 level by using a paired t-test.
-
Contrast the federal income taxation of a corporation with that of a sole proprietorship and a partnership. Which of the three types of organizations must file a federal income tax return?
-
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March ............................. 4,000 April ............................... 10,000 May...
-
Preston, Incorporated, manufactures wooden shelving units for collecting and sorting mail. The company expects to produce 340 units in July and 370 units in August. Each unit requires 1.50 hours of...
-
Beacons Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Beacons Company prepared the following end-of-period spreadsheet at December 31, 20Y5, the...
-
Suppose you won the lottery but not all of your winnings will come in one year. Instead, you will get a series of annual payments over the next five years. The table below tells you what your payment...
-
In the face of a financial crisis such as that created by the dot.com collapse and the 9/11 terrorist attacks in the US, why would a central bank have responded by lowering interest rates and...
-
How has industrialization affected the family, kinship, marriage, and divorce?
-
Where does H. erectus go first when it leaves Africa, and how do populations of H. erectus differ from one another in space and time?
-
Are the advantages and disadvantages you have listed in answer to question 1 long run or short run in nature?
-
A boyfriend can signal to a girlfriend that he loves her by giving an appropriate gift. Do you think saying I love you can also serve as a signal? Why or why not?
-
Stereoisomerism Crossword There Are Many Different Definitions Associated With Stereoisomerism That It Can Be Very Tough To Remember All Of Them. Fill In The Blanks Of The Crossword Puzzle Based On...
-
Recall that Chapter 8 described the binary search algorithm for finding a particular entry in an ordered list. The idea behind binary search is to begin looking in the exact center of the list. If...
-
Many companies argue that they do not pay their managers a bonus, because they believe their employees will work hard for a "fair" wage and do not need to be motivated with a bonus. Why would...
-
Distinguish between the value chain, the supply chain, and the distribution chain.
-
Its not the job of accounting to determine strategy. It is only used to measure results. Discuss.
-
Show that if there exists at least one constraint in the standard maximum problem, say the \(i^{\text {th }}\), such that \(a_{i j}\) is strictly greater than zero for all \(j\), then the problem is...
-
An enterprising farmer wants to devote some of his land to the raising of hogs, chickens, and ostriches. He will use no more than 1000 square yards for this purpose. After deducting the cost of feed,...
-
A construction contractor builds single-family dwellings and apartment buildings. The contractor can make \(\$ 5000\) profit on each house and \(\$ 50,000\) on each apartment. It takes 400 hours to...
Study smarter with the SolutionInn App