{"id":114729,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/acc303-module-3-project-2"},"modified":"2017-08-03T16:09:45","modified_gmt":"2017-08-03T16:09:45","slug":"acc303-module-3-project-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/acc303-module-3-project-2\/","title":{"rendered":"ACC303 module 3 project 2"},"content":{"rendered":"<div class=\"the_content_wrapper\">\n<p>ACC303 module 3 project 2<br \/> For this module you are to complete the following assignment:<br \/> From the QuickBooks \u201cStudent Problems and Cases\u201d book:<\/p>\n<p>Question 4-1<\/p>\n<p>Question 4-2<\/p>\n<p>Question 4-3<\/p>\n<p>Question 4-4<\/p>\n<p>Question 4-5<\/p>\n<p>Report Requirement 4-1 (export the report to Excel and submit it, do not \u201cprint\u201d the report)<\/p>\n<p>green Rectangle<\/p>\n<p>Line<\/p>\n<p>Previous<\/p>\n<p>Next<\/p>\n<p>Project 2<\/p>\n<p>For this module you are to complete the following assignment:<\/p>\n<p>From the QuickBooks \u201cStudent Problems and Cases\u201d book:<\/p>\n<p>Question 4-1<\/p>\n<p>Question 4-2<\/p>\n<p>Question 4-3<\/p>\n<p>Question 4-4<\/p>\n<p>Question 4-5<\/p>\n<p>Report Requirement 4-1 (export the report to Excel and submit it, do not \u201cprint\u201d the report)<\/p>\n<p>\u2022 Question 4-1: Rock Castle Construction \u2013 Questions about customers, sales, and collections<\/p>\n<p>a. Which customer has the largest outstanding account balance on the current date (12\/15\/2016)? Which one has the smallest balance excluding zero balances?<\/p>\n<p>b. What is the total amount of invoices for the current fiscal year-to-date?<\/p>\n<p>c. What is the total amount of open invoices for the current month to day (12\/1\/2016 to 12\/15\/2016)?<\/p>\n<p>d. Which customer paid the largest amount using MasterCard this fiscal year-to-date?<\/p>\n<p>\u2022 Question 4-2:<\/p>\n<p>a. How many paychecks did Elizabeth Mason receive in November 2016?<\/p>\n<p>b. Explain the difference between the nature of payroll checks and liability checks for payroll?<\/p>\n<p>c. Which employee received the largest net paycheck every pay period in the current fiscal year?<\/p>\n<p>\u2022 Question 4-4b:Rock Castle Construction \u2013 Print a list of vendor\u2019s transactions and export thelist<\/p>\n<p>a. Print a list of bills for the vendor Perry Windows &amp; Doors for the current fiscal year to date using only four columns in the following order from left to right: Amount, Open Balance, Date, and Due Date. Sort the list by account balance, with the largest amount on top.<\/p>\n<p>b. Export the list in part (a) to Excel using the Export Transactions menu item. After exporting to Excel, print a list of bills for Perry Windows &amp; Doors with an invoice amount of $1,000 or<\/p>\n<p>more. Except for the excluded bills, the columns and sorting should be the same as in Questions 4-4a. All headings should be in bold. The printout should include a description of the printout and the date.<\/p>\n<p>\u2022 Question 4-5: Larry\u2019s Landscaping &amp; Garden Supply \u2013 Use drill down in cash receipts<\/p>\n<p>Open the Customer Center: Received Payments list window. Drill down on Check No. 3250 dated 11\/20\/2016.<\/p>\n<p>a. Who was the customer?<\/p>\n<p>b. Were there any other sales to the customer in Question 4-5a that are currently unpaid? Explain.<\/p>\n<p>c. What was the sales invoice number and date of the sale for the above collection?<\/p>\n<p>d. What products or services were sold on the invoice?<\/p>\n<p>e. Was a discount taken by the customer on this receipt?<\/p>\n<p>\u2022Question 4-6: Larry\u2019s Landscaping &amp; Garden Supply \u2013 Use drill down of employees<\/p>\n<p>Open the Employees Center and use drill down to open the Edit Employee window for Shane Hamby.<\/p>\n<p>a. What is his social security number?<\/p>\n<p>b. What is his annual salary amount?<\/p>\n<p>c. What is his filing status for federal taxes?<\/p>\n<p>d. For the payment to Hamby on 6\/16\/2016, what was the amount of his total earnings and federal income tax withholding?<\/p>\n<p>e. How much did Larry\u2019s Landscaping &amp; Garden Supply pay for his Federal unemployment for the pay period of 6\/16\/2016?<\/p>\n<p>\u2022 Question 4-7: Larry\u2019s Landscaping &amp; Garden Supply \u2013 Use drill down of Chart of Accounts<\/p>\n<p>a. Use drill down to determine the balance in the Bank of Anycity Loan account at 11\/30\/2016. What is the balance?<\/p>\n<p>b. What were the total debits and credits for the 10\/28\/2016 transaction to that account?<\/p>\n<p>\u2022 Report Requirement 4-1 (export the report to Excel and submit it, do not \u201cprint\u201d thereport):<\/p>\n<p>a. Print and hand in a standard profit and loss statement for Larry\u2019s Landscaping &amp; Garden Supply for this fiscal quarter to dsate (10\/01\/2016 to 12\/15\/2016) in two columns?<\/p>\n<p>b. Print and hand in a standard profit and loss statement for Larry\u2019s Landscaping &amp; Garden Supply, by quarter for the last fiscal year. Each quarter and the total should be in separate columns<\/p>\n<p>c. Which quarter was the most profitable for the company during the last fiscal year?<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>ACC303 module 3 project 2 For this module you are to complete the following assignment: From the QuickBooks \u201cStudent Problems and Cases\u201d book: Question 4-1 Question 4-2 Question 4-3 Question 4-4 Question 4-5 Report Requirement 4-1 (export the report to <a href=\"https:\/\/www.benedictsol.com\/blogs\/acc303-module-3-project-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-114729","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/114729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=114729"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/114729\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=114729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=114729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=114729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}