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%
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%
Chapter4A: Nopat Breakeven: Revenues Needed To Cover Total Operating Costs
Section: Chapter Questions
Problem 1EP
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 |
| 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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub