Question

In: Accounting

1.2 Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two...

1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25 1.2
Bunny Ltd manufactures a single product. Its Statement of Profit & Loss for the two years are given below:
2019 2018 Units sold 300 000 units 240 000 units Sales revenue N$ 1 500 000 N$ 1 200 000 Cost of goods sold N$ 800 000 N$ 740 000 Gross margin N$ 700 000 N$ 460 000 Less: Operating expenses N$ (450 000) N$ (420 000) Net Income N$ 250 000 N$ 40 000 The Company’s cost of goods sold and operating expenses are mixed costs.
REQUIRED: MARKS
1.2
Using the High-Low Method, separate the cost of goods sold and operating expenses into their variable and fixed elements, and accordingly determine the cost estimation formula for each type of cost. 10 TOTAL MARKS FOR QUESTION 1 25

Solutions

Expert Solution

  • All working forms part of the answer
  • The same question has been posted numerous times.
  • All answers are at the bottom, after the workings.
  • HIGH LOW Method working for Cost of Goods Sold

Units

Cost

High Level

                        300,000

$                800,000.00

Low Level

                        240,000

$                740,000.00

Difference

                          60,000

$                   60,000.00

A

Difference in Cost

$                   60,000.00

B

Difference in units

                            60,000

C = A/B

Variable cost per unit

$                             1.00

Working

High Level

Low Level

A

Total Cost

$              800,000.00

$                740,000.00

B

Total Units

300000

240000

C

Variable cost per unit

$                           1.00

$                             1.00

D = B x C

Total Variable cost

$              300,000.00

$                240,000.00

E = A - D

Total Fixed Cost

$              500,000.00

$                500,000.00

  • HIGH LOW Method working for Operating Expenses

Months

Units

Cost

High Level

                        300,000

$                450,000.00

Low Level

                        240,000

$                420,000.00

Difference

                          60,000

$                   30,000.00

A

Difference in Cost

$                   30,000.00

B

Difference in units

                          60,000

C = A/B

Variable cost per unit

$                             0.50

Working

High Level

Low Level

A

Total Cost

$              450,000.00

$                420,000.00

B

Total Units

300000

240000

C

Variable cost per unit

$                           0.50

$                             0.50

D = B x C

Total Variable cost

$              150,000.00

$                120,000.00

E = A - D

Total Fixed Cost

$              300,000.00

$                300,000.00

  • Answers

Variable Cost

Fixed Cost

Cost Equation

Cost of Goods Sold

$1.00

per unit

$500,000

= $ 500000 + ($ 1 x Units sold)

Operating Expenses

$0.50

per unit

$300,000

= $ 300000 + ($ 0.50 x Units sold)


Related Solutions

The profit before tax, as reported in the statement of profit and loss for Aileen Ltd...
The profit before tax, as reported in the statement of profit and loss for Aileen Ltd for the year ended 30 June 2020, amounted to $150,000, including the following revenue and expense items: Revenues Sales revenue $600,000 Interest revenue 60,000 Government grant 40,000 Expenses Cost of goods sold 300,000 Bad debts expense 8,000 Depreciation expense – equipment 6,000 Depreciation expense – plant 25,000 Research and development expense 51,000 Wages expense 120,000 Long service leave expense 40,000 The draft statement of...
Zeta Ltd was set up in 2008 in Beijing. The company's statement of profit or loss...
Zeta Ltd was set up in 2008 in Beijing. The company's statement of profit or loss for the year end 31 December 2019 is as follows: RMB RMB Sales 212,654,300 Cost of sales (203,378,200) 9,276,100 Income from Investment 630,000 Other income. 50,000 Total Income 9,956,100 Financial expense (3,768,230) Administrative expense (3,006,000) Marketing expense (1,963,500) Other cost and expense (207,800) (8,945,530) Net profit for 2019 1,010,570       The following information is relevant to the items that was recorded in the...
The statement of profit or loss for Blue Cross (Pty) Ltd for the financial year ended...
The statement of profit or loss for Blue Cross (Pty) Ltd for the financial year ended 28 February 2019 is as follows: R Sales (note 1) 2000 000 Cost of sales (800 000) Gross profit 1200 000 Salaries (450 000) Depreciation (note 3) (100 000) Repairs (15 000) Profit from the sale of machinery (note 4) 30 000 Local dividends received 35 000 Interest received 28 000 Profit before tax 728 000 Note 1 Blue Cross (Pty) Ltd received a...
Question 4 The statement of profit or loss for Blue Cross (Pty) Ltd for the financial...
Question 4 The statement of profit or loss for Blue Cross (Pty) Ltd for the financial year ended 28 February 2019 is as follows: R Sales (note 1) R2000 000 Cost of sales R(800 000) Gross profit R1200 000 Salaries R(450 000) Depreciation (note 3) R (100 000) Repairs R(15 000) Profit from the sale of machinery (note 4) R30 000 Local dividends received R35 000 Interest received R28 000 Profit before tax R728 000 Note 1 Blue Cross (Pty)...
ToyWorks Ltd. is a company that manufactures and sells a single product, which they call a...
ToyWorks Ltd. is a company that manufactures and sells a single product, which they call a Toodle. For planning and control purposes they utilize a monthly master budget, which is usually developed at least six months in advance of the budget year. Their fiscal year end is June 30. During the summer of 2019, Chris Leigh, the ToyWorks controller, spent considerable time with Pat Frazer, the Manager of Marketing, putting together a sales forecast for the next budget year (July...
The profit and loss statement of Kitsch Ltd., an S corporation, shows $100,000 book income. Kitsch...
The profit and loss statement of Kitsch Ltd., an S corporation, shows $100,000 book income. Kitsch is owned equally by four shareholders. From supplemental data, you obtain the following information about items that are included in book income. Selling expenses ($21,200) Tax-exempt interest income 3,000 Dividends received 9,000 §1231 gain 7,000 Depreciation recapture income 11,000 Net income from passive real estate rentals 5,000 Long-term capital loss (6,000) Salary paid to owners (each) (12,000) Cost of goods sold (91,000) a. The...
USE INDIRECT METHOD The profit or loss section of the statement of comprehensive income of ITS...
USE INDIRECT METHOD The profit or loss section of the statement of comprehensive income of ITS NOT OK NOT TO BE OK company for the year ended December 31, 2020 as reproduced below: Sales- 6,100,000 COGS- 3,700,000 GROSS PROFIT- 2,400,000 Gain on sale of equipment- 100,000 Salaries expense- (820,000) Insurance expense- 380,000 Depreciation expense- 220,000 Profit before interest and income tax -1,080,000 Interest Expense- 120,000 Profit before income tax- 960,000 Income tax expense- 288,000 Profit- 672,000 The following info is...
Question 1 Kearsley Ltd manufactures a single product, a laminated product used in kitchen surfaces. The...
Question 1 Kearsley Ltd manufactures a single product, a laminated product used in kitchen surfaces. The standard cost is £118 and is made up as follows:                                                                                                      £ Direct materials             8 sq. metres at £5 per square metre       40.00 Direct labour                 6 hours at £5 per hour                           30.00 Variable overheads       6 hours at £3 per hour                           18.00 Fixed overheads           6 hours at £5 per hour                           30.00                                                                                                 118.00 The standard selling price of the product is £150....
2.2. Develop a profit-and-loss statement for the Westgate division of North Industries. This division manufactures light...
2.2. Develop a profit-and-loss statement for the Westgate division of North Industries. This division manufactures light fixtures sold to consumers through home improvement and hardware stores. Cost of goods sold represents 30% of net sales. Marketing expenses include selling expenses, promotion expenses, and freight. Selling expenses include sales salaries totaling $4 million per year and sales commissions (4% of sales). The company spent $4 million on advertising last year, and freight costs were 4% of sales. Other costs include $2...
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning...
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is March 31. The sales forecast consisted of these few lines: • For the year ended March 31, 2020: 620,000 units at $15.00 each* • For the year ended March 31, 2021: 640,000 units at $16.50 each • For the year ended...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT