Problems 20-3a problem 22-4a (excel solution)

PROBLEM 22-4A

Teller Co. sold 20,000 units of its only product and incurred a \$70,000 loss (ignoring taxes) for the current year as shown here. During a planning session for year 2010’s activities, the production manager notes that variable costs can be reduced 50% by installing a new machine that automates several operations. To obtain these savings, the company must increase its annual fixed costs by \$210,000. The maximum output capacity of the company is 40,000 units per year.

tELLER COMPANY

Contribution Margin Income Statement

For Year Ended December 31, 2009

Sales                              \$1,000,000

Variable costs                   800,000

Contribution margin       \$ 200,000

Fixed costs                        270,000

Net loss                         \$ (70,000)

Required

1. Compute the break-even point in dollar sales for year 2009.

2. Compute the break-even point in dollar sales for year 2010 assuming the machine is installed and there is no change in unit sales price.

3. Prepare a forecasted contribution margin income statement for 2010 that shows the expected results with the machine installed. Assume that the unit sales price and the number of units sold will not change and no income taxes.

4. Compute the sales level required in both dollars and units to earn \$210,000 of after-tax income in 2010 with the machine installed and no change in unit sales price. The income tax rate is 30%. (Hint: Use procedures in Exhibits 22.18 and 22.20.)

5. Prepare a forecasted contribution margin income statement that shows the results at the sales level computed in part (4). Assume an income tax rate of 30%.

Exhibits 22.18: Income relations in CVP Analysis

Sales

– Variable costs

Contribution margin

– Fixed costs

Income (pretax)

Book checks:

3. Net income, \$120,000

4. Required sales, \$1,300,000 or 26,000 units

5. Net income: \$210,000

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.