Question

In: Accounting

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: R45

The cost for fixed production overheads are R127 500 and selling and administrative expenses are broken down as follows:

 Salary of sales manager for the year: R75 000

 Sales commission: 10% of sales

Required: (Round of answers to the nearest rand or whole number)

4.1 Calculate the breakeven quantity. 

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

4.3 Calculate the margin of safety.

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


Solutions

Expert Solution

Segregating Fixed and variable cost.

Variable cost Per unit Fixed cost Per unit

Total

Direct material 135 x 2000=270000 135 270000
Direct labor 90 x2000 =180000 90 180000
Overhead 45 x2000=90000 45 90000
Fixed production OH 127500 127500/2000=63.75 127500
Selling and admn OH a) Commission 45x2000=90000 450x10%=45 90000
Selling and admn oh b)Manager salary 75000 75000/2000 47.5 75000
Total 630000 315 202500 101.25 832500

CVP tables

Amount Per unit
Sales 2000 x450 =900000 450
Less: VAriable cost 630000 315
Contribution 270000 135
Less: Fixed cost 202500 101.25
Net income 67500 23.75

4.1 ) Vreakeven quantity = Fixed cost / Contribution per unit

202500/135= 1500 units

4.2) Break even value(throuh marginal income ratio)

Marginal income ratio(contribution ratio) = Contribution / sales x100

270000/900000 x100 or 135/450x100

= 30%

Breakeven = Fixed cost / contribution ratio

=202500/30% =675000

to check the answer we know break even units are1500 units and selling price is 450

Breakeven value = breakeven units x selling price

1500 x 450 = 675000

4.3) No of units = Desired profit + Fixed cost / Contribution per unit

150000+202500/ 135= 2611.11 or 2611 units

4.4)

Amount Per unit
Sales 900000 450
Less variable cost 330 x2000 =660000 (315+15) 330
Contribution 240000 120
Less: fixed cost 202500(1+.01)=222750 111.375
Net income 17250 8.625

Break even qty = Fixed cost / contribution per unit

222750 /120 = 1856.25 units


Related Solutions

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:...
The following information are the balances extracted from the books of Xxx for the year ended...
The following information are the balances extracted from the books of Xxx for the year ended 31 December 2017: accounts                  dr                        cr opening stock        8000 buildings                 15000 debitors                  4000 purchases               22000 salaries                    1200 sales                                                   36000 discount                  800 sales returns          1000 furniture                 3000 office exp               300 wages                      600 purchase returns                               600 interest                                                  500 travelling exp         400 insurance                 600 machinery              8000 carriage on purchases 800 commission           600 cash in hand          1400 rent and rates         2400 capital                                                   25000 creditors                                                8000 totals                      70100                   70100...
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.
QUESTION TWO The following information was extracted from ABC Ltd’s financial statements for the year ended...
QUESTION TWO The following information was extracted from ABC Ltd’s financial statements for the year ended 31 December 2019. a. Sales on 30 November 2019 were K100 million and K110 million on 31 December 2019. For the year 2020, sales are expected to double at a constant monthly rate. b. 80% of the sales made are on account; the remainder on cash. c. From past experience, 5% of the receivables have turned out to be irrecoverable. d. Credit customers pay...
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...
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.
The following information has been extracted from the books of M & M limited company, an...
The following information has been extracted from the books of M & M limited company, an entity that is listed on the Exchange market, for the year ending December 2019. CapitalComponent Contribution [$] Component       Cost(%) $2 Ordinary Shares 2 000 000 34 Retained Earnings 800 000 34 $1 Cumulative Preference Shares 1 400 000 32 Convertible       Loan Notes 800 000 25 Total Financing 5 000 000 The convertible loan notes were issued two years ago at a face value of...
15. The following information was extracted from the financial records of Pineapple Limited: Equipment purchased on...
15. The following information was extracted from the financial records of Pineapple Limited: Equipment purchased on 1 July 2018 for $200 000 (accounting depreciation 10% straight line; tax depreciation 15% straight line). If the company tax rate is 30%, the deferred tax item that will be recorded by Pineapple Limited at 30 June 2019 is
Following information is extracted from the books of GMN Limited: a. Current Accounts  2016: CA...
Following information is extracted from the books of GMN Limited: a. Current Accounts  2016: CA = 22,900; CL = 15,300  2015: CA = 17,600; CL = 12,400 b. Fixed Assets and Depreciation  2016: NFA = 98,100; 2015: NFA = 75,700  Depreciation Expense = 2700 c. Long-term Debt and Equity (R.E. not given)  2016: LTD = 47,000; Common stock & APIC = 1,400  2015: LTD = 35,850; Common stock & APIC = 1,400 d. Income...
The following information has been extracted from the books of M & M limited company, an...
The following information has been extracted from the books of M & M limited company, an entity that is listed on the Exchange market, for the year ending December 2019. CapitalComponent Contribution [$] Component       Cost(%) $2 Ordinary Shares 2 000 000 34 Retained Earnings 800 000 34 $1 Cumulative Preference Shares 1 400 000 32 Convertible       Loan Notes 800 000 25 Total Financing 5 000 000 The convertible loan notes were issued two years ago at a face value of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT