Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 19, Problem 1R
The records of Anderjak Corporation contain the following information for the month of January:
The company has no beginning inventory.
REQUIREMENT
You have been asked to prepare a variable costing (direct costing) income statement and an absorption costing income statement for the month of January. Review the worksheet VARCOST that follows these requirements.
Expert Solution & Answer
To determine
Prepare a income statement for january by using variable costing and absorption costing method.
Explanation of Solution
Prepare a income statement using absorption costing:
Income statement | ||
Absorption costing | ||
Particulars | Amount ($) | Amount ($) |
Sales | $ 2,400,000 | |
Cost of goods sold: | ||
Beginning inventory cost | $ 266,875 | |
Variable manufacturing costs | 980,000 | |
Fixed manufacturing costs | 315,000 | |
Total goods available for sale | $ 1,561,875 | |
Less: ending inventory | 91,875 | |
Cost of goods sold | 1,470,000 | |
Gross profit | $ 930,000 | |
Selling expenses: | ||
Fixed selling expenses | $ 100,000 | |
Variable selling expenses | 160,000 | |
Total selling expenses | 260,000 | |
Operating income | $ 670,000 |
Table (1)
Prepare a income statement using variable costing:
Income statement | ||
Variable costing | ||
Particulars | Amount ($) | Amount ($) |
Sales | $ 2,400,000 | |
Cost of goods sold: | ||
Beginning inventory cost | $ 210,000 | |
Variable manufacturing costs | 980,000 | |
Total goods available for sale | $ 1,190,000 | |
Less: ending inventory | 70,000 | |
Variable cost of goods sold | 1,120,000 | |
Manufacturing margin | $ 1,280,000 | |
Variable selling expenses | 160,000 | |
Contribution margin | $ 1,120,000 | |
Fixed costs: | ||
Fixed manufacturing costs | $ 315,000 | |
Fixed selling expenses | 100,000 | |
Total fixed costs | $ 415,000 | |
Operating income | $ 705,000 |
Table (2)
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
As an accountant for Lee Company, your supervisor gave you the following calculations of the gross profit for the first quarter:
Prepare schedules computing the ending inventory ( in units and dollars) and proving the cost of goods sold shown here under each of the three alternatives.
MNO Manufacturing Company which uses the periodic inventory system showed the following transactions during the month of May: (round-off to the nearest peso)
1. . WHAT IS THE COST OF THE UNITS ISSUED UNDER THE FIFO COSTING METHOD?
SOLUTIONS MUST BE IN GOOD ACCOUNTING FORM. EXCEL FORM WILL ALSO BE GREAT
MNO Manufacturing Company which uses the periodic inventory system showed the following transactions during the month of May: (round-off to the nearest peso)
Using the data in No. 9, what is the cost of the units issued under the FIFO costing method?
Chapter 19 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
- Presented below is information related to Blowfish radios for the Hootie Company for the month of July. Check below image for information Instructions(a) Assuming that the periodic inventory method is used, compute the inventory cost at July 31 under each of the following cost flow assumptions.(1) FIFO.(2) LIFO.(3) Weighted-average.(b) Answer the following questions.(1) Which of the methods used above will yield the lowest figure for gross profit for the income statement? Explain why.(2) Which of the methods used above will yield the lowest figure for ending inventory for the balance sheet? Explain why.arrow_forwardThe following data are taken from the general ledger and other records of Coral Park Production Co. on January 31, the end of the first month of operations in the current fiscal year: a. Prepare a statement of cost of goods manufactured. b. Prepare the cost of goods sold section of the income statement.arrow_forwardTrini Company had the following transactions for the month. Calculate the cost of goods sold dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forward
- Prepare an income statement of Mary's manufacturers the year ended 31 December using the: 1. Marginal costing method. 2. Absorption costing method.arrow_forwardUse the following information for the next two questions: Thursday Co. is estimating the cost of its inventory at month-end. The accountant determined the following:arrow_forwardThe following balances appeared in the inventory accounts of Forest Components for July. Materials Inventory Work-in-Process Inventory Finished Goods Inventory Beginning Ending $12,480 10,600 7,100 73,800 $2,800 Cost of Goods Sold Required: a. Prepare journal entries to record these transactions. b. Prepare T-accounts to show the flow of costs during the period from Materials Inventory through Cost of Goods Sold. Complete this question by entering your answers in the tabs below. Required A Required B Prepare journal entries to record these transactions. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet C D G H A B E F Purchased $16,990 of materials on account. Note: Enter debits before credits. Debit Credit General Journal Transactionarrow_forward
- During the first month of operations ended August 31, Kodiak Fridgeration Company manufactured 45,000 mini refrigerators, of which 42,000 were sold Operating data for the month are summarized as follows Sales Manufacturing costs; Direct materials 4 Direct labor 1 Variable manufacturing cost Fixed manufacturing cost 7 Selling and administrative expenses Variable Fixed $5,220,000.00 1,380,000.00 828.000.00 506,000.00 $756,000.00 294,000.00 $9,660,000.00 5,954,000.00 1,050,000.00arrow_forwardMcCracken Aerial, Inc., produces and sells a unique type of TV antenna. The company has just opened a new plant to manufacture the antenna, and the following cost and revenue data have been provided for the first month of the plant's operation in the form of a worksheet. Beginning inventory. Units produced 80,000 Units sold 70,000 Selling price per unit Selling and administrative expenses: $30 Variable per unit .. Fixed (total) ... $1 $160,000 Manufacturing costs Direct materials cost per unit $10 Direct labor cost per unit ... Variable manufacturing overhead cost per unit. Fixed manufacturing overhead cost (total) . $4 $2 $640,000arrow_forwardCost of Materials Issuances Under the FIFO Method An incomplete subsidiary ledger of materials inventory for May is as follows: a. Complete the materials isuances and balances for the materials subsidiary ledger under FIFO. Received Issued Balance Receiving Materials Unit Unit Report Quantity Requisition Quantity Amount Date Quantity Amount Price price Number Number May 1 260 $8 $2,080 25 $10 260 V 2,080 V 180 May 4 180 V 10 V 1,800 103 290 May 10 10 V 31 120 12 May 21 10 V 12 V 116 170 May 27 12 Feedback V Check My Work a. Calculate the amount of each materials issue, using FIFO. In the Balance section, separate each different unit price and its quantity. b. Determine the materials inventory balance at the end of May. Feedback V Check My Work b. Calculate the amount of each materials issue, using FIFO. In the Balance section, separate each different unit price and its quantity.arrow_forward
- Please show your computations through excel. d. Using AVERAGE method, compute for the cost of goods sold assuming there was no beginning or ending inventory of finished goods for the month.arrow_forwardNevens Company uses a periodic inventory system. During November, the following transactions occurred: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions: a. FIFO b. LIFO c. Average cost 2. Next Level What can you conclude about the effects of the inventory cost flow assumptions on the financial statements?arrow_forwardBalamb Corporation had the following transactions for the month: Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. first-in, first-out (FIFO) last-in, first-out (LIFO) weighted averagearrow_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 Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY