Please open this spreadsheet and compute: (1) The number of units needed to be sold in order to attain $100,000 in net income. (2) The number of units needed to be sold in order to break even. Please submit your response as a spreadsheet. If possible, please leave any formulas intact so that I can review them.
Show work on excel spreadsheet.
Homework Answers
1. Number of units needed to be sold in order to attain $ 100,000 in net income = ( Fixed Cost + Target Income ) / Contribution Margin per Unit = $ ( 60,000 + 100,000 ) / $ ( 80 - 60 ) = 8,000 units.
Required revenue to achieve target operating income = ( Fixed Cost + Target Income ) / Contribution Margin Ratio = $ ( 60,000 + 100,000 ) / 0.25 = $ 640,000.
2. The number of units needed to be sold in order to break even = Fixed Cost / Contribution Margin per Unit = $ 60,000 / $ 20 = 3,000 units
Add Answer to:
Please open this spreadsheet and compute: (1) The number of units needed to be sold in...
APPLY THE CONCEPTS: Target income (number of units sold) Suppose a business has pricing and cost...
APPLY THE CONCEPTS: Target income (number of units sold) Suppose a business has pricing and cost information as follows:: Price and Cost Information Amount Selling Price per Unit $10.00 Variable Cost per Unit $5.00 Total Fixed Cost $100 For the upcoming period, the company wishes to generate operating income of $400. Given the cost and pricing structure for the company’s product, how many units must the company sell to attain its target income? Remember that the basic equation for calculating...
Assignment Exercise 18–3: Target Operating Income Acme Medical Supply Company desires a target operating income amount...
Assignment Exercise 18–3: Target Operating Income Acme Medical Supply Company desires a target operating income amount of $100,000, with assumption inputs as follows: Desired (target) operating income amount = $100,000 Unit price for sales = $80 Variable cost per unit = $60 Total fixed cost = $60,000 Compute the required revenue to achieve the target operating income and compute a contribution income statement to prove the totals.
Please fill in the missing spots and SHOW YOUR WORK for each answer per the spreadsheet...
Please fill in the missing spots and SHOW YOUR
WORK for each answer per the spreadsheet under the
enter calculations below as needed spot.
Legrand Company produces hand cream in plastic jars. Each jar sells for $3.40. The variable cost for each jar (materials. labor, and overhead) total $2.55. Total fixed cost is $58,140. During the most recent years, 81,600 jars were sold. 1. What is the break-even point in units for Legrand? What is the margin of safety in...
Just Calculation 2 please and could I see the formulas in excel Query company's projected income...
Just Calculation 2 please and could I see the formulas in
excel
Query company's projected income statement shows the following results from selling 100,000 units of product. Net sales are $2,000,000 - total expenses are $1,760,000-net income is $240,000. The details of the expenses are as following TOTAL FIXED 420,000.00 340,000.00 $60,000.00 820,000.00 VARIABLE Cost of goods sold Selling expenses Administrative expenses Total Expenses 780,000.00 100,000.00 60,000.00 $940,000.00 1,200,000.00 $440,000.00 $120,000.00 $1,760,000.00 Compute the break-even point in dollars and units...
Please show how to do it. Using the Contribution Margin method of computing target operating income,...
Please show how to do it. Using the Contribution Margin method of computing target operating income, calculate the desired (target) operating income using the following: 1. If the desired (target) operating income is $6,400. 2. Unit price for sales is $400. 3. Variable cost per unit is $240. 4. Total fixed cost is $8,000. Units Per Unit Sold Cost Amount Revenue Variable Costs Contribution Margin Fixed Costs Operating Income
7) Total Variable cost = Number of units sold x variable cost per unit 8) Operating...
7) Total Variable cost = Number of units sold x variable cost per unit 8) Operating Leverage = Contribution Margin / Net Income Complete the below table: Sales Variable Cost Total Contribution Margin Fixed Costs Operating Income Break-even Sales Revenue 150,000 125,000 50,000 B 85,000 35,000 15,000 75,000 65,000 113,750 D 180,000 50,000 144,000 Remember: 1) Variable costs rise and fall with an increase or decrease in revenue 2) Fixed costs do not rise and fall with an increase or...
Assume that a company has forecasted 5,800 units sold, has an average selling price of $25.00...
Assume that a company has forecasted 5,800 units sold, has an average selling price of $25.00 per unit, unit variable cost of $10.00 per unit, and a total fixed cost equal to $84,000. Using the template provided, perform the following analyses: a. Create a Contribution-format Income Statement based on the forecasted data b. Create a Contribution-format Income Statement based on the Break-even Sales Volume c. Create a Contribution-format Income Statement based on a target profit equal to $6,000 INCOME STATEMENTS...
3 Information: 5 Number of Units Produced 6 Number of units Sold 3200 3200 $48 per...
3 Information: 5 Number of Units Produced 6 Number of units Sold 3200 3200 $48 per unit $26 per unit Cost of Goods Sold Detail: Direct materials Direct Labor Manufacturing Overhead: Rent on Factory Building Depreciation on Equipment Other Expen Salaries for Rent of Offic Depreciation Commission 8 Revenue per unit $275 per unit $25,000 total 10 12 A) Traditional Absorption Costing Income Statement B) Contribution Margin Income Statement income Statement using Variable Costing) Calculate Total variable Total fixed cc...
Cost data Number of Bikes Produced and Sold 625 800 1,050 Total costs: Total variable costs...
Cost data Number of Bikes Produced and Sold 625 800 1,050 Total costs: Total variable costs Total fixed costs 125000 Total costs Cost per unit: Variable cost per unit Fixed cost per unit Total cost per unit 543.75 $650.00 Bikes produced and sold: Total revenue Variable costs Contribution margin Fixed costs Net operating income Selling price Contribution margin ratio (MC Total revenue) Net operating income / Total revenue
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the...
Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may...
Please fill in the missing spots and SHOW YOUR
WORK for each answer per the spreadsheet under the
enter calculations below as needed spot.
Legrand Company produces hand cream in plastic jars. Each jar sells for $3.40. The variable cost for each jar (materials. labor, and overhead) total $2.55. Total fixed cost is $58,140. During the most recent years, 81,600 jars were sold. 1. What is the break-even point in units for Legrand? What is the margin of safety in...
Just Calculation 2 please and could I see the formulas in
excel
Query company's projected income statement shows the following results from selling 100,000 units of product. Net sales are $2,000,000 - total expenses are $1,760,000-net income is $240,000. The details of the expenses are as following TOTAL FIXED 420,000.00 340,000.00 $60,000.00 820,000.00 VARIABLE Cost of goods sold Selling expenses Administrative expenses Total Expenses 780,000.00 100,000.00 60,000.00 $940,000.00 1,200,000.00 $440,000.00 $120,000.00 $1,760,000.00 Compute the break-even point in dollars and units...
7) Total Variable cost = Number of units sold x variable cost per unit 8) Operating Leverage = Contribution Margin / Net Income Complete the below table: Sales Variable Cost Total Contribution Margin Fixed Costs Operating Income Break-even Sales Revenue 150,000 125,000 50,000 B 85,000 35,000 15,000 75,000 65,000 113,750 D 180,000 50,000 144,000 Remember: 1) Variable costs rise and fall with an increase or decrease in revenue 2) Fixed costs do not rise and fall with an increase or...
3 Information: 5 Number of Units Produced 6 Number of units Sold 3200 3200 $48 per unit $26 per unit Cost of Goods Sold Detail: Direct materials Direct Labor Manufacturing Overhead: Rent on Factory Building Depreciation on Equipment Other Expen Salaries for Rent of Offic Depreciation Commission 8 Revenue per unit $275 per unit $25,000 total 10 12 A) Traditional Absorption Costing Income Statement B) Contribution Margin Income Statement income Statement using Variable Costing) Calculate Total variable Total fixed cc...
Cost data Number of Bikes Produced and Sold 625 800 1,050 Total costs: Total variable costs Total fixed costs 125000 Total costs Cost per unit: Variable cost per unit Fixed cost per unit Total cost per unit 543.75 $650.00 Bikes produced and sold: Total revenue Variable costs Contribution margin Fixed costs Net operating income Selling price Contribution margin ratio (MC Total revenue) Net operating income / Total revenue
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago