Question

In: Civil Engineering

1.) A company is producing a product that has the following data: volume of sales per...

1.) A company is producing a product that has the following data:

volume of sales per year = 3

00,000 units

selling price per unit = $10

0

variable cost = $6

0 per unit

fixed costs per year = $6

00,000

book depreciation = $4

00,000

tax depreciation = $50

0,000

debt interest = $1

00,000

tax rate = 40%

With the above data determine

(a) Before

-

tax profit

(b) After

-

tax profit

(c) Break

-

even yea

rly volume of sales

(d) Break

-

even selling price

(e) Plot the break

-

even chart

Solutions

Expert Solution

From the given data

Total sales revenue = selling price * total volume of shares

= 300,000*100

=30000,000 dollars

total cost of firm = variable cost + fixed cost

= variable price * total volume+ fixed cost

= 60* 300,000+600,000  

= 18600,000 dollars

Earning before interest tax depreciation(EBITD) = sales - cost

= 30000,000-18600,000

= 11400,000 dollars

Earnings before interest and tax (EBIT)= EBITD - depreciation

=11400,000-(400,000+500,000)

=10500,000 dollars

Earnings before tax = EBIT - interest

= 10500,000-100,00,

=10400,000 dollars

BEFORE TAX PROFIT = 10400,000 DOLLARS

tax = 40 % = 0.4* 10400,000 = 4160,000 dollars

AFTER TAX PROFIT = 10400,000-4160,000 = 6240,000 DOLLARS

Break even yearly volume of sales

= ( fixed cost )/ ( selling price per unit - variable cost per unit)

= 600000/(100-60)

=600000/40 = 15000 units

Break even selling price = break even quantity * selling price per unit

=15000*100=1500,000 dollars

PLOT


Related Solutions

1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable...
1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable cost $50 per unit   Fixed cost $300,000             If the dollar contribution margin per unit is increased by 10%, total fixed cost is decreased by 20%, and all other factors remain the same, by how much will net income increase? 2.   Hamada Company sells a single product. The product has a selling price of $100 per unit and variable expenses of 80% of sales. If the...
A company has the following history of sales for an item. Month       Sales Volume Jan.             ...
A company has the following history of sales for an item. Month       Sales Volume Jan.              120 Feb.                90 Mar.             100 Apr.               75 May             110 Jun.                50 Jul.                 75 Aug.             130 Sep.              110 Oct.              90 Compute the monthly demand forecast for April through November using a 3-month moving average. Compute the monthly demand forecast for June through November using a 5-month moving average. Compute the monthly demand forecast for April through November...
Table MA.1 Current product data Volume (000 bottles) Selling price per bottle £ Direct costs per...
Table MA.1 Current product data Volume (000 bottles) Selling price per bottle £ Direct costs per bottle £ Distribution cost per bottle £ Bottles per machine hour Bottles per labour hour Shampoo 2,000 1.50 0.6 0.20 2,600 14,000 Conditioner 1,500 1.75 0.5 0.20 3,100 6,700 Liquid soap 500 1.25 0.4 0.30 2,010 1,500 Note: Assume direct costs and distribution are 100% variable. The majority of direct costs are materials with a small proportion of direct labour. Table MA.2 Factory indirect...
A company has recorded data on the weekly sales for its product (y) and the unit...
A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to answer the following questions. A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). The data resulting from a random sample of 7 weeks follows. Use Excel’s Regression Tool to...
1. Laker Company Reported the following January purchases and sales data for its only product. Date...
1. Laker Company Reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units Sold at Retail Jan 1 Beginning Inventory 140 units @ $6 = $840 Jan 10 Sales 100 units @$15 Jan 20 Purchase 60 units @ $5 = $300 Jan 25 Sales 80 units @ $15 Jan20 Purchase 180 units @ $4 = $720 Totals 380 units A. Laker uses a periodic inventory system. Calculate COGS and Ending inventory...
A company has the following information: Unit sales             13,400 Sales price per unit          $...
A company has the following information: Unit sales             13,400 Sales price per unit          $ 90.00 Variable costs per unit   $ 40.00 Fixed costs          $ 500,000 A. What is the company’s contribution margin per unit? B. What is the company’s total contribution margin? C. What is the company’s operating income? D. What is the company’s margin of safety in units? E. If the company had a target operating income of $636,000, what would be the target sales in...
1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year.
  1. For a new product, sales volume in the first year is estimated to be 50,000 units and is projected to grow at a rate of 7% per year. The selling price is $100 and will increase by $10 each year. Per-unit variable costs are $22 and annual fixed costs are $1,000,000. Per-unit costs are expected to increase 4% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to predict the net present...
A company has recorded data on the weekly sales for its product (y) ($10), the unit...
A company has recorded data on the weekly sales for its product (y) ($10), the unit price of the competitor's product (x1), and advertising expenditures (x2) ($10). The data resulting from a random sample of 7 weeks follows. Use Excel's Regression Tool to answer the following questions: Week Price Advertising Sales 1 .33 5 20 2 .25 2 14 3 .44 7 22 4 .40 9 21 5 .35 4 16 6 .39 8 19 7 .29 9 15 1....
A company has collected its sales data of a certain product for 10 days before and...
A company has collected its sales data of a certain product for 10 days before and after an ad campaign was run. The sales numbers (in thousands) before and after the ad campaign are as follows: before [79, 65, 62, 61, 67, 73, 56, 74, 83, 69], after [65, 76, 75, 44, 71, 66, 57, 68, 78, 74]. The researchers do NOT believe that the underlying distributions are normal, and want to take the magnitude of the difference into account....
Intercontinental, Inc., provides you with the following data for its single product: Sales price per unit...
Intercontinental, Inc., provides you with the following data for its single product: Sales price per unit $ 51.00 Fixed costs (per month): Selling, general, and administrative (SG&A) 900,000 Manufacturing overhead 1,800,000 Variable costs (per unit): Direct labor 6.00 Direct materials 13.00 Manufacturing overhead 9.00 SG&A 5.00 Number of units produced per month 300,000 units Required: Compute the amounts for each of the following assuming that both production levels are within the relevant range. (Do not round intermediate calculations. Round your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT