Rinaldo arrives in a cheerful mood because he has just received some new sales prospects. You congratulate him and tell him about your Sage 50 experiences. He is pleased with your progress but says that because you are still new to the work, he will continue to mentor and supervise you closely over the next few weeks. Rinaldo then hands you the following list of transactions that occurred throughout mid May up to yesterday (May 20) and asks you to record them in Sage 50: Transactions from mid May 2017 May & Purchased 10 units DK800 desktop computers from Big Telco at $1,100 each, Invoice No. 793. May 9 Made a cash sale to Handys Electronics, Invoice No. 3060 for the following items: 4 units DKBDD desktop computers for $1,700 each plus 5% sales tax 4 units Swish Phones for $1,600 each plus 5% sales tax. Received Check No. 618 for $13,860 from this customer. May 12 Received a sales order from Turbo Tech. Sales Order No. 3013. The following items are required to be shipped by May 23, 2017: 3 units DKBOO desktop computers at $1,700 each plus 5% sales tax 15 units Tony ZIO MLP projectors at $2,200 each, plus 5% sales tax. May 15 Issued Check No. 4078 for $6,300 to pay Advanced Property Management for three month's worth of rent in advance. May 16 Purchased 6 units Zii game consoles from Big Telco for a list price of $840 each, Invoice No. 798. Issued Check No. 4079 for the full payment of this purchase. May 16 Ordered 9 units Tony ZIO MLP projectors for $1,420 each, from Mega Tech, Purchase Order No. 471. May 18 sold merchandise on credit to Radio Hut, Irwoice No. 3061. The items sold were: 11 units Swish Phones for $1,600 each plus 5% sales tax 10 units Zii game consoles for $1,300 each plus 5% sales tax. May 19 Received 9 units Tony ZIO MLP projectors, Invoice No. 759. These items were ordered from Mega Tech for $1,420 each, Purchase Order No. 471. Once you have finished recording the above transactions using Sage 50, Rinaldo instructs you to prepare a bank deposit ticket for any check received during the middle of May so that he can take it to the bank this afternoon. Rinaldo also asks you to print a more up-to-date trial balance that includes all transactions up until the end of yesterday (May 20, 2017). He wants to compare this trial balance to the one that you made for him earlier. In particular, he is interested to know the impact of the Mid May transactions on the accounts of the business. As usual, he will also ask you to answer several questions about Sage 50. Instructions 1. Use Sage 50 to record all of the Mid May transactions for Intermaweb Computer in Sage 50. Note that: For each check received by the business, the check number is to be recorded in the reference field of the Receive Money window. When recording purchase invoices in the Purchases/Receive Inventory window, you must enter the check number of each check issued at the time of the purchase) in the Reference . When recording purchase invoices in the Purchases/Receive Inventory window, you must enter the check number of each check issued at the time of the purchase) in the Reference field of that window. 2. After all of the above transactions have been entered into Sage 50, use that software to create a bank deposit ticket as of May 21, 2017 (Deposit Ticket ID 2) and indude all of the checks received during the middle of May into that deposit ticket 3. Print the trial balance for Intermaweb Computer as of May 21, 2017 and transcribe your answers into the trial balance provided below. Note that your printed trial balance must not include accounts with zero balances. 4. Answer all of the questions that Rinaldo asks you below. Intermaweb Computer General Ledger Trial Balance As of May 21, 2017 Debit Amt Credit Amt Account ID Account Description 1020 Checking Account 13860 1100 Accounts Receivable 1150 Allowance for Doubtful Account 1200 inventory 1100 13200 1300 Office Supplies 1400 Prepaid Rent 1500 Property and Equipment 1900 Accum. Depreciation - Prop.Et 2000 Accounts Payable 1100 2310 Sales Tax Payable 6801 2330 Federal Payroll Taxes Payable 2600 Short Term Debt 2700 Long Term Debt-Noncurrent 3910 Retained Earnings 3930 Common Stock 4000 Sales Income 5000 Cost of Goods Sold 6000 Salaries Expanse 2330 Federal Payroll Taxes Payable 2600 Short Term Debt 2700 Long Term Debt-Noncurrent 3910 Retained Earnings 3930 Common Stock 4000 Sales Income 5000 Cost of Goods Sold 6000 Salaries Expense 6100 Payroll Tax Expense 6150 Bad Debt Expense 6400 Utilities Expense 6450 Office Supplies Expense 6500 Telephone Expense 6850 Service Charge Expense 6900 Purchase Disc-Expense Items 7050 Depreciation Expense Total: 14960 14960 Questions on Sage 50 10-315.EMMTB.SE.02 After you have recorded the given transa in Sage 50, Rinal asks you to open the Purchase Orders window and identify the fields that are provided in that window. To open the Purchase Orders window: 1. From the Navigation Bar, click Vendors & Purchases 2. In the Vendors & Purchases Tasks section, click the Purchase Orders icon 3. Select the New Purchase Order option from the drop-down list that appears next to the Purchase Orders icon. Select the fields that are not in the Purchase Orders window: Good thru and PO No. ONP account and Ship via Vendor ID and Ship to O Ship by and Customer PO. Rinaldo arrives in a cheerful mood because he has just received some new sales prospects. You congratulate him and tell him about your Sage 50 experiences. He is pleased with your progress but says that because you are still new to the work, he will continue to mentor and supervise you closely over the next few weeks. Rinaldo then hands you the following list of transactions that occurred throughout mid May up to yesterday (May 20) and asks you to record them in Sage 50: Transactions from mid May 2017 May & Purchased 10 units DK800 desktop computers from Big Telco at $1,100 each, Invoice No. 793. May 9 Made a cash sale to Handys Electronics, Invoice No. 3060 for the following items: 4 units DKBDD desktop computers for $1,700 each plus 5% sales tax 4 units Swish Phones for $1,600 each plus 5% sales tax. Received Check No. 618 for $13,860 from this customer. May 12 Received a sales order from Turbo Tech. Sales Order No. 3013. The following items are required to be shipped by May 23, 2017: 3 units DKBOO desktop computers at $1,700 each plus 5% sales tax 15 units Tony ZIO MLP projectors at $2,200 each, plus 5% sales tax. May 15 Issued Check No. 4078 for $6,300 to pay Advanced Property Management for three month's worth of rent in advance. May 16 Purchased 6 units Zii game consoles from Big Telco for a list price of $840 each, Invoice No. 798. Issued Check No. 4079 for the full payment of this purchase. May 16 Ordered 9 units Tony ZIO MLP projectors for $1,420 each, from Mega Tech, Purchase Order No. 471. May 18 sold merchandise on credit to Radio Hut, Irwoice No. 3061. The items sold were: 11 units Swish Phones for $1,600 each plus 5% sales tax 10 units Zii game consoles for $1,300 each plus 5% sales tax. May 19 Received 9 units Tony ZIO MLP projectors, Invoice No. 759. These items were ordered from Mega Tech for $1,420 each, Purchase Order No. 471. Once you have finished recording the above transactions using Sage 50, Rinaldo instructs you to prepare a bank deposit ticket for any check received during the middle of May so that he can take it to the bank this afternoon. Rinaldo also asks you to print a more up-to-date trial balance that includes all transactions up until the end of yesterday (May 20, 2017). He wants to compare this trial balance to the one that you made for him earlier. In particular, he is interested to know the impact of the Mid May transactions on the accounts of the business. As usual, he will also ask you to answer several questions about Sage 50. Instructions 1. Use Sage 50 to record all of the Mid May transactions for Intermaweb Computer in Sage 50. Note that: For each check received by the business, the check number is to be recorded in the reference field of the Receive Money window. When recording purchase invoices in the Purchases/Receive Inventory window, you must enter the check number of each check issued at the time of the purchase) in the Reference . When recording purchase invoices in the Purchases/Receive Inventory window, you must enter the check number of each check issued at the time of the purchase) in the Reference field of that window. 2. After all of the above transactions have been entered into Sage 50, use that software to create a bank deposit ticket as of May 21, 2017 (Deposit Ticket ID 2) and indude all of the checks received during the middle of May into that deposit ticket 3. Print the trial balance for Intermaweb Computer as of May 21, 2017 and transcribe your answers into the trial balance provided below. Note that your printed trial balance must not include accounts with zero balances. 4. Answer all of the questions that Rinaldo asks you below. Intermaweb Computer General Ledger Trial Balance As of May 21, 2017 Debit Amt Credit Amt Account ID Account Description 1020 Checking Account 13860 1100 Accounts Receivable 1150 Allowance for Doubtful Account 1200 inventory 1100 13200 1300 Office Supplies 1400 Prepaid Rent 1500 Property and Equipment 1900 Accum. Depreciation - Prop.Et 2000 Accounts Payable 1100 2310 Sales Tax Payable 6801 2330 Federal Payroll Taxes Payable 2600 Short Term Debt 2700 Long Term Debt-Noncurrent 3910 Retained Earnings 3930 Common Stock 4000 Sales Income 5000 Cost of Goods Sold 6000 Salaries Expanse 2330 Federal Payroll Taxes Payable 2600 Short Term Debt 2700 Long Term Debt-Noncurrent 3910 Retained Earnings 3930 Common Stock 4000 Sales Income 5000 Cost of Goods Sold 6000 Salaries Expense 6100 Payroll Tax Expense 6150 Bad Debt Expense 6400 Utilities Expense 6450 Office Supplies Expense 6500 Telephone Expense 6850 Service Charge Expense 6900 Purchase Disc-Expense Items 7050 Depreciation Expense Total: 14960 14960 Questions on Sage 50 10-315.EMMTB.SE.02 After you have recorded the given transa in Sage 50, Rinal asks you to open the Purchase Orders window and identify the fields that are provided in that window. To open the Purchase Orders window: 1. From the Navigation Bar, click Vendors & Purchases 2. In the Vendors & Purchases Tasks section, click the Purchase Orders icon 3. Select the New Purchase Order option from the drop-down list that appears next to the Purchase Orders icon. Select the fields that are not in the Purchase Orders window: Good thru and PO No. ONP account and Ship via Vendor ID and Ship to O Ship by and Customer PO