Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Are you familiar with the systems understanding aid in the course, Accounting Information Systems? I'm having trouble with recording all the journals. My instructor has
Are you familiar with the systems understanding aid in the course, Accounting Information Systems? I'm having trouble with recording all the journals. My instructor has given me the totals but I can't get the right answers. I've attached the transaction list and journals.
Document No. 1 Transactions List December 16-31, 2013 Complete each of the following transactions in accordance with the seven-step process on pages 11-12 of the Instructions, Flowcharts, and Ledgers book (step 5). Remember the importance of the systems flowcharts on pages 18-24 for details as to (a) documents to prepare, (b) approvals and other internal control procedures, (c) accounting entries, and (d) filing. You are to perform the roles of Ray Kramer, Nancy Ford, and Jim Adams. Some of the following events require the preparation or modification of systems documents and some do not. Although systems documents accompany most business transactions, you are asked to prepare and work with only a representative sample in this project. Each event on the transactions list includes one of three symbols, which determine whether documents from the loose document set in this project must be prepared or used: You are required to prepare or modify documents from the loose document set for this event. An accounting entry may or may not be required. Yes You are not required to prepare or modify documents from the loose document set because documents would not normally be prepared or modified for this type of event. An accounting entry is required, with one exception: the December 20 change in pay rates. No You are not required to prepare or modify documents from the loose document set, although this type of event would normally require you to do so. These events are included to provide additional practice in recording transactions. An accounting entry is required. No Hints are provided in boxed areas like this. December Yes 16 Received validated deposit receipt (Doc. No. 11) from the bank for $7,931.96 deposit made December 14. B Follow flowchart on page 21. No recording occurs at this time. Cash receipts prelist is Doc. No. 9. File Doc. No. 9 and Doc. No. 11 in the Temporary file tab. December Yes 16 Ordered the following inventory on account from Velocity Sporting Goods, using purchase order No. 328 (Doc. No. 16). Units 115 60 70 85 Vendor address: Freight carrier: Freight charges: Allowances: Yes 16 19 1285 Colgrove Avenue, Pierre, SD 57501 Interstate Motor Freight Collect (i.e., paid by Waren Sports Supply) None Follow flowchart on page 22. Use purchase order No. 325 (Doc. No. 16) as a guide. Use the price list (Doc. No. 3). No receiving or recording occurs at this point for this transaction. Tear document apart and file, following the flowchart guidance. Borrowed $80,000 from First American Bank and Trust by issuing a two-year note payable (Doc. No. 14) with a stated annual interest rate of 6%. Check No. 545 (Doc. No. 8) for $80,000 was received from the bank and deposited. Reviewed the terms and conditions of the note and signed it (Ray Kramer) as the borrower. Yes Description Basketball pole pad Basketball bag Portable inflation pump Trainer's first aid kit Restrictively endorse means to write the following on the back of the check: \"For deposit only. Waren Sports Supply.\" See flowchart, page 21, for recording and depositing. Detach the bottom portion of the check and file in the Shipping/Banking file tab. File the note in the Shipping/Banking file tab. Received customer purchase order No. ST3107 (Doc. No. 4) in the mail from Clayborn University, approved their credit and shipped the goods. All goods ordered were shipped, except that only 45 shoulder pad sets were available for shipment. Carrier & number: Allied Trucking; Carrier number 2154 Freight charges: FOB shipping point; Billed to buyer (i.e., paid by Clayborn) Route: Express Truck & driver: Truck 2961XZ, Linda Arensmeier Freight rate: $15.00 per 100 lbs. Shipment: 3 cartons/goal and rim sets @ 26 lbs./carton 6 cartons/backboards @ 125 lbs./carton 5 cartons/shoulder pad sets @ 40 lbs./carton 4 cartons/football helmets @ 24 lbs./carton B 2 See flowchart, pages 18 and 19; follow all steps carefully. You will use several documents and record an entry in the sales journal and the accounts receivable subsidiary ledger for this transaction. For guidance in preparing the bill of lading, see pages 35-36 of the Reference book. December Yes 20 Received sales return request No. R8034 (Doc. No. 12) in the mail from Eastern Wisconsin University (EWU). The request was approved and the acknowledgment copy mailed to EWU. No 20 Increased employee pay rates, and employees changed their federal income tax withholding amounts, both effective December 16. There were no changes in filing status or withholding allowances. New Federal Income Tax New Pay Rate Withholding Amt. Ray Kramer $3,600.00 semimonthly $466.71 Jim Adams $22.00 per hour $365.06 Nancy Ford $18.00 per hour $136.90 Yes 23 Follow the flowchart steps on page 20. No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. Received merchandise from Velocity Sporting Goods as listed on purchase order No. 328. All merchandise listed on the purchase order was delivered in good condition and in the quantities ordered, except that only 100 basketball pole pads (Item No. BB-019) were received. The goods were placed immediately in the inventory warehouse. Freight carrier: Freight bill: Interstate Motor Freight No. 26425 (Doc. No. 19), received with shipment Remember to follow the flowchart on page 22. You can't record a purchase yet because the invoice hasn't been received. Yes 23 Received check No. 28564 (Doc. No. 8) from Branch College for payment in full for charge invoice No. 730, and deposited the check. No 23 Received legal notification from Benson, Rosenbrook, and Martinson, P.C., attorneys at law, that Stevenson College had filed bankruptcy and will be unable to pay any of its outstanding debts to its suppliers. Write off the account as a bad debt. Yes B 24 Remember that Waren Sports Supply uses the \"Allowance\" method rather than \"Direct write-off\" for accounting for bad debts. Received all goods that Waren had authorized Eastern Wisconsin University (EWU) to return on EWU's return request No. R8034 for credit against their account balance. 3 Yes 24 Process and record the sales return now. Received check No. 49326 (Doc. No. 8) for $9,000 from Eastern Wisconsin University in partial payment of the remaining amount (after sales return) on charge invoice No. 729, and deposited the check. Do not finalize a deposit slip until you determine whether there are other cash receipts on the same day. December Yes 24 Received vendor invoice No. 34719 (Doc. No. 18) from Velocity Sporting Goods for goods ordered December 16 and received December 23. Yes 24 Issued a check (Doc. No. 20) to Interstate Motor Freight for the amount of the freight bill (Doc. No. 19) for the Velocity Sporting Goods shipment received December 23. Yes 24 Follow the flowchart steps on page 22. Upon receiving the invoice, you can now record the purchase using the date on which Waren incurred the liability for the goods, December 23. Follow the flowchart steps on page 23. Received check No. 7403 (Doc. No. 8) for $9,165 and customer purchase order No. 94772 (Doc. No. 4) in the mail from Andover University for a cash sale. All goods ordered were shipped and the cash sale was processed and recorded. Carrier & number: Freight charges: Route: Truck & driver: Freight rate: Shipment: No 24 Start with the flowchart on page 21. Made a special promotional sale on account to Rosemont University. For the promotion, Waren agreed to a 15% reduction in the selling prices of the following items: Quantity 30 5 Yes B 26 Interstate Motor Freight; Carrier number 62XY404 Collect (i.e., paid by Andover University) Direct Truck 64, Dale Hoch $15.00 per 100 lbs. 5 cartons/basketballs @ 23 lbs./carton 4 cartons/hip, tail, arm pad sets @ 36 lbs./carton 2 cartons/footballs @ 16 lbs./carton Item No. BA-054 BA-807 Description Premium aluminum bat Pitching machine Received office supplies from Chicago Office Supply as listed on purchase order No. 327 (Doc. No. 16), a copy of which is being held in accounting. Chicago Office Supply's vendor invoice No. 2378 (Doc. No. 18) was received with the goods. All supplies ordered were received in good condition and taken directly to the office, but the invoice was not paid. 4 No 26 Sold bookshelves to Nancy Ford for $300. Nancy will pay this amount to Waren in January of 2014. The bookshelves were purchased for a cost of $1,000 on September 30, 2007 along with other office furniture costing $49,750 (total purchase was $50,750). The bookshelves were fully depreciated at the end of 2012. Add a new general ledger account on page 36. Assign it G/L #10210 - Accounts Receivable from Employees. Be sure to include this account in the proper section of Waren's 2013 financial statements. Do not be concerned that the new account is out of sequence in the G/L. Waren reorganizes its chart of accounts and G/L at the beginning of a new fiscal year. Don't forget to update the fixed asset subsidiary ledger on pages 42- 43. December No 26 Received check No. 4014 from Central Brokerage for $1,200 of dividend income. The dividends were earned on various common stocks in the marketable securities general ledger account. Yes 30 Issued check (Doc. No. 20) to Velocity Sporting Goods for payment in full of their invoice No. 34719 for goods received December 23. No 30 Received check No. 14002 for $6,122.55 from Rosemont University in payment of the promotional sale on account made December 24. Yes 31 Yes Paychecks are considered \"Mailed/Given to Outsiders.\" Timecards are filed in the \"Accounting\" file tab. Recall that federal income tax withholding amounts were listed earlier with employee pay rate increases. 31 Received the laptop computers ordered on Waren's purchase order No. 325 (Doc. No. 16) and vendor invoice No. 2423 (Doc. No. 18) from Chicago Office Supply. The computers were received in new and undamaged condition and taken directly to the office. The estimated useful life is 5 years with no salvage value. 31 Received vendor invoice No. 72654 (Doc. No. 18) from University Athletic News for advertisements Waren ran during the Christmas season and immediately issued a check (Doc. No. 20) for payment in full. B Recall that the original sale was made at a 15% promotional discount. Because Rosemont paid within ten days of the original sale, be sure to record the applicable discount. Received payroll time cards (Doc. No. 21) from Ford and Adams for the time period ended December 31 and prepared the payroll for all three employees, including paychecks. Yes Consider the credit terms before making the payment. Purchase orders are not issued for services that Waren purchases. 5 No No 31 Purchased 200 shares of Redhawk Corporation common stock for $22.00 per share plus commission of $90.00. Immediately issued a check payable to Central Brokerage. 31 The Board of Directors declared a $2.25 per share dividend on the 3000 shares of $75 par value common stock outstanding. The dividends will be payable on January 31, 2014 to all stockholders of record as of January 25, 2014. No 31 Add a new general ledger account on page 36. Assign it G/L #29010 - Dividends Declared. Be sure to include this account in the proper section of Waren's 2013 financial statements. Issued check to First American Bank and Trust for $10,000 for partial payment on the bank note, which included no payment for interest. The terms on the back of the bank note stipulate that prepayments can be made without early payment penalty. For purposes of the year-end adjusting entry for accrued interest that you will be making later, assume that this payment was not received by the bank until January 2, 2014. December No 31 Issued check for $4,800 to First Security Insurance for the premium on Waren's six-month liability insurance policy. The policy period runs from December 1, 2013 to June 1, 2014. No 31 Sold 150 shares of Sohn Corporation common stock for $27.00 per share. The shares were originally purchased on July 11, 2013 for $21.00 per share plus a commission of $60. Central Brokerage retained a commission of $70 on the sale and forwarded check No. 4289 for the net sale proceeds to Waren. No Yes No Calculate and record the gain or loss on the sale of the marketable securities. Be sure to consider the effects of both the purchase and sale commission expenses. 31 Loaned $8,000 to Maple Valley Electric by issuing a four-year note receivable with a stated annual interest rate of 8%. The funds were loaned by issuing a check. Interest payments of $640.00 are due on December 31 of each year, beginning in 2014. The entire principal is due four years from December 31, 2013. 31 The company signed an agreement to sublease an office in its building to Basso & Associates at a monthly rental rate of $1,200 . In connection with the sublease, Waren received check No. 55941 for $3,600 from Basso & Associates covering rent for the first quarter of 2014. B Remember to consider the time period to which this expenditure applies. Add a new general ledger account on page 36. Assign it G/L #21100 - Unearned Revenue. Be sure to include this account in the proper section of Waren's 2013 financial statements. 6 MONTH-END PROCEDURES - After you have recorded all the transactions, go to page 12 of the Instructions, Flowcharts, and Ledgers book and complete all the month-end procedures. An additional month-end requirement for this project is: Yes Monthly Statement - Prepare a monthly statement (Doc. No. 15) for Clayborn University. YEAR-END PROCEDURES - After completing all the month-end procedures, go to page 14 of the Instructions, Flowcharts, and Ledgers book and complete all the year-end procedures. Additional information for the year-end procedures is: No Ending Inventory - A physical inventory was taken 1/1/14, before business began for the new year. Merchandise on hand cost $193,306.00 . No Bad Debt Expense - The expense for bad debts is estimated at the end of the year as one-quarter of one percent (0.0025) of net sales. No Marketable Securities - At December 31, 2013, the market value of marketable securities held by Waren approximated the cost of the securities. The project is now complete. Good work! Review your materials to make certain everything is finalized. Complete the filing of documents, records, and working papers using the file tabs and the envelope in which the Aid is packaged. File all materials as indicated in the flowcharts. B 7 Document No. 3 PRICE LISTS CURRENT AS OF DECEMBER 1, 2013 VELOCITY SPORTING GOODS Item No. Baseball items: BA-054 BA-158 BA-199 Description Premium aluminum bat Baseballs - 12 game balls Fielding glove Cost Selling Price $ 139.00 42.00 46.00 205.00 65.00 61.00 BA-281 BA-445 BA-507 BA-667 BA-694 BA-807 60 lb. dry line marker Catcher's mask Baseball equipment bag Ball bucket with seat - set of 3 Batting gloves - 1 pair Pitching machine 65.00 48.00 27.00 23.00 24.00 164.00 107.00 72.00 41.00 32.00 33.00 240.00 BA-859 Set of bases 111.00 185.00 25.00 94.00 35.00 135.00 258.00 95.00 83.00 10.00 25.00 26.00 400.00 140.00 115.00 14.00 35.00 42.00 Basketball items: BB-008 Basketball BB-019 Basketball pole pad BB-113 BB-267 BB-358 BB-399 BB-431 BB-538 Scoreboard and timer Goal and rim set Backboard Basketball net Whistle and lanyard - set of 6 Basketball bag BB-688 BB-926 Portable inflation pump Trainer's first aid kit 69.00 30.00 110.00 43.00 Shoulder pad set 89.00 125.00 39.00 55.00 21.00 135.00 58.00 90.00 29.00 225.00 16.00 96.00 27.00 83.00 26.00 25.00 150.00 38.00 122.00 40.00 Football items: FB-027 FB-091 FB-225 FB-344 FB-513 Hip, tail, arm pad set Football helmet Football Portable storage locker FB-573 FB-650 FB-812 FB-874 FB-952 Kicking tees - set of 6 Football post pad Collapsible cones - set of 8 Sideline repair kit Portable hand warmer CHICAGO OFFICE SUPPLY Item No. 4126 4733 5433 8506 5302 Description Laser printer toner cartridge Copier paper - box Rewritable CDs Flash drive - 4GB Invoice forms - 100 Cost $ 46.50 19.50 12.50 14.50 6.00 6211 8843 2342 6277 7246 Legal pad - box of 5 Time cards - box of 50 Black ink pens - box of 12 Pencils - box of 24 Business envelopes - box of 1000 12302 12480 15321 3.95 6.90 4.50 2.25 15.50 Laptop computer Flat panel monitor High-speed copier $ 2,150.00 195.00 6,950.00 Approved By Ray Krame B 9 GENERAL JOURNAL: Date Nov Account No. 30 40600 20600 20400 20500 November and December Explanation Payroll Tax Expense FICA Payable SUTA Payable FUTA Payable Post Debit Credit 1,068.43 21.00 1,003.58 50.03 14.82 To record November payroll Nov 30 41000 Other Operating Expense 10100 Cash To record November bank service charge 21.00 SALES JOURNAL: November and December Invoice or Subsidiary Subs Credit Memo Account Post Number Number CM41 411 (23,014.00) 724 406 2,460.00 2,460.00 10 Branch College 725 408 32,912.00 32,912.00 14 Eastern Wisconsin University 726 410 24,905.00 24,905.00 Date Nov Customer 7 Stevenson College 7 Rosemont University Debit Accts Rec Sales Returns Sales G/L 10200 Monthly Totals G/L 30200 G/L 30100 37,263.00 Dec Credit 23,014.00 23,014.00 60,277.00 2 Rosemont University 727 406 4,174.00 4,174.00 7 Clayborn University 728 407 7,252.00 7,252.00 9 Eastern Wisconsin University 729 410 21,872.00 21,872.00 730 408 1,656.00 1,656.00 13 Branch College CASH RECEIPTS JOURNAL: November and December DEBIT CREDIT Dept Nov Description 7 13 17 18 Stevenson College McClain College Rosemont University Branch College 21 Eastern Wisconsin Unversity Monthly Totals Dec 6 Gates Unversity 9 14 15 15 Rosemont University Hancock College Clayborn University Atwood Brothers Sales Disc Control G\\L G\\L Subs Trans Subs G\\L Acct Trans Post Initials Date Cash 10100 30300 Acct No. Amount Post Ref 30100 No. Amount Ref 411 34,682.00 406 408 2,460.00 32,912.00 410 5,000.00 NF NF NF NF NF 34,682.00 7,767.00 2,410.80 32,253.76 82,113.56 NF 4,090.52 5,306.00 7,106.96 825.00 Other G/L 5,891.00 NF NF Sales 7767 49.20 658.24 5,000.00 RK Accounts Receivable G/L 10200 707.44 75,054.00 7,767.00 ### 83.48 406 4,174.00 145.04 407 7,252.00 ### 31200 825.00 PURCHASES JOURNAL November and December DEBIT Vendor Date Credit Other G/L Accounts Payable G/L 20100 Purchases 3 Velocity Sporting Goods 21 Chicago Office Supply Invoice G\\L Acct. Trans Post Subs Trans Subs Returns No. Nov Vendor Purchases 30500 No. Amount Ref Acct No. Amount Post Ref G/L 30600 33371 2275 Monthly Totals 27,380.00 40300 27,380.00 558.09 252 253 558.09 5 Velocity Sporting Goods 12 Chicago Office Supply 33965 2344 27,938.09 Dec 27,380.00 558.09 0 36115.00 10800 7367.00 252 253 36115.00 7367.00 CASH DISBURSEMENTS JOURNAL: November and December CREDIT DEBIT Purchases Date Check Description 8 1124 Chicago Office Supply 13 1125 Velocity Sporting Goods 13 1126-8 See Payroll Journal 15 1129 Internal Revenue Service 15 15 17 17 18 18 23 30 1130 1131 1132 1133 1134 1135 1136 1137-9 Internal Revenue Service State of Illinois Worldwide Management Board of Water & Light Interstate Motor Freight University Athletic News Chicago Office Supply See Payroll Journal Monthly Totals Cash Discounts Subs Trans Subs G/L 10100 Number Nov G/L 30700 Acct No Amount Post Ref 26,832.40 7 12 13 13 14 14 15 1140 1141 1142 1143 1144 1145 1146 Freight-In 547.60 985.80 252 27,380.00 30,800.00 44,181.03 First Security Insurance Chicago Office Supply Velocity Sporting Goods Worldwide Management Board of Water & Light Interstate Motor Freight Internal Revenue Service 2,575.00 7,367.00 35,392.70 4,800.00 1,360.25 778.75 3,523.23 15 1147 Internal Revenue Service 15 1148 State of Illinois 15 1149-51 See Payroll Journal 14.82 50.03 Post Amount Ref 1,559.33 2,016.46 13.33 44.98 4,800.00 1,763.65 3,250.00 3,575.79 13.33 44.98 4,800.00 1,763.65 2,356.99 3,250.00 558.09 Trans No 40200 253 G/L Other G/L Acct 20300 20600 20500 20400 40100 41000 985.80 Dec Accounts Payable G/L 20100 ### 253 547.60 558.09 28,923.89 13,447.75 RK 2,356.99 41000 722.30 253 252 7,367.00 36,115.00 2,575.00 40100 41000 4,800.00 1,360.25 20300 20600 20500 20400 1,516.07 2,007.16 14.82 50.03 ### Payroll Journal: November and December EARNINGS Date Employee DEDUCTIONS PAYMENT Subs Regular Regular Overtime Overtime Gross Pay FICA Fed W/H Net Pay Check Post Hours Pay Hours Pay G/L 40500 G/L 20600 G/L 20300 G/L 10100 No Ref Nov ### Ray Kramer 3500.00 3500.00 2790.54 1126 2253.72 172.41 328.47 1752.84 1127 88.00 1848.00 Nancy Ford 49.00 833.00 833.00 63.73 8.72 760.55 1128 3500.00 3500.00 267.75 441.71 2790.54 1137 2012.01 153.91 268.04 1590.06 1138 27.42 914.55 1139 Jim Adams 88.00 1680.00 Nancy Ford 60.00 1020.00 1020.00 78.03 12381.00 737.73 13118.73 1003.58 Monthly Totals 10.54 405.72 441.71 Jim Adams Nov ### Ray Kramer 12.88 267.75 332.01 Dec ### Ray Kramer 1516.07 10599.08 3500.00 3500.00 267.75 441.71 2790.54 1149 Jim Adams 88.00 1680.00 5.77 181.76 1861.76 142.43 230.48 1488.85 1150 Nancy Ford 88.00 1360.00 1.23 31.37 1391.37 106.43 65.79 1219.15 1151Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started