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 inventoryCost of goods soldEnding inventoryCost of goods available for salePurchases (gross)Purchase discountsPurchase returnsFreight-in202420252026$ 225EA$681$ 639$ 225$ 195EAEA966$ 854$720$ 675$SASA36 $33$4248$ 323150$34

Cost of goods sold is the cost of units sold during the period. It is the difference between cost…

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. 2024 2025 2026 Beginning inventory $ 225 Cost of goods sold $ 681 $ 639 Ending inventory $ 225 $ 195 Cost of goods available for sale $ 966 $ 854 Purchases (gross) $ 720 $ 675 Purchase discounts $ 36 $ 33 Purchase returns Freight-in $ 42 $ 48 $ 32 $ 31 $ 50 $ 34

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. 2024 2025 2026 Beginning inventory $ 225 Cost of goods sold $ 681 $ 639 Ending inventory $ 225 $ 195 Cost of goods available for sale $ 966 $ 854 Purchases (gross) $ 720 $ 675 Purchase discounts $ 36 $ 33 Purchase returns Freight-in $ 42 $ 48 $ 32 $ 31 $ 50 $ 34

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

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.
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.
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
Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
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.
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.
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?
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.
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
Lower of Cost or Market Merediths Appliance Store has the following data for the items in its inventory at the end of the accounting period: Required: 1. Compute the carrying value of Merediths ending inventory using the lower of cost or market rule applied on an item-by-item basis. 2. Prepare the journal entry required to value the inventory at lower of cost or market. 3. CONCEPTUAL CONNECTION What is the conceptual justification for valuing inventory at the lower of cost or market?
Lower of Cost or Market Garcia Company uses FIFO, and its inventory at the end of the year was recorded in the accounting records at $17,800. Due to technological changes in the market, Garcia would be able to replace its inventory for $16,500. Required: 1. Using the lower of cost or market method, what amount should Garcia report for inventory on its balance sheet at the end of the year? 2. Prepare the journal entry required to value the inventory at the lower of cost or market.