Periodic Inventory Method

Problem:

Rockford Corporation is a wholesale plumbing supply distributor. The corporation was organized in 1981, under the laws of the State of Illinois, with an authorized capitalization of 10,000 shares of no-par common stock with a stated value of $30 per share. The common stock is sold over the counter in the local area. You have been hired as of Monday, December 27, 2010, to replace the controller, who has resigned. As controller, you are responsible for the corporations accounting records, preparation of the financial statements, safeguarding the corporate assets, and providing management with financial information to set prices and to monitor and control operations. You have an assistant who keeps the payroll records, the plant asset ledger, and the perpetual inventory (by quantity only). The corporation secretary maintains the stockholder records, and the receptionist/secretary acts as the petty cashier.

Rockford Corporation closes its books annually on December 31 but prepares financial statements quarterly. Adjusting entries are posted to the general ledger only at year-end; at the end of the first, second, and third quarter the adjustments are entered only on a ten-column work sheet, not in the general ledger. Therefore, the adjusting entries to be recorded on December 31 are annual adjustments that you must journalize and then post to the general ledger accounts before preparing the financial statements.

Rockford Corporation maintains a quantity-only perpetual inventory system and takes a physical count on December 31 to cost the inventory on hand and to adjust the inventory carrying amount per the general ledger. Purchases are recorded at the gross amount (discounts taken are recognized at the date of payment) of the suppliers invoice, and the terms vary with each supplier. Sales on account are subject to terms of 2/10, n/30. Discounts are taken and granted only when the terms are met. The corporation uses the following journals and ledgers:

JOURNALS

2. A sales journal (S)to record sales of merchandise on account.
3. A purchases journal (P)to record purchases of merchandise on account.
4. A cash receipts journal (CR)to record all cash receipts.
5. A cash disbursements journal (CD)to record all cash payments.
6. A general journal (J)to record all transactions that cannot be recorded in the other journals.

LEDGERS

2. A general ledger.
3. An accounts receivable subsidiary ledger.
4. An accounts payable subsidiary ledger.

In recording sales transactions, each sale should be posted on the day of the sale directly to the customers account in the subsidiary ledger, using the invoice number as the posting reference number in the subsidiary account. Also, cash receipts from customers should be posted to the subsidiary ledger on the day they are received. The purchase order number should be used as the posting reference number in the subsidiary ledger for purchases on account from suppliers. Purchases from suppliers and payments to them should be posted daily. All other individual posting may be made weekly or at the month-end. Account numbers should be used as posting reference numbers in the journals. Officers, sales, and office personnel are salaried employees and are paid monthly on the last day of each month. The delivery truck drivers and warehouse employees are hourly wage employees and are paid biweekly. Each biweekly pay period ends Friday. On the following Monday your assistant, who maintains the payroll records, provides you with a payroll summary from which you prepare general journal entries to record the biweekly payroll and the employers taxes on the payroll. The biweekly employees paychecks are distributed on the following day (Tuesday).

The January 1, 2010, balances appear in the general ledger accounts as well as the November 30, 2010, balances, for those accounts whose balances have changed. The balance in Treasury Stock-Common account consists of 700 shares. All transactions affecting the noncurrent accounts from January 1, 2010, through November 30, 2010, with explanations, appear in these accounts to facilitate the preparation of the statement of cash flows. Subsidiary ledger account balances as of November 30, 2010, are as follows (the balances appear in the appropriate subsidiary ledger accounts):

Accounts Receivable

Boecker Builders	$62,920
The Potts Company	50,300
Swanson Brothers Construction	24,050
Trudys Plumbing	15,100
Coconino Contractors, Inc.	27,800
Rankin Plumbing Corp.	74,350
Beverlys Building Products	14,000
Bilder Construction Company	45,200
Iwanaga Plumbing and Heating	3,700
Total accounts receivable	$317,420

Accounts Payable

Phoenix Plastics	$17,450
Edwards Plumbing Supplies, Inc.	20,050
Oxenford Copperworks	26,400
Smith Pipe Company	38,100
Ron & Rods Plumbing Products	14,850
Khatan Steel Corp.	10,000
Total accounts payable	$126,850

The transactions through December 23 have already been recorded by the former controller. You are to begin your work by entering the transaction of December 27 for the payment of cash to repurchase stock.

December

1

Received a check in the amount of $23,569 from Swanson Brothers Construction in full payment of invoice No. 1120 dated November 26 in the amount of $24,050.

1

Sold sewer and drainage pipe to Beverlys Building Products on account, invoice No. 1201 for $13,150.

2

Purchased copper tubing and fittings from Edwards Plumbing Supplies Inc. on account, purchase order No. 315 for $24,320, terms n/60.

2

Issued check No. 1580 for $26,400 to Oxenford Copperworks in settlement of the balance owed on purchase order No. 280.

3

A court notice indicates that Iwanaga Plumbing and Heating is bankrupt and payment of its account improbable; the president orders the account to be written off as a bad debt (invoice No. 780).

3

Sold bathroom fixtures to Bilder Construction Company on account, invoice No.1202 for $44,900.

6

Received a check in the amount of $49,294 from The Potts Company in full payment of invoice No. 1128 dated November 27 for $50,300.

6

Sold plumbing supplies and plastic pipe to Coconino Contractors, Inc. on account, invoice No. 1203 for $10,300.

6

Issued check No. 1581 for $810 to Standard Oil Co. in payment of gas, oil, and truck repair from Tierneys Standard Service.

7

Issued check No. 1582 for $9,900 to Khatan Steel Corp. in full settlement of purchase order No. 312 for $10,000.

7

Issued check No. 1583 for $10,486 to Phoenix Plastics in full payment of Phoenixs invoice dated November 28 in the amount of $10,700, for purchase order No. 313, terms 2/10, n/30.

7

Received a check in the amount of $72,863 from Rankin Plumbing Corp. in full payment of invoice No. 1129 dated November 28 for $74,350.

7

The payroll summary for the biweekly pay period ended Friday, December 3 contained the following information:

Delivery and warehouse wages..............................	$4,860
FICA taxes withheld ................................................	350
Federal income taxes withheld ..............................	900
State income taxes withheld ..................................	190
Net pay..............................................................	$3,420
Employers payroll taxes:
FICA tax ............................................................	$350
Federal unemployment tax..............................	-
State unemployment tax ..................................	-

Issued check No. 1584 for the amount of the net pay and deposited it in the payroll bank account. Individual payroll checks were then prepared for distribution to the biweekly employees on Tuesday, December 7.

8

Sold cast pipe to Trudys Plumbing on account, invoice No. 1204 for $26,300.

8

Received a check in the amount of $27,800 from Coconino Contractors, Inc. in full payment of invoice No. 1091 dated October 20.

8

Purchased bathroom fixtures from Phoenix Plastics, on account, purchase order No. 316 for $52,700 terms 1/10, n/30.

9

Received a check in the amount of $29,000 from Boecker Builders in partial payment of balance outstanding covering invoice Nos. 1050 and 1071.

9

Issued check No. 1585 for $600 to Scooter Gordon for lettering and sign painting on some delivery trucks.

9

Issued check No. 1586 for $6,750 to Phoenix Plastics, in payment of Phoenixs invoice dated November 10 in the amount of $6,750, our purchase order No. 299.

10

Issued check No. 1587 for $37,719 to Smith Pipe Company in full payment of their invoice dated November 28, terms 1/15, n/60, our purchase order No. 314.

10

Received a check in the amount of $15,100 from Trudys Plumbing in full settlement of invoice No. 1106 dated November 7.

10

Sold pipe, fixtures, and accessories to Trudys Plumbing on account, invoice No. 1205 for $24,850.

13

Sold plumbing supplies and copper tubing to The Potts Company on account, invoice No. 1206 for $31,450

13

Received a check in the amount of $33,920 from Boecker Builders in full payment of invoice No. 1071.

13

Cash sales to date totaled $12,292.

14

Received a check in the amount of $25,774 from Trudys Plumbing in payment of invoice No. 1204.

14

Sold plumbing fixtures and supplies to Boecker Builders, on account, invoice No. 1207 for $21,730.

15

The Potts Company returned defective copper tubing that it purchased on December 10. A credit memo in the amount of $4,680 is issued relative to invoice No. 1206.

15

The defective copper tubing is returned to Edwards Plumbing Supplies, Inc. along with a debit memo in the amount of $3,550 in reduction of purchase order No. 315.

15

Issued check No. 1588 for $399 in payment of November telephone bill to Northern Illinois Communications.

16

Issued check No. 1589 in the amount of $11,360 in payment of federal withholding taxes, $9,573, and FICA taxes, $1,787, payable on November salaries and wages; the check is remitted to the Winnebago County Bank as the depository.

16

Issued check No. 1590 for $52,173 to Phoenix Plastics, Inc. in payment of purchase order No. 316.

17

The president informs you that Bilder Construction Company agrees to convert the $45,200 overdue account receivable (invoice No. 1120) to a 14% note due six months from today.

17

Purchased plumbing materials from Smith Pipe Company on account, purchase order No. 317 for $43,800 terms 1/15, n/60.

17

Sold drain tile, plastic pipe, and copper tubing to A & B Hardware on account, invoice No. 1208 for $7,920.

20

Sold fixtures and materials to Coconino Contractors, Inc. on account, invoice No. 1209 for $42,780.

20

An invoice in the amount of $1,021 was received from S. White Trucking Company for transportation-in on purchase order No. 317 and paid by issuing check No. 1591.

