Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

NOTE: 20YY = 2015 the current year 20YY -1 = 2014 the prior year. Monthly Transa

ID: 2467830 • Letter: N

Question

NOTE:

20YY = 2015 the current year

20YY -1 = 2014 the prior year.

Monthly Transactions and Closing Transactions

For each event listed below, prepare a journal entry to reflect the event

DESCRIPTION OF EVENTS OCCURRING during the month of January, 20YY

#

Date

Description of Event

1

January 3

Employees are paid monthly on the first business day of the month for work done in the previous month. The total payroll for the previous month is $100,000. (Ignore payroll taxes for this assignment.) Accounting wrote and distributed the paychecks.

2

January 3

GBI received payment of $20,750 from Northwest Bikes in Seattle, WA for the balance due on their account.

3

January 3

Windy City Bikes in Chicago, IL ordered $23,525 of bicycle accessories (trading goods inventory) from GBI. The cost of the accessories (to GBI) is $13,280. The goods were shipped to Windy City immediately via UPS using Windy City’s UPS shipping number.

4

January 7

GBI received $16,544 in safety product inventory ( trading goods) and $18,119 in raw materials from Dallas Bike Basics. This inventory was ordered on December 28.

5

January 10

GBI paid the December 2014 accrued utility bill of $988.

NOTE: GBI’s account on the utility company website is updated at the end of each month when the meter is read. GBI uses this data to accrue the expenses at the end of each month (in this case on December 31st.) This allows recognition of the expense in the correct period. Expenses are usually accrued at the end of the month as “Accrued Expenses.”

6

January 10

GBI’s advertisement in the English language edition of Italian Cycling Journal was published today. This ad was prepaid at the end of October 2014 for six months of advertising, November 2014 through April 2015, (Two months of advertising have already been used through December 2014.)

7

January 10

GBI received payment from Windy City Bikes for their order from January 3.

8

January 12

GBI paid for the inventory order that they received from Dallas Bike Basics January 7.

9

January 17

GBI paid an invoice from Lightbulb Accessory Kits for ordered goods that were received on December 20. The amount of the invoice from Lightbulb is $14,000 due net 30.

10

January 17

Rocky Mountain Bikes in Denver, CO placed an order with GBI for $128,130 worth of bicycles to be delivered immediately. Rocky Mountain will pay the shipping. The bikes cost GBI $79,441. GBI shipped the order immediately so that Rocky Mountain can start promoting the bikes.

11

January 20

GBI received notice that Bunky’s Bicycle Emporium had declared section 13 bankruptcy which meant GBI would not be able to collect the $1,460 that Bunky’s owed them.

12

January 20

GBI sent a $15,000 check to Night Rider Aluminum Products for an order of bicycle parts GBI received December 30th.

13

January 31

GBI pays sales tax once a quarter via the state’s electronic filing and payment system. GBI filed its return and paid $3,063 in sales tax for the prior quarter ending December 31.

Using these account balances and additional adjustment information below, record adjusting journal entries. Adjustment information as of January 31, 20YY not already given in the original transaction(s):):

1.Production Machinery, Equipment and Fixtures were placed in service on January 1, 2010, are expected to last 20 years with no salvage value. GBI depreciates fixed assets on a straight-line basis and those assets acquired in the first half of the month are depreciated for the entire month, while fixed assets placed in service during the last half of the month are not depreciated until the second month. Depreciation is rounded to the nearest dollar and assets are depreciated on a monthly basis (i.e. number of days in the month is not of consequence).

2. GBI used the Internet to review the monthly charges for utilities the business consumed during January. Based on the internet report, the amount to be billed by the utilities company for January usage is $996.*** SEE NOTE****

3. GBI counted the office supplies (Inventory – Operating Supplies) on hand after the close of business on the last day of the month and determined the cost of the unused office supplies to be $480. Any difference is expensed to supplies expense. *** SEE NOTE****

                                                                                          

4. Liability insurance for the six month period October 1, 2014 - March 31, 2015 in the amount of $15,000 was paid September 1, 2014. Liability insurance is assumed to be utilized uniformly over the six month policy period. Determine any January 20YY expense.

5. GBI needs to recognize the wages expense for the month. Since all employees are paid salaries and no changes have been made, this amount is the same as the previous month salaries. (For purposes of this assignment, ignore manufacturing and assume all labor costs will be expensed. Ignore payroll taxes). *** SEE NOTE****

NOTE: You may get an error message on these entries that says “Account xxx requires an assignment to a CO Object”. Please see the instructions for Entering Journal Entries for how to work through this message and resolve it.

Chart of Accounts – GBI GL00

           

G/L Account

G/L Acct Long Text

100000

Bank Account

110100

Accounts Receivable (Direct Posting Account)

110150

Allowance for Bad Debts

110200

Interest Receivable

200600

Inventory-Operating Supplies

200900

Inventory-Raw Materials (Direct Post)

200910

Inventory-Finished Goods (Direct Post)

200920

Inventory-Trading Goods (Direct Post)

200930

Inventory-Semi-finished Goods (Direct Post)

210000

Prepaid Insurance

211000

Prepaid Supplies

212000

Prepaid Advertising

215000

Prepaid Rent

216000

Deposits on Purchases

220000

Notes Receivable

220110

Land (Direct Post)

220210

Production Machinery, Equip & Fixtures(Dir.Post)

220310

Accumulated Depreciation-Machinery (Direct Post)

220400

Office Furniture

220500

Accumulated Depreciation-Office Furniture

220600

Office Equipment and Computers

220700

Accumulated Depreciation - Office Equipment

300100

Payables-Income Taxes

300200

Accounts Payable (Direct Posting Account)

300300

Payables-Interest

300400

Payables-Short-Term Notes

300500

Payables-Long-Term Notes

300600

Payables-Commissions

300700

Payables-Salaries and Wages

300800

Accrued Expenses

310000

Goods Receipt / Invoice Receipt Account

320000

Accrued Tax – Output

321000

Accrued Tax- Input

322000

Unearned Revenues

329000

Common Stock

329100

Additional Paid-in-Capital

330010

Retained Earnings (Direct Posting)

600000

Sales Revenue

610000

Sales Discount

620000

Miscellaneous Revenue

630000

Revenue Deductions

640000

Gain or Loss on Sale of Assets

650000

Customer Service Revenue

650100

Customer Service Revenue Settlement

700000

Labor Expense

720000

Raw Material Consumption Expense

720100

Finished Product Consumption Expense

720200

Trading Good Consumption Expense

720300

Semi-Finished Consumption Expense

740000

Supplies Expense

740100

Telephone and Internet Expense

740200

Legal and Professional Expense

740300

Rent Expense

740400

Insurance Expense

740500

Payroll Expense-Office

740600

Payroll Expense-Administrative

740700

Sales Expense

740800

Tax Expense - Property

740900

Tax Expense- Income

741000

Miscellaneous Expense

741100

Warranty Expense

741200

Bad Debt Expense

741300

Information Technology Expense Account

741500

Utilities Expense

741600

Manufacturing Output settlement

741700

Manufacturing Output Settlement Variance

741800

Depreciation Expense

741900

Advertising Expense

742000

Vendor Discounts Missed

742100

Shipping Expense

760000

Purchase Price Difference

760100

Production Variance

770000

Research and Development

780000

Cost of Goods Sold

#

Date

Description of Event

1

January 3

Employees are paid monthly on the first business day of the month for work done in the previous month. The total payroll for the previous month is $100,000. (Ignore payroll taxes for this assignment.) Accounting wrote and distributed the paychecks.

2

January 3

GBI received payment of $20,750 from Northwest Bikes in Seattle, WA for the balance due on their account.

3

January 3

Windy City Bikes in Chicago, IL ordered $23,525 of bicycle accessories (trading goods inventory) from GBI. The cost of the accessories (to GBI) is $13,280. The goods were shipped to Windy City immediately via UPS using Windy City’s UPS shipping number.

4

January 7

GBI received $16,544 in safety product inventory ( trading goods) and $18,119 in raw materials from Dallas Bike Basics. This inventory was ordered on December 28.

5

January 10

GBI paid the December 2014 accrued utility bill of $988.

NOTE: GBI’s account on the utility company website is updated at the end of each month when the meter is read. GBI uses this data to accrue the expenses at the end of each month (in this case on December 31st.) This allows recognition of the expense in the correct period. Expenses are usually accrued at the end of the month as “Accrued Expenses.”

6

January 10

GBI’s advertisement in the English language edition of Italian Cycling Journal was published today. This ad was prepaid at the end of October 2014 for six months of advertising, November 2014 through April 2015, (Two months of advertising have already been used through December 2014.)

7

January 10

GBI received payment from Windy City Bikes for their order from January 3.

8

January 12

GBI paid for the inventory order that they received from Dallas Bike Basics January 7.

9

January 17

GBI paid an invoice from Lightbulb Accessory Kits for ordered goods that were received on December 20. The amount of the invoice from Lightbulb is $14,000 due net 30.

10

January 17

Rocky Mountain Bikes in Denver, CO placed an order with GBI for $128,130 worth of bicycles to be delivered immediately. Rocky Mountain will pay the shipping. The bikes cost GBI $79,441. GBI shipped the order immediately so that Rocky Mountain can start promoting the bikes.

11

January 20

GBI received notice that Bunky’s Bicycle Emporium had declared section 13 bankruptcy which meant GBI would not be able to collect the $1,460 that Bunky’s owed them.

12

January 20

GBI sent a $15,000 check to Night Rider Aluminum Products for an order of bicycle parts GBI received December 30th.

13

January 31

GBI pays sales tax once a quarter via the state’s electronic filing and payment system. GBI filed its return and paid $3,063 in sales tax for the prior quarter ending December 31.

Explanation / Answer

Journal Entry Date Particulars Dr. Amt Cr. Amt Jan-03 Payables-Salaries and Wages                Dr.          100,000 2015 To Cash          100,000 (Record the salary paid for the M/o Dec - 2014) Jan-03 Cash                                                                Dr.            20,750 2015    To Acccounts Receivables            20,750 (Record the amount recd from Northwest bikes) Jan-03 Accounts Payable                                     Dr.            23,525 2015     To Sales            23,525 (Record the trading goods inventory billed to Windy City bikes) Jan-03 Cost of Goods sold                                    Dr.            13,280 2015    To Inventory - Trading Goods            13,280 (record the cost of trading inventories sold to Windy city Bike) Jan-07 Inventory - Trading Goods                     Dr.            16,544 2015 Inventory - Raw Materials                     Dr.            18,119    To Accounts Payable            34,663 (record the goods received from Dallas Bie Basics) Jan-10 Accrued Expenses                                    Dr.                  988 2015    To Cash                  988 (Record the Utilities bill paid for the M/o Dec, 2014) Jan-10 No entry 2015 For Publication of advertisement in Italian Cycle Journal Jan-10 Cash                                                             Dr.            23,525 2015    To Accounts Receivables            23,525 (Record the amount received from Windy city bikes) Jan-12 Accounts Payable                                    Dr.            34,663 2015    To Cash            34,663 (record the amount paid to Dallas Bikes Classic) Jan-17 Accounts Receivables                          Dr.            14,000 2015 To Cash            14,000 (Record the amount paid to Lightbulb Accessories Kit) Jan-17 Accounts Receivables                          Dr.          128,130 2015 To Sales          128,130 (Record the bicycles sold to Rock mountain Bikes) Jan-17 Cost of Goods sold                                    Dr.            79,441 2015    To Inventory - Finished Goods            79,441 (record the cost of trading inventories sold to Rocy Mountain Bikes) Jan-20 Bad Debts                                                    Dr.              1,460 2015 To Accounts Receivables              1,460 (record the amount to be received from Bunky Cycle Emporium as Uncollectible or written off) Jan-31 Sales Tax Payable                                   Dr. 3063 2015    To Cash 3063 (Record the sales tax paid for the Qtr ending Dec, 2014) Jan-31 Depreciation Expenses                         Dr. Amount not Given in Question 2015 To Accumulated Dep - Prodtuction Mach To Accumulated Dep - Equipments To Accumulated Dep - Office Furniture (record the Depreciation expenses for the M/o Jan, 2015) Jan-31 Advertising Expense                              Dr. Amount not Given in Question 2015    To Prepaid Advertising (Record the advertising exp. For the M/o Jan 2015 paid in Oct 2014) Jan-31 Utilities Exp.                                             Dr.                  996 2015    To Accrued Expenses                  996 (Record the Utilities Expenses accrued for the M/o Jan 2015) Jan-31 Supplies Exp.                                            Dr. Amount not Given in Question 2015    To Inventory- Operating Supplies (record the supplies expenses for the M/o Jan-2015) Jan-31 Insurance Exp.                                         Dr.              2,500 2015 To Prepaid Insurance              2,500 (Record the Insurance exp. For the M/o Jan 2015) Insurance Exp. For Jan 2015 = $15000 / 6 Months = $2500 Jan-31 Salaries & Wages Exp.                          Dr.          100,000 2015    To Payables - Salaries & Wages          100,000 (Record the salaries payable for the M/o Jan 2105)