The following information pertains to two competitors, Superior Inc. and Michigan Corp.
Company |
Beginning Inventory |
Ending Inventory |
Cost of Goods Sold |
|||
Superior Inc. |
$183,000 | $146,000 | $1,230,719 | |||
Michigan Corp. |
$394,000 | $453,000 | $2,280,825 |
Superior Inc. reported sales revenues of $1,613,000, and Michigan
Corp. reported sales revenue of $3,379,000.
Calculate the inventory turnover ratio for Superior and Michigan. (Round answers to 1 decimal place, e.g. 10.5.)
Superior Inc. | Michigan Corp. | |||
---|---|---|---|---|
Inventory turnover ratio |
Enter ratio rounded to 1 decimal place. times | Enter ratio rounded to 1 decimal place. times |
Calculate the gross margin and gross margin ratio for Superior and Michigan. (Round gross margin ratio to 1 decimal place, e.g. 10.5%.)
Superior Inc. | Michigan Corp. | |||||
---|---|---|---|---|---|---|
Gross margin |
$Enter a dollar amount. | $Enter a dollar amount. | ||||
Gross margin ratio |
Enter percentage rounded to 1 decimal place. | % | Enter percentage rounded to 1 decimal place. | % |
On the basis of inventory turnover, which company is moving its inventory faster?
Select company name. moves its inventory faster. |
Superior Inc. | Michigan Corp. | |
Inventory turnover ratio | 7.5 times | 5.4 times |
Working:
Inventory turnover ratio = Cost of goods sold/Average inventory
Superior Inc. | Michigan Corp. | |
Cost of goods sold (a) | 1230719 | 2280825 |
Beginning inventory | 183000 | 394000 |
Ending inventory | 146000 | 453000 |
329000 | 847000 | |
Average inventory (b) | 164500 | 423500 |
Inventory turnover ratio (a)/(b) | 7.48 | 5.39 |
Superior Inc. | Michigan Corp. | |
Gross margin | $ 382,281 | $ 1,098,175 |
Gross margin ratio | 23.7% | 32.5% |
Working:
Superior Inc. | Michigan Corp. | |
Sales revenues (a) | 1613000 | 3379000 |
Less: Cost of goods sold | 1230719 | 2280825 |
Gross margin (b) | 382281 | 1098175 |
Gross margin ratio (b)/(a) | 23.7% | 32.5% |
Superior Inc. is moving its inventory faster.
The following information pertains to two competitors, Superior Inc. and Michigan Corp. Company Beginning Invento...
You have the following information for Novak Corp. for the month ended October 31, 2017. Novak Corp. uses a periodic method for inventory.DateDescriptionUnitsUnit Cost or Selling PriceOct. 1Beginning inventory59$24Oct. 9Purchase11026Oct. 11Sale10035Oct. 17Purchase11027Oct. 22Sale6440Oct. 25Purchase6329Oct. 29Sale10440Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.)Weighted-average cost per unit$enter the Weighted-average cost per unit in dollars rounded to 3 decimal placesCalculate ending inventory, cost of goods sold, gross profit under each of the following methods.(1) LIFO.(2) FIFO.(3) Average-cost. (Round answers...
This information is available for Culver Inc. for 2021 and 2022. (in millions) 2021 2022 Beginning inventory Ending inventory $2,239 $2,442 2,442 2,958 24,943 23,259 Cost of goods sold Sales 43,441 42,427 Calculate the inventory turnover, days in inventory, and gross profit rate for Culver Inc. for 2021 and 2022. (Round gross profit rate to 2 decimal places, eg. 0.25 and all other answers to 1 decimal place, e.g. 15.2. Use 365 days for calculation.) 2021 2022 Inventory turnover ratio...
The financial statements of ConAgra Foods,
Inc.’s 2017 annual report disclose the following
information.
(in
millions)
2017
2016
2015
Year-end inventories
$934.2
$1,044.1
$1,642.6
Fiscal Year
2017
2016
Net sales
$7,826.9
$8,664.1
Cost of goods sold
5,484.8
6,234.9
Net income
648.0
(665.9)
Compute ConAgra’s (a) inventory turnover and (b) the average days
to sell inventory for 2017 and 2016. (Round inventory
turnover to 1 decimal place, e.g. 7.6 and average days to sell
inventory to 0 decimal places, e.g. 65.)...
Exercise 5-08 a-b Financial information for two companies are presented below. Fill in the missing amounts. Metlock, Inc. Larkspur, Inc. Sales revenue $86,000 $enter a dollar amount Sales returns and allowances enter a dollar amount 4,600 Net sales 80,000 102,000 Cost of goods sold 53,600 enter a dollar amount Gross profit enter a subtotal of the two previous amounts 36,720 Operating expenses 14,400 enter a dollar amount Net income enter a total net income 17,340 Calculate the profit margin and...
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) Beginning inventory Ending inventory 2020 2021 2022 $1,800 $2,300 $2,600 2,300 2,600 2,700 Cost of goods sold 18,450 21,805 21,730 Sales revenue 40,200 47,200 47,140 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover times times times e Textbook and Media Calculate the days in inventory for 2020, 2021, and 2022....
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) Beginning inventory Ending inventory Cost of goods sold 2020 2021 2022 $2,100 $2,500 $2,800 2,500 2,800 2,900 20,930 23,850 23,655 38,900 43,600 43,480 Sales revenue Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover times times times e Textbook and Media Calculate the days in inventory for 2020, 2021, and 2022....
The following financial information is for Crane Company. CRANE COMPANY Balance Sheets December 31 Assets 2022 2021 Cash $ 71,000 $ 69,000 Debt investments (short-term) 50,000 41,000 Accounts receivable 107,000 92,000 Inventory 234,000 162,000 Prepaid expenses 29,000 23,000 Land 135,000 135,000 Building and equipment (net) 261,000 187,000 Total assets $887,000 $709,000 Liabilities and Stockholders’ Equity Notes payable $169,000 $106,000 Accounts payable 66,000 54,000 Accrued liabilities 42,000 42,000 Bonds payable, due 2025 250,000 171,000 Common stock, $10 par 203,000 203,000 Retained...
You have the following information for Metlock, Inc. for the month ended October 31, 2017. Metlock, Inc. uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 60 $26 Oct. 9 Purchase 128 28 Oct. 11 Sale 109 34 Oct. 17 Purchase 110 29 Oct. 22 Sale 55 39 Oct. 25 Purchase 71 31 Oct. 29 Sale 118 39 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average...
Sarasota Corporation and Marigold Corporation, two companies of
roughly the same size, are both involved in the manufacture of
shoe-tracing devices. Each company depreciates its plant assets
using the straight-line approach. An investigation of their
financial statements reveals the information shown below.
Sarasota Corp.
Marigold Corp.
Net income
$ 246,750
$ 331,500
Sales revenue
2,056,250
2,210,000
Total assets (average)
4,112,500
3,453,125
Plant assets (average)
2,840,000
1,874,000
Intangible assets (goodwill)
365,100
0
(a)
For each company, calculate these values: (Round return...
Bridgeport Corporation and Flint Corporation, two companies of
roughly the same size, are both involved in the manufacture of
shoe-tracing devices. Each company depreciates its plant assets
using the straight-line approach. An investigation of their
financial statements reveals the information shown below.
Bridgeport Corp.
Flint Corp.
Net income
$ 257,280
$ 320,880
Sales revenue
1,715,200
2,005,500
Total assets (average)
4,288,000
4,011,000
Plant assets (average)
2,730,000
1,858,000
Intangible assets (goodwill)
321,100
0
(a)
For each company, calculate these values: (Round return...