20

Received a check in the amount of $24,353 from Trudys Plumbing in payment of invoice No. 1205.

21

Purchased office supplies from the Pen & Pad, issuing check No. 1592 in the amount of $1,360. (Note: Debit asset account).

21

The payroll summary for the biweekly pay period ended Friday, December 17, contained the following information:

Delivery and warehouse wages..............................	$5,770
FICA taxes withheld ................................................	415
Federal income taxes withheld ..............................	1,067
State income taxes withheld ..................................	225
Net pay..............................................................	$4,063
Employers payroll taxes:
FICA tax ............................................................	$ 415
Federal unemployment tax..............................	-
State unemployment tax ..................................	-

Issued check No. 1593 for the amount of the net pay and deposited it in the payroll bank account. Individual payroll checks were then prepared for distribution to the biweekly employees on Tuesday, December 21.

22

Purchased a new Faith computer for $6,100 from Business Basics, Inc., purchase order No. 318, paying $600 down through Check No. 1594 with the balance due in thirty days (n/30). The computer has an estimated life of five years with a salvage value of $1,300. Use subsidiary account No. 16. Journalize the entire entry in the cash disbursements journal.

22

Purchased bathroom and kitchen fixtures from Phoenix Plastics, on account, purchase order No. 319 for $48,330, terms 1/10, n/30.

23

Received a bill from DeKalb Transport for $2,300 for transportation-in costs incurred during the last 30 days, terms n/30. NOTE: Transactions up to this point have been recorded. At this point you became controller and are responsible for recording all further transactions.

27

The board of directors voted to purchase 1,000 shares of its own stock from stockholder Dionne Schivone at $83 per share and issued check No. 1595 in payment. Stock repurchases are recorded at cost. Rockford is purchasing these shares because Ms. Schivone had been a valuable employee.

27

The board of directors declared a $2.70 per-share cash dividend payable on January 14 to stockholders of record on December 27 (after purchase of stock).

27

The president informs you that Beverlys Building Products agrees to convert the $14,000 overdue accounts receivable (invoice No. 1119) balance to a 12% note due six months from today.

28

A half-acre parcel of land adjacent to the building is acquired in exchange for 600 shares of unissued common stock. The land has a fair value of $54,000 and will be used immediately as an outside storage lot and parking lot.

28

An invoice in the amount of $2,650 is received from Wayne McManus, lawyer, for legal services involved in the acquisition of the adjacent parcel of land; check No. 1596 is issued in payment.

28

Sold pipe and plumbing materials to Boecker Builders on account, invoice No. 1210 for $42,040.

29

Issued check No. 1597 in the amount of $500 to the Northern Star for advertisement run in the home building supplement of December 15.

29

Issued check No. 1598 in the amount of $925 to Standard Oil Co. in payment of gas, oil, and truck repairs from Standard Oil Co. (use Freight-out).

29

Purchased copper and cast iron pipe from Oxenford Copperworks on account, purchase order No. 320 for $55,940, terms 1/10, n/30.

29

Check No. 1599 for $15,000 is issued to the bond sinking fund trustee, Chicago Trust Co., for deposit in the sinking fund (use Other Assets).

30

Received a check for $21,730 from Boecker Builders in payment of invoice No. 1207.

30

Sold plumbing supplies to Swanson Brothers Construction on account, invoice No. 1211 for $24,650.

30

Issued check No. 1600 for $43,362 to Smith Pipe Company in payment of purchase order No. 317.

31

The custodian of the petty cash fund submits the following receipts for reimbursement and reports a cash-on-hand count of $8.

Postage stamps used ..............................................	$38
United Parcel (freight-out) ....................................	23
C.O.D. postage (freight-in) ....................................	51
Christmas office decorations ..................................	30

Check No. 1601 is issued and cashed to reimburse the fund.

31

Sold an electric truck-lift to Leila Stierman Co. for $2,500 cash. The original cost was $7,900 with salvage value of $900, a life of 10 years, and accumulated depreciation recorded through 12/31/09 of $4,550. The straight-line method is used. (Note: the company follows the practice of recording a half years depreciation in the year of acquisition and a half year in the year of disposal.) First, bring the depreciation expense up to date in the general journal. Then journalize the entire entry for the sale in the general journal.

31

Sold bathroom fixtures and plumbing supplies to Trudys Plumbing on account, invoice No. 1212 for $55,770.

31

Because for some time the petty cash fund has been smaller than required for monthly expenditures, the fund is increased by $75 by cashing check No. 1602 and placing the money in the petty cash fund.

31

The payroll summary for the monthly paid employees is submitted so that December checks can be distributed before the year-end; the details are as follows:

Sales salaries ............................................................	$16,000
Office and administrative salaries..........................	22,900
Federal income taxes withheld ..............................	7,196
State income taxes withheld ..................................	1,517
FICA taxes withheld ................................................	2,120
Net pay..............................................................	$28,067

