1.    Using the Goal Seek Tool find the Net Income breakeven point        for both years changing the units sold   while price remains fixed at $25.00 2.     Using the Goal Seek Tool find the price each year that creates an income            1200 in 2018 and 2019 holding sales at 3500 units      2018 2019 Total Revenue 61436 63644 Cost of Goods Sold 46077 47733 Gross Profit 15359 15911 General & Admin 12,884 13,411 Depreciation 1250 1,250 Rent 650 650 Operating Expenses 14,784 15,311 EBIT 575 600 Interest Expense 575 600 Earnings Before Taxes 0 0 Income Tax Expense 0 0 Net Income 0 0       Units Sold 2,457 2,546 Price 25.00 25.00 Tax Rate 40.0% 40.0% Cost of Good Sold 75.0% 75.0%

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

1.    Using the Goal Seek Tool find the Net Income breakeven point

       for both years changing the units sold   while price remains fixed at $25.00

2.     Using the Goal Seek Tool find the price each year that creates an income   

        1200 in 2018 and 2019 holding sales at 3500 units   

  2018 2019
Total Revenue 61436 63644
Cost of Goods Sold 46077 47733
Gross Profit 15359 15911
General & Admin 12,884 13,411
Depreciation 1250 1,250
Rent 650 650
Operating Expenses 14,784 15,311
EBIT 575 600
Interest Expense 575 600
Earnings Before Taxes 0 0
Income Tax Expense 0 0
Net Income 0 0
     
Units Sold 2,457 2,546
Price 25.00 25.00
Tax Rate 40.0% 40.0%
Cost of Good Sold 75.0% 75.0%
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Break-even Analysis
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
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