Whitman Corporation, a merchandising company, reported sales of 7,400 units for May at a selling price of P 677 per unit. The cost of goods sold (all variable) was P 441 per unit and the variable selling expense was P 54 per unit. The total fixed selling expense was P 155,600. The variable administrative expense was P 24 per unit and the total fixed administrative expense was P 370,400. Prepare a traditional format and contribution format income statement for May. You may use the excel file in the practice sheet.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
100%

Whitman Corporation, a merchandising company, reported sales of 7,400 units for May at a selling price of P 677 per unit. The cost of goods sold (all variable) was P 441 per unit and the variable selling expense was P 54 per unit. The total fixed selling expense was P 155,600. The variable administrative expense was P 24 per unit and the total fixed administrative expense was P 370,400. Prepare a traditional format and contribution format income statement for May. You may use the excel file in the practice sheet.

 

Please see the attatched photo for reference. 

Chapter 1: Applying Excel
Data
Sales
$12,000
Variable costs:
Cost of goods sold
Variable selling
Variable administrative
$6,000
$600
$400
Fixed costs:
Fixed selling
$2,500
Fixed administrative
$1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-9
Traditional Format Income Statement
$ 12,000
6,000
6,000
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses:
Selling
Administrative
2$
3,100
1,900
5,000
$ 1,000
Net operating income
Contribution Format Income Statement
Sales
$ 12,000
Variable expenses:
Cost of goods sold
Variable selling
2$
6,000
600
Variable administration
400
7,000
5,000
Contribution margin
Fixed expenses:
Fixed selling
2,500
Fixed administrative
1,500
4,000
$ 1,000
Net operating income
Transcribed Image Text:Chapter 1: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling Variable administrative $6,000 $600 $400 Fixed costs: Fixed selling $2,500 Fixed administrative $1,500 Enter a formula into each of the cells marked with a ? below Exhibit 2-9 Traditional Format Income Statement $ 12,000 6,000 6,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling Administrative 2$ 3,100 1,900 5,000 $ 1,000 Net operating income Contribution Format Income Statement Sales $ 12,000 Variable expenses: Cost of goods sold Variable selling 2$ 6,000 600 Variable administration 400 7,000 5,000 Contribution margin Fixed expenses: Fixed selling 2,500 Fixed administrative 1,500 4,000 $ 1,000 Net operating income
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education