Reference no: EM131571689
Problem 1 -
Below you will see an unadjusted trial balance run at month end followed by information needed to make adjusting entries.
|
Baltimore Glass CompanyUnadjusted Trial BalanceJanuary 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 $60,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:- Problems.rar
|
What is relevant range
: 1. What is relevant range? 2. Give two examples of costs that are variable costs and two examples of fixed costs.
|
|
Review case study of different croissants
: A croissant shop has plain croissants, cherry croissants, chocolate croissants, almond croissants, apple croissants, and broccoli croissants.
|
|
Dollar return and percent return
: If you owned 730 shares of Sprint, what was your dollar return and percent return?
|
|
Time to pay off the debt months and effective annual rate
: A loan is offered with monthly payments and a 14.25 percent APR. What’s the loan’s effective annual rate (EAR)?
|
|
Prepare a multi-step income statement
: The company uses a calendar year. Prepare a multi-step income statement. Consider depreciation to be a selling and administrative expense
|
|
Employee benefits payable by the company
: Perth Talent Search has an annual payroll of $150,000. At December 31, 2017 Perth owes salaries of $7,300 of which employee withholdings payable
|
|
How many ways are there to choose a dozen bagels
: A bagel shop has onion bagels, poppy seed bagels, egg bagels, salty bagels, pumpernickel bagels, sesame seed bagels, raisin bagels, and plain bagels.
|
|
Symposium images- black lives matter
: Give each image a title that reflects the main idea you are developing in that slide.
|
|
Framework from the last mini-project
: Copy the framework from the last mini-project and change the rates. Combine the summary tables from these analysis.
|