Question

In: Finance

ABC Sdn Bhd’s profit plan for the year of 2019 is summarized below: Items                   RM...

ABC Sdn Bhd’s profit plan for the year of 2019 is summarized below:

Items

                  RM

RM

Sales (20,000 units)

1,000,000

Manufacturing costs:

    Material

85,000

    Labour

80,000

    Fixed overhead

132,500

    Variable overhead

202,500

Distribution costs:

    Fixed

170,000

    Variable

95,000

Administration costs:

    Fixed

87,500

    Variable

17,500

Total costs

870,000

Profit before tax

130,000

Determine the following:

(i) Compute the variable cost ratio and the P/V (contribution margin) ratio.

(ii) What is the breakeven point in RM? In units?

(iii) Calculate margin of safety in RM & %.

(iv) Assume that the management is considering revising the sales price downward by 10%. The price decrease is expected to bring about a 20% increase in sales volume.

  • Is the revised price a better alternative? (show calculation).
  • What is the new breakeven point in units & in RM ?
  • What is the new margin of safety in RM & in % ?

Solutions

Expert Solution

i. variable cost ratio= variable cost/Net sales= material + labour + variable overhead/ net sales *100

= 85000+ 80000+202500/1000000*100= 36.75%

.P/V ratio= contribution/sales*100= sales-variable cost/sale*100= 632500/1000000*100= 63.25%

ii. Break even point in units and value= In value- fixed cost/p/v ratio= 132500/63.25%= 209486

in units= total units=20000= fixed cost/contribution per unit= 132500/31.625= 4190 units (Approx)

iii. Margin of safety in value and %= in value= current sales - Break even sales=1000000-209486= 790514

in % = (current sales -break even sales)/current sales*100= (1000000-209486)/1000000*100= 79.05%

iv. sales price reduced by 10 resulting in 20 % increase in volume- current sales price=50 reduced price=45

no of units = 200000 increased units = 20000*1.2=24000 total sales= 45*24000= 1080000

   variable cost= 396900

contribution 683100

fixed overheads 132500

pv ratio = 63.25 % there is no  change in pv ratio .

new break even point in value= fixed overhead/c

ontribution %= 132500/63.25% =209486

in units= 132500/28.4625= 4655 units(approx)

new margin of safety in value=  1080000-209486= 856031 in %= 1080000-209486/1080000*100= 80.60%


Related Solutions

a) Based on the information below, prepared a financial position of company ABC Sdn Bhd. as...
a) Based on the information below, prepared a financial position of company ABC Sdn Bhd. as at 31.12.2019.          Items   RM Inventories 600,000 Retained earnings 270,000 Long-term loan 60,000 Tax payables 180,000 Trade receivables 780,000 Share capital 240,000 Overdraft 400,000 Furniture & Fittings 270,000 Trade payables 420,000 Other payables 80,000                                                                                                                                              b) You are required to calculate and comments on the following:    (i) Non-current asset (ii) Current asset    (iii) Current liabilities    (iv)...
Company ABC estimated revenue is 10 million in 2019 and 2% growth per year. Profit margin...
Company ABC estimated revenue is 10 million in 2019 and 2% growth per year. Profit margin is stable annually and equals to 20%. Non-cash P&L items estimated at 12% of total sales. Company will purchase equipment at 2021 for 3 million. Interest expense is 800.000 annually and tax rate is 20%. Calculate FCFF for first 3 years. Explain the method you would use to calculate PV of future cash flows after year 3. Using results, calculate value of the company...
Transactions for the year 2019 are summarized as follows: Sold merchandise on credit in the amount...
Transactions for the year 2019 are summarized as follows: Sold merchandise on credit in the amount of $325,000, terms 2/10, N30. The cost of the merchandise sold was $195,500. Collected accounts receivable in the amount of $ 278,950, minus discounts of $ 3,000. Wrote off an uncollectible account in the amount of $2,600.00. Accepted a 60-day, 8 % note receivable in the amount $12,500.00 from a credit customer, in exchange for an extension on a customer’s overdue account receivable. The...
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017...
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017 Year 2016 $ $ $ $ Sales revenue 1,095,910 1,060,900 1,030,000 1,000,000 Less: Cost of goods sold (895,358) (866,755) (842,540) (820,000) Gross profit 200,552 194,145 187,460 180,000 Other operating expenses (162,877) (161,827) (160,900) (160,000) Income before tax 37,675 32,318 26,560 20,000 Less: Income tax expense (3,768) (3,232) (2,656) (2,000) Net income 33,907 29,086 23,904 18,000 Required: Compute the index-number trend percentages for the accounts...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. DR. (RM)...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. DR. (RM) CR. (RM) Account receivables 109,658 Buildings 1,372,680 Cash 1,314,264 Cost of goods sold 856,152 Equipment 504,000 Patent 60,276 Income tax expense 60,340 Inventory 551,950 Land 766,800 Maintenance and repair expenses 11,953 Office expense 14,086 Prepaid insurance 48,000 Property tax expense 1,680 Salaries and wages expenses 25,334 Sales returns and allowance 1,176 Accounts payable 36,936 Accumulated depreciation - buildings 137,268 Accumulated depreciation - equipment 252,000...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM)...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM) Cr. (RM) Account receivables              109,658 Buildings          1,372,680 Cash          1,314,264 Cost of goods sold              856,152 Equipment              504,000 Patent                60,276 Income tax expense                60,340 Inventory              551,950 Land              766,800 Maintenance and repair expenses                11,953 Office expense                14,086 Prepaid insurance                48,000 Property tax expense                  1,680 Salaries and wages expenses                25,334 Sales returns and allowance...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM)...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM) Cr. (RM) Account receivables              109,658 Buildings          1,372,680 Cash          1,314,264 Cost of goods sold              856,152 Equipment              504,000 Patent                60,276 Income tax expense                60,340 Inventory              551,950 Land              766,800 Maintenance and repair expenses                11,953 Office expense                14,086 Prepaid insurance                48,000 Property tax expense                  1,680 Salaries and wages expenses                25,334 Sales returns and allowance...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM)...
Below is an Unadjusted Trial Balance of Jasa Tading Bhd at 31 December 2019. Dr. (RM) Cr. (RM) Account receivables              109,658 Buildings          1,372,680 Cash          1,314,264 Cost of goods sold              856,152 Equipment              504,000 Patent                60,276 Income tax expense                60,340 Inventory              551,950 Land              766,800 Maintenance and repair expenses                11,953 Office expense                14,086 Prepaid insurance                48,000 Property tax expense                  1,680 Salaries and wages expenses                25,334 Sales returns and allowance...
(RM MILLION) FOR THE YEAR ENDED 31 DECEMBER 2019 2018 2019 INCOME STATEMENT 1.Revenue 10,638 11,860...
(RM MILLION) FOR THE YEAR ENDED 31 DECEMBER 2019 2018 2019 INCOME STATEMENT 1.Revenue 10,638 11,860 2.Net total expenses 9,419 11,136 3.Operating profit 1,219 725 4.Profit before taxation 1,335 -522 5.Taxation 360 238 6.Net profit 1,695 -283 BALANCE SHEET 7.Deposits, cash and bank balances 3,327 2,588 8.Total assets 18,550 25,595 9.Net debt (Total debt - Total Cash) 287 -2,159 10.Shareholders' equity 6,185 2,911 CASH FLOW STATEMENTS 11.Cash flow from operating activities 353 2,081 12.Cash flow from investing activities 9,049 4,660...
Variable and Absorption Costing Summarized data for 2019 (the first year of operations) for Gorman Products,...
Variable and Absorption Costing Summarized data for 2019 (the first year of operations) for Gorman Products, Inc., are as follows: Sales (70,000 units) $2,800,000 Production costs (80,000 units) Direct material 880,000 Direct labor 720,000 Manufacturing overhead: Variable 544,000 Fixed 320,000 Operating expenses: Variable 175,000 Fixed 240,000 Depreciation on equipment 60,000 Real estate taxes 18,000 Personal property taxes (inventory & equipment) 28,800 Personnel department expenses 30,000 a. Prepare an income statement based on full absorption costing. Only use a negative sign...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT