Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 19, Problem 1R

The records of Anderjak Corporation contain the following information for the month of January:

Chapter 19, Problem 1R, The records of Anderjak Corporation contain the following information for the month of January:

The

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
Check Mark
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
ParticularsAmount ($)Amount ($)
Sales 80,000×$30 $ 2,400,000
Cost of goods sold:  
     Beginning inventory cost$ 266,875  
     Variable manufacturing costs 70,000×$14980,000 
     Fixed manufacturing costs315,000 
     Total goods available for sale$ 1,561,875  
     Less: ending inventory =$1,561,87515,000+70,000×15,000+70,00080,000=18.375×5,00091,875 
          Cost of goods sold 1,470,000
Gross profit $ 930,000
Selling expenses:  
     Fixed selling expenses$ 100,000  
     Variable selling expenses80,000×$2160,000 
          Total selling expenses 260,000
Operating income $ 670,000

Table (1)

Prepare a income statement using variable costing:

Income statement
Variable costing
ParticularsAmount ($)Amount ($)
Sales $ 2,400,000
Cost of goods sold:  
     Beginning inventory cost$ 210,000  
     Variable manufacturing costs 70,000×$14980,000 
     Total goods available for sale$ 1,190,000  
     Less: ending inventory=$1,190,00015,000+70,000×15,000+70,00080,000=14×5,00070,000 
          Variable cost of goods sold 1,120,000
Manufacturing margin $ 1,280,000
Variable selling expenses 80,000×$2 160,000
Contribution margin $ 1,120,000
Fixed costs:  
     Fixed manufacturing costs$ 315,000  
     Fixed selling expenses100,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?
Knowledge Booster
Background pattern image
Accounting
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Text book image
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