National Aluminum Products Company is a state owned enterprise. Its main product is PVC pipes manufactured...

National Aluminum Products Company is a state owned enterprise. Its main product is PVC pipes manufactured through extrusion process. The company is catering for the needs of the country for PVC articles, particularly in sanitary work. The company has just enhanced its capacity to 450 units per day. The average selling price of PVC pipes is computed to be OMR 25 per unit. Given below is the company’s last year revenue and cost information:

	OMR
Revenue	1875000
Direct material	562500
Indirect material	14000
Direct labor	281250
Indirect labor	8600
Transportation of sold units	12500
Salaries of management staff	375000
Insurance	26000
Marketing	16500
Building rent and dep	24000
Utilities (Electricity & Water)	15800
Cleaning and maintenance	5000
Total cost	1341150

Operating income	533850
VAT Tax @ 30%	160155
Net Income	373695

a) Compute the break-even point for last year.

b) Assume that if the company spends 23000 OMR on additional marketing, the company can sell the unit at 5% higher price. Keeping other cost pattern the same, what will be the new break-even point?

c) Assume that there are 260 working days in a year, what will be the after tax profit, if the company operates at its full capacity?

d) How many units the company must sell, if the management sets the next year target an after tax profit of OMR 480,000?

e) What will be the margin of safety, if the company is able to sell its full capacity?

Solutions

Expert Solution

PARTICULAR	OMR	A. RATE (Quantity 75000)	B. New Rate
Revenue	1875000	25 (SP)	26.25 (SP)

Direct Material	562500
Indirect Material	14000
Direct Labour	281250
Indirect Labour	8600
Transportation	12500
Total Variable cost	878850	11.718 (VC)	11.718 (VC)

Salaries	375000		375000
Insurance	26000		26000
Marketing	16500		16500
Building Rent & Dep	24000		24000
Utilities	15800		15800
Cleaning & Maint	5000		5000
Additional Marketing			23000
Total Fixed cost	462300		485300

a. Break even point = Quantity at which profit = 0

i.e Contribution = (SP - VC) * Quantity = Fixed cost

Thus BEP Quantity = Fixed cost / (SP-VC) = 462300/ (25-11.718) = 34807

b. New Breakeven point = Fixed cost / (SP-VC) = 485300/ (26.25-11.718) = 33395

c. Total production in a year = 260 days*450 units = 117000 units in a year

Profit before tax = Contribution - Fixed cost = (25-11.718)*117000 -462300= 1091694

Profit after tax (PAT) = 1091694*70% = 764186

d. PAT+Tax = PBT + Fixed cost = Contribution = Quantity (SP-VC)

PBT = 480000+480000/70*30/100 = 685714

Contribution = 685714 + 462300 = 1148014

Contribution = 1148014 = Quantity (SP-VC) = Quantity (25-11.718)

Quantity = 1148014 / (25-11.718) = 86434

e. Margin of safety = (Current sales - breakeven sales)/Current sales *100

= (117000 - 34807)/ 117000 = 70.25%

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Product J is one of the many products manufactured and sold by Oceanside Company. An income...

Product J is one of the many products manufactured and sold by Oceanside Company. An income statement by product line for the past year indicated a net loss for Product J of $12,250. This net loss resulted from sales of $260,000, cost of goods sold of $186,500, and operating expenses of $85,750. It is estimated that 30% of the cost of goods sold represents fixed factory overhead costs and that 40% of the operating expense is fixed. If Product J...

Product J is one of the many products manufactured and sold by Oceanside Company. An income...

Product J is one of the many products manufactured and sold by Oceanside Company. An income statement by product line for the past year indicated a net loss for Product J of $2,750. This net loss resulted from sales of $275,000, cost of goods sold of $186,500, and operating expenses of $85,750. It is estimated that 30% of the cost of goods sold represents fixed factory overhead costs and that 40% of the operating expense is fixed. If Product J...

Enterprises manufactures one of the components used to assemble its main company product. Specialty? Products, Inc.,...

Enterprises manufactures one of the components used to assemble its main company product. Specialty? Products, Inc., has offered to make the component at a cost of $12.40 per unit. Nesbitt Enterprises' current cost is $15.00 per unit of the? component, based on the 120,000 components that Nesbitt Enterprises currently produces. This current cost per unit is based on the following? calculations: Direct material per unit $5.50 Direct labor per unit 5.75 Variable manufacturing overhead per unit 0.75 Fixed manufacturing overhead...

Instant Enterprises manufactures one of the components used to assemble its main company product. Specialty? Products,...

Instant Enterprises manufactures one of the components used to assemble its main company product. Specialty? Products, Inc., has offered to make the component at a cost of $12.90 per unit. Instant ?Enterprises' current cost is $18.75 per unit of the? component, based on the 125,000 components that Instant Enterprises currently produces. This current cost per unit is based on the following? calculations: Direct material per unit $5.50 Direct labor per unit 7.25 Variable manufacturing overhead per unit 2.75 Fixed manufacturing...

Luangwa Mineral Resources is a State Owned Enterprise (SOE) that was in past managed parastatal before...

Luangwa Mineral Resources is a State Owned Enterprise (SOE) that was in past managed parastatal before being privatize after liberalization of the Zambia economy. The privatization of the firm was decided because the firm had been run down and was not performing well as expected. Further the firm accrued huge liabilities and was running losses consistently. After being privatized the new owners (majority shareholders 75%) re capitalized the firm by investing $160 million to improve operation and clear outstanding debts....

QUESTION TWO Case Study Luangwa Mineral Resources is a State Owned Enterprise (SOE) that was in...

QUESTION TWO Case Study Luangwa Mineral Resources is a State Owned Enterprise (SOE) that was in past managed parastatal before being privatize after liberalization of the Zambia economy. The privatization of the firm was decided because the firm had been run down and was not performing well as expected. Further the firm accrued huge liabilities and was running losses consistently. After being privatized the new owners (majority shareholders 75%) re capitalized the firm by investing $160 million to improve operation...

1. Discuss, what challenges arise when a state-owned enterprise is restructured? [20Marks]

10- Two managers of a state owned enterprise in 1980’s China talking: “We will easily meet...

10- Two managers of a state owned enterprise in 1980’s China talking: “We will easily meet the production target assigned by the state planners of producing 50.000 tractors this year, using 80% of our production capacity. With the new regulations, we can produce motorcycles on the side… With demand high, supply low, and prices so high, we will make great profit…” What is the new regulations is he talking about related to?

Gold Nest Company of Guandong, China is a family owned enterprise that makes birdcages for the...

Gold Nest Company of Guandong, China is a family owned enterprise that makes birdcages for the South China market. The company sells its birdcages through an extensive network of street vendors who receive commission on their sales. The company uses job-order costing system in which overhead is applied to jobs on the basis of direct labor cost. Its predetermined overhead rate is based on a cost formula that estimated $330,000 of manufacturing overhead for an estimated activity level of $200,000...

Brassard Company manufactured 1,500 units of its only product during 2019. The inputs for this production...

Brassard Company manufactured 1,500 units of its only product during 2019. The inputs for this production are as follows: 450 pounds of Raw Material G at $1.50 per pound 300 pounds of Raw Material H at cost of $2,75 per pound 300 direct labor hours at $20 per hour The firm manufactured 1,800 units of the same product in 2017 with the following inputs: 500 pounds of Raw Material G at a cost of $1,20 per pound 360 pounds of...

Subjects