Question

In: Accounting

Moon (Ltd) manufacture specially treated garden benches. The following information was extracted from the budget for...

Moon (Ltd) manufacture specially treated garden benches. The following information was extracted from the budget for the year ended 29 February 2016:

Estimated sales for the financial year 2 000 units

Selling price per garden bench R450

Variable production cost per garden bench:

- Direct material - R135

- Direct labour -R90

- Overheads -R45

Fixed production overheads R127 500

Selling and administrative expenses:

- Salary of sales manager for the year - R75000

- Sales commission-10% of sales

Required: (round off answers to the nearest rand or whole number)

3.1 Calculate the break-even quantity.

3.2 Determine the break-even value using the marginal income ratio.

3.3 Calculate the margin of safety (in Rand terms).

3.4 Determine the number of sales units required to make a profit of R150 000.

3.5 Suppose Moon (Ltd) wants to make provision for a 10% increase in fixed production costs and an increase in variable overhead costs of R15 per unit. Calculate the new break-even quantity.

Expert Solution

Income Statement of Moon Ltd.
Particulars	Quantity	Price	Amount in Rand Terms
Sales	2,000	450	900,000
Less: Variable Cost
Direct Material	2,000	(135)	(270,000)
Direct Labor	2,000	(90)	(180,000)
Overheads	2,000	(45)	(90,000)
Sales Commission(10% of sales)	2,000	(45)	(90,000)
Contribution		135	270,000
Less: Fixed Overheads	2,000	(64)	(127,500)
Less: Salary of Sales Manager	2,000	(38)	(75,000)
Profit	2,000	34	67,500

1. Calculation of Break Even Quantity
(Total Fixed Costs/ Contribution per unit)
Total Fixed Costs	202,500
Contribution per unit	135
Break Even (In Quantity)	1,500

2. Calculation of Break Even Value
(Total Fixed Costs/ Margin Income Ratio)

Total Fixed Costs	202,500
Margin Income Ratio	30%
Break Even (In Value)	675,000

3. Calculation of Margin of Safety (In Rand Terms)
Actual Sales	900,000
Less: Break Even Sales	(675,000)
Margin of Safety (In Rand Terms)	225,000

4. Calculation of Sales at Desired Profits
Particulars	Rand Terms
Total Fixed Costs	202,500
Desired Profits	150,000
Desired Contribution	352,500
Margin Income Ratio	30%
Desired Sales Value	1,175,000

5. Calculation of New Break Even Quantity
Revised Production Overheads	140,250
Salary of Sales Manager	75,000
Total Revised Fixed Costs	215,250

Revised Contribution per unit(135-15)	120
Break Even (In Quantity)	1,794

ekkarill92 answered 1 year ago

Greenweed Limited manufactures specially treated garden benches. The following information was extracted from the budget for the year ended 29 February 2020:

Greenweed Limited manufactures specially treated garden benches. The following information was extracted from the budget for the year ended 29 February 2020:The estimated sales for the financial year are 2000 units. The selling price per garden bench is R450. Variable production cost per garden bench comprises of the following: Direct materials: R135 Direct Labour: R90 Overheads: R45The cost for fixed production overheads are R127 500 and selling and administrative expenses are broken down as follows: Salary of sales manager for...

The following information was extracted from the records of Dolphin Ltd for the year ended 30...

The following information was extracted from the records of Dolphin Ltd for the year ended 30 June 20X1 · Cost of equipment that was sold: $530,000 · Accumulated depreciation for equipment that was sold: $310,000 · Cost of equipment that was purchased: $510,000 · Gain on sale of equipment: $50,000 Required: Write in the box below the net cash used for investing activities for the year ended 30 June 20X1.

The following information has been extracted from the financial records of Platinum Ltd and its subsidiary...

The following information has been extracted from the financial records of Platinum Ltd and its subsidiary Serum Ltd at 30 June 2017. Income statement Platinum Ltd ($) Serum Ltd ($) Sales revenue 198,000 112,000 Cost of goods sold -149,000 -102,000 Gross profit 49,000 10,000 Dividend revenue 8,000 25,000 Depreciation expense -12,000 -11,000 Other expenses -8,000 -4,000 Profit before tax 37,000 20,000 Tax expense -11,100 -6,000 Profit for the year 25,900 14,000 Retained earnings – 30 June 2016 110,000 46,000 Interim...

