Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 16, Problem 3R
The following data pertain to 2012 activities of Twisp Industries:
Use your completed worksheet to determine the firmʼs 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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following select account data is taken from the records of Reese Industries for 2019.
A. Use the data provided to compute net sales for 2019.B. Prepare a simple income statement for the year ended December 31, 2019.C. Compute the gross margin for 2019.D. Prepare a multi-step income statement for the year ended December 31, 2019.
(The given is in the photo.)
Required:
1. SHOW THE COMPUTATION OF SM-X NET SALES REVENUE. COST OF GOODS SOLD AND GROSS PROFIT FOR THE YEAR ENDED DEC 31 2020
Please refer to the picture below for the information. Please show the complete solution and kinldy include label. Thank you so much.
Question 1: How much is the amount of "Cost of Goods Sold" to be reported in the 2015 Statement of comprehensive income assuming the company’s policy is to charge loss on inventory write-down to COST OF GOODS SOLD and charge loss on inventory write-down to OTHER EXPENSE, respectively.
Question 2: How much is the amount of "Cost of Goods Sold" to be reported in the 2016 Statement of comprehensive income?
Chapter 16 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Assume your company uses the periodic inventory costing method, and the inventory count left out an entire warehouse of goods that were in stock at the end of the year, with a cost value of $222,000. How will this affect your net income in the current year? How will it affect next years net income?arrow_forwardUSE THE BELOW INCOME STATEMENT AND INFORMATION TO ANSWER THE NEXT FOUR QUESTIONS AND COMPLETE THE INCOME STATEMENT. Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Interest Expenses Other Expenses Income before Taxes Income Tax Expenses Net Income ● ● MY Company Income Statement December 31, 2018 (Amounts in thousands) Use the following ratio data to complete FS Company's income statement. Inventory turnover is 4 (beginning inventory was $895: ending inventory was $758). Inventory turnover = cost of goods sold / Average inventory Rate of Return on Sales is 0.15 O $10,500 (a) $2,561 $458 (b) $554 $2,046 (c) (d)arrow_forwardPlease help me to answer this question and give explanations for each answer. Thank you very very much For each of the independent events listed below, analyze the impact on the indicated items at the end of the current year by placing the appropriate code letter in the box under each item. Code: O = item is overstated U = item is understated NA = item is not affected Events Items Assets Owner’s Equity Cost of Goods Sold Net Income 1. A physical count of goods on hand at the end of the current year resulted in some goods being counted twice. 2. The ending inventory in the previous period was overstated. 3. Goods purchased on account in December of the current year and shipped FOB shipping point were recorded as purchases, but were not included in the count of goods on hand on December 31 because they had not arrived by December 31.…arrow_forward
- The table shows the balances and transactions that ABC Company had during 2009. Using the information in the table, What would the company's inventory amount be on the December 31, 2009 balance sheet if the perpetual First-in, First-out method is used? (Answers are rounded to the nearest dollar.)arrow_forwardDebit $ 3,580 31,400 1,715 Credit Cash Merchandise inventory Store supplies Office supplies Prepaid insurance Store equipment Accumulated depreciation, store equipment Office equipment Accumulated depreciation, office equipment Accounts payable Zen Woodstock, capital Zen Woodstock, withdrawals Rental revenue 645 3,960 57,615 $ 6,750 13,100 6,550 4, 000 52, 000 31, 500 14,600 501,520 Sales Sales returns and allowances 2,915 5,190 331, 315 Sales discounts Purchases 2,140 4,725 Purchase returns and allowances Purchase discounts Transportation-in Sales salaries expense Rent expense, selling space Advertising expense Store supplies expense Depreciation expense, store equipment Office salaries expense Rent expense, office space Office supplies expense Insurance expense Depreciation expense, office equipment 3,690 34,710 24,080 6,400 27,630 13,000 Totals $592, 285 $592, 285 a. The balance on January 1, 2020, in the Store Supplies account was $480. During the year, $1,235 of store supplies…arrow_forwardBest Company had the following transactions in March 2020: Purchased merchandising amounting to P36,000. Terms, March 2 2/10, n/30 FOB Shipping Point. Paid freight bill amounting to P4,000. Returned P3,000 of the merchandise purchase on March March 5 2 because they were defective Sold merchandise on account for P10,000, Terms 3/15, March 8 n/30. The cost of merchandise sold was P6,000 March 10 Paid the purchase made on March 2 Received P2,.000 of merchandise sold on March 8. The March 12 cost of the merchandise returned was P1.200. March 22 Received cash from the March 8 sale.arrow_forward
- HACHING Company suspects that there is missing inventory in its warehouse at December 31, 2021. All sales and purchases were made on account. Also, the gross profit ratebased on net sales is consistent every year. To aid in your investigation, you obtained the following: How much is the net sales revenue for the year?arrow_forwardA condensed income statement for Weber Associates and a partially completed vertical analysis follow. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). 2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a minus sign. Round your answers to the nearest whole percent.) Net Revenues Cost of Goods Sold Research and Development Expense Sales and Marketing Expense General and Administrative Expense Income from Operations Other…arrow_forwardUse the following financial information to find the entry you would make on an income statement for COST OF GOODS SOLD for the year ended December 31, 2011: Gross Sales, $241,000; Sales Returns and Allowances, $5,600; Sales Discounts, $1,000; Merchandise Inventory, January 1, 2011, $62,500; Merchandise Inventory, December 31, 2011, $70,200; net purchases, $95,600; Freight In, $525; Salaries, $93,800; Rent, $17,900; Utilities, $1,325; Insurance, $2,025; and Income Tax, $16,950. O $38,200 $70,525 O $88,425 $234,400 Xarrow_forward
- Rockingham Communications reported the following figures in its annual financial statements: n to view the figures.) Question Viewer Compute the rate of inventory turnover and days' sales in inventory for Rockingham Communications. (Round to two decimal places.) Select the labels and enter the amounts to compute the inventory turnover. (Enter the amount for average inventory to one decimal place, X.X. Round your answer to two decimal places, X.XX.) Data table + Print ÷ Cost of Goods Sold Beginning Merchandise Inventory Ending Merchandise Inventory Done C…... $ 18,200 560 420 X = = Inventory turnover timesarrow_forwardCruz Company uses LIFO for inventory costing and reports the following financial data. It also recomputed inventory and cost of sold using FIFO for comparison purposes. LIFO inventory LIFO cost of goods sold FIFO inventory FIFO cost of goods sold Current assets (using LIFO) Current assets (using FIFO) Current liabilities 1. Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using (a) LIFO numbers and (b) FIFO number Current ratio Inventory turnover Days' sales in inventory Answer is not complete. (a) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using LIFO numbers. Current ratio Inventory turnover Days' sales in inventory Current ratio Inventory turnover Days' sales in inventory $ $ $ $ Year 2 $ 290 870 360 825 350 420 170 Numerator 1 Denominator 350.0 / $ $ 870.0 111.0 X $ $ $ Numerator 1 350.0 / (a) Compute its current ratio, inventory turnover, and days' sales in inventory for Year 2 using LIFO numbers.…arrow_forward1) Why is Cost of Goods Sold listed under revenues on the Income Statement if it is actually an expense?2) Does it have a credit or debit balance?3) What other if any statements does it appear on, and what accounts does it affect?I am providing a sample question and if you could help explain it I would appreciate it."ABC International has a beginning balance in its inventory asset account of $500,000. It buys $450,000 of materials from suppliers during the month. At month-end, it counts its ending inventory and determines that there is $200,000 of inventory on hand. The cost of goods sold journal entry is:"Debit CreditCost of Goods Sold $750,000Purchases $450,000Inventory $300,000"This entry matches the ending balance in the inventory account to the costed actual ending inventory, while…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Job Cost Sheet - Job Cost Accounting System; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=ElD8nKNXE1I;License: Standard Youtube License