required: Step # 9, 10, 11,12,13,14,15,16,17,18, 21 (Excel format), 22 (word format- memorandum) and Audit questions #1 - 16.

In this protelem, you will process the sales and purchaves transactions for the wish Questions 4-B on pagess 195196 as yoa ceenfiete this probicm. Dispiay reprith an necesary to answer the questiott: Warning: The knventory valubon (Werchandise Inventory and Cont of Coobs Sold accounts) may be aflected by the order in which transactions are eriethey Therefore, making corrections to earlier transactons or changing the seguenices which transactiors are entered may afect the fifo method of valuation usitu in thy problem. If you mant maike a rorthabon to a prevously entered transachich a the Step 1t Start fitegrated Accoumting Be. Step 2. Load opening bafances file 148 Problem 04-B. Step 3: Enter your name in the Your Name text box and click OK. Step 4: Save the file with a file name of 04-B Your name. Step 5: Enter the following purchase order and purchase involce transactions. Weekly Purchase Order and Purchase Irvoice Transactions Feb 08 Ordered the following merchandise from Nantz Vacuum Cicaner Co. terms 2/10, n/30. Purchase Order No. 277. 09 Ordered the following menchandise from Alpha Vacuum Mfgus inc, terms 2/10, n/30. Purchase Order No. 278. 12 Received the following merchandise for Purchase Order No. 275 from Handy Manufacturing. Inc, terms 2/10, n/30. Purchase Invoice No. 859. 14 Received the foliowing merchandise for Purchase Order No, 276 from Royal Accessories, lnc., terms 2/10, n/30. Purchase invoice No. 860. Weekly Sales Invoice Transactions Feb 08 The following merchandise was returned to Vetter Vacuum Center: 7% sales tax, Sales invoice No, 531: Feb 09 Sold the following merchandise to Fraze Department Stores, terms 2/10,n/30,7% sales tax, Sales Invoice No. S32. Feb 10 Sold the following merchandise to Robert Thorson, terms 30 days, 7% sales tax, Sales invoice No. 533: Feb 11 Sold the following merchandise to Jennifer Martens, terms 30 days, 7%6 sales tax, Sales Invoice No. 534 : Feb 12 Sold the following merchandise to Broderick Company, terms 210, n/30, 796 sales tax, Sales invoice No. 535 : Feb 13 Sold the following merchandise to Lilly Industres, inc., terms a ro, Weably Coih Payment Transactions Zw dekisunt5 51.15. Oheck Ma. 3621. dicount. Check Ho 1622 3epp if. fater the follewing canh recelpt transactions. Wrebly Canh Recelpt Transactions fot 10 Arcelied cauh on acrount trom Bassett Cleaning, the covering subes livoise No. 527 for 5909.13, less 29 discoint 11818 11. Recerved cash on account from Robert Thorion, covering Sales irvoice Na. 528 for 5347.75, no discount. 14 dectived cash on account from Broderick Company, coverng Salis invoice No 529 for 51,076.84, less 2. dincount. 52134. Step 9: Display the purchase order, purchase involce, and sales invole, reglsters for the period February 8 through February 14 . Step 10: Display the general, purchases, cash payments, sales, and cash receipts fournals for the period February 8 through February 14 Step 11: Dlsplay a Ceneral Ledger report for the Accounts Recelvable, Sales, Sales Returns and Allowance, and Sales Discount accounts. Step 12: Display a Trial Balance report. Step 13: Display a Schedule of Accounts Recelvable and an Accounts Receivable Ledger report for all customers. geep 17i Dispiny the Yearly sales report. swe 18: Display the Top Customers graph. gtep 19: Save your datin to disk. step 20: Optlonal spresduheet integration activity. necessary. 2. Display and oopy the yeaty ales repon to decligboand in sprestshect format. b. Start your spresdeheet wifte are and lowe file tas Spreafhheet o4.s. c. Seiect cell A1 as the currem cell (if nct alrealy selected) and paste the yearly sales report into the spreatsheet. 4. In cell B35. enter the IF funstiot appespriate for your spreadsheet woftware to divplay the descrivinie of each invensory ioem with year-to-date grons ales greater than $3,000,00 - if thot, dieptay "Delete this tow "For esample, IFE10>3000.B10, Delete this row""). Copy the formula from cell a3s to cells B36-B50 e. In cell Ca5, enter the If function appropriate for your spreaduheet software to display the amount of each inventory item with yeat-6s. date gross sales greater than $3,000,00 - if mot, display a blank. For example, af IFE10s 3000. R10,* *). Copy the formula frum cell C.35 to cells C36-CSO. f. Delete the rows in cells B35-B50 that contain "Delete this row." g. Sum the amount (column C) of the items that match the criteria, and use this sum to calculate and display the percent of yearfy total sales. h. Print the list of items that meet the criteria. i. Save your spreadsheet data with a file name of O4-B Your Name: Step 21: Optional word processing Integration activity. Prepare a memorandum to the Owner of Vetter Vacuam Center iDiane Vetter) listing the items of inventory with year-to-date gross sales greater than $3,000.00 and their percent of total sales. a. Copy the list of inventory items from the specadsheet. d Format the document as neceksary. c. Enter your name and today's date where indicated. f. Prut the memorandum. g. Save the memorandum document with a file name of 04B Youp Name. If you have access to the Internet, use your browser to find information about VAT (value added tax) in another country. Hint: Use internationgl taxation as a scarch string, then use search argument VAT. Report on your findings. Be sure to include the sources, including URLs (Web addreiss. of your reported findings. Step 22: End the fntegrated Accounting 8e session. Register Reports 1. What is the total amount of purchase orders for the period? 2. What is the total amount of purchase invoices for the period? 3. What is the total amount of sales for the period? journal and Ledger Reports 4. What are the total debits and credits shown on the purchases joumal? 5. What are the total debits and credits shown on the cash payments joumal? 6. What are the total debits and credits shown on the sales joumal? 7. What are the total debits and credits shown on the cash receipts journal? 8. From the general ledger report, what was the Accounts Receivable account balance on February 14? 9. What is the account balance of the following accounts as of February 14 ? Sales Sales Returns and Allowances Sales Discount 11. From the schedule of accounts receivable, what is the total due from an customers as of February 14? Does it equal the current balance in the Accounts Receivable account? 12. From the statement of account for Wingler Motel, what is the current account balance? Inventory Reports and Graph: 13. How many items were sold during the period? 14. Which item has the greatest sales volume based on the dollar amount? 15. What is the total amount of yearly sales? 16. From the graph, what customer has greatest amount of sales to date? In this protelem, you will process the sales and purchaves transactions for the wish Questions 4-B on pagess 195196 as yoa ceenfiete this probicm. Dispiay reprith an necesary to answer the questiott: Warning: The knventory valubon (Werchandise Inventory and Cont of Coobs Sold accounts) may be aflected by the order in which transactions are eriethey Therefore, making corrections to earlier transactons or changing the seguenices which transactiors are entered may afect the fifo method of valuation usitu in thy problem. If you mant maike a rorthabon to a prevously entered transachich a the Step 1t Start fitegrated Accoumting Be. Step 2. Load opening bafances file 148 Problem 04-B. Step 3: Enter your name in the Your Name text box and click OK. Step 4: Save the file with a file name of 04-B Your name. Step 5: Enter the following purchase order and purchase involce transactions. Weekly Purchase Order and Purchase Irvoice Transactions Feb 08 Ordered the following merchandise from Nantz Vacuum Cicaner Co. terms 2/10, n/30. Purchase Order No. 277. 09 Ordered the following menchandise from Alpha Vacuum Mfgus inc, terms 2/10, n/30. Purchase Order No. 278. 12 Received the following merchandise for Purchase Order No. 275 from Handy Manufacturing. Inc, terms 2/10, n/30. Purchase Invoice No. 859. 14 Received the foliowing merchandise for Purchase Order No, 276 from Royal Accessories, lnc., terms 2/10, n/30. Purchase invoice No. 860. Weekly Sales Invoice Transactions Feb 08 The following merchandise was returned to Vetter Vacuum Center: 7% sales tax, Sales invoice No, 531: Feb 09 Sold the following merchandise to Fraze Department Stores, terms 2/10,n/30,7% sales tax, Sales Invoice No. S32. Feb 10 Sold the following merchandise to Robert Thorson, terms 30 days, 7% sales tax, Sales invoice No. 533: Feb 11 Sold the following merchandise to Jennifer Martens, terms 30 days, 7%6 sales tax, Sales Invoice No. 534 : Feb 12 Sold the following merchandise to Broderick Company, terms 210, n/30, 796 sales tax, Sales invoice No. 535 : Feb 13 Sold the following merchandise to Lilly Industres, inc., terms a ro, Weably Coih Payment Transactions Zw dekisunt5 51.15. Oheck Ma. 3621. dicount. Check Ho 1622 3epp if. fater the follewing canh recelpt transactions. Wrebly Canh Recelpt Transactions fot 10 Arcelied cauh on acrount trom Bassett Cleaning, the covering subes livoise No. 527 for 5909.13, less 29 discoint 11818 11. Recerved cash on account from Robert Thorion, covering Sales irvoice Na. 528 for 5347.75, no discount. 14 dectived cash on account from Broderick Company, coverng Salis invoice No 529 for 51,076.84, less 2. dincount. 52134. Step 9: Display the purchase order, purchase involce, and sales invole, reglsters for the period February 8 through February 14 . Step 10: Display the general, purchases, cash payments, sales, and cash receipts fournals for the period February 8 through February 14 Step 11: Dlsplay a Ceneral Ledger report for the Accounts Recelvable, Sales, Sales Returns and Allowance, and Sales Discount accounts. Step 12: Display a Trial Balance report. Step 13: Display a Schedule of Accounts Recelvable and an Accounts Receivable Ledger report for all customers. geep 17i Dispiny the Yearly sales report. swe 18: Display the Top Customers graph. gtep 19: Save your datin to disk. step 20: Optlonal spresduheet integration activity. necessary. 2. Display and oopy the yeaty ales repon to decligboand in sprestshect format. b. Start your spresdeheet wifte are and lowe file tas Spreafhheet o4.s. c. Seiect cell A1 as the currem cell (if nct alrealy selected) and paste the yearly sales report into the spreatsheet. 4. In cell B35. enter the IF funstiot appespriate for your spreadsheet woftware to divplay the descrivinie of each invensory ioem with year-to-date grons ales greater than $3,000,00 - if thot, dieptay "Delete this tow "For esample, IFE10>3000.B10, Delete this row""). Copy the formula from cell a3s to cells B36-B50 e. In cell Ca5, enter the If function appropriate for your spreaduheet software to display the amount of each inventory item with yeat-6s. date gross sales greater than $3,000,00 - if mot, display a blank. For example, af IFE10s 3000. R10,* *). Copy the formula frum cell C.35 to cells C36-CSO. f. Delete the rows in cells B35-B50 that contain "Delete this row." g. Sum the amount (column C) of the items that match the criteria, and use this sum to calculate and display the percent of yearfy total sales. h. Print the list of items that meet the criteria. i. Save your spreadsheet data with a file name of O4-B Your Name: Step 21: Optional word processing Integration activity. Prepare a memorandum to the Owner of Vetter Vacuam Center iDiane Vetter) listing the items of inventory with year-to-date gross sales greater than $3,000.00 and their percent of total sales. a. Copy the list of inventory items from the specadsheet. d Format the document as neceksary. c. Enter your name and today's date where indicated. f. Prut the memorandum. g. Save the memorandum document with a file name of 04B Youp Name. If you have access to the Internet, use your browser to find information about VAT (value added tax) in another country. Hint: Use internationgl taxation as a scarch string, then use search argument VAT. Report on your findings. Be sure to include the sources, including URLs (Web addreiss. of your reported findings. Step 22: End the fntegrated Accounting 8e session. Register Reports 1. What is the total amount of purchase orders for the period? 2. What is the total amount of purchase invoices for the period? 3. What is the total amount of sales for the period? journal and Ledger Reports 4. What are the total debits and credits shown on the purchases joumal? 5. What are the total debits and credits shown on the cash payments joumal? 6. What are the total debits and credits shown on the sales joumal? 7. What are the total debits and credits shown on the cash receipts journal? 8. From the general ledger report, what was the Accounts Receivable account balance on February 14? 9. What is the account balance of the following accounts as of February 14 ? Sales Sales Returns and Allowances Sales Discount 11. From the schedule of accounts receivable, what is the total due from an customers as of February 14? Does it equal the current balance in the Accounts Receivable account? 12. From the statement of account for Wingler Motel, what is the current account balance? Inventory Reports and Graph: 13. How many items were sold during the period? 14. Which item has the greatest sales volume based on the dollar amount? 15. What is the total amount of yearly sales? 16. From the graph, what customer has greatest amount of sales to date