Question
In: Accounting
Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000...
Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000 0.24 $1,350,000 $1,150,000 Fixed Costs Selling $500,000 Administrative $485,000 Manufacturing Overhead $150,000 $1,135,000 Profit Dollars Percentage Calculate the Contribution Margin Calculate the Gross Margin Ratio Calculate Breakeven Sales Calculate Margin of Safety based on the 5% expected sales increase.
| Income Statement | Projected Income Statement | ||||||
| Sales Revenue | $2,500,000 | ||||||
| Variable Costs | |||||||
| Purchases | $750,000 | 0.3 | |||||
| Direct labor | $600,000 | 0.24 | $1,350,000 | ||||
| $1,150,000 | |||||||
| Fixed Costs | |||||||
| Selling | $500,000 | ||||||
| Administrative | $485,000 | ||||||
| Manufacturing Overhead | $150,000 | $1,135,000 | |||||
| Profit | |||||||
| Dollars | Percentage | ||||||
| Calculate the Contribution Margin | |||||||
| Calculate the Gross Margin Ratio | |||||||
| Calculate Breakeven Sales | |||||||
| Calculate Margin of Safety based on the 5% expected sales increase. | |||||||
Solutions
Expert Solution
| Income Statement | Projected Income Statement | |
| Sales Revenu (a) | $2,500,000 | $2,625,000 |
| (2500000*1.05) | ||
| Les: Variable cost | ||
| Purchase (30% X a) | $750,000 | $787,500 |
| Direct Material (24%*a) | $600,000 | $630,000 |
| Total Variable cost (b) | $1,350,000 | $1,417,500 |
| Contribution Margin (c= a-b) | $1,150,000 | $1,207,500 |
| Less: Fixed Cost (d) | ||
| Selling | $500,000 | $500,000 |
| Administrative | $485,000 | $485,000 |
| Manufacturing OH | $150,000 | $150,000 |
| Total Fixed Oh | $1,135,000 | $1,135,000 |
| Profit (e=c-d) | $15,000 | $72,500 |
| Contribution Margin Ratio= Contribution / Sales |
| Projected |
| = 1207500/2625000= 46% |
| Contribution Margin Dollar:= $1207500 |
| Original |
| =1150000/2500000= 46% |
| Contribution Margin Dollar:= $1150000 |
| Gross Margin Ratio= Gross Profir / Sales |
| Projected |
| 1057500/2625000= 40.29% |
| Gross Profit= Sales- Variable Cost- Manufacturing Overhead |
| =2625000-1417500-150000= 1057500 |
| Original |
| 1000000/2500000= 40% |
| Gross Profit= Sales- Variable Cost- Manufacturing Overhead |
| =2500000-1350000-150000= $1000000 |
| Projected |
| BreakEven Sales (in $)= Fixed Cost/ CM Ratio |
| =1135000/ 46%= 2467391 |
| Break Even Sales %= Breakeven Sales/ Total Sales |
| =2467391.304/2625000= 94% |
| Original |
| BreakEven Sales (in $)= Fixed Cost/ CM Ratio |
| =1135000/ 46%= 2467391 |
| Break Even Sales %= Breakeven Sales/ Total Sales |
| =2467391.304/250000= 98.70% |
| Margin of Safety |
| Total Sales- BEP Sales |
| =2625000-2467391.304= $157608.69 |
ekkarill92 answered 10 months agoRelated Solutions
Using the income statement below compute the following items. Sales $1,250,000 25 Variable costs 750,000 15...
Using the income statement below compute the following
items.
Sales
$1,250,000
25
Variable costs
750,000
15
Contribution margin
500,000
10
40%
Fixed operating costs
200,000
Earnings before interest and taxes
300,000
Interest
125,000
Earnings before taxes
175,000
Taxes (30%)
52,500
Net income
$122,500
Note: The company made and sold 50,000 units this year
Required: Record the answers in the designated spots
below. Round to the dollar, do not record the dollar sign, and no
comma is needed between thousands and...
Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution...
Sherpa Manufacturing has the following income statement for
6,000 units: Sales $600,000 Variable costs 360,000 Contribution
margin 240,000 Fixed costs 80,000 Net income $160,000 (a) At what
sales volume (in sales dollars) does Sherpa break even? (b) At what
sales volume (in units) does Sherpa break even? (c) Given the
income statement above, compute the margin of safety. (d) What
level of sales volume must be attained to reach net income of
$200,000? (e) What level of sales volume must...
Sales, Production, Direct Materials Purchases, and Budget that estimates direct labor hours and related costs needed...
Sales, Production, Direct Materials Purchases, and Budget that
estimates direct labor hours and related costs needed to support
budgeted production.Direct Labor Cost Budgets
The An accounting device used to plan and control resources of
operational departments and divisions.budget director of Royal
Furniture Company requests estimates of sales, production, and
other operating data from the various administrative units every
month. Selected information concerning sales and production for
February is summarized as follows:
a. Estimated sales of King and Prince chairs for...
Sales, Production, Direct Materials Purchases, and Budget thatestimates direct labor hours and related costs needed...
Sales, Production, Direct Materials Purchases, and Budget that
estimates direct labor hours and related costs needed to support
budgeted production.Direct Labor Cost BudgetsThe An accounting device used to plan and control resources of
operational departments and divisions.budget director of Gourmet
Grill Company requests estimates of sales, production, and other
operating data from the various administrative units every month.
Selected information concerning sales and production for July is
summarized as follows:a. Estimated sales for July by sales territory:Maine:Backyard Chef310 units at...
Sales, Production, Direct Materials Purchases, and Budget that estimates direct labor hours and related costs needed...
Sales, Production, Direct Materials Purchases, and Budget that
estimates direct labor hours and related costs needed to support
budgeted production.Direct Labor Cost Budgets
The An accounting device used to plan and control resources of
operational departments and divisions.budget director of Royal
Furniture Company requests estimates of sales, production, and
other operating data from the various administrative units every
month. Selected information concerning sales and production for
February is summarized as follows:
a. Estimated sales of King and Prince chairs for...
Ash Company incurred direct materials costs of $1,600,000 during the year. Direct Labor costs were $600,000....
Ash Company incurred direct materials costs of $1,600,000 during
the year. Direct Labor costs were $600,000. Manufacturing overhead
was applied at the rate of 70% of direct labor costs. What were Ash
Company’s total manufacturing costs for the year?
Superior Painting Company has the following production data for
January:
· Beginning work in process, 0 units
· Units transferred out, 35,000
· Units in ending work in process, 10,000, which are 45%
complete for conversion costs
Materials are added only...
Consider the following income statements for Nero Company: Income statement 1 Revenue = 1,800 Direct costs...
Consider the following income statements for Nero Company:
Income statement 1
Revenue = 1,800
Direct costs = (300)
Contribution margin = 1,500
Fixed costs = (500)
Operating income = 1,000
Income statement 2
Revenue = 1,400
Direct costs = (200)
Contribution margin = 1,200
Fixed costs = (300)
Operating income = 900
Income statement 3
Revenue = 2,000
Direct costs = (800)
Contribution margin = 1,200
Fixed costs = (400)
Operating income = 800
Identify which income statement is prepared...
Variable costs as a percentage of sales for Lemon Inc. are 80%, current sales are $600,000,...
Variable costs as a percentage of sales for Lemon Inc. are 80%,
current sales are $600,000, and fixed costs are $130,000. What is
the break even point in sales?
610000
520000
650000
none of the above
Variable costs per unit: Direct materials $ 10 Direct labor $ 8 Variable manufacturing overhead $...
Variable costs per unit:
Direct materials
$
10
Direct labor
$
8
Variable manufacturing overhead
$
3
Variable selling and administrative expenses
$
6
Fixed costs per year:
Fixed manufacturing overhead
$
117,000
Fixed selling and administrative expenses
$
320,000
During the last year, 29,250 units were produced and 24,000
units were sold. The Finished Goods inventory account at the end of
the year shows a balance of $110,250 for the 5,250 unsold
units.
Required:
1. Determine whether the...
Below is Income Statement information for NatNah, a builder of acoustic accessories. Revenue: $3,107,262 Variable costs:...
Below is Income Statement information for NatNah, a builder of
acoustic accessories.
Revenue: $3,107,262
Variable costs: 30% of revenue
Fixed costs: $1,000,000
Depreciation: $475,000
Bond Issue A: $300,000 face value, 10% coupon
Bond Issue B: $500,000 face value, 8% coupon
Bond Issue C: $900,000 face value, 12% coupon
Tax rate: 40%
Common shares issued and Outstanding: 250,000
a. Calculate the degree of operating leverage for the firm.
b. Calculate the degree of financial leverage for the firm.
c. Calculate the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Problem 18-5 Beta and Leverage North Pole Fishing Equipment Corporation and South Pole Fishing Equipment Corporation...
- Stenson, Inc., imposes a payback cutoff of three years for its international investment projects. Assume the...
- Mayfield Company sells two products, Blue models and Plaid models. Blue models sell for $41per unit...
- Write an overview of common concerns about adolescent development. Cite any sources.
- When a company has positive net income, does that also mean they have positive cash flows?...
- Consider a project with an initial investment of $60,000, a 6 year usefule life (and study...
- (MATLAB) im trying to solve an equation for gravitational force for 41 radius values in between...
ADVERTISEMENT