Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Retail Celebrity Tan Co. Inventory, August 1 Transactions during August: Purchases (net) Sales Ranchworks Co. Inventory, March 1 Transactions during March through November: Purchases (net) Sales Estimated gross profit rate Required: Cost $300,000 $575,000 2,021,900 3,170,000 3,250,000 $880,000 9,500,000 15,800,000 38% 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method, presenting details of the computations. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Selected data on inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Retail Celebrity Tan Co. Inventory, August 1 Transactions during August: Purchases (net) Sales Ranchworks Co. Inventory, March 1 Transactions during March through November: Purchases (net) Sales Estimated gross profit rate Required: Cost $300,000 $575,000 2,021,900 3,170,000 3,250,000 $880,000 9,500,000 15,800,000 38% 1. Determine the estimated cost of the inventory of Celebrity Tan Co. on August 31 by the retail method, presenting details of the computations. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Numberof Units Per Unit Total Apr. 3 Inventory 90 $450 $40,500 8 Purchase 180 540 97,200 11 Sale 121 1,500 181,500 30 Sale 76 1,500 114,000 May 8 Purchase 150 600 90,000 10 Sale 90 1,500 135,000 19 Sale 45 1,500 67,500 28 Purchase 150 660 99,000 June 5 Sale 90 1,575 141,750 16 Sale 120 1,575 189,000 21 Purchase 270 720 194,400 28 Sale 135 1,575 212,625 Required: 1. Record the inventory, purchases, and cost of merchandise 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 Merchandise Sold Unit Cost column and…
Please make a weighted average- perpetual chart
Generalized Statement Instructions Instructions Multiple-Step Income Statement Use the following information to prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Sauter Office Supplies for the year ended December 31, 20-. Sales $156,300 Sales Returns and Allowances 2,360 Sales Discounts 4,167 Interest Revenue 425 Merchandise Inventory, January 1, 20- 29,600 Purchases 112,000 Purchases Returns and Allowances 5,640 Purchases Discounts 2,690 Freight-In Merchandise Inventory, December 31, 20-- 875 33,000 Wages Expense 27,600 Supplies Expense 700 Phone Expense 900 Utilities Expense 8,000 Insurance Expense 1,300 Depreciation Expense-Equipment Miscellaneous Expense 3,800 590 Interest Expense 4,700 H
Multiple-Step Income Statement Use the following information to prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Sauter Office Supplies for the year ended December 31, 20--. Sales $159,700 Sales Returns and Allowances 2,070 Sales Discounts 4,171 Interest Revenue 424 Merchandise Inventory, January 1, 20-- 27,500 Estimated Returns Inventory, January 1, 20-- 500 Purchases 110,000 Purchases Returns and Allowances 4,540 Purchases Discounts 2,710 Freight-In 885 Merchandise Inventory, December 31, 20-- 33,900 Estimated Returns Inventory, December 31, 20-- 1,100 Wages Expense 27,000 Supplies Expense 800 Phone Expense 900 Utilities Expense 7,000 Insurance Expense 1,200 Depreciation Expense—Equipment 3,900 Miscellaneous Expense 590 Interest Expense 4,600
Multiple-Step Income Statement Use the following information to prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Sauter Office Supplies for the year ended December 31, 20--. Sales $160,000 Sales Returns and Allowances 2,300 Sales Discounts 4,175 Interest Revenue 425 Merchandise Inventory, January 1, 20-- 28,400 Estimated Returns Inventory, January 1, 20-- 600 Purchases 109,000 Purchases Returns and Allowances 4,560 Purchases Discounts 2,670 Freight-In 895 Merchandise Inventory, December 31, 20-- 30,100 Estimated Returns Inventory, December 31, 20-- 900 Wages Expense 27,400 Supplies Expense 800 Phone Expense 800 Utilities Expense 8,000 Insurance Expense 1,200 Depreciation Expense—Equipment 3,900 Miscellaneous Expense 590 Interest Expense 4,700 Sauter Office Supplies Income Statement For Year Ended December 31, 20-- Revenue from sales: $ $…
ces Montoure Company uses a periodic inventory system. It entered into the following calendar-year purchases and sales transactions. Date Activities January 1 Beginning inventory February 10 Purchase March 13 Purchase March 15 Sales August 21 Purchase September 5 Purchase September 10 Sales Totals Units Acquired at Cost Units Sold at Retail 685 units @$45.00 per unit 570 units @ $42.00 per unit 285 units @ $27.00 per unit 1,140 units @ $75.00 per unit 185 units 585 units @ $50.00 per unit @ $46.00 per unit 2,310 units 770 units @ $75.00 per unit 1,910 units Required: 1. Compute cost of goods available for sale and the number of units available for sale. Cost of goods available for sale Number of units available for sale 2. Compute the number of units in ending inventory. Ending inventory units units
The following information applies to the questions displayed below; Hemming Company reported the following current-year purchases and sales for its only product. Date Activities January 1 Beginning inventory January 10 Sales March 14 Purchase March 15 Sales- July 30 Purchase October S October 26 Sales Purchase Totals 275 units 450 units 475 units Units Acquired at Cost $13.00- $18.00 $23.00- Units Sold at Retail $3,575 230 units $43.00 8,100 10,925 408 units 455 units $43.00 $43.00 175 units 1,375 units @$28.90 4,900 $ 27,500 1,885 units Hemming uses a periodic inventory system. (a) Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. (b) Determine the costs assigned to ending inventory and to cost of goods sold using LIFO. (c) Compute the gross profit for each method. a) Periodic FIFO Beginning inventory Purchases March 14 July 30 October 28 Total b) Periodio LIFO Beginning inventory Purchases: Cost of Goods Available for Sale Cost of Goods Sold…
Calculate the cost of goods sold dollar value for B65 Company for the month, considering the following transactions under first-in, first-out (FIFO) cost allocation methods and using perpetual inventory. Beginning inventory Purchased Sold Sold Ending inventory $6,000 $0 $4,950 $3,000 Number of Units 100 80 50 25 105 Unit Cost $66 75. Sales $120 125
During the year, TRC Corporation has the following inventory transactions. Date Jan. 1 Beginning inventory Apr. 7 Purchase Jul.16 Purchase Oct. 6 Purchase Weighted Average Cost Total Beginning Inventory Purchases: Apr 07 Jul 16 Oct 06 Transaction Sales revenue Gross profit For the entire year, the company sells 450 units of inventory for $70 each. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 2 decimal places and all other answers to the nearest whole number.) Number of Units 60 140 210 120 530 Cost of Goods Available for Sale # of units 60 140 210 120 530 Average Cost per unit Cost of Goods Available for Sale $ $ Unit Cost 3,120 $ 52 54 57 58 7,560 11,970 6.960 29,610 Total Cost $ 3,120 7,560 11,970 6,960 $29,610 Cost of Goods Sold - Weighted Average Cost of units Sold Average Cost of Cost per Unit Goods Sold Ending Inventory - Weighted Average Cost # of units in Ending Inventory…
weighted average
3
Inventory - Perpetual Moving Weighted Average The following information was available from the inventory records of the Bean Company for January: Balance at January 1 Purchases: January 6 January 26 Sales (at $15/unit): January 7 January 31 Balance at January 31 Units 2,000 3,000 2,700 (2,500) (3,500) 1,700 Unit Cost $9.77 10.30 10.71 Total Cost $19,540 30,900 28,917 Assuming that Bean uses a perpetual moving weighted average system, record the entry/entries needed on January 31. Keep unit costs to 3 decimals.