Consider the following partially completed income statements for merchandising companies and compute the missing amounts: (Click the icon to view the Income Statements.) Net Sales Revenue Cost of Goods Sold: Beginning Merchandise Inventory Purchases and Freight In Cost of Goods Available for Sale Ending Merchandise Inventory Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income $ $ Rustic Gear 101,000 52,000 (2,300) 64,000 37,000 15,000 $ Lee Supply 28,000 93,000 (2,300) 112,000 84,000

Consider the following partially completed income statements for merchandising companies and compute the missing amounts: (Click the icon to view the Income Statements.) Net Sales Revenue Cost of Goods Sold: Beginning Merchandise Inventory Purchases and Freight In Cost of Goods Available for Sale Ending Merchandise Inventory Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income $ $ Rustic Gear 101,000 52,000 (2,300) 64,000 37,000 15,000 $ Lee Supply 28,000 93,000 (2,300) 112,000 84,000

Name: Ee.63. Consider the following partially completed income statements fo
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Ee.63. Consider the following partially completed income statements for merchandising companies and compute the missing amounts:(Click the icon to view the Income Statements.)Net Sales RevenueCost of Goods Sold:Beginning Merchandise InventoryPurchase

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

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%
Selected data on merchandise inventory, purchases, and sales for Jaffe Co. and Coronado Co. are as follows: Instructions 1. Determine the estimated cost of the merchandise inventory of Jaffe Co. on February 28 by the retail method, presenting details of the computations. 2. a. Estimate the cost of the merchandise inventory of Coronado Co. on October 31 by the gross profit method, presenting details of the computations. b. Assume that Coronado Co. took a physical inventory on October 31 and discovered that 366,500 of merchandise was on hand. What was the estimated loss of inventory due to theft or damage during May through October?
Selected data on merchandise inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks Co. are as follows: Instructions 1. Determine the estimated cost of the merchandise inventory of Celebrity Tan Co. on August 31 by the retail method, presenting details of the computations. 2. a. Estimate the cost of the merchandise inventory of Ranchworks Co. on November 30 by the gross profit method, presenting details of the computations. b. Assume that Ranchworks Co. took a physical inventory on November 30 and discovered that 369,750 of merchandise was on hand. What was the estimated loss of inventory due to theft or damage during March through November?
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.
Use the weighted-average (AVG) 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.
Calculate the cost of goods sold dollar value for B74 Company for the sale on November 20, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for (a) first-in, first-out (FIFO); (b) last-in, first-out (LIFO); and (c) weighted average (AVG).
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?
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 first-in, first-out (FIFO).
The following information is available for Cooke Company for the current year: The gross margin is 40% of net sales. What is the cost of goods available for sale? a. 5840,000 b. 960,000 c. 1,200,000 d. 1,220,000
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 weighted average (AVG).
Analyzing the Accounts Casey Company uses a perpetual inventory system and engaged in the following transactions: a. Made credit sales of $825,000. The cost of the merchandise sold was $560,000. b. Collected accounts receivable in the amount of $752,600. c. Purchased goods on credit in the amount of $574,300. d. Paid accounts payable in the amount of $536,200. Required: Prepare the journal entries necessary to record the transactions. Indicate whether each transaction increased cash, decreased cash, or had no effect on cash.