Issued check No. 1603 for the amount of the net pay and deposited it in the payroll bank account. Individual payroll checks were prepared for distribution to all monthly employees by the end of the day.

Employers payroll taxes:
FICA tax (all office and administrative)..........	$2,120
Federal unemployment tax..............................	-
State unemployment tax ..................................	-

31

Cash sales since December 13 total $25,980.

Adjusting entries

2. The annual provision for doubtful accounts receivable is recorded by providing a charge to Bad Debt Expense in an amount equal to 2% of net sales.
3. An inventory count of the office supplies revealed $830 of supplies on hand at year end.
4. A physical inventory on Friday, January 7, 2011, results in a total dollar value assigned to the ending inventory at lower of cost or market of $539,930 (use Income Summary account for adjustment purposes).
5. The insurance premium outstanding on January 1, 2010, covers the period January 1 through August 31, 2010. The insurance premium of $7,050 recorded in August covers the period of September 1, 2010 through August 31, 2011. Rockford estimates that 75% of the premiums are attributable to general activities and 25% to selling activities (use Miscellaneous Selling Expense).
6. The payroll summary for the employees who are paid biweekly shows the following information at December 31, 2010:

   Delivery and Warehouse Wages ............................	$5,600
   FICA Taxes Payable ................................................	375
   Federal Withholding Taxes ....................................	1,036
   State Withholding Taxes..........................................	218
   Net pay..............................................................	$3,971

7. The employer?s share of the FICA tax ($375) must be accrued; no state or federal unemployment tax is incurred during the fourth quarter because all wages and salaries earned during the last quarter exceed the maximum subject to unemployment tax.
8. Interest has accrued at 8% on the mortgage notes payable since July 1, 2010. The next six-month interest payment at 9% on the bonds is due on March 1, 2011. The discount on bonds payable has not been amortized for any part of 2010; the bonds are dated March 1, 2004, and mature March 1, 2014. (Use straight-line.)
9. The interest accrued to 12/31/10 on notes receivable is composed of the following:

   Platteville Plumbers, 10%, 6 months, due March 31, 2011	$1,125
   Bilder Construction, 11%, 6 months, due June 14, 2011	232
   Beverly?s Building, 9%, 6 months, due June 26, 2011	17
   	$1,374

   The interest accrued at 12/31/10 on the note payable of $15,000 @ 10% is $1,500. Interest is payable on January 2, 2011. (The note is due in 2011.)
10. A warehouse lease payment of $10,890 was made on September 1, 2010, for rental through February 28, 2011. (The Prepaid Rent account is for advance lease payments on the warehouse.)
11. $530 is owed to Northern Electric Co. and $279 is owed to City of Rockford for utility services provided during December 2010.
12. Plant and equipment to be depreciated are composed of the following:

    Assets	Date Acquired	Cost	Estimated usage or Life	Salvage Value		Depreciation Method
    Building	7/1/06	$306,000	25 years	$20,000		sum-of-the-years? digits
    Truck No. 1	4/1/07	28,000	60,000 miles	3,100		miles driven
    Truck No. 2	9/1/09	33,000	60,000 miles	4,200		miles driven
    Lift No. 1	8/17/03	7,900	10 years	900		straight-line
    (Sold 12/31/10)
    Lift No. 2	3/29/07	4,500	10 years	500		straight-line
    Lift No. 3	9/16/08	5,000	10 years	500		straight-line
    Office	All prior to	32,800	7 years	2,000		straight-line
    Equipment	1/1/10
    Computer	12/22/10	6,100	5 years	1,300		Double-decling balance

    Truck No. 1 has been driven 45,000 miles prior to 1/1/10 and truck No. 2 has been driven 30,500 miles prior to 1/1/10. During 2010 truck No. 1 was driven 12,000 miles and truck No. 2 was driven 14,000 miles. Remember that the Rockford Company takes a half-year?s depreciation in the year of acquisition and a half-year in the year of sale.
13. Complete the work sheet. In completing the worksheet, compute State of Illinois corporate income taxes at 41/2% of pretax income. The state income tax is deductible on the federal tax return, and the federal tax is not deductible on the Illinois return. Assume federal corporate income tax on income subject to federal tax is as follows:

    first $50,000	@15%
    next 25,000	@25%
    remainder	@34%

    Income between $100,000 and $335,000 is assessed a 5% federal surtax, not to exceed $11,750. Hint: Corporations subject to federal income tax must make estimated tax payments throughout the year. At the time of the payment, the account Income Tax Expense is debited and Cash is credited. To determine the taxable income at year end, net the total debits and total credits from the income statement in the worksheet. Note that the estimated income tax expense is listed as a debit and must be subtracted from total debits when determining taxable income (federal tax is not a deductible item).