A company has the following information in its records. Certain data have been intentionally omitted ($ in thousands). Required: Determine the missing numbers. Note: Enter all amounts as positive numbers. Enter your answers in thousands. Beginning inventory Cost of goods sold Ending inventory Cost of goods available for sale Purchases (gross) Purchase discounts Purchase returns Freight-in 2024 $ $ $ $ $ 69 $ 69 $ 69 69 $ 2025 290 $ 672 $ 636 279 $ 210 951 $ 915 664 30 45 47 $ 55 705 $ 33 $ 39 $ 28 2026 279 $ 210 $ 656 $ 189 69 $ $845 $ 660 $ 69 29 31

A company has the following information in its records. Certain data have been intentionally omitted ($ in thousands). Required: Determine the missing numbers. Note: Enter all amounts as positive numbers. Enter your answers in thousands. Beginning inventory Cost of goods sold Ending inventory Cost of goods available for sale Purchases (gross) Purchase discounts Purchase returns Freight-in 2024 $ $ $ $ $ 69 $ 69 $ 69 69 $ 2025 290 $ 672 $ 636 279 $ 210 951 $ 915 664 30 45 47 $ 55 705 $ 33 $ 39 $ 28 2026 279 $ 210 $ 656 $ 189 69 $ $845 $ 660 $ 69 29 31

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 3R: The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to...

See similar textbooks

Similar questions

A retailer returns $400 worth of inventory to a manufacturer and receives a full refund. What accounts recognize this return before the retailer remits payment to the manufacturer? A. accounts payable, merchandise inventory B. accounts payable, cash C. cash, merchandise inventory D. merchandise inventory, cost of goods sold
Perpetual and Periodic Inventory Systems Below is a list of inventory systems options. a. Perpetual inventory system b. Periodic inventory system c. Both perpetual and periodic inventory systems Required: Match each option with one of the following: 1. Only revenue is recorded as sales are made during the period; the cost of goods sold is recorded at the end of the period. 2. Cost of goods sold is determined as each sale is made. 3. Inventory purchases are recorded in an inventory account. 4. Inventory purchases are recorded in a purchases account. 5. Cost of goods sold is determined only at the end of the period by subtracting the cost of ending inventory from the cost of goods available for sale. 6. Both revenue and cost of goods sold are recorded during the period as sales are made. 7. The inventory is verified by a physical count.
Refer to the information for Morgan Inc. above. If Morgan uses a perpetual inventory system, what is the cost of ending inventory under FIFO at April 30? a. $32,500 b. $38,400 c. $63,600 d. $69,500
Use the last-in, first-out (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Information relating to inventory for Janie Par Gifts is provided below. Beginning merchandise inventory 120,000 Ending merchandise inventory 90,000 Purchases 250,000 1. Set up a spreadsheet similar to the one provided below. 2. Enter the appropriate information from above into the Trial Balance columns. 3. Prepare appropriate adjustments and extensions to the Adjusted Trial Balance columns.
The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?
The following data were extracted from the accounting records of Harkins Company for the year ended April 30, 2019: a. Prepare the cost of merchandise sold section of the income statement for the year ended April 30, 2019, using the periodic inventory system. b. Determine the gross profit to be reported on the income statement for the year ended April 30, 2019. c. Would gross profit be different if the perpetual inventory system was used instead of the periodic inventory system?
Consider each of the following independent situations. Should a company report the goods in its inventory? (a) Goods purchased by the company with shipping terms FOB shipping point that are in transit at the end of the year (b) Goods received by the company on consignment (c) An estimate of the amount of goods sold by the company that it expects the buyer to return (d) Goods required to be purchased by the company under an unconditional purchase obligation
The following are independent errors made by a company that uses the periodic inventory system: a. Goods in transit, purchased on credit and shipped FOB destination, 10,000, were included in purchases but not in the physical count of ending inventory. b. Purchase of a machine for 2,000 was expensed. The machine has a 4-year life, no residual value, and straight-line depreciation is used. c. Wages payable of 2,000 were not accrued. d. Payment of next years rent, 4,000, was recorded as rent expense. e. Allowance for doubtful accounts of 5,000 was not recorded. The company normally uses the aging method. f. Equipment with a book value of 70,000 and a fair value of 100,000 was sold at the beginning of the year. A 2-year, non-interest-bearing note for 129,960 was received and recorded at its face value, and a gain of 59,960 was recognized. No interest revenue was recorded and 14% is a fair rate of interest. Required: 1. Next Level Indicate the effect of each of the preceding errors on the companys assets, liabilities, shareholders equity, and net income in the year in which the error occurs. State whether the error causes an overstatement (+), an understatement (), or no effect (NE). 2. Prepare the correcting journal entry or entries required at the beginning of the year for each of the preceding errors, assuming the company discovers the error in the year after it was made. Ignore income taxes.
Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Using the information provided in RE8-4, prepare the journal entry to record the write-down of inventory for Paul Corporation assuming that it uses the allowance method instead of the direct method. Paul Corporation uses FIFO and reports the following inventory information: Assuming Paul uses a perpetual inventory system and the direct method, prepare the journal entry to record the write-down if inventory.
Kulsrud Company would like to estimate the current inventory level. Using the gross profit method and the following information, estimate the current inventory level for Kulsrud Company. Goods available for sale 100,000 Net sales 150,000 Normal gross profit as a percent of sales 40%