Question
In: Accounting
Sheridan uses the conventional retail method to determine its ending inventory at cost. Assume the beginning...
Sheridan uses the conventional retail method to determine its ending inventory at cost. Assume the beginning inventory at cost (retail) were $395000 ($599000), purchases during the current year at cost (retail) were $2155000 ($3400000), freight-in on these purchases totaled $134000, sales during the current year totaled $3100000, and net markups (markdowns) were $77000 ($113000). What is the ending inventory value at cost? Hint: Round intermediate calculation to 3 decimal places, e.g. 0.635 and final answer to 0 decimal places.
Solutions
Expert Solution
Ending inventory at cost = $ 560519
| Cost | Retail | ||
| Beginning Inventory | $ 395000 | $ 599000 | |
| Purchases | $ 2155000 | $ 3400000 | |
| Freight in | $ 134000 | ||
| Merchandise available for Sale | $ 2684000 | $ 3999000 | |
| Add: Markups | $ 77000 | ||
| Totals | $ 2684000 | $ 4076000 | |
| Cost to Retail Ratio | 64.95% | ||
| Less: Markdowns | $ 113000 | ||
| Less: Net sales | $ 3100000 | ||
| Ending inventory at retail | $ 863000 |
Explanation:
Cost:
Merchandise available for sale:
= Beginning inventory + Purchases + Fright-in
= $395,000 + $2,155,000 + $134,000
= $2,684,000
Retail:
Merchandise available for sale:
= Beginning inventory + Purchases + Markups
= $599,000 + $3,400,000 + $77,000
= $4,076,000
Retail total = $4,076,000
Ending inventory at retail = Retail total - Markdowns - Net sales
= $4,076,000 - $113,000 - $3,100,000
= $863,000
Computation of Cost to retail ratio
Cost-to-retail ratio is equal to the total cost of goods available for sale divided by the retail value of goods available for sale.
Cost to retail ratio = cost of goods available for sale / retail value of goods available for sale.
= $2,684,000 ÷ ($3,100,000 + $863,000 )
= $2,574,000 ÷ $3,963,000
= 64.95%
Retail value of goods available for sale. = Net Sales + Ending inventory at retail = 3100000 + 863000 = $ 3963000
Ending inventory at retail = $863,000
Computation of Ending inventory at cost
Ending inventory at cost = Ending inventory at retail x Cost to retail ratio
Ending inventory at cost = $863,000 × 64.95%
= $ 560519
Kindly give a positive rating if you are satisfied with the answer.
ekkarill92 answered 1 year agoRelated Solutions
Ivanhoe Inc. uses the conventional retail method to determine its ending inventory at cost. Assume the...
Ivanhoe Inc. uses the conventional retail method to determine
its ending inventory at cost. Assume the beginning inventory at
cost (retail) were $383500 ($584000), purchases during the current
year at cost (retail) were $3208000 ($4993600), freight-in on these
purchases totaled $149500, sales during the current year totaled
$4466000, and net markups were $404000. What is the ending
inventory value at cost? Hint: Round intermediate calculation to 3
decimal places, e.g. 0.635 and final answer to 0 decimal
places.
Please show...
The XYZ Company uses the conventional retail inventory method to estimate ending inventory for its monthly...
The XYZ Company uses the conventional retail inventory method to
estimate ending inventory for its monthly financial statements and
presents the following data for one department for February 2020.
Present a schedule that shows the ending inventory at cost and
highlight that cell with color and a thick outside border. Label
each column and row clearly so your workpaper can be used by other
people in Marquette's accounting department. Present the cost to
retail percentage as a percentage with two...
Tangor Inc. uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements.
Tangor Inc. uses the conventional retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of October 2018.
At Cost At Retail
Inventory, 10/1/18 52,000 78,000
Freight in 16,600
Markdowns (net) 3,600
Markups 9,000
Markup cancellations 2,000
Purchases 272,000 423,000
Sales 385,000
Purchase returns 5,600 8,000
Normal spoilage and breakage 10,000
Employee...
7. Michael Jackson's Strings uses the conventional retail method to estimate ending inventory. Cost data for...
7. Michael Jackson's Strings uses the conventional retail method
to estimate ending inventory. Cost data for the most recent quarter
is shown below:
Cost Retail
Beginning inventory
$46,000
$63,000
Net purchases
154,000
215,000
Net
markups
22,000
Net
markdowns
35,000
Net
sales
220,000
To the nearest thousand, estimated ending inventory using the
conventional retail method is
A. $30,000.
B. $32,000.
C. $34,000.
D. $37,000.
8. Mario Brothers Company adopted the dollar-value
LIFO inventory method on January 1, 2015....
Determine the ending inventory under the conventional retail method for the furniture department of Bonita Department...
Determine the ending inventory under the conventional retail
method for the furniture department of Bonita Department Stores
from the following data. (Round ratio of cost to
selling price to 2 decimal places, e.g. 15.25% and final answer to
0 decimal places, e.g. 5,125.)
Cost
Retail
Inventory, Jan. 1
$154,200
$291,700
Purchases
1,361,600
2,249,100
Freight-in
69,200
Markups, net
92,000
Markdowns, net
48,600
Sales revenue
2,251,400
Ending inventory
$
1. Determine the ending inventory under the conventional retail method for the furniture department of Tamarisk...
1. Determine the ending inventory under the conventional retail
method for the furniture department of Tamarisk Department Stores
from the following data.
Cost
Retail
Inventory, Jan. 1
$152,400
$287,600
Purchases
1,426,400
2,070,000
Freight-in
70,900
Markups, net
95,900
Markdowns, net
46,500
Sales revenue
2,093,100
Ending inventory -->
_______
Retail inventory method; various cost methods Sparrow Company uses the retail inventory method to estimate ending...
Retail inventory method; various cost methods
Sparrow Company uses the retail inventory method to estimate
ending inventory and cost of goods sold. Data for 2016 are as
follows:
Cost
Retail
Beginning Inventory
$90,000
$180,000
Purchases
$355,000
$581,000
Freight-in
$9,000
Purchase Returns
$7,000
$11,000
Net Markups
$16,000
Net Markdowns
$12,000
Normal Spoilage
$3,000
Abnormal Spoilage
$4,800
$8,000
Sales
$540,000
Sales Returns
$10,000
The company records sales net of employee discounts. Discounts
for 2016 totaled $4,000.
Required:
Estimate Sparrow’s ending inventory and...
Almaden Valley Variety Store uses the retail inventory method to estimate ending inventory and cost of...
Almaden Valley Variety Store uses the retail inventory method to
estimate ending inventory and cost of goods sold. Data for 2021 are
as follows:
Almaden Valley Variety Store uses the retail inventory method to
estimate ending inventory and cost of goods sold. Data for 2021 are
as follows:
Cost
Retail
Beginning
inventory
$
22,000
$
30,000
Purchases
112,600
175,000
Freight-in
2,500
Purchase
returns
4,500
12,000
Net markups
11,000
Net
markdowns
8,000
Normal
spoilage
5,200
Net sales
162,000
Required:
Complete the...
Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold....
Sparrow Company uses the retail inventory method to estimate
ending inventory and cost of goods sold. Data for 2018 are as
follows:
Cost
Retail
Beginning inventory
$
89,000
$
179,000
Purchases
352,000
579,000
Freight-in
8,900
Purchase returns
6,900
10,900
Net markups
15,900
Net markdowns
11,900
Normal spoilage
2,900
Abnormal spoilage
4,512
7,900
Sales
539,000
Sales returns
9,900
The company records sales net of employee discounts. Discounts for
2018 totaled $3,900.
Required:
1. Estimate Sparrow’s ending inventory and cost of
goods...
Sparrow Company uses the retail inventory method to estimate ending inventory and cost of goods sold....
Sparrow Company uses the retail inventory method to estimate
ending inventory and cost of goods sold. Data for 2016 are as
follows:
Cost Reatail
Begining inventory. $90,000. $180,000
Purchases 335,000. 580,000
Freight in 9,000
Purchase returns. 7,000 11,000
Net markups 16,000
Net markdowns 12,000
Normal spoilage 3,000
Abnormal spoliage. 4,800 8,000
Sales 540,000
Sales returns 10,000
The company records sales net of employee discounts. Discounts
for 2016 totaled $4,000.
Required:
Estimate Sparrow’s ending inventory and cost of goods sold...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What is OPEC and how would it be described in economic terms? 200 words
- explain the construction and working of indirect arc furnace with sketch
- Write a MATLAB function, called arbpoly, that computes a polynomial arbitrary nth degree. The function will...
- Over the past seven weeks, we have explored different decades of US history and applied principles...
- One economic question is deciding how to produce. That means businesses need to make decisions on...
- Is 2k-1 odd? I get that 2(some int k) + 1 is the property for odd...
- A 0.25 kg block slides down a ramp that is 0.6 m tall, 0.8 m long...
ADVERTISEMENT