Question

Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and in
a. Compute the gross profit margin (GPM) for each of these companies for 2013 and 2012 Tiffany Blue Nile 2013 2012 2013 0 Gro
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer with working note is given below

Gross profit is shown to 2 decimal points since nothing is specified in question

Sales Cost of Goods sold Gross profit Gross profit margin (GPM) Tiffany 2013 2012 $4,031 $3,794 $1,691 $1,631 $2,340 $2,163 5

Sales Cost of Goods sold Gross profit Gross profit margin (GPM) Tiffany 2013 2012 $4,031 $3,794 $1,691 $1,631 $2,340 $2,163 58% 57% Zale 2013 $1,888 $904 $984 52% 2012 $1,867 $906 $961 51% $ Millions Blue Nile 2013 2012 $450 $400 $366 $325 $84 $75 19% 19%(Gross profit/Sales)% | b) Inventory Turnover Avg inventory days outstanding Tiffany 0.7 492 Zale Blue Nile 1.2 10.8 305 34 Working notes Opening inventory Closing inventory Average inventory Tiffany $2,234.01 $2,327.00 $2,280.5 Zale $742.0 $768.0 $755.0 Blue Nile $33.0 A $35.0 B $34.0 (A+B)/2 Inventory turnover (A/B) Cost of Goods sold-A Average inventory - B 0.7 $1,691.0 $2,280.5 1. 2 $904.01 $755.00 10.8 $366.0 $34.0 Avg inventory days outstanding (A/B) 365 days - A Inventory turnover - B 1 492 365 0 .7 305 34 365 365 1. 210.8 Amount saved in taxes to date Amount saved in taxes for year ending 7/31/2013 Million $22.1 $63*35% $1.6 ($63-$58.3)*35%

Add a comment
Know the answer?
Add Answer to:
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...

    Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). (5 millions) 2013 2012 Tiffany & Co. Revenues $4,031 $3,794 Cost of goods sold 1,091 1,631 Inventory 2.327 2.234 Zale Corporation Revenues 51,885 51.867 Cost of goods sold 904 906 Inventory 768 742 Blue Nile, Inc Revenues 5450 5400 Cost of goods...

  • Calculating Gross Profit and Inventory Turnover The following table presents sales revenue, cost of goods sold,...

    Calculating Gross Profit and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three computer/electronics companies, Samsung Electronics Co., Hewlett- Packard Company, and Apple Inc. Smilliens Fiscal year ending Samsung Electronics Co. Ltd. S. Korean Won Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Revenues 206,205,987 228,602,667 201,103,613 Cost of goods sold 128.273,800 137,696,309 126,651,931 Inventory 17,317.504 19.134.868 17,747,413 Hewlett-Packard Company (US dollar) Oct. 31, 2014 Oct. 31, 2013 Oct. 31, 2012...

  • Computing Cost of Sales and Ending Inventory Stocken Company has the following financial records for the...

    Computing Cost of Sales and Ending Inventory Stocken Company has the following financial records for the current period: Units Unit cost Beginning inventory 100 $48 Purchases #1 650 44 #2 550 40 #3 200 38 Ending inventory at the end of this period is 350 units. Compute the ending inventory and the cost of goods sold for the current period using (a) first-in, first-out, (b) average cost, and (c) last-in, first-out. FIFO Average cost LIFO Cost of goods sold Answer...

  • Part B Calculating Gross Profit and Inventory Turnover The following table presents sales revenue, cost of...

    Part B Calculating Gross Profit and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three computer/electronics companies, Samsung Electronics Co., Hewlett-Packard Company, and Apple Inc. Fiscal year ending Dec. 31, 2013 228,692,667 $ millions Samsung Electronics Co. Ltd.(S. Korean won) Dec. 31, 2014 Dec. 31, 2012 Revenues Cost of goods sold Inventory 206,205,987 201,103,613 28,278,800 137,696,309 126,651,93 7,317,504 19,134,868 17,747,413 Oct. 31, 2014 oct. 31, 2013 Oct. 31, 2012 77,887 59,468 6,317...

  • 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. LIFO...

     During the year, TRC Corporation has the following inventory transactions. For the entire year, the company sells 400 units of inventory for $50 each. Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 4 decimal places and all other answers to...

  • Gross Profit margin = Gross Profit / Total Revenue, Gross Profit = Sales - Cost of...

    Gross Profit margin = Gross Profit / Total Revenue, Gross Profit = Sales - Cost of Goods Sold. Operating Profit = Operating Revenue - Cost of Goods Sold (COGS) - Operating Expenses - Depreciation - Amortization. However, for a hospital, there is no "Cost of Goods Sold", so how to calculate Gross Profit margin and Operating Profit ?

  • Consider the following financial data for J. White Industries: Total assets turnover: 1.5 Gross profit margin...

    Consider the following financial data for J. White Industries: Total assets turnover: 1.5 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 35% Quick ratio: 0.85 Days sales outstanding (based on 365-day year): 36 days Inventory turnover ratio: 6.0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Complete the balance sheet and sales information...

  • Oriole Inc. has sales of $5,800,000, a gross profit margin of 32.0 percent, and inventory of...

    Oriole Inc. has sales of $5,800,000, a gross profit margin of 32.0 percent, and inventory of $850,000. What are the company's inventory turnover ratio and days' sales in inventory? (Round inventory turnover ratio to 3 decimal places, e.g. 12.555 and days' sales in inventory to 1 decimal place, e.g. 12.5. Use 365 days for calculation.)

  • Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross...

    Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost   FIFO (PERIODIC) Unit Selling Price July 1 July 13 July 25 July 31 Beginning Inventory Purchase Sold Ending Inventory Units Unit Cost 40 $10 200 (100) 140 $14 Units Cost per Unit Total Beginning Inventory Purchases July 13 Goods Available for Sale Cost of Goods Sold Units from Beginning Inventory Units from July 13 Purchase...

  • S6-7 (similar to) Cola Company made sales of $30,000 million during 2014. Cost of goods sold...

    S6-7 (similar to) Cola Company made sales of $30,000 million during 2014. Cost of goods sold for the year totaled $12,900 million. At the end of 2013, Cola's inventory stood at $1,300 million, and Cola ended 2014 with inventory of $1,700 million. Compute Cola's gross profit percentage and rate of inventory turnover for 2014. Begin by computing Cola's gross profit percentage for 2014. (Round your answer to the nearest tenth of a percent, X.X%.) Cola's gross profit percentage for 2014...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT