Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows:
Cost |
Retail |
|
Celebrity Tan Co. | ||
Inventory, August 1 | $ 260,000 | $ 595,000 |
Transactions during August: | ||
Purchases (net) | 2,263,400 | 3,475,000 |
Sales | 3,275,000 | |
Ranchworks Co. | ||
Inventory, March 1 | $870,000 | |
Transactions during March through November: | ||
Purchases (net) | 9,260,000 | |
Sales | 15,050,000 | |
Estimated gross profit rate | 40% |
Required: | |||||||
1. | Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method.* Enter all ratios as percents, rounded to one decimal place. | ||||||
2. |
|
Retail Inventory Method
The retail inventory method is based on the mark-up over the cost for arriving at retail price. If u mark is 25 percent,
an item bought for $80 would sell for (80+25%*80)= $100
Celebrity Tan Co.
RetailValue |
||
Inventory ,Aug 1 |
$595,000 |
|
Purchases |
$3,475,000 |
|
Available for sale |
$4,070,000 |
|
Sales during the period |
$3,275,000 |
|
Retail value of ending inventory |
$795,000 |
|
Cost |
||
Beginning Inventory |
$260,000 |
|
Purchases |
$2,263,400 |
|
Cost of goods available for sale |
$2,523,400 |
|
Cost to retail Ratio |
0.770503817 |
(2523400/3275000) |
Retail value of ending inventory |
||
Cost of ending inventory |
$612,550.53 |
(795000*0.77050382) |
Estimated cost of inventory on August31 of of Celebrity Tan Co.=$612,550.53
Ranchworks Co.
The gross profit method uses gross profit rate which is 40% in this case.
Sales during the period=15,050,000
Gross Profit(40%)=$15050000*40%=$6,020,000
Cost of goods sold =$15050000-$6,020,000=$9,030,000
Costs |
||
Inventory ,March1 |
$870,000 |
|
Purchases, march to Nov |
$9,260,000 |
|
Available for sale |
$10,130,000 |
|
Cost of goods sold |
$9,030,000 |
|
Ending inventory |
$1,100,000 |
(10130000-9030000) |
Estimated inventory on November 30:$1,100,000
Estimated loss during the period=$1,100,000-$367,250=$732,750
Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Cost Retail Celebrity Tan Co. Inventory, August 1 $ 260,000 $ 595,000 Transa...
Selected data on merchandise inventory, purchases, and sales for Celebrity Tan and Ranchworks Co. are as follows: Cost Retail Celebrity Tan Merchandise inventory, August 1 $223,000 $328,000 Transactions during August: Purchases (net) 2,565,000 3,772,000 Sales 3,880,000 Ranchworks Co. Merchandise inventory, March 1 $234,000 Transactions during March through November: Purchases (net) 3,104,000 Sales 4,705,000 Estimated gross profit rate 33% Required: 1. Determine the estimated cost of the merchandise inventory of Celebrity Tan on August 28 by the retail method, presenting details...
Retail Method; Gross Profit Method Selected data on merchandise inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: 1. Determine the estimated cost of the merchandise inventory of Celebrity Tan Co. on August 31 by the retail method. 2a. Estimate the cost of the merchandise inventory of Ranchworks Co. on November 30 by the gross profit method. 2b. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that $369,750 of merchandise...
2a. Estimate the cast of the inventory of Ranchworks Co. an Navember 30 by the gross profit method, presenting details of the computations. Far those boxes sign which yau must enter subtracted or negative numbers use a minus Ranchworks Co. Estimated Cost Inventory November 30 Csl 2b. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that $369,750 of inventory was on hand. What was the estimated loss of inventory due to theft or damage during...
2a. Estimate the cost of the inventory of Ranchworks Co. on November 30 by the gross profit method, presenting details of the computations. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Ranchworks Co. Estimated Cost of Inventory November 30 Cost Inventory, March 1 880,000 Net purchases 9,500,000 Merchandise available for sale 10,380,000 Sales 15,800,000 Estimated gross profit 6,004,000 Estimated cost of goods sold 9,796,000 x Estimated inventory, November 30 584,000 Retail method;...
Problem 17.5A Estimating inventory by the retail method. LO 17-5 The August 1 inventory of Hawkins Company had a cost of $81,000 and a retail value of $116,000. During August, merchandise was purchased for $97,710 and marked to sell for $143,000. August sales totaled $127,000. Required: 1. Compute the retail value of the ending inventory as of August 31. 2. Compute the approximate cost of the ending inventory 3. Compute the cost of goods sold during August. Analyze: What is...
Royal Gorge Company uses the gross profit method to estimate ending inventory and cost of goods sold when preparing monthly financial statements required by its bank. Inventory on hand at the end of October was $59,400. The following information for the month of November was available from company records: Purchases $ 119,000 Freight-in 3,900 Sales 225,000 Sales returns 9,500 Purchases returns 8,500 In addition, the controller is aware of $12,500 of inventory that was stolen during November from one of...
Irving inc 7. Radighieri inc. uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to a single department for the month of August 2018 Inventory, August 1. 2018 At cost $ 1.000 At retail $136.000 Purchases (exclusive of freight and returns) At cost $185.000 At retail $261.000 Freight-in 21,600 Purchase returns At cost $9.200 At retail $12,400 Markups $9,000 Markup cancellations $3,000 Markdowns (net) $16,600 Normal spoilage and breakage at retail...
Check my Problem 17.5A Estimating inventory by the retail method. LO 17-5 The August inventory of Hawkins Company had a cost of $71,000 and a retail value of $106.000. During August, merchandise was purchased for $93.910 and marked to sell for $133.000. August sales totaled $117.000 Required: 1. Compute the retail value of the ending Inventory as of August 31 2. Compute the approximate cost of the ending Inventory 3. Compute the cost of goods sold during August Analyte: What...
LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4 , using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column...
2) ) Beginning inventory, purchases, and sales for Item HM46 are as follows: August 1 Inventory 59 units @ $25 9 Sale 47 units 13 Purchase 42 units @ $28 28 Sale 19 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on August 28 and (b) the inventory on August 31. a. Cost of merchandise sold on August 28 b. Inventory on August 31 Beginning inventory, purchases, and...