50.1K

Verified Solution

Link Copied!

Zoom Insert Table Chart Text Shape Media 1 2 3 5 R. Santana invested $50,000 cash, a $24,000 computer system, and $6,000 of office equipment in the company in exchange for its common stock. The company paid $3,300 cash for four months' rent. (Use Prepaid Rent account.) The company purchased $1,350 of computer supplies on credit from Harris Office Products. The company paid $2,220 cash for one year's premium on a property and liability insurance policy. The company initially records insurance as a prepaid expense. The company billed West Leasing $4,800 for services performed in instaping a new Web server. The company paid $1,350 cash for the computer supplies purchased from Harris Office Products on October 3. The company hired Lyn Addie as a part-time assistant for $125 per day. as needed. 6 8 1 0 1 2 The company billed West Leasing another $1,400 for services performed. 1 5 1 7 The company received $4,800 cash from West Leasing as partial payment on its account. The company paid $805 cash to repair computer equipment that was damaged when moving it. The company paid $1,375 cash for advertisements published in the local newspaper The company received $1,400 cash from West Leasing on its account. ON 2 2 00 N The company billed IFM Company $5,208 for services performed. 3 1 The company paid $875 cash for Lyn Addie's wages for seven days' work. 3 1 The company paid $875 cash for Lyn Addie's wages for seven days' work. 3 1 The company paid $3,600 cash in dividends. 1 The company reimbursed R. Santana in cash for business automobile mileage allowance (Santana logged 1,000 miles at $0.32 per mile). 2 5 8 8 The company received $4,633 cash from Liu Corporation for computer services performed. The company purchased computer supplies for $1,075 cash from Harris Office Products. The company billed Gomez Co. $5,750 for services performed. The company received notification from Alex's Engineering Co. that Computer Solutions' bid of $3,950 for an upcoming project was accepted. The company received $2,208 cash from IFM Company as partial payment of the October 28 bill. The company donated $250 cash to the United Way in the company's 1 3 8 2 2 name. AN The company completed work and sent a bill for $3,950 to Alex's Engineering Co. The company sent another bill to IFM Company for the past-due amount 2 AN 2 5 The company completed work and sent a bill for $3,950 to Alex's Engineering Co. The company sent another bill to IFM Company for the past-due amount of $3,000. The company reimbursed R. Santana in cash for business automobile mileage (1,200 miles at $0.32 per mile). 2 8 3 0 The company paid $1,750 cash for Lyn Addie's wages for 14 days' work. 3 0 The company paid $2,000 cash in dividends. De 2 C. 3 Paid $1,025 cash to Hilltop Mall for Computer Solutions' share of mall advertising costs. Paid $500 cash for minor repairs to the company's computer. Received $3,950 cash from Alex's Engineering Co. for the receivable from November Paid cash to Lyn Addie for six days of work at the rate of $125 per day. 4 1 0 1 4 1 5 Notified by Alex's Engineering Co. that Computer Solutions' bid of $7,000 on a proposed project has been accepted. Alex's paid a $1,500 cash advance to Business Solutions. Purchased $1,100 of computer supplies on credit from Harris Office Products. Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8. 1 6 ON Completed a project for Liu Corporation and received $5,625 cash. 22-26 Took the week off for the holidays. Received $3,000 cash from Gomez Co. on its receivable. 2 8 2 9 Reimbursed R. Santana for business automobile mileage (600 miles at $0.32 per mile). The company paid $1,500 cash in dividends. 3 1 Required: 1. Open the Excel file provided and save as YourName_ACCT305_PS1. The Excel file includes the following worksheets: general journal, general ledger, and 2019 trial balance. You will add additional worksheets to the file as you complete the assignment. NOTE: You may find it helpful to view two worksheets at the same time. This can be done by using view, new window, side by side. 2. (5 points) Prepare journal entries to record each of the above transactions for Computer Solutions for October through December 2019 using the general journal sheet in the Excel file provided. 3. (5 points) Using the general ledger provided in the Excel file, post the transactions from the general journal to the general ledger. 4. (5 points) Transfer balances from the general ledger to the unadjusted trial balance provided. Use SUM formulas to total columns and ensure your trial balance is in balance. If columns do not balance search for errors and correct! (CHECK FIGURES: Cash - (Oct) 42,675; (Nov) 43,737; (Dec) 53,845; Computer Services Revenue - (Oct) 11,408; (Nov) 25,741; (Dec) 31,366; Advertising Expense - (Oct) 1,375; (Nov) 1,375; (Dec) 2,400) 5. Upload your Excel spreadsheet to Blackboard. Zoom Insert Table Chart Text Shape Media 1 2 3 5 R. Santana invested $50,000 cash, a $24,000 computer system, and $6,000 of office equipment in the company in exchange for its common stock. The company paid $3,300 cash for four months' rent. (Use Prepaid Rent account.) The company purchased $1,350 of computer supplies on credit from Harris Office Products. The company paid $2,220 cash for one year's premium on a property and liability insurance policy. The company initially records insurance as a prepaid expense. The company billed West Leasing $4,800 for services performed in instaping a new Web server. The company paid $1,350 cash for the computer supplies purchased from Harris Office Products on October 3. The company hired Lyn Addie as a part-time assistant for $125 per day. as needed. 6 8 1 0 1 2 The company billed West Leasing another $1,400 for services performed. 1 5 1 7 The company received $4,800 cash from West Leasing as partial payment on its account. The company paid $805 cash to repair computer equipment that was damaged when moving it. The company paid $1,375 cash for advertisements published in the local newspaper The company received $1,400 cash from West Leasing on its account. ON 2 2 00 N The company billed IFM Company $5,208 for services performed. 3 1 The company paid $875 cash for Lyn Addie's wages for seven days' work. 3 1 The company paid $875 cash for Lyn Addie's wages for seven days' work. 3 1 The company paid $3,600 cash in dividends. 1 The company reimbursed R. Santana in cash for business automobile mileage allowance (Santana logged 1,000 miles at $0.32 per mile). 2 5 8 8 The company received $4,633 cash from Liu Corporation for computer services performed. The company purchased computer supplies for $1,075 cash from Harris Office Products. The company billed Gomez Co. $5,750 for services performed. The company received notification from Alex's Engineering Co. that Computer Solutions' bid of $3,950 for an upcoming project was accepted. The company received $2,208 cash from IFM Company as partial payment of the October 28 bill. The company donated $250 cash to the United Way in the company's 1 3 8 2 2 name. AN The company completed work and sent a bill for $3,950 to Alex's Engineering Co. The company sent another bill to IFM Company for the past-due amount 2 AN 2 5 The company completed work and sent a bill for $3,950 to Alex's Engineering Co. The company sent another bill to IFM Company for the past-due amount of $3,000. The company reimbursed R. Santana in cash for business automobile mileage (1,200 miles at $0.32 per mile). 2 8 3 0 The company paid $1,750 cash for Lyn Addie's wages for 14 days' work. 3 0 The company paid $2,000 cash in dividends. De 2 C. 3 Paid $1,025 cash to Hilltop Mall for Computer Solutions' share of mall advertising costs. Paid $500 cash for minor repairs to the company's computer. Received $3,950 cash from Alex's Engineering Co. for the receivable from November Paid cash to Lyn Addie for six days of work at the rate of $125 per day. 4 1 0 1 4 1 5 Notified by Alex's Engineering Co. that Computer Solutions' bid of $7,000 on a proposed project has been accepted. Alex's paid a $1,500 cash advance to Business Solutions. Purchased $1,100 of computer supplies on credit from Harris Office Products. Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8. 1 6 ON Completed a project for Liu Corporation and received $5,625 cash. 22-26 Took the week off for the holidays. Received $3,000 cash from Gomez Co. on its receivable. 2 8 2 9 Reimbursed R. Santana for business automobile mileage (600 miles at $0.32 per mile). The company paid $1,500 cash in dividends. 3 1 Required: 1. Open the Excel file provided and save as YourName_ACCT305_PS1. The Excel file includes the following worksheets: general journal, general ledger, and 2019 trial balance. You will add additional worksheets to the file as you complete the assignment. NOTE: You may find it helpful to view two worksheets at the same time. This can be done by using view, new window, side by side. 2. (5 points) Prepare journal entries to record each of the above transactions for Computer Solutions for October through December 2019 using the general journal sheet in the Excel file provided. 3. (5 points) Using the general ledger provided in the Excel file, post the transactions from the general journal to the general ledger. 4. (5 points) Transfer balances from the general ledger to the unadjusted trial balance provided. Use SUM formulas to total columns and ensure your trial balance is in balance. If columns do not balance search for errors and correct! (CHECK FIGURES: Cash - (Oct) 42,675; (Nov) 43,737; (Dec) 53,845; Computer Services Revenue - (Oct) 11,408; (Nov) 25,741; (Dec) 31,366; Advertising Expense - (Oct) 1,375; (Nov) 1,375; (Dec) 2,400) 5. Upload your Excel spreadsheet to Blackboard

Answer & Explanation Solved by verified expert

See Answer