Reference no: EM131527620

Problem 1 -

Below you will see an unadjusted trial balance run at month end followed by information needed to make adjusting entries.

Baltimore Glass Company Unadjusted Trial Balance January 31, 2017
Acct. No.	Account Title	Debit	Credit
101	Cash	39,512
110	Accounts Receivable	182,610
120	Merchandise Inventory	573,987
125	Supplies on Hand	3,252
130	Prepaid Insurance	1,000
131	Prepaid Rent	7,500
150	Equipment	270,000
160	Accumulated Depreciation		90,000
202	Accounts Payable		110,587
210	Salaries Payable		-
215	Interest Payable		-
220	Current Portion of Long Term Debt		12,000
240	Long Term Debt		120,000
301	Capital Stock		220,000
302	Retained Earnings, 12/31/16		211,144
401	Sales		348,080
510	Cost of Goods Sold	-
520	Advertising Expense	1,000
530	Sales Salaries Expense	18,600
531	Sales Commission Expense	-
532	Supplies Expense	-
540	Office Salaries Expense	12,950
550	Utilities Expense	-
555	Insurance Expense	-
558	Rent Expense	-
560	Professional Fees Expense	1,400
570	Depreciation Expense	-
580	Interest Expense	-
		1,111,811	1,111,811

Adjusting items and notes:

1. The company uses a calendar year.

2. Insurance was prepaid at the beginning of the year by paying $6,000 for a 12 month policy.

3. It is estimated that supplies on hand equal $2,000 at month end.

4. The rent is prepaid quarterly and $7,500 covered the first quarter of 2017.

5. Equipment was all purchased at one time and has a life of 10 years with no salvage value.  The equipment was 40 months old at the end of October.

6. At month end sales commissions of $3,000 were earned but unpaid.  The company records sales commission liability as a salary liability.

7. The interest rate on long term debt is 6% per year.  Interest will actually be paid at the end of each calendar quarter. (Don't forget the current portion of debt)

8. It is estimated that electricity usage equaled $800 during January and the company expects to be billed in early February. Bills for utilities are entered into accounts payable.

9. The company has a long history of cost of goods sold and 70% is a reasonable estimate to use for monthly financial statements.

10. The company considers sales salaries, commissions, supplies, and advertising to be selling expense and all other expenses to be administrative.

Do the following requirements below.  Create proper headings for each statement.

1. Record adjusting journal entries from information above.  You will need to calculate cost of goods sold to adjust inventory.  Draw T-accounts on your draft to help figure this out.

2. Prepare an adjusted trial balance including the adjusting entries made

3. Prepare a multi-step income statement.  Consider depreciation to be a selling and administrative expense.  Include a detailed cost of goods sold section including purchases and goods available for sale.

4. Prepare a statement of retained earnings

5. Prepare a classified balance sheet

6. Prepare closing journal entries including an entry to adjust the inventory balance. Prepare entries to income summary and retained earnings even though this is a month end only.

Problem 2 -

Compute the ending inventory using LIFO for both the  periodic and the perpetual methods below:

		units	price
1-Jan	Beginning inventory	3,500	$                     3.00
14-Jan	Bought	1,500	$                     3.15
5-Feb	Sold	1,000
22-Feb	Bought	2,000	$                     3.20
7-Mar	Sold	1,500
15-Mar	Sold	2,000
5-Apr	Bought	1,000	$                     3.25
10-Apr	Sold	800
12-Apr	Sold	800
22-Apr	Sold	500
4-May	Sold	600
10-May	Bought	2,000	$                     3.30
25-May	Sold	500

Attachment:- Assignment File.rar