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
The cost accountant for Sunset Fashions has compiled the following information for last quarter's operations:
Administrative costs
Merchandise inventory, April 1
Merchandise inventory, June 30
Merchandise purchases
Miscellaneous store costs
Sales commissions
Sales revenue
Store lease
Utilities
Transportation-in costs
Wages and benefits
Required:
1. Prepare a cost of goods sold statement.
2. Prepare an income statement.
Complete this question by entering your answers in the tabs below.
Required 1 Required 2
Prepare an income statement.
SUNSET FASHIONS
Income Statement
For the Quarter Ended June 30
Sales revenue
Cost of goods sold
Gross margin
Store rent
Operating loss
$
$
$ 232,000
55,000
45,500
1,790,000
23,400
134,400
3,126,000
53,000
57,900
124,400
770,000
$
3,126,000
1,923,900
1,202,100
53,000
68,400
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.
The 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
Transaction
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
- The 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_forwardThe following data are taken from the general ledger and other records of Phoenix Products Co. on October 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
- Accounting records for Antoinette Designs (AD) for November show the following (each entry is the total of the actual entries for the account for the month): Account Titles Work-in-Process Inventory (Direct Labor) Wages Payable Direct Materials Inventory Accounts Payable Finished Goods Inventory Work-in-Process Inventory Cost of Goods Solda Finished Goods Inventory Debit 7,200 122,130 136,800 131,400 Credit 7,200 Required: a. What was the finished goods inventory balance on November 30? b. How much manufacturing overhead was applied for November? c. What was the manufacturing overhead rate for November? d. How much manufacturing overhead was incurred for November? e. What was the Work-in-Process Inventory on November 1? f. What was the Work-in-Process Inventory on November 30? 122,130 136,800 131,400 aThis entry does not include any over- or underapplied overhead. Over- or underapplied overhead is written off to Cost of Goods Sold once for the month. For November, the amount written…arrow_forwardPlease assist with the remaining questions: e) What is the balance in the Cost of Goods Sold account after the adjustment? f) Compute Elite's gross profit earned on the jobs sold, after adjusting for the manufacturing overhead variance. g) Post the appropriate entries to Work in Process Inventory account and determine the account balance on March 31 (end of the quarter).arrow_forwardFor product costs associated with a product to be reported on the income statement: Multiple Choice The product may be in any of the manufacturer's inventory accounts. The product must be sold. The company must expect to sell the product during the next twelve months. The product must still be in Work in Process Inventory. The product must be transferred to Finished Goods Inventory.arrow_forward
- Cost 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_forwardWhat is the balance in the Cost of Goods Sold account after the adjustment? 2.Post the appropriate entries to Work in Process Inventory Control account & determine the account balance on January 31, the end of the month. 3.arrow_forwardDo not give answer in imagearrow_forward
- Compute the Cost of Goods Sold and Operating Profit Margin by using the information stated abovearrow_forward1 Kim's Asphalt does driveway and parking lot resurfacing work for large commercial clients as well as small residential clients. An inventory of materials and equipment is on hand at all times so that work can start as quickly as possible. Special equipment is ordered as required. On May 1, the Materials and Equipment Inventory account had a balance of $44.000. The Work-in-Process Inventory account is maintained to record costs of work not yet complete. There were two such jobs on May 1 with the following costs. Job 27 Job 33 Highlands Mal1 $16,575 14,300 4,290 Pine Ridge Estates $ 53,300 26,658 7,995 Materials and equipment Direct labor Overhead (applied) Overhead has been applied at 30 percent of the costs of direct labor. During May, Kim's Asphalt started two new jobs. Additional work was carried out on Jobs 27 and 33. with the latter completed and billed to Pine Ridge Estates. Details on the costs incurred on jobs during May follow. Job Materials and equipment Direct labor (wages…arrow_forwardDonald Reagan Consulting Company had the following transactions completed during the month of December. Note: You must determine the cost of the goods based on a Perpetual, FIFO inventory system. DR began the month with 2,139 units of inventory that had the following purchase dates, costs, and units: * November 20, $11.99/unit, 129 units * November 30, $12.08/unit, 2010 units Using the following transactions, record journal entries for The DR Consulting Company. December 1 The company declared a cash dividend of $3,400 to stockholders' of record on December 16. The cash dividend will be paid on December 30. December 3 The company sold equipment that had an original cost of $19,900 with accumulated depreciation of $15,000. DR received $1,000 of cash and signed a note receivable for $3,200. December 5 DR purchased 1,000 units of inventory for $12.10 per unit with terms 2/5, n/20. December 7 DR sold 1,110 of the units in inventory for $23.00 per unit to Todd Red's with terms 1/10,…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 Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
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
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY