Question

In: Accounting

J Horner is the proprietor of a shop selling paintings and ornaments. For the purposes of...

J Horner is the proprietor of a shop selling paintings and ornaments. For the purposes of his financial statements he wishes the business to be divided into two departments:

Dept. A Paintings

Dept. B Ornaments

The following balances have been extracted from his nominal ledger at 31 August 2016:

Debit

Credit

K

K

Sales Department A

75,000

Sales Department B

50,000

Stocks Department A, 1 September 2015

1,250

Stocks Department B, 1 September 2015

1,000

Purchases Department A

51,000

Purchases Department B

38,000

Wages of sales assistants Department A

7,200

Wages of sales assistants Department B

6,800

Picture framing costs

300

General office salaries

13,200

Fire insurance – buildings

360

Lighting and heating

620

Repairs to premises

175

Internal telephone

30

Cleaning

130

Accountancy charges

1,490

General office expenses

510

Inventory at 31 August 2016 valued at:

Dept. A K1, 410

Dept. B K912

The proportion of the total floor area occupied by each department was:

Dept. A two-fifths

Dept. B three- fifths

The apportionment should be made by using the methods as follows:

Area-fire insurance, lighting and heating, repairs, telephone, cleaning; turnover-general office salaries, accountancy, general office expenses.

Required:

  1. Prepare Sishwashwa’s department income statement for the year ending 31 August 2016, apportioning the costs, where necessary, to show the net profit or net loss of each department.
  2. Explain the purpose of preparing a departmental Income statement

Solutions

Expert Solution

Answer (a)

Turnover apportionment( ratio)

For Dept A = Dept A Turnover/( Total Turnover of departments) = 3/5

For Dept B = Dept B Turnover/( Total Turnover of departments) = 2/5

Area based apportionment( ratio)

For Dept A = 2/5 (given)

  For Dept B = 3/5 ( given)

Application of apportionment

For Dept A & B; Respective expense head * respective ratio( based on area or turnover apportionment)

Sishwashwa’s department income statement for the year ending 31 August 2016
Particulars Department A (k) Department B (k)
Operating Revenue
Sales                              75,000.00                 50,000.00
Closing Inventory                                1,410.00                     912.00
Total                              76,410.00                 50,912.00
Less:
Operational Expense
Opening Inventory                                1,250.00                  1,000.00
Purchase                              51,000.00                 38,000.00
Wages of sales assistants                                7,200.00                  6,800.00
Picture framing cost                                   300.00                            -  
Total                              59,750.00                 45,800.00
Less:
General Expenses
General office salaries                                7,920.00                  5,280.00
Fire insurance-building                                   144.00                     216.00
Lightning & Heating                                   248.00                     372.00
Repairs to premises                                    70.00                     105.00
Internal telephone                                    12.00                       18.00
Cleaning                                    52.00                       78.00
Accountancy Charges                                   894.00                     596.00
General Office expenses                                   306.00                     204.00
                               9,646.00                  6,869.00
Total expenditure                              69,396.00                 52,669.00
Net Profit / ( Loss)                                7,014.00                 (1,757.00)
Department A : Net profit of K7,014
Department B : Net loss of K1,757

Workings

Area based apportionment( 2:3)
Particulars Dept A Dept B Total
Fire insurance              144.00             216.00             360.00
Lightning & Heating              248.00             372.00             620.00
Repairs                70.00             105.00             175.00
Telephone                12.00               18.00               30.00
Cleaning                52.00               78.00             130.00
Turnover based apportionment( 3:2)
Particulars Dept A Dept B Total
General Office salaries           7,920.00          5,280.00        13,200.00
accountancy              894.00             596.00          1,490.00
general office expense              306.00             204.00             510.00

Answer (b)

Departmental income statement helps the owners to identify which unit is more profitable and which department is utilising more money. Thus department wise income statement helps the owner to control the operational activities of each department and helps to analyse the running of each department.


Related Solutions

Frank is the sole proprietor of a small business.  In 2019, the business income for purposes of...
Frank is the sole proprietor of a small business.  In 2019, the business income for purposes of computing the Section 179 deduction is $350,000.  During the year, the following assets were placed in service.  (Assume no bonus depreciation) Asset # 1 – Machinery  - $1,790,000 Asset # 2 – Equipment - $365,000 Asset # 3 – Computer - $96,000 Asset # 4 – Equipment - $468,000 3a) Calculate the amount of the phase out limitation? 3b) What is the maximum amount of Section 179...
Larry is the sole proprietor of a trampoline shop. During 2017, the following transactions occurred. •...
Larry is the sole proprietor of a trampoline shop. During 2017, the following transactions occurred. • Unimproved land adjacent to the store was condemned by the city on February 1. The condemnation proceeds were $15,000. The land, acquired in 1986, had an allocable basis of $40,000. Larry has additional parking across the street and plans to use the condemnation proceeds to build his inventory. • A truck used to deliver trampolines was sold on January 2 for $3,500. The truck...
. A bike shop is selling a fashionable newly designed folding bike. The shop is now...
. A bike shop is selling a fashionable newly designed folding bike. The shop is now considering how many of them to order for the coming season. The supplier requires that orders for the bikes must be placed in quantities of 25. The cost per bike is $820, $790, $750 and $700 for an order of 25, 50, 75 and 100 respectively. The bikes will be sold for $1,200 each. Since there will be a new design for folding bikes...
Tim’s Bicycle Shop sells 21-speed bicycles. For purposes of a cost-volume-profit analysis, the shop owner has...
Tim’s Bicycle Shop sells 21-speed bicycles. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows: Product Type Sales Price Invoice Cost Sales Commission High-quality $ 1,150 $ 490 $ 70 Medium-quality 570 270 60 Three-quarters of the shop’s sales are medium-quality bikes. The shop’s annual fixed expenses are $196,500. (In the following requirements, ignore income taxes.) Required: Compute the unit contribution margin for each product type. What is the shop’s sales mix?...
J&W’s Fabrication Shop (J&W) sells fabricated parts to General Motors Corporation. General Motors normally pays on...
J&W’s Fabrication Shop (J&W) sells fabricated parts to General Motors Corporation. General Motors normally pays on a net 30 day basis (within 30 days of the delivery date). But when the economic slowdown occurred, GM started paying net 120 days. Based on the last shipment from two weeks ago, GM owes J&W 320 thousand dollars.   J&W’s cash flow is thin and they need to borrow money to meet payroll for ninety days. Regina has been approached by J&W who has...
You are the owner of a chain of tea shop in Thailand, brewing and selling the...
You are the owner of a chain of tea shop in Thailand, brewing and selling the latest types of teas internally but buying all necessary factors from the market. Your 50 or so shops located around the city can seat around 20 patrons each and currently only sell caffeinated drinks. At this stage of growing your business you are considering vertical and horizontal integration. Using the theory of the optimal boundary of the firm, discuss the make-or-buy decision as well...
A retail shop has monthly costs of $2,000 selling the best-selling product for $20 per unit....
A retail shop has monthly costs of $2,000 selling the best-selling product for $20 per unit. Variable costs are 1/3 of the unit price. Find the BEP What profit (or loss) would result by selling 3,000 units? How many units were sold if the total profit per one year was $16,000? What is the variable cost for the quantity of (c)?
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2008, the following data are developed:       Sales:                                                                20,000 units Unit selling price:                                                       RM35 Variable costs per RM of sales:             Sales commissions                                                 6%             Delivery expense                                                   2%             Advertising                                                            4% Fixed costs per quarter:             Sales salaries                                             RM24,000             Office salaries                                                  17,000             Depreciation                                                      6,000             Insurance                                                            2,000             Utilities                                                              1,000 Prepare a selling and administrative...
irkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget....
irkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. 1. Sales: 20,800 units quarter 1; 22,100 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,900, office salaries $6,160, depreciation $4,490, insurance $2,080, utilities $880, and repairs expense $670. 4. Unit selling price: $24....
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense...
Valquez Manufacturing Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2016, the following data are developed: 1.   Sales: 20,000 units; unit selling price:                       $35 2.   Variable costs per dollar of sales:             Sales commissions                                                6%             Delivery expense                                                   2%             Advertising                                                             4% 3.   Fixed costs per quarter:             Sales salaries                                                $24,000             Office salaries                                                  17,000             Depreciation                                                       5,000             Insurance                                                           1,000             Utilities                                                               2,000 Instructions Prepare a selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT