Hello,

I need your hepl. Please response as soon as possible cuz my homework is gonna due tomorrow morning :(. I really appreciate your hepl.

I need your help with SUA 1 in Accounting Information System course, which is attached below. Based on Transaction list, Can you complete excel for me?

DATA ENTRY FOR ALTERNATIVE SOLUTIONS (Enter information in red cells only - all other cells protected) (Read all information shown in blue before entering data in adjacent cells) # of shoulder pad sets shipped for Clayborn University (invoice #731): 45 (range 25-59) # of basketball pole pads received for Velocity PO 328: 90 (range 60-114) Wage and withholding information: Wage Rate $3,600.00 (choose one from the following: 3550, 3575, 3600, 3650, 3700, or 3750) $22.00 (choose one from the following: 21.30, 21.50, 21.80, 22.00, 22.50, or 23.00) $18.00 (choose one from the following: 17.30, 17.50, 17.80, 18.00, 18.20, 18.40) Ray Kramer Jim Adams Nancy Ford Bad debt percentage in words: one-fifth (type in either one-quarter, one-fifth, two-fifths, or one-half; note: use these exact words) Customer monthly statement sent to (enter name): Eastern Wisconsin University(type in either Eastern Wisconsin University, Branch College, or Clayborn University) Price List - Velocity Sporting Goods' Items Item No. Description Cost (no changes) Selling Price BA-054 BA-158 BA-199 BA-281 BA-445 BA-507 BA-667 BA-694 BA-807 BA-859 Bat Baseballs Fielding glove Dry line marker Catcher's mask Baseball equip. bag Ball bucket w/ seat Batting gloves Pitching machine Set of bases 139.00 no change 42.00 no change 46.00 no change 65.00 no change 48.00 no change 27.00 no change 23.00 no change 24.00 no change 164.00 no change 111.00 no change 205.00 (range $195-220) 65.00 (range $58-66) 61.00 (range $60-72) 107.00 (range $78-108) 72.00 (range $65-72) 41.00 (range $34-41) 32.00 (range $29-36) 33.00 (range $28-38) 240.00 (range $205-260) 185.00 (range $145-185) BB-008 BB-019 BB-113 BB-267 BB-358 BB-399 BB-431 BB-538 BB-688 BB-926 Basketball Basketball pole pad Scoreboard & timer Goal and rim set Backboard Basketball net Whistle & lanyard Basketball bag Inflation pump Trainer's first aid kit 25.00 no change 94.00 no change 258.00 no change 95.00 no change 83.00 no change 10.00 no change 25.00 no change 26.00 no change 69.00 no change 30.00 no change 35.00 no change 135.00 no change 400.00 no change 140.00 (range $125-145) 115.00 (range $98-130) 14.00 (range $12-16) 35.00 (range $35-40) 42.00 (range $35-42) 110.00 (range $90-110) 43.00 (range $38-43) FB-027 FB-091 FB-225 FB-344 FB-513 FB-573 FB-650 FB-812 FB-874 FB-952 Shoulder pad set Hip/tail/arm pad set Football helmet Football Storage locker Kicking tees Football post pad Collapsible cones Sideline repair kit Hand warmer 89.00 no change 39.00 no change 55.00 no change 21.00 no change 135.00 no change 16.00 no change 96.00 no change 27.00 no change 83.00 no change 26.00 no change 125.00 (range $120-140) 58.00 no change 90.00 (range $75-90) 29.00 no change 225.00 (range $180-230) 25.00 (range $20-25) 150.00 (range $135-150) 38.00 (range $35-40) 122.00 (range 115-130) 40.00 (range $32-40) ACCT NO. ACCOUNT TITLE 11/30 UNADJUSTED TRIAL BALANCE DEBIT CREDIT ASSETS 10100 10200 10300 10400 10500 10600 10700 10800 10900 11000 20100 20200 20300 20400 20500 20600 20700 20800 20900 21000 Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid Expenses Marketable securities Interest Receivable Fixed assets Accumulated depreciation Notes Receivable LIABILITIES Accounts payable Wages & Salaries Payable Federal income taxes withheld State unemployment taxes payable Federal unemployment taxes payable F.I.C.A. taxes payable Federal incomes taxes payable Dividends Payable Interest payable Notes payable STOCKHOLDERS' EQUITY 26000 Common stock 27000 Paid-in Capital in Excess of Par 29000 Retained earnings REVENUE AND GROSS PROFIT 30100 Sales 30200 Sales returns and allowances 30300 Sales discounts taken 30400 Cost of goods sold 30500 Purchases 30600 Purchases returns and allowances 30700 Purchases discounts taken 30800 Freight-in 30900 Gain/Loss- Sale of Fixed Assets Revenue Cycle TRIAL BALANCE DEBIT 31000 Gain/Loss- Sale of Marketable Sec. 31100 Interest/Dividend Income 31200 Miscellaneous revenue 40100 40200 40300 40400 40500 40600 40700 40800 40900 41000 EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries expense Payroll tax expense Federal income tax expense Interest expense Bad debt expense Other operating expense TOTALS $ - Check Figures $ 1,959,049.68 $ $ - $ - Revenue Cycle TRIAL BALANCE CREDIT Expenditure Cycle Payroll Cycle TRIAL BALANCE DEBIT CREDIT TRIAL BALANCE DEBIT CREDIT $ - $ - $ - $ - $ - Month-End Cycle General Journal UNADJUSTED TRIAL BALANCE DEBIT CREDIT $ - $ - WAREN SPORTS SUPPLY BALANCE SHEET AT DECEMBER 31, 2017 AND 2016 ASSETS 2017 2016 CURRENT ASSETS Cash Accounts receivable - net Inventory Marketable securities Total current assets $11,025.19 7,814.19 101,681.00 0.00 120,520.38 FIXED ASSETS - Net of accumulated depreciation 239,105.50 Total assets $359,625.88 LIABILITIES & STOCKHOLDERS' EQUITY CURRENT LIABILITIES Accounts payable Payroll taxes withheld and payable Federal income taxes payable Interest payable Total current liabilities NOTE PAYABLE Total liabilities STOCKHOLDERS' EQUITY Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $11,279.35 3,284.54 29,797.00 0.00 44,360.89 0.00 44,360.89 225,000.00 90,264.99 315,264.99 $359,625.88 WAREN SPORTS SUPPLY STATEMENT OF INCOME AND RETAINED EARNINGS For the Year Ended December 31, 2017 REVENUE Sales Less: Sales returns and allowances Sales discounts taken Net sales COST OF GOODS SOLD Beginning inventory Net purchases Freight-in Goods available for sale Less: Ending inventory Cost of goods sold GROSS MARGIN OPERATING EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries Payroll taxes Bad debt expense Other operating expense Total operating expenses Operating income OTHER INCOME - Miscellaneous income OTHER EXPENSE - Interest expense INCOME BEFORE TAXES FEDERAL INCOME TAXES NET INCOME RETAINED EARNINGS - Beginning of year RETAINED EARNINGS - End of year WAREN SPORTS SUPPLY STATEMENT OF CASH FLOWS YEAR ENDED DECEMBER 31, 2017 CASH FLOWS FROM OPERATING ACTIVITIES Net income Adjustments to reconcile net income to net cash from operating activities Depreciation (Increase) decrease in assets: Accounts receivable Inventory Increase (decrease) in liabilities: Accounts payable Payroll taxes withheld and payable Federal income taxes payable Interest payable Net cash provided by operating activities CASH FLOWS FROM INVESTING ACTIVITIES Cash payments for fixed assets Purchase of marketable securities Net cash used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES Cash proceeds from loans NET INCREASE IN CASH CASH - Beginning of year CASH - End of year WAREN SPORTS SUPPLY BANK RECONCILIATION December 31, 2017 Bank Statement General Ledger Unadjusted balance, 12-31-17 Add: Deduct: Outstanding checks Adjustments: Bank service charge Adjusted balance, 12-31-17 $0.00 $0.00 Journal Entry - December 31, 2017 Acct. No. 41000 Other operating expense 10100 Cash Debit Credit WAREN SPORTS SUPPLY ACCOUNTS RECEIVABLE AGED TRIAL BALANCE DECEMBER 31, 2017 CUST NO. CUSTOMER AMOUNT DUE AGE IN DAYS 31-60 CURRENT 61-90 TOTAL WAREN SPORTS SUPPLY ACCOUNTS PAYABLE TRIAL BALANCE DECEMBER 31, 2017 VEND. NO. AMOUNT PAYABLE NAME TOTAL WAREN SPORTS SUPPLY FIXED ASSET TRIAL BALANCE DECEMBER 31, 2017 ASSET TOTALS COST ACCUM. DEPREC. NET BOOK VALUE OVER 90 WAREN SPORTS SUPPLY YEAR-END WORKSHEET December 31, 2017 ACCT NO. ACCOUNT TITLE 10100 10200 10300 10400 10600 10800 10900 ASSETS Cash Accounts receivable Allowance for doubtful accounts Inventory Marketable securities Fixed assets Accumulated depreciation 20100 20300 20400 20500 20600 20700 20900 21000 LIABILITIES Accounts payable Federal income taxes withheld State unemployment taxes payable Federal unemployment taxes payable F.I.C.A. taxes payable Federal incomes taxes payable Interest payable Notes payable 26000 29000 STOCKHOLDERS' EQUITY Common stock Retained earnings 30100 30200 30300 30400 30500 30600 30700 30800 31200 REVENUE AND GROSS PROFIT Sales Sales returns and allowances Sales discounts taken Cost of goods sold Purchases Purchases returns and allowances Purchases discounts taken Freight-in Miscellaneous revenue 40100 40200 40300 40400 40500 40600 40700 40800 40900 41000 EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries expense Payroll tax expense Federal income tax expense Interest expense Bad debt expense Other operating expense Sub-totals Net Income (Loss) TOTALS (Accounts with no activity in this worksheet are excluded in this solution.) 12/30/2016 POST CLOSING TRIAL BALANCE DEBIT CREDIT 11,025.19 11,065.00 3,250.81 101,681.00 320,665.00 81,559.50 11,279.35 1,326.76 281.17 83.31 1,593.30 29,797.00 225,000.00 90,264.99 -------------------- -------------------444,436.19 444,436.19 12/30/2017 UNADJUSTED TRIAL BALANCE DEBIT CREDIT ADJUSTMENTS DEBIT CREDIT ADJUSTED TRIAL BALANCE DEBIT CREDIT INCOME STATEMENT DEBIT CREDIT BALANCE SHEET DEBIT CREDIT WAREN SPORTS SUPPLY POST-CLOSING TRIAL BALANCE December 31, 2017 ACCT. NO. ACCOUNT TITLE DEBIT CREDIT ASSETS 10100 10200 10300 10400 10600 10800 10900 11000 Cash Accounts receivable Allowance for doubtful accounts Inventory Marketable securities Fixed assets Accumulated depreciation Notes receivable 20100 20300 20400 20500 20600 20700 20900 21000 LIABILITIES Accounts payable Federal income taxes withheld State unemployment taxes payable Federal unemployment taxes payable F.I.C.A. taxes payable Federal income taxes payable Interest payable Notes payable 26000 29000 STOCKHOLDERS' EQUITY Common stock Retained earnings TOTALS ------------------------- ------------------------$0.00 $0.00 ============= ============= RK GENERAL LEDGER 10100 - CASH Oct. 1 Balance Forward Oct. 31 Oct. 31 Oct. 31 Net Wages and Salary Oct. 31 Bank Service Charge Nov. 30 Nov. 30 Nov. 30 Net Wages and Salary Nov. 30 Bank Service Charge Journal 10200 - ACCOUNTS RECEIVABLE Oct. 1 Balance Forward Oct. 31 Oct. 31 Nov. 30 Nov. 30 Journal 10300 - ALLOWANCE FOR DOUBTFUL ACCOUNTS Oct. 1 Balance Forward 10400 - INVENTORY Jan. 1 Balance Forward CR CD PR G CR CD PR G S CR S CR Journal Journal Debit Credit Debit Balance 44,351.12 110,395.64 98,066.06 10,546.67 25.00 46,109.03 43,850.15 10,879.10 21.00 73,472.34 82,113.56 Debit Credit Debit Balance 49,451.00 86,714.00 74,369.00 61,796.00 75,054.00 24,005.00 37,263.00 Debit Debit Credit Credit Balance 1,750.81 Credit Debit Balance 101,681.00 10600 - MARKETABLE SECURITIES Oct. 1 Balance Forward Journal Debit Credit Debit Balance 24,000.00 10800 - FIXED ASSETS Oct. 1 Balance Forward Journal Debit Credit Debit Balance 320,665.00 GENERAL LEDGER 10900 - ACCUMULATED DEPN. Oct. 1 Balance Forward Journal Debit Credit Credit Balance 81,559.50 20100 - ACCOUNTS PAYABLE Oct. 1 Balance Forward Oct. 31 Oct. 31 Nov. 30 Nov. 30 Journal Debit Credit Credit Balance 1,087.83 20300 - FED. INCOME TAXES W/H Oct. 1 Balance Forward Oct. 31 Oct. 31 Nov 30 Nov 30 Journal 20400 - STATE UNEMPLOYMENT TAXES PAYABLE Oct. 1 Balance Forward Oct. 31 Nov. 30 Nov. 30 20500 - FEDERAL UNEMPLOYMENT TAXES PAYABLE Oct. 1 Balance Forward Oct. 31 Nov. 30 P CD P CD CD PR CD PR Journal G CD G Journal G CD 85,920.80 82,372.83 4,635.80 27,938.09 28,923.89 Debit 3,650.00 Credit Credit Balance 1,292.00 1,292.00 1,275.44 1,275.44 1,369.75 1,369.75 1,275.44 Debit 59.14 Credit Balance 0.00 59.14 60.96 60.96 Credit 59.14 Debit Credit 10.00 10.00 Credit Balance 0.00 10.00 Nov. 30 G 10.30 10.30 GENERAL LEDGER 20600 - F.I.C.A. TAXES PAYABLE Oct. 1 Balance Forward Oct. 31 Oct. 31 F.I.C.A. Withheld Oct. 31 Employer's Tax Nov. 30 Nov. 30 F.I.C.A. Withheld Nov. 30 Employer's Tax Journal CD PR G CD PR G Debit Credit Credit Balance 1,731.12 1,731.12 979.32 979.32 1,958.64 1,014.65 1,014.65 2,029.30 1,958.64 20700 - FED. INCOME TAXES PAYABLE Oct. 1 Balance Forward Journal Debit Credit Credit Balance 0.00 20900 - INTEREST PAYABLE Oct. 1 Balance Forward Journal Debit Credit Credit Balance 0.00 21000 - NOTES PAYABLE Oct. 1 Balance Forward Journal Debit Credit Credit Balance 0.00 26000 - COMMON STOCK Oct. 1 Balance Forward Journal Debit Credit Credit Balance 225,000.00 28000 - INCOME SUMMARY Journal Debit Credit Balance Credit 29000 - RETAINED EARNINGS Oct. 1 Balance Forward Journal Debit Credit Balance 90,264.99 GENERAL LEDGER 30100 - SALES Oct. 1 Balance Forward Oct. 31 Credit Sales Oct. 31 Cash Sales Nov. 30 Credit Sales Nov. 30 Cash Sales Journal 30200 - SALES RETURNS & ALLOW. Oct. 1 Balance Forward Nov. 30 Journal 30300 - SALES DISCOUNTS TAKEN Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal 30400 - COST OF GOODS SOLD 30500 - PURCHASES Oct. 1 Balance Forward Oct. 31 Nov. 30 Debit S CR S CR S CR CR Journal Journal P P Credit 86,714.00 36,607.00 60,277.00 7,767.00 Debit Credit 23,014.00 Debit Credit 580.36 707.44 Debit Debit 81,285.00 27,380.00 Credit Credit Credit Balance 1,326,865.00 1,450,186.00 1,518,230.00 Debit Balance 34,617.00 57,631.00 Debit Balance 13,856.38 14,436.74 15,144.18 Debit Balance Debit Balance 969,835.00 1,051,120.00 1,078,500.00 30600 - PURCHASES RETURNS AND ALLOWANCES Oct. 1 Balance Forward Journal Debit Credit Credit Balance 19,445.00 GENERAL LEDGER 30700 - PURCHASES DISC. TAKEN Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal 30800 - FREIGHT-IN Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal Debit CD CD CD CD Credit 1,625.70 547.60 Debit Credit 2,985.60 2,356.99 31200 - MISCELLANEOUS REVENUE Oct. 1 Balance Forward Journal Debit Credit 40100 - RENT EXPENSE Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal Debit Credit 40200 - ADVERTISING EXPENSE Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal 40300 - OFFICE SUPPLIES EXPENSE Oct. 1 Balance Forward Oct. 31 CD CD CD CD Journal P 4,800.00 4,800.00 Debit Credit 4,525.00 3,250.00 Debit 985.80 Credit Credit Balance 13,388.00 15,013.70 15,561.30 Debit Balance 18,038.35 21,023.95 23,380.94 Credit Balance 0.00 Debit Balance 43,200.00 48,000.00 52,800.00 Debit Balance 13,030.00 17,555.00 20,805.00 Debit Balance 3,518.41 4,504.21 Nov. 30 40400 - DEPRECIATION EXPENSE P Journal 558.09 Debit 5,062.30 Credit Debit Balance GENERAL LEDGER 40500 - WAGES AND SALARIES EXP. Oct. 1 Balance Forward Oct. 31 Nov. 30 Journal PR PR Debit Credit 12,801.43 13,263.50 Journal 40700 - FED. INCOME TAX EXPENSE Journal Debit Credit Debit Balance 40800 - INTEREST EXPENSE Dec. 31 Dec. 31 Journal Debit Credit Debit Balance 40900 - BAD DEBT EXPENSE Journal Debit Credit Debit Balance 41000 - OTHER OPERATING EXPENSE Oct. 1 Balance Forward Oct. 31 Oct. 31 Oct. 31 Nov. 30 Nov. 30 Journal Debit Credit G P CD G CD Credit Debit Balance 8,233.12 9,281.58 10,367.49 40600 - PAYROLL TAX EXPENSE Oct. 1 Balance Forward Oct. 31 Nov. 30 G G Debit Debit Balance 100,027.73 112,829.16 126,092.66 1,048.46 1,085.91 25.00 3,650.00 1,985.21 21.00 1,763.65 Debit Balance 17,880.14 17,905.14 21,555.14 23,540.35 23,561.35 25,325.00 Ctrl Init NF NF NF Ctrl Init NF Ctrl Init NF Ctrl Init NF NF NF Ctrl Init NF NF NF ACCOUNTS PAYABLE SUBSIDIARY LEDGER 252 VELOCITY SPORTING GOODS 1285 Colgrove Ave. Pierre, SD 57501 TERMS: 2/10, Net 30 DATE Oct. 1 Oct. 5 Oct. 14 Nov. 3 Nov. 13 Dec. 5 Dec. 13 FREIGHT : Collect Description Balance Forward Vendor Invoice # 32407 Check # 1112 Vendor invoice # 33371 Check # 1125 Vendor invoice # 33965 Check # 1142 Debit Credit 81,285.00 81,285.00 27,380.00 27,380.00 36,115.00 36,115.00 Balance 0.00 81,285.00 0.00 27,380.00 0.00 36,115.00 0.00 253 CHICAGO OFFICE SUPPLY 1441 E. Michigan Chicago, Illinois 60606 TERMS: Due on receipt of invoice DATE Oct. Oct. Oct. Nov. Nov. Nov. Dec. Dec. 1 7 19 8 21 23 12 12 Description Balance Forward Check # 1111 Vendor invoice # 2112 Check # 1124 Vendor invoice # 2275 Check # 1136 Vendor invoice # 2344 Check # 1141 FREIGHT: No Charge Debit Credit 1,087.83 985.80 985.80 558.09 558.09 7,367.00 7,367.00 Balance 1,087.83 0.00 985.80 0.00 558.09 0.00 7,367.00 0.00 261 GILLETT CONSULTING 5613 Lantern View Chicago, Illinois 60612 TERMS: Net 30 days DATE Oct. 1 Oct. 3 Description Balance Forward Vendor Invoice # 9884 Debit Credit 3,650.00 Balance 0.00 3,650.00 ACCOUNTS RECEIVABLE SUBSIDIARY LEDGER 406 ROSEMONT UNIVERSITY 121 E. Front Louisville, Kentucky 40202 DATE Description Oct. 1 Balance Forward Oct. 6 Invoice # 722 Oct. 14 Payment # 722 Nov. 7 Invoice # 724 Nov. 17 Payment # 724 Dec. 2 Invoice # 727 Dec. 9 Payment #727 CLAYBORN UNIVERSITY 13210 S. Upton Logansport, Indiana 46947 DATE Description Oct. 1 Balance Forward Dec. 7 Invoice # 728 Dec. 14 Payment # 728 Debit CREDIT LIMIT: Credit 29,018.00 29,018.00 2,460.00 2,460.00 4,174.00 4,174.00 $125,000 Balance 0.00 29,018.00 0.00 2,460.00 0.00 4,174.00 0.00 407 BRANCH COLLEGE 242 W. Holt Rd. Trenton, Missouri 64683 DATE Description Oct. 1 Balance Forward Oct. 7 Payment # 721 Nov. 10 Invoice # 725 Nov. 18 Payment # 725 Dec. 13 Invoice # 730 Debit CREDIT LIMIT: Credit 7,252.00 7,252.00 $125,000 Balance 0.00 7,252.00 0.00 408 UNIVERSITY OF SOUTHERN IOWA 13210 S. Logan Dubuque, Iowa 52003 DATE Description Oct. 1 Balance Forward Debit CREDIT LIMIT: Credit 45,351.00 32,912.00 32,912.00 1,656.00 $100,000 Balance 46,551.00 1,200.00 34,112.00 1,200.00 2,856.00 409 EASTERN WISCONSIN UNIVERSITY 14123 W. Saginaw Madison, Wisconsin 53702 DATE Description Oct. 1 Balance Forward Nov. 14 Invoice # 726 Nov. 21 Partial payment # 726 Dec. 9 Invoice # 729 Debit CREDIT LIMIT: Credit $100,000 Balance 0.00 Debit CREDIT LIMIT: Credit $75,000 Balance 0.00 24,905.00 19,905.00 41,777.00 410 STEVENSON COLLEGE 2689 Industrial Boulevard Chicago, Illinois 60614 DATE Description Oct. 1 Balance Forward Oct. 24 Invoice # 723 Nov. 7 Return for credit - #CM 41 Nov. 7 Payment # 723 24,905.00 5,000.00 21,872.00 411 Debit CREDIT LIMIT: Credit 57,696.00 23,014.00 34,682.00 $75,000 Balance 2,900.00 60,596.00 37,582.00 2,900.00 PAY RATE HISTORY Pay Rate Time Unit Filing Status Withholding Allowances Effective Date Approved By Ray Kramer $3,400.00 $3,500.00 semimonthly semimonthly M M 2 2 12/16/15 12/16/16 RK RK Jim Adams $20.00 $21.00 hourly hourly S S 2 2 12/16/15 12/16/16 RK RK Nancy Ford $17.00 hourly M 3 10/01/17 Hire date, RK EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Home Address Employed Date of Birth DATE Period Ending 10-1-13 Balance forward 10-15-13 10-31-13 Cumulative Annual Total 11-15-13 11-30-13 Cumulative Annual Total 12-15-13 Cumulative Annual Total Ray Kramer 417 Cherry Chicago, 60912 4/6/06 Date of Termination 2/15/1974 Occupation Manager Paid 10-15-13 10-31-13 11-15-13 11-29-13 12-13-13 HOURS WORKED Regular Overtime Hours Hours Soc.Sec.No. Phone No. Gross Pay 63,000.00 3,500.00 3,500.00 70,000.00 3,500.00 3,500.00 77,000.00 3,500.00 365-73-2376 781-3565 F.I.C.A. 4,819.50 Federal Income Tax 6,930.00 Net Pay 51,250.50 267.75 267.75 5,355.00 267.75 267.75 5,890.50 267.75 385.00 385.00 7,700.00 385.00 385.00 8,470.00 385.00 2,847.25 2,847.25 56,945.00 2,847.25 2,847.25 62,639.50 2,847.25 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Jim Adams Home Address 2522 Longfellow, Chicago,60823 Employed 1/16/13 Date of Termination Date of Birth 10/1/1988 Occupation Accounting Clerk DATE HOURS WORKED Period Regular Overtime Ending Paid Hours Hours 10-1-17 Balance forward 10-15-17 10-15-17 10-31-17 10-31-17 Cumulative Annual Total 11-15-17 11-15-17 11-30-17 11-29-17 Cumulative Annual Total 12-15-17 12-13-17 80.00 96.00 5.70 8.25 88.00 88.00 12.70 14.30 88.00 11.60 Gross Pay 37,027.73 1,859.55 2,275.88 41,163.16 2,248.05 2,298.45 45,709.66 2,213.40 Soc.Sec.No. Phone No. 379-54-9833 351-5874 2,832.62 Federal Income Tax 4,320.00 Net Pay 29,875.11 142.26 174.11 3,148.99 171.97 175.83 3,496.79 169.32 197.00 291.00 4,808.00 284.00 296.00 5,388.00 275.00 1,520.29 1,810.77 33,206.17 1,792.08 1,826.62 36,824.87 1,769.08 F.I.C.A. Cumulative Annual Total Employee's Name Nancy Ford Home Address 1018 Whittier, Chicago, 60823 Employed 10/01/17 Date of Termination Date of Birth 5/22/1984 Occupation Clerk DATE HOURS WORKED Period Regular Overtime Ending Paid Hours Hours 10-1-17 Balance forward 10-15-17 10-15-17 10-31-17 10-31-17 Cumulative Annual Total 11-15-17 11-15-17 11-30-17 11-30-17 Cumulative Annual Total 12-15-17 12-15-17 Cumulative Annual Total 48.00 50.00 49.00 52.00 88.00 1.20 Soc.Sec.No. Phone No. 367-55-4832 351-5251 Gross Pay 0.00 F.I.C.A. 0.00 Federal Income Tax 0.00 816.00 850.00 1,666.00 833.00 884.00 3,383.00 1,526.60 62.42 65.03 127.45 63.73 67.62 258.80 116.79 7.02 10.42 17.44 8.72 11.03 37.19 68.00 Net Pay 0.00 746.56 774.55 1,521.11 760.55 805.35 3,087.01 1,341.81 FIXED ASSET SUBSIDIARY LEDGER Item Office Furniture Purch.From Chicago Office Supply Est Life 5 years Date Sept. 30 Dec. 31 Dec. 31 Dec. 31 Dec. 31 Dec. 31 Dec. 31 11 11 12 12 14 15 16 Asset Record Debit Credit 50,750.00 Asset Record Debit Credit 69,255.00 Asset Record Debit Credit 200,660.00 Asset Record Debit Credit 7,367.00 Item Purch.From Est Life 5 Date Depreciation Method Where Located Est. Salvage Value $ Balance 69,255.00 Depreciation Record Debit Credit Balance Depreciation Method Where Located Est. Salvage Value $ Balance 200,660.00 Straight-line Warehouse 0 Asset Record Credit Balance Asset NBV 200,660.00 10,033.00 190,627.00 Straight-line Office 0 Depreciation Record Debit Credit Balance Depreciation Method Where Located Est. Salvage Value $ Debit 6,925.50 20,776.50 Asset NBV 69,255.00 62,329.50 48,478.50 Depreciation Record Debit Credit Balance Depreciation Method Where Located Est. Salvage Value $ Balance 7,367.00 5,075.00 15,225.00 25,375.00 35,525.00 45,675.00 50,750.00 Asset NBV 50,750.00 45,675.00 35,525.00 25,375.00 15,225.00 5,075.00 0.00 Straight-line Loading Dock 0 10,033.00 Item High-Speed Copier Purch.From Chicago Office Supply Est Life 5 years Date Dec. 12 17 Depreciation Record Debit Credit Balance 6,925.50 13,851.00 Item Inv. Handling System Purch.From Conveyor Systems, Inc. Est Life 10 years Date Jul. 5 16 Dec. 31 16 Balance 50,750.00 Straight-line Office 0 5,075.00 10,150.00 10,150.00 10,150.00 10,150.00 5,075.00 Item Delivery Trucks Purch.From Dyckstra Ford Est Life 5 years Date Apr. 21 15 Dec. 31 15 Dec. 31 16 Depreciation Method Where Located Est. Salvage Value $ Asset NBV 7,367.00 Straight-line Depreciation Record Debit Credit Balance Asset NBV WAREN SPORTS SUPPLY GENERAL JOURNAL December, 2017 DATE Dec. 23 ACCT. NO. 10300 10200 EXPLANATION 1 Allowance for doubtful accounts Accounts receivable To write off uncollectible Stevenson College account Dec. 31 41000 10100 2 Other operating expense Cash To record December bank service charges 3 Dec. 31 40600 20600 20400 20500 Payroll tax expense F.I.C.A. payable State unemployment taxes payable Federal unemployment taxes payable To record December payroll taxes Dec. 31 40400 10900 4 Depreciation expense Accumulated depreciation To record 2013 depreciation 5 Dec. 31 40800 20900 Interest expense Interest payable To accrue interest on note payable (80,000 X 15/365 X .06) Dec. 31 40900 10300 6 Bad debt expense Allowance for doubtful accounts To record 2013 provision for bad debts POST DEBIT CREDIT Dec. 31 30400 30600 30700 10400 30500 30800 7 Cost of goods sold Purchases returns and allowances Purchases discounts taken Inventory Purchases Freight-in To adjust inventory (to reflect results of 12-31-13 physical inventory) and record cost of goods sold Dec. 31 40700 20700 8 Federal income tax expense Federal income taxes payable To record 2013 federal income tax provision Dec. 31 30100 31200 30200 30300 30400 28000 9 Sales Miscellaneous revenue Sales returns and allowances Sales discounts taken Cost of goods sold Income summary To close revenue and gross profit accounts to income summary Dec. 31 28000 40100 40200 40300 40400 40500 40600 40700 40800 40900 41000 10 Income summary Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries expense Payroll tax expense Federal income tax expense Interest expense Bad debt expense Other operating expense To close expense accounts to income summary 11 Dec. 31 28000 29000 Income summary Retained earnings To close income summary to retained earnings SALES JOURNAL Date Dec. Dec. Dec. Dec. Customer 2 Rosemont University 7 Clayborn University 9 E. Wisconsin University 13 Branch College Inv. or Cr. Memo Number 727 728 729 730 DECEMBER Subs. Acct. No. 406 407 410 408 Subs. Post P P P P Debit Acct. Rec. Sales Returns G/L 10200 G/L 30200 4,174.00 7,252.00 21,872.00 1,656.00 Credit Sales G/L 30100 4,174.00 7,252.00 21,872.00 1,656.00 ---------------------- ---------------------- ---------------------Monthly totals ============ ============ ============ CASH RECEIPTS JOURNAL Date Description Dec. 6 Gates University Dec. 9 Rosemont University Dec. 12 Hancock College Dec. 14 Clayborn University Dec. 14 Atwood Brothers Ctrl Init NF NF NF NF NF DEBIT Cash Sales Disc. G/L 10100 G/L 30300 5,891.00 4,090.52 83.48 5,306.00 7,106.96 145.04 825.00 DECEMBER CREDIT A/R - G/L 10200 Subs. A/C # Amt. Post 406 4,174.00 P 407 7,252.00 P Sales G/L 30100 5,891.00 A/C # Other G/L Amt. 5,306.00 31200 825.00 ------------------------- ------------------ --------------------------------------------- ----------------------- ---------------------- ============== ========== ============ ============ Monthly totals ============= Post PURCHASES JOURNAL Date Dec. Dec. 5 12 Vendor Velocity Sporting Goods Chicago Office Supply Vendor Invoice No. 33965 2344 DECEMBER Debit Purchases G/L 30500 Acc# 36,115.00 10800 Credit Other G/L A/P - G/L 20100 Amount Post Subs. A/C# Amount Post P 252 36,115.00 P 7,367.00 253 7,367.00 ----------- ----------- ----------- ====== ====== ====== Purch. Ret. G/L 30600 Monthly totals Summary Totals 10800 40300 CASH DISBURSEMENTS JOURNAL Date Dec. 7 Dec. 12 Dec. 13 Dec. 13 Dec. 13 Dec. 13 Dec. 13 Dec. 13 Dec. 13 Dec. 13 Check No. 1140 1141 1142 1143 1144 1145 1146 Description First Security Insurance Chicago Office Supply Velocity Sporting Goods Worldwide Management Board of Water and Light Interstate Motor Freight Internal Revenue Service 1147 Internal Revenue Service 1148 State of Illinois 1149-51 See Payroll Journal DECEMBER CREDIT DEBIT Cash Purch. Disc. A/P - G/L 20100 Freight-in G/L 10100 G/L 30700 Subs. A/C # Amt. Post G/L 30800 2,575.00 7,367.00 253 7,367.00 P 35,392.70 722.30 252 36,115.00 P 4,800.00 1,360.25 778.75 778.75 3,399.05 10.30 60.96 Other G/L A/C # Amt. 41000 2,575.00 40100 41000 4,800.00 1,360.25 20300 20600 20500 20400 1,369.75 2,029.30 10.30 60.96 ---------------- ------------------ ------------------ ----------------- ---------------- ========= ========== ========== ========= ========= Monthly totals Post PAYROLL JOURNAL Date Dec. Dec. Employee 13 Ray Kramer Jim Adams Nancy Ford Regular Hours 80.00 80.00 Regular Pay 3,500.00 1,680.00 1,360.00 EARNINGS Overtime Hours 11.60 1.20 DECEMBER DEDUCTIONS Gross Pay F.I.C.A. Fed.Inc.Tax G/L 40500 G/L 20600 G/L 20300 3,500.00 267.75 385.00 533.40 2,213.40 169.32 275.00 166.60 1,526.60 116.79 68.00 Overtime Pay PAYMENT Net Pay G/L 10100 2,847.25 1,769.08 1,341.81 31 Ray Kramer Jim Adams Nancy Ford ----------------Monthly totals ============ ======== ========== ======== ========== ========== Ck . No. 1149 1150 1151 Subs Post Ref P P P Document No. 1 Transactions List December 1631, 2013 Complete each of the following transactions in accordance with the seven-step process on pages 1112 of the Instructions, Flowcharts, and Ledgers book (step 5). Remember the importance of the systems flowcharts on pages 1824 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 x 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. x x x 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: x x x x x Yes 16 x x x 19 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. 4GUVTKEVKXGN[\u0002 GPFQTUG\u0002 OGCPU\u0002 VQ\u0002 YTKVG\u0002 VJG\u0002 HQNNQYKPI\u0002 QP\u0002 VJG\u0002 DCEM\u0002 QH\u0002 VJG\u0002 EJGEM\u001c\u0002 (QT\u0002 FGRQUKV\u0002QPN[\u0010\u00029CTGP\u00025RQTVU\u00025WRRN[\u0010 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 35 shoulder pad sets were available for shipment. Carrier & number: Freight charges: Route: Truck & driver: Freight rate: Shipment: x x x B 1285 Colgrove Avenue, Pierre, SD 57501 Interstate Motor Freight Collect (i.e., paid by Waren Sports Supply) None 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. x Yes Description Basketball pole pad Basketball bag Portable inflation pump 6TCKPGTU\u0002HKTUV\u0002CKF\u0002MKV Allied Trucking; Carrier number 2154 FOB shipping point; Billed to buyer (i.e., paid by Clayborn) Express Truck 2961XZ, Linda Arensmeier $15.00 per 100 lbs. 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 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 3536 of the Reference book. 2 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. x 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,575.00 semimonthly $460.46 Jim Adams $21.30 per hour $345.97 Nancy Ford $17.30 per hour $126.02 x 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 90 basketball pole pads (Item No. BB-019) were received. The goods were placed immediately in the inventory warehouse. Freight carrier: Freight bill: x Interstate Motor Freight No. 26425 (Doc. No. 19), received with shipment 4GOGODGT\u0002 VQ\u0002 HQNNQY\u0002 VJG\u0002 HNQYEJCTV\u0002 QP\u0002 RCIG\u0002 \u0014\u0014\u0010\u0002 ;QW\u0002 ECPV\u0002 TGEQTF\u0002 C\u0002 RWTEJCUG\u0002 [et DGECWUG\u0002VJG\u0002KPXQKEG\u0002JCUPV\u0002DGGP\u0002TGEGKXGF\u0010 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. x Yes 24 Received all goods that Waren had authorized Eastern Wisconsin University (EWU) to return QP\u0002'97U\u0002return request No. R8034 for credit against their account balance. x 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. x B 4GOGODGT\u0002 VJCV\u0002 9CTGP\u0002 5RQTVU\u0002 5WRRN[\u0002 WUGU\u0002 VJG\u0002 #NNQYCPEG\u0002 OGVJQF\u0002 TCVJGT\u0002 VJCP\u0002 &KTect write-QHH\u0002HQT\u0002CEEQWPVKPI\u0002HQT\u0002DCF\u0002FGDVU\u0010 Do not finalize a deposit slip until you determine whether there are other cash receipts on the same day. 3 December Yes 24 Received vendor invoice No. 34719 (Doc. No. 18) from Velocity Sporting Goods for goods ordered December 16 and received December 23. x x 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. x 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: x No 24 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 Start with the flowchart on page 21. Made a special promotional sale on account to Rosemont University. For the promotion, Waren agreed to a 20% reduction in the selling prices of the following items: Quantity 45 20 Item No. BA-054 BA-807 Description Premium aluminum bat Pitching machine Yes 26 Received office supplies from Chicago Office Supply as listed on purchase order No. 327 (Doc. 0Q\u0010\u0002\u0013\u0018\u000b\u000e\u0002C\u0002EQR[\u0002QH\u0002YJKEJ\u0002KU\u0002DGKPI\u0002JGNF\u0002KP\u0002CEEQWPVKPI\u0010\u0002%JKECIQ\u00021HHKEG\u00025WRRN[U\u0002vendor 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. No 26 Sold bookshelves to Nancy Ford for $400. Nancy will pay this amount to Waren in January of 2014. The bookshelves were purchased for a cost of $1,200 on September 30, 2007 along with other office furniture costing $49,550 (total purchase was $50,750). The bookshelves were fully depreciated at the end of 2012. x x x B 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 9CTGPU\u0002\u0014\u0012\u0013\u0015 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. &QPV\u0002HQTIGV\u0002VQ\u0002WRFCVG\u0002VJG\u0002HKZGF\u0002CUUGV\u0002UWDUKFKCT[\u0002NGFIGT\u0002QP\u0002RCIGU\u0002\u0016\u001443. 4 December No 26 Received check No. 4014 from Central Brokerage for $900 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. x No 30 Received check No. 14002 for $10,858.40 from Rosemont University in payment of the promotional sale on account made December 24. x x Yes 31 Consider the credit terms before making the payment. Recall that the original sale was made at a 20% 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. x x x 2C[EJGEMU\u0002CTG\u0002EQPUKFGTGF\u0002/CKNGF\u0011)KXGP\u0002VQ\u00021WVUKFGTU\u0010 Timecards CTG\u0002HKNGF\u0002KP\u0002VJG\u0002#EEQWPVKPI\u0002HKNG\u0002VCD\u0010 Recall that federal income tax withholding amounts were listed earlier with employee pay rate increases. Yes 31 Received the lCRVQR\u0002EQORWVGTU\u0002QTFGTGF\u0002QP\u00029CTGPU\u0002purchase 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. Yes 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. x No No 31 Purchased 150 shares of Redhawk Corporation common stock for $15.00 per share plus commission of $75.00. Immediately issued a check payable to Central Brokerage. 31 The Board of Directors declared a $3.00 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. x No B Purchase orders are not issued for services that Waren purchases. 31 Add a new general ledger account on page 36. Assign it G/L #29010 Dividends Declared. Be sure to include this account in tJG\u0002 RTQRGT\u0002 UGEVKQP\u0002 QH\u0002 9CTGPU\u0002 \u0014\u0012\u0013\u0015 financial statements. Issued check to First American Bank and Trust for $11,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. 5 December No 31 Issued check for $1,800 VQ\u0002 (KTUV\u0002 5GEWTKV[\u0002 +PUWTCPEG\u0002 HQT\u0002 VJG\u0002 RTGOKWO\u0002 QP\u0002 9CTGPU\u0002 UKZ-month liability insurance policy. The policy period runs from December 1, 2013 to June 1, 2014. x No 31 Remember to consider the time period to which this expenditure applies. Sold 300 shares of Sohn Corporation common stock for $28.00 per share. The shares were originally purchased on July 11, 2013 for $23.00 per share plus a commission of $72. Central Brokerage retained a commission of $81 on the sale and forwarded check No. 4289 for the net sale proceeds to Waren. x x 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. No 31 Loaned $5,000 to Maple Valley Electric by issuing a four-year note receivable with a stated annual interest rate of 9%. The funds were loaned by issuing a check. Interest payments of $450.00 are due on December 31 of each year, beginning in 2014. The entire principal is due four years from December 31, 2013. No 31 The company signed an agreement to sublease an office in its building to Basso & Associates at a monthly rental rate of $600 . In connection with the sublease, Waren received check No. 55941 for $1,800 from Basso & Associates covering rent for the first quarter of 2014. x Add a new general ledger account on page 36. Assign it G/L #21100 Unearned Revenue. Be sure to include this account in tJG\u0002 RTQRGT\u0002 UGEVKQP\u0002 QH\u0002 9CTGPU\u0002 \u0014\u0012\u0013\u0015 financial statements. 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 monthend requirement for this project is: Yes Monthly Statement Prepare a monthly statement (Doc. No. 15) for Eastern Wisconsin 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 $188,711.00 . No Bad Debt Expense The expense for bad debts is estimated at the end of the year as onefifth of one percent (0.002) 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 6 Document No. 3 PRICE LISTS CURRENT AS OF DECEMBER 1, 2013 VELOCITY SPORTING GOODS Item No. Description Baseball items: BA-054 BA-158 BA-199 BA-281 BA-445 BA-507 BA-667 BA-694 BA-807 BA-859 Premium aluminum bat Baseballs 12 game balls Fielding glove 60 lb. dry line marker &DWFKHUV\u0003PDVN Baseball equipment bag Ball bucket with seat set of 3 Batting gloves 1 pair Pitching machine Set of bases Basketball items: BB-008 BB-019 BB-113 BB-267 BB-358 BB-399 BB-431 BB-538 BB-688 BB-926 Football items: FB-027 FB-091 FB-225 FB-344 FB-513 FB-573 FB-650 FB-812 FB-874 FB-952 Cost Selling Price $ 139.00 42.00 46.00 65.00 48.00 27.00 23.00 24.00 164.00 111.00 210.00 59.00 65.00 102.00 66.00 40.00 31.00 35.00 220.00 158.00 Basketball Basketball pole pad Scoreboard and timer Goal and rim set Backboard Basketball net Whistle and lanyard set of 6 Basketball bag Portable inflation pump 7UDLQHUV\u0003ILUVW\u0003DLG\u0003NLW 25.00 94.00 258.00 95.00 83.00 10.00 25.00 26.00 69.00 30.00 35.00 135.00 400.00 142.00 125.00 12.00 38.00 39.00 107.00 39.00 Shoulder pad set Hip, tail, arm pad set Football helmet Football Portable storage locker Kicking tees set of 6 Football post pad Collapsible cones set of 8 Sideline repair kit Portable hand warmer 89.00 39.00 55.00 21.00 135.00 16.00 96.00 27.00 83.00 26.00 138.00 58.00 79.00 29.00 210.00 24.00 139.00 35.00 120.00 34.00 CHICAGO OFFICE SUPPLY Item No. Description 4126 4733 5433 8506 5302 6211 8843 2342 6277 7246 Laser printer toner cartridge Copier paper box Rewritable CDs Flash drive 4GB Invoice forms 100 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 Laptop computer Flat panel monitor High-speed copier Cost $ 46.50 19.50 12.50 14.50 6.00 3.95 6.90 4.50 2.25 15.50 $ 2,150.00 195.00 6,950.00 Approved By Ray Kramer