accounting question The following information has been extracted from the financial records of Associate Ltd at...

accounting question The following information has been extracted from the financial records of Associate Ltd at 1 April 2004 and at 31 March 2017. Associate Ltd 1 April 2004 Associate Ltd 31 March 2017 $ $ Sales 1 800 000 Less cost of goods sold 1 200 000 Gross profit 600 000 Less expenses 328 400 Profit before tax 271 600 Plus rental income 26 000 Less income tax expense 71 880 Profit after tax 225 720 Retained earnings- opening...

The following information relates to Moon Light Ltd. (a) At the beginning of the accounting period...

The following information relates to Moon Light Ltd. (a) At the beginning of the accounting period the company has a salary payable liability of $200 and at the reporting date a salary payable of $360. During the year the salary expense shown in the income statement was $400. (b) At the beginning of the accounting period the company has property, plant and equipment (PPE) with a carrying amount of $400. At the end of the accounting period, the carrying amount...

The information below was extracted from the books of Battle Field Ltd for the year ended...

The information below was extracted from the books of Battle Field Ltd for the year ended December 31, 2019. Battle Field Ltd. Condensed Income Statement For the Year Ended December 31, 2019 Sardines GHS Tuna Flakes GHS Oatmeal GHS Total GHS Sales 500,000 400,000 100,000 1,000,000 Costs of goods sold: Variable costs Fixed costs 220,000 120,000 200,000 80,000 60,000 20,000 480,000 220,000 Total cost of goods sold 340,000 280,000 80,000 700,000 Gross profit 160,000 120,000 20,000 300,000 Operating expenses: Variable...

Dean & Deluca Ltd (D&D) is listed on Singapore Exchange and the following information was extracted...

Dean & Deluca Ltd (D&D) is listed on Singapore Exchange and the following information was extracted from Thomson Reuters Eikon: • Share price = $1.50 • Number of outstanding shares = 5 million • Beta = 0.8 • Last traded price of each 5% bond = $920 • Bonds pay coupons semi-annually and mature in 6 years • Face value of bond =$1,000 • Number of bonds issued = 5,000 Yield on government long-term bond = 3% Equity risk premium...

(i) The following information is extracted from the financial statements of XERO

(i) The following information is extracted from the financial statements of XEROLimited:Cash $677,423 Accounts Payable $1,721,669Accounts Receivable $1,845,113 Notes Payable $2,113,345Inventories $1,312,478Total Current Assets $3,835,014 Total Current Liabilities $3,835,014Net Sales $9,912,332Cost $5,947,399 (a) Briefly explain what you understand by the term ‘operating cycle’. (1 mark)Click or tap here to enter text. (b) What is the operating cycle for XERO Limited? Click or tap here to enter text. (c) What can you say about XERO Limited’s accounts receivable and inventorymanagement if...

Q1. The following balances have been extracted from the books of Caswell Ltd as at 31...

Q1. The following balances have been extracted from the books of Caswell Ltd as at 31 December 2009. £ £ £1 ordinary shares 600,000 6% preference shares 600,000 5% debentures 480,000 Share premium account 330,000 Debenture interest paid 12,000 Bad debts written off 20,280 Provision for doubtful debts 24,480 Cash in hand 18,960 Debtors & Creditors 207,000 78,000 Bank balance 379,200 Land at cost 540,000 Buildings at cost 1,140,000 Fixtures and fittings at cost 660,000 Accumulated depreciation: Buildings...

The following information was extracted from the 2020 financial statements of Arigato LLC:

The following information was extracted from the 2020 financial statements of Arigato LLC:Income from continuing operations before income tax $755,123Selling and administrative expenses 480,357Income from continuing operations 495,951Gross profit 1,357,530The amount reported for Other Revenue/Gains and Other Expenses/Losses is: $ Blank 1. Fill in the blank, read surrounding text.Use “-“ sign for negative amount, as needed. Use commas, as needed.