C) Going back to the original data, the team speculates that they might be able to achieve profitability without changing the sales price if they were to reduce the cost of materials used in manufacture. If the direct materials cost were reduced by eighty cents per unit, how many units would have to be sold i) to break even? ii) to earn a profit of $25,000? D) Again with original data, the team speculates that the problem might lie in inadequate promotion. They want to know by how much they could increase advertising and still allow the company to earn a target profit of 5% of sales on sales of 60,000 units.

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
C) Going back to the original data, the team speculates that they might be able to achieve profitability without changing the sales price if they were to reduce the cost
of materials used in manufacture. If the direct materials cost were reduced by eighty cents per unit, how many units would have to be sold
i) to break even?
ii) to earn a profit of $25,000?
D) Again with original data, the team speculates that the problem might lie in inadequate promotion. They want to know by how much they could increase advertising
and still allow the company to earn a target profit of 5% of sales on sales of 60,000 units.
Transcribed Image Text:C) Going back to the original data, the team speculates that they might be able to achieve profitability without changing the sales price if they were to reduce the cost of materials used in manufacture. If the direct materials cost were reduced by eighty cents per unit, how many units would have to be sold i) to break even? ii) to earn a profit of $25,000? D) Again with original data, the team speculates that the problem might lie in inadequate promotion. They want to know by how much they could increase advertising and still allow the company to earn a target profit of 5% of sales on sales of 60,000 units.
On these Excel sheets, you will need to prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget.
The cells will be checked for appropriate formulas, when appropriate. Please highlight the specific answer to the question being posed.
Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take
next year to reach profitability. They begin by reviewing the most recent income statement (below).
Sales (45,000 units at $15)
Less cost of goods sold:
Gross margin
Less operating expenses
Net loss
Direct materials
Direct labor
Manufacturing overhead
Carolina Manufacturing Company
Income Statement
For the Year Ended December 31
Selling expenses
Variable
Sales commissi
Shipping
Fixed (advertisi
Administrative expenses
Variable (billing
Fixed (salaries
135,000
117,450
147,750
40,500
8,100
180,000
2,700
72.000
$675,000
400,200
274,800
228,600
74,700
($28,500)
All variable expenses vary with the number of units sold, except for sales commissions, which are based on a percentage of sales dollars. Variable manufacturing
overhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year.
Transcribed Image Text:On these Excel sheets, you will need to prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget. The cells will be checked for appropriate formulas, when appropriate. Please highlight the specific answer to the question being posed. Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take next year to reach profitability. They begin by reviewing the most recent income statement (below). Sales (45,000 units at $15) Less cost of goods sold: Gross margin Less operating expenses Net loss Direct materials Direct labor Manufacturing overhead Carolina Manufacturing Company Income Statement For the Year Ended December 31 Selling expenses Variable Sales commissi Shipping Fixed (advertisi Administrative expenses Variable (billing Fixed (salaries 135,000 117,450 147,750 40,500 8,100 180,000 2,700 72.000 $675,000 400,200 274,800 228,600 74,700 ($28,500) All variable expenses vary with the number of units sold, except for sales commissions, which are based on a percentage of sales dollars. Variable manufacturing overhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting systems
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