Flowcharting, memo, PLEASE READ THOROUGHLY! Thank you in advance!

SYSTEM IMPLEMENTATION AND TRANSACTION PROCESSING PROJECT (300 POINTS) MARY'S SUNSHINE POOL CASE BACKGROUND The objectives of this project are as follows: To reinforce your learning the AIS concepts presented in class To experience a transaction processing application To see the composition of the fields on different tables, such as the fields contained in the general ledger table, the accounts receivable table, etc. To see the advantages of the automated features contained in an accounting information system, such as the automatic posting of transactions To demonstrate on-line computer controls such as field edits, reasonableness checks, etc. To see the interfaces between sub-systems and the general ledger and increase your ability to track information into the financial reports To experience implementing an accounting system To practice project planning with an inflexible deadline To experience an extensive, multi-part project completed as a team. REQUIREMENTS Assume that Mary's Sunshine Pool Incorporated has hired you as a consultant to analyze the company's performance and to implement a computerized accounting system. The present accounting system is entirely manual. The new system will be an accounting software package that runs on a microcomputer Points 1. 25 Requirement Prepare a project plan in Gantt chart format showing how you and your partner completed the project Prepare a system flowchart of Mary's Sunshine Pool Company's transaction processing under the manual system as described in this handout Perform the company set up and process transactions for the company. 2. 50 3. 125 4. 75 Prepare a one-page memo to the company owners analyzing their business performance. Total task points 50 Participation points to be split between team members 275 CASE MATERIALS MARY'S SUNSHINE POOL INCORPORATED 4000 AIS Rocks Blvd. Anywhere, XX 12345 Federal Tax ID: XX-XXXXXXX COMPANY BACKGROUND Mary's Sunshine Pool Incorporated is a merchandising firm that sells various pool supplies,c.g., chemicals, diving boards, pumps, ladders, poolside fumiture, pmol games, floating loungers. present, Mary's Sunshine has a manual accounting system; however, the company has hired you to implement an accounting program to be used on a personal computer as of July 1, the beginning of the current fiscal year. Mary and Ed, the stockowners of the company, have made available to you the balance sheet and data from the subsidiary ledgers for the fiscal year ended June 30. As of June 30, Mary's Sunshine Pool Company consisted of a showroom and an office in one building, a distribution center in another building, and five employees. The employees are: Lauren Allen, a salesperson at the showroom, Paul Barton and Criest Callahan, traveling salesmen, and Fred and Ted Hill, Mary and Ed's twin sons who work at the distribution center only during the summer rrunths. Mary's Sunshine Pool Incorporated owns the land, the showroom/office building, the distribution center building, a delivery truck and two automobiles driven by the traveling salesmen. REVENUE CYCLE Order Processing Sales are made to users of pool supplies. Pool supplies are displayed and orders for products are taken in the showroom. The traveling salesmen also take orders. The distribution center is located on the same lot as the showroom/office building. It is here that the orders are filled and shipped. All sales are credit sales, which are subject to the approval of Ed. Ed approves credit based on his "gut" feeling for each individual case and on the opinions of his bowling buddies. Generally. Ed wants to make the sales and few orders are not approved. In the few cases where Ed does not approve the credit, he marks his copy of the sales order accurdingly. He makes a copy of all of the disapproved orders and two copies of the approved orders. He sends one copy of both the approved and disapproved orders and all of the original orders to Mary. He sends a copy of the approved orders to the twins so they can fill them. Mary prepares a report for each salesperson listing both the sales orders turned down for credit and the approved sales and sends the reports along with the marked sales orders to the salespeople. The salespeople notify customers of disapproved credit and then throw the reports and disapproved sales orders in their car trunks or wastebaskets. The salespeople file the original approved sales orders for later usc. Mary files the copies of the approved orders until a shipping notice is received. The copies of the disapproved orders are thrown away. Shipping Out of town orders are shipped common carrier FOB Destination. Recently, Ed had a brief meeting with the twins about the possibility of sending the bulk of freight shipments through one common carrier, Belated Shipping Company. The advantage to Mary's Sunshine would be a rebate paid quarterly of up to 15% of freight charges. Based on prior years business, this rebate would total excess of $15,000 per year. Without giving this practice much thought, Ed told the twins to begin using Belated Shipping Company as much as possible. The twins take all of the approved orders, find and box the merchandise and prepare a bill of lading for the carrier. The twins send their copy of the sales order marked shipped' and a copy of the bill of lading to Mary. After an order has heen shipped, the twins update the inventory cards to keep an accurate record of items on hand. At the end of the week, all of the inventory cards are reviewed and a weekly inventory report is prepared. Accounts Receivable Mary matches the sales order marked "shipped" to her copy of the sales order. She then prepares a two-part invoice and mails the original to the customer. She records the sales in the sales journal and the receivables in the subsidiary ledger. Mary files by date her copy of the invoice with her copy of the sales order and the shipping documents. During the summer scason, Mary's Sunshine often has difficulty in shipping customer orders in a timely manner. Supplier delays in delivery to Mary's Sunshine and increased volume cause delays in outgoing shipments. At the end of some months, Mary prepares and mails customer invoices ahead of actual shipment. She claims this practice more closely matches revenues and expenses. As usual, Mary records the sales in the sales journal and in the accounts receivable subsidiary ledger. Customers are allowed to take a 2% discount if they pay within 10 days of the billing date; otherwise, the net armuunt is due in 30 days. Once per month, Mary prepares a listing of delinquent customers that she sends to the salespeople. They are responsible for collecting the overdue amounts. Cash Receipts Mary opens the mail cach day; sorts the cash receipts and the invoices to be paid and logs them in the appropriate logs. Mary records the receipts on customers account in the cash receipts journal and in the accounts receivable subsidiary ledger. After recording all the cash receipts, she prepares a deposit slip and takes the cash to the bank. DISBURSEMENT CYCLE Purchasing Every Friday afternoon, the salespeople prepare weekly sales reports from their copies of the sales orders. They send the reports to Ed and then refile their sales orders by customer name. Ed reviews the weekly sales reports and the weekly inventory reports prepared by Fred and Ted. Ed 'eyeballs' the numbers, notes any shortages in inventory, and prepares 3-part purchase orders. He mails the original to the vendor, sends one to the twins in the distribution center and one copy to Mary. As noted above, Fred and Ted have a card file for keeping track of inventory. Each card has a running balance to expedite the preparation of the weekly inventory reports for Ed. When they receive a copy of a purchase order, they pull the cards for the item(s) ordered, record the quantity ordered and the P.O. number, and file the purchase order in numerical order. When the shipment arrives, Fred und Ted pulls the purchase order to make sure that the items received were the items orcicred and notc any hack orders on the purchase order. Then they pull the inventory cards, mark the items received, and preparc a receiving report that is sent to Mary Cash Disbursements As noted above. Mary opens the mail and separates and logs the cash receipts and the invoices to be paid. Invoices are filed in alphabetical order by due date. Each Thursday, Mary pulls the invoices that are due that week and types three-part checks. The checks, along with the invoices, are given tu Ed for his approval and signature. After Ed signs the checks, Mary mails the original, files the second copy in check number order, and attaches the third copy to the invoice. She then enters the check in the cash disbursement journal and the accounts payable subsidiary ledger. The third copy of the check and the attached invoice arc filed alphabetically by vendor name. Payroll A full service payroll processing company called Payroll Paid Promptly (PPP) processes payroll, PPP calculates the payroll, creates and mails the checks to the employees and remits all payroll taxes and other withholdings to the appropriate locations. They send Mary a report once per month reflecting the transactions made on behalf of PPP Mary prepares a journal entry to reflect the payroll and updates the general ledger. PPP charges a fee of 10% of the gross payroll for the payroll service. Mary prepares the check for these services once per month. The ernployees, who are paid once a month, are as follows: Lauren Allen, a salesperson at the showroom Paul Barton and Ernest Callahan, traveling salesmen Fire and Till tone whory at the distribution conter 1. Project Plan Determine the tasks that you will perform to complete the project a. Determine how your team will complete the tasks b. Prepare a Gantt chart with time and dates indicated c. & b Prepare a final Gantt chart showing when the tasks were competed and how many hours each task took compared to your planned hours. Hint think carefully about how you want to complete the tasks and how much you trust your partner to get his/her portion of the project done. 2. Prepare a system flowchart Follow the flowcharting guidelines in your textbook and as we have discussed in class, The final copy of the flowchart should be prepared using flowcharting softwarc or Microsoft office. Hint: It is usually the cusiest to set up the flowchart with a page for cach process. 3. Set up Company and process transactions a. Configure Company (Set Up Information) You need to start by creating a new company for the business. Read through the entire case before you start setting up your company. Note: given that this is a class project, the company name should be your names. Complete the company information making up information as you see fit. The proper date to start recording the transactions is 7/1. The fiscal year is 7/1/CY through 06/30/NY. You will establishing the chart of accounts, the vendors, the customers and the inventory and service products. As part of your configuration, you need to decide the coding schemes that will be used for cach of these data files. Also, to save yourself time, carefully set up the "default" information for customers, vendors, and inventory items. The company uses one checking account. The business has used prenumbered invoices and checks in the past. However, given that they need to purchase new forms to accommodate the new software they plan to restart their numbering sequences at 1, Given the small size of the company and the lack of available accounting expertise, the company has decided to outsource payroll to a company specializing in payroll services. This company provides a monthly report upon which to basc thc payroll journal entries. Further, given the small size of the cumpany and the lack of systems experience the new system will be implemented without using e-commerce Note: Be very careful working through the company set up options, this is where you establish how your company will function. If you get it wrong to start, it will affect all later transactions and reporting. b. Implement a chart of accounts Packaged software usually comes with several chart of accounts ternplates. When selling up your company, you should select a standard chart of accounts for the industry and type of product you will be selling. Then go through the chart of accounts and modify it to suit this business. After you have modified the accounts, use the balance sheet provided in Appendix A to load the beginning balances using a Journal entry. c. Load beginning balances You also need to set up the account balances for the customers. vendors and inventory. The appropriate balances are given in the subsidiary ledgers for customers (Appendix B), vendors (Appendix C), and inventory products (Appendix D). Inventory Inventory items are shown appendix D. The company would like to use the perpetual weighted average cost method to value inventory. There are two applicable price levels for the company: normal pricing and governmental pricing (the goverment entities get a 2% discount). Note: Set up your price levels (discounts) before you set up your customers. Customers Note: Before you set up your customers and vendors, go in and set the defaults, the software will then pre-fill the default values for certain fields. Terms are 2/10, net 30. All products are subject to state sales tax. The state sales tax rate is 6%. The open invoice method is used for all customers. Govemmental customers get a preferred price (2% discount). In addition, Governmental customers do not pay sales tax. The ship-lo and billing address are the same for all the customers. You should assure some reasonable information for any data fields that you feel are critical, but for which information is not provided. Statements are prepared and sent to each customer at the end of each month. APPENDIX B provides information for the customer subledgers. Vendors The only trade accounts payable with outstanding balances at this time are shown in APPENDIX C. The credit terms for all trade creditors are Net 30 and all product purchases are exempt from sales tax. You should assume some reasonable information for the required fields. Additional vendors will be established as invoices are received for payment. 3. Process transactions Record the transactions for Mary's Sunshine listed on the transaction list for July (See Appendix E) 3. Analyze performance Prepare a one-page memo to Mary's Sunshine's proprietor summarizing your opinions on the company's business performance. Hint: use memo formar (to:,from, subject, etc.). Remember memos must be easy to read. Grammar counts. 3. Prepare package to show your work Prepare the documentation package of items listed in Appendix G. 3. Complete the team point distribution on D2L You have 50 points to distribute between yourself and your partner. If you worked on the project equally then you do not have to complete the print distribution form. Each of you will receive 25 points If you believe you and your partner did not work equally then complete the form as you see fit. I will average you and your partners points and add them to your task points 1. For example, if you believe you did the majority of the work then give yourself 50 and your partner 0. If your partner believes that you worked equally and splits points 25/25, then you will receive 37.5 participation points and your partner will receive 12.5 participation points. a. b. 3. Grading The project will be evaluated using the grading sheet shown in Appendix H. APPENDIX A MARY'S SUNSHINE POOL INCORPORATED BALANCE SHEET June 30 (YEAR OF AUTOMATION) $83,500.00 $83,983.00 $(1,152.00) $54,629.00 $1,029.00 $2,000.00 $223,989.00 Assets Current Assets Cash Accounts Receivable Less: Allow. Dbtful Accts Merchandise Inventory Office Supplies Prepaid Insurance Total Current Assets Property and Equipment Land Buildings Less: Accum. Depr. Office Equipment Less: Accum. Depr. Vehicles Less: Accum. Depr. Total Property and Equipment Total Assets $50,000.00 $140,000.00 $(28,000.00) $15,570.00 $(11,650.00) $42,100.00 $(16,300.00) $191,720.00 $415,709.00 $30,300.00 $67,000.00 $7,380.00 $104,680.00 Liabilities & Owner's Equity. Current Liabilities Accounts Payable Notes Payable Mortgage Notes Payable (current portion) Total Current Liabilities Long-Term Liabilities Mortgage Notes Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Liabilities and Owner's Equity $79,500.00 $184,180.00 $110,000.00 $121,529.00 $415,709.00 APPENDIX B MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS RECEIVABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Customer Date Balance Hill Township Cobb YMCA Girl's Camp Valley and Hill Park Cobb County Parks and Recreation Workout Pool and Spa Invoice number 2289 2437 2440 2444 2450 2525 5/01/XX 5/15/XX 5/21/XX 5/31/XX 6/01/XX 6/05/XX $7,474.00 $6,900.00 $7,836.00 $5,000.00 $2,863.00 $5,700.00 Marietta City School System Hill and Dell Housing Development Park for Kids and Adults WatershipDown Township Chumming YWCA Forsyth County School System Cobb Community College Fulton County Parks and Recreation Water Park Resorts 2526 2598 2621 2651 2655 2662 2777 2788 2789 6/06/XX 6/08/XX 6/10/XX 6/15/XX 6/21/XX 6/22/XX 6/25/XX 6/26/XX 6/30/XX $8,316.00 $7,516.00 $3,500.00 $4,881.00 $7,296.00 $5,064.00 $6,137.00 $2,300.00 $3,200.00 TOTAL ACCOUNTS RECEIVABLE $83,983.00 Terms are 2/10, net/30 for all customers Aside: Add appropriate data such as an address and phone number for the first 3 customers. APPENDIX C MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS PAYABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) APPENDIXC MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS PAYABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Vendor Fennell Chemicals Major Pool Supply Alcoa Auto Alcoa Electric Kennesaw Supply Township Service Jay & Jay Parts John's Supply Cool Pool Supplies Alcoa Service TOTAL ACCOUNTS PAYABLE Invoice number Zf456 745 888779 P55227 94387 S7788 12345 Kkvv1 Cool167 Yy55 Invoice Date 06/15/XX 06/02/XX 06/10/XX 06/20/XX 06/15/XX 06/08/XX 06/30/XX 06/30/XX 06/08/XX 06/30/XX Balance $ 8,900.00 $ 2,300.00 $ 400.00 $ 3,300.00 $ 2,600.00 $ 400.00 $ 1,200.00 $ 6,200.00 $ 3,400.00 $ 1,600.00 $30,300.00 Aside: Add appropriate data such as an address and phone number for the first 3 vendors. APPENDIXD MARY'S SUNSHINE POOL INCORPORATED INVENTORY DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Item Preferred Vendor Quantity ROP ROQ Avs: Unit Total on Hand Unit Sales Cost $0.80 Price $2.00 Chem. Pool treatment Fennell Chernicals 25,000 lbs SOO 1000 $ 20,000.00 5 10 16'x20x8' vinyl liner 24' x 20'x10' liner 8' diving board 16' pool rope 20' pool rope Poolside lounger Table w/umbrella Water volleyball sets Pump valves TOTAL INVENTORY Major Pool Supply Major Pool Supply Major Pool Supply Major Pool Supply Major Pool Supply Cool Pool Supplies Cool Pool Supplies Cool Pool Supplies Alcoa Service 8 cu 4 ea 13 ea 50 ca 65 ea 14 ea 40 ca 20 ea 1.005 ea 2 5 5 5 15 10 20 5 50 4 5 10 10 10 20 10 100 $325.00 $400.00 $98.00 $25.00 $30.00 $40.00 S525.00 $18.75 $4.00 $750.00 $800.00 $200.00 $50.00 $60.00 $100.00 $800.00) $30.00 $8.00 $2,600.00 $1,600.00 $1,274.00 $1,250.00 $1,950.00 $56.00 $21,000.00 $375.00 $4,020.00 $54,629.00 APPENDIX E TRANSACTIONS LIST Purchases/Cash Disbursements 1. Created a purchase order for 170 Poolside loungers for $37.50,95 Tables with umbrellas for $500.00 and 40 Water volleyball sets for $15.00. 1. Created a purchase order for 15 16'x20'x'' vinyl liners for $300.00, 25 24'x20'x10' liners for $390.00, 20 8' diving boards for $90, 100 16' pool ropes for $20.00 and 50 20' pool ropes for $25.00 3. Record the purchase of the new computer system. It was purchased at Computer World for $10,500.00 including sales tax. This amount should be charged to a Computer Equipment account. $2100.00 is paid on delivery and a no interest note is signed for two installments one on 12/31 of the current year and the second 12/31, a year later. 6. Received goods from Cool Pool as ordered on July 1. 7. Received goods from Major Pool as ordered on July 1. 14. Created a purchase order for 40 long pool ropes @$30.00 and 40 short pool ropes @$25.00. 21. Prepared checks for the following bills: Invoice Number Account Vendor Amount WP200 BSM 333 7704993487 U2 7888 Water and Sewage Mobile phone bill Telephone Utilities Freight Expense County Overchargers Mobilerus SoutheastBell Georgia Utilities Belated Shipping 327.69 129.15 122.51 198.21 5100.25 21. Created a purchase order for 125 Tables with umbrellas at $480 and 25 poolside loungers at $35. 22. Received goods from Major Pool as ordered on July 14 26. Received goods from Cool Pool as ordered on July 22. 31. Record payroll (for July 31). See report from PPP (Appendix F) 31. Pay PPP for payroll services at 10% of gross salaries. Sales/Cash Receipts Sales/Cash Receipts 2. Sold 30 16' pool ropes, 1 diving board, 35 tables with umbrellas and 2 water volleyball sets to Hill Township at list price. 3. Sold 2000 lbs Chem. Pool treatment, 1 16'x20'x8' vinyl liner and 45 Pump valves to Water Park Resorts at list price 3. Sold 2 8' diving boards, 36 20' pool ropes, 10 Poolside loungers, 5 Tables w/umbrellas and 3 Water volleyball sets to Fulton County Parks and Recreation at 2% discount from list price. 7. Sold 1000 lbs Chem. Pool treatment to Cobb County Parks and Recreation at 2% less than list price. 8. Sold 1 24'x20'x10' liners, 2 8' diving boards, 30 16' pool ropes and 20 Pump valves at list to Park for Kids and adults. 9. Sold 1 8' diving board, 20 20' pool ropes, 30 Poolside loungers, 20 Tables w/umbrellas and 2 Water volleyball sets to Hill and Dell Housing Development at list price. 10. Sold 1 24'x20'x10' liners, 16 20' pool ropes, 30 Poolside loungers and 15 Tables w/umbrellas to Workout Pool and Spa at list price. 11. Received check 123 from Hill Township to pay for the goods purchased on July 2. Included in this check as $2,000 to be applied to the remainder of their balance due. 14. Sold 1 24'x20'x10' liners, 16 20' pool ropes, 25 pump valves and 2000 lbs of chemical treatment to Cobb Community College at 2% discount from list price. 15. Received check number 4455 from Valley and Hill Park to pay their balance in full. Adjusting entries for July are as follows: Amount Adjustments 1. Sold two vehicles for $14,000. The vehicles combined had an original cost of $24,500 and accumulated depreciation of $9,500 at the time of the sale. 2. Depreciation on the showroom/office building and the distribution center building (average life is 10 years, no salvage value, straight line depreciation) Per your calculation 3. Depreciation on the office equipment (average life is 5 years, no salvage value, straight line depreciation) Per your calculation 4. Per your Depreciation on the vehicles (average life is 8 years, no salvage value, straight line depreciation) calculation 5. Depreciation on the new computer Per your calculation Mary's Sunshine wants to use straight-line depreciation with a 3-year life and no salvage value. 6. Accrued interest expense on the mortgage $876.25 7. Expired insurance (1 year policy) Per your calculation $200 8. Office supplies remaining 9. Bad Debt Expense .5 % of credit sales $55.00 10. Bank Service Charges 11. Estimate and accrue Corporate Income Tax expense at 15% Per your calculation APPENDIX F REPORT FROM PPP FOR 7/31 PAYROLL Payroll checks created: Name Gross Salary Federal Retirement Charitable Net Pay. Social Security State Income Medical Insurance Income Contribs (FICA). Tax Lauren Allen Paul Barton Ernest Callahan Ted Hill Fred Hill $ 25.00 $ 25.00 $ 300.00 $ 500.00 $ 300.00 Tax $ 225.00 $ 396.00 $ 396.00 $ 56.00 $ 56.00 $1129.00 $1,500.00 $1,800.00 $1,800.00 $ 800.00 $ 800.00 $6,700.00 $ 90.00 $ 108.00 $ 108.00 $ 48.00 $ 48.00 $402.00 $ 75.00 $ 90.00 $ 90.00 $ 40.00 $ 40.00 $335.00 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $286.60 $ 727.68 $623.68 $848.68 $ 598.68 $ 598.68 $3397.40 $1100.00 $50.00 Employer contributions and payroll taxes remitted: Name FUTA Retirement SUTA Social Security Total Medical Insurance Lauren Allen Paul Barton Ernest Callahan Ted Hill Fred Hill (FICA) S 90.00 S 108.00 S 108.00 5 48.00 S 48.00 $402.00 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $57.32 $286.60 S 300.00 S 500.00 S 300.00 0 0 0 $1100.00 S447.32 S665.32 S465.32 $133.32 $133.32 S1844.60 $ 6.40 $6.40 $12.80 $ 21.60 $ 21,60 S43.20 APPENDIXG DOCUMENTATION PACKAGE Prepare a package of the following items to support your work. Please upload your project files to 'Course Project' in Assignments in D2L. Only one group partner should submit the files (please indicate names of all group members in cover sheet below). Be sure each item is clearly identified. 1. Cover Sheet with Names, Course name and date - please upload Word document 2. Project plan - plcase upload your project plan file(s) prepared using software (such as Excel, Project, ctc.) 3. Columnar System Flowchart of the Accounting processes under the Manual System - please upload your flowcharts file(s) prepared using software (such as Excel, Visio. Gliffy, etc.) For items 4-6 below, please upload the .pdf files that are produced directly from Quickbooks. Important: do not alter the files in any way. 4. Print outs of: a. Charts of Accounts b. Customer list c Vendor list d. Products File (An inventory item detail list or price list) S. Example documents: a Sales invoice b. Credit Memo c. Purchase Order d. Check to a vendor c. July AR statement to a customer 6. Reports: a Income Statement (for July) b. Balance Sheet as of July 31 c Cash flow statement d. Aged Accounts receivable as of July 31 e. Accounts payable open balance as of July 31 7. Memo Analyzing Business Performance - please upload Word document APPENDIX H GRADING SCHEME Possible pts 5 25 50 6 9 10 50 25 Item Formatting: Cover sheet with names, all items are clearly identified Project Plan Flowchart Charts of Accounts (numbering makes sense, accounts are relevant to the business and utilized) Master files: Customer list, Vendor list, Products File (An inventory item detail list or price list) Documents: Sales invoice, Credit memo, Purchase order, Check to a vendor, AR statement to a customer Income Statement (for July) (format, net income, complete processing of transactions) Balance Sheet as of July 31st (format, ties to income statement, all accounts have normal balances) Cash Flow statement Aged accounts receivable as of July 31st (format, ties to balance sheet) Accounts payable open balance as of July 31st (format, ties to balance sheet) Memo discussing the business's performance (format, relevance) Neat and Complete Total Plus participation points 5 5 5 75 5 275 SYSTEM IMPLEMENTATION AND TRANSACTION PROCESSING PROJECT (300 POINTS) MARY'S SUNSHINE POOL CASE BACKGROUND The objectives of this project are as follows: To reinforce your learning the AIS concepts presented in class To experience a transaction processing application To see the composition of the fields on different tables, such as the fields contained in the general ledger table, the accounts receivable table, etc. To see the advantages of the automated features contained in an accounting information system, such as the automatic posting of transactions To demonstrate on-line computer controls such as field edits, reasonableness checks, etc. To see the interfaces between sub-systems and the general ledger and increase your ability to track information into the financial reports To experience implementing an accounting system To practice project planning with an inflexible deadline To experience an extensive, multi-part project completed as a team. REQUIREMENTS Assume that Mary's Sunshine Pool Incorporated has hired you as a consultant to analyze the company's performance and to implement a computerized accounting system. The present accounting system is entirely manual. The new system will be an accounting software package that runs on a microcomputer Points 1. 25 Requirement Prepare a project plan in Gantt chart format showing how you and your partner completed the project Prepare a system flowchart of Mary's Sunshine Pool Company's transaction processing under the manual system as described in this handout Perform the company set up and process transactions for the company. 2. 50 3. 125 4. 75 Prepare a one-page memo to the company owners analyzing their business performance. Total task points 50 Participation points to be split between team members 275 CASE MATERIALS MARY'S SUNSHINE POOL INCORPORATED 4000 AIS Rocks Blvd. Anywhere, XX 12345 Federal Tax ID: XX-XXXXXXX COMPANY BACKGROUND Mary's Sunshine Pool Incorporated is a merchandising firm that sells various pool supplies,c.g., chemicals, diving boards, pumps, ladders, poolside fumiture, pmol games, floating loungers. present, Mary's Sunshine has a manual accounting system; however, the company has hired you to implement an accounting program to be used on a personal computer as of July 1, the beginning of the current fiscal year. Mary and Ed, the stockowners of the company, have made available to you the balance sheet and data from the subsidiary ledgers for the fiscal year ended June 30. As of June 30, Mary's Sunshine Pool Company consisted of a showroom and an office in one building, a distribution center in another building, and five employees. The employees are: Lauren Allen, a salesperson at the showroom, Paul Barton and Criest Callahan, traveling salesmen, and Fred and Ted Hill, Mary and Ed's twin sons who work at the distribution center only during the summer rrunths. Mary's Sunshine Pool Incorporated owns the land, the showroom/office building, the distribution center building, a delivery truck and two automobiles driven by the traveling salesmen. REVENUE CYCLE Order Processing Sales are made to users of pool supplies. Pool supplies are displayed and orders for products are taken in the showroom. The traveling salesmen also take orders. The distribution center is located on the same lot as the showroom/office building. It is here that the orders are filled and shipped. All sales are credit sales, which are subject to the approval of Ed. Ed approves credit based on his "gut" feeling for each individual case and on the opinions of his bowling buddies. Generally. Ed wants to make the sales and few orders are not approved. In the few cases where Ed does not approve the credit, he marks his copy of the sales order accurdingly. He makes a copy of all of the disapproved orders and two copies of the approved orders. He sends one copy of both the approved and disapproved orders and all of the original orders to Mary. He sends a copy of the approved orders to the twins so they can fill them. Mary prepares a report for each salesperson listing both the sales orders turned down for credit and the approved sales and sends the reports along with the marked sales orders to the salespeople. The salespeople notify customers of disapproved credit and then throw the reports and disapproved sales orders in their car trunks or wastebaskets. The salespeople file the original approved sales orders for later usc. Mary files the copies of the approved orders until a shipping notice is received. The copies of the disapproved orders are thrown away. Shipping Out of town orders are shipped common carrier FOB Destination. Recently, Ed had a brief meeting with the twins about the possibility of sending the bulk of freight shipments through one common carrier, Belated Shipping Company. The advantage to Mary's Sunshine would be a rebate paid quarterly of up to 15% of freight charges. Based on prior years business, this rebate would total excess of $15,000 per year. Without giving this practice much thought, Ed told the twins to begin using Belated Shipping Company as much as possible. The twins take all of the approved orders, find and box the merchandise and prepare a bill of lading for the carrier. The twins send their copy of the sales order marked shipped' and a copy of the bill of lading to Mary. After an order has heen shipped, the twins update the inventory cards to keep an accurate record of items on hand. At the end of the week, all of the inventory cards are reviewed and a weekly inventory report is prepared. Accounts Receivable Mary matches the sales order marked "shipped" to her copy of the sales order. She then prepares a two-part invoice and mails the original to the customer. She records the sales in the sales journal and the receivables in the subsidiary ledger. Mary files by date her copy of the invoice with her copy of the sales order and the shipping documents. During the summer scason, Mary's Sunshine often has difficulty in shipping customer orders in a timely manner. Supplier delays in delivery to Mary's Sunshine and increased volume cause delays in outgoing shipments. At the end of some months, Mary prepares and mails customer invoices ahead of actual shipment. She claims this practice more closely matches revenues and expenses. As usual, Mary records the sales in the sales journal and in the accounts receivable subsidiary ledger. Customers are allowed to take a 2% discount if they pay within 10 days of the billing date; otherwise, the net armuunt is due in 30 days. Once per month, Mary prepares a listing of delinquent customers that she sends to the salespeople. They are responsible for collecting the overdue amounts. Cash Receipts Mary opens the mail cach day; sorts the cash receipts and the invoices to be paid and logs them in the appropriate logs. Mary records the receipts on customers account in the cash receipts journal and in the accounts receivable subsidiary ledger. After recording all the cash receipts, she prepares a deposit slip and takes the cash to the bank. DISBURSEMENT CYCLE Purchasing Every Friday afternoon, the salespeople prepare weekly sales reports from their copies of the sales orders. They send the reports to Ed and then refile their sales orders by customer name. Ed reviews the weekly sales reports and the weekly inventory reports prepared by Fred and Ted. Ed 'eyeballs' the numbers, notes any shortages in inventory, and prepares 3-part purchase orders. He mails the original to the vendor, sends one to the twins in the distribution center and one copy to Mary. As noted above, Fred and Ted have a card file for keeping track of inventory. Each card has a running balance to expedite the preparation of the weekly inventory reports for Ed. When they receive a copy of a purchase order, they pull the cards for the item(s) ordered, record the quantity ordered and the P.O. number, and file the purchase order in numerical order. When the shipment arrives, Fred und Ted pulls the purchase order to make sure that the items received were the items orcicred and notc any hack orders on the purchase order. Then they pull the inventory cards, mark the items received, and preparc a receiving report that is sent to Mary Cash Disbursements As noted above. Mary opens the mail and separates and logs the cash receipts and the invoices to be paid. Invoices are filed in alphabetical order by due date. Each Thursday, Mary pulls the invoices that are due that week and types three-part checks. The checks, along with the invoices, are given tu Ed for his approval and signature. After Ed signs the checks, Mary mails the original, files the second copy in check number order, and attaches the third copy to the invoice. She then enters the check in the cash disbursement journal and the accounts payable subsidiary ledger. The third copy of the check and the attached invoice arc filed alphabetically by vendor name. Payroll A full service payroll processing company called Payroll Paid Promptly (PPP) processes payroll, PPP calculates the payroll, creates and mails the checks to the employees and remits all payroll taxes and other withholdings to the appropriate locations. They send Mary a report once per month reflecting the transactions made on behalf of PPP Mary prepares a journal entry to reflect the payroll and updates the general ledger. PPP charges a fee of 10% of the gross payroll for the payroll service. Mary prepares the check for these services once per month. The ernployees, who are paid once a month, are as follows: Lauren Allen, a salesperson at the showroom Paul Barton and Ernest Callahan, traveling salesmen Fire and Till tone whory at the distribution conter 1. Project Plan Determine the tasks that you will perform to complete the project a. Determine how your team will complete the tasks b. Prepare a Gantt chart with time and dates indicated c. & b Prepare a final Gantt chart showing when the tasks were competed and how many hours each task took compared to your planned hours. Hint think carefully about how you want to complete the tasks and how much you trust your partner to get his/her portion of the project done. 2. Prepare a system flowchart Follow the flowcharting guidelines in your textbook and as we have discussed in class, The final copy of the flowchart should be prepared using flowcharting softwarc or Microsoft office. Hint: It is usually the cusiest to set up the flowchart with a page for cach process. 3. Set up Company and process transactions a. Configure Company (Set Up Information) You need to start by creating a new company for the business. Read through the entire case before you start setting up your company. Note: given that this is a class project, the company name should be your names. Complete the company information making up information as you see fit. The proper date to start recording the transactions is 7/1. The fiscal year is 7/1/CY through 06/30/NY. You will establishing the chart of accounts, the vendors, the customers and the inventory and service products. As part of your configuration, you need to decide the coding schemes that will be used for cach of these data files. Also, to save yourself time, carefully set up the "default" information for customers, vendors, and inventory items. The company uses one checking account. The business has used prenumbered invoices and checks in the past. However, given that they need to purchase new forms to accommodate the new software they plan to restart their numbering sequences at 1, Given the small size of the company and the lack of available accounting expertise, the company has decided to outsource payroll to a company specializing in payroll services. This company provides a monthly report upon which to basc thc payroll journal entries. Further, given the small size of the cumpany and the lack of systems experience the new system will be implemented without using e-commerce Note: Be very careful working through the company set up options, this is where you establish how your company will function. If you get it wrong to start, it will affect all later transactions and reporting. b. Implement a chart of accounts Packaged software usually comes with several chart of accounts ternplates. When selling up your company, you should select a standard chart of accounts for the industry and type of product you will be selling. Then go through the chart of accounts and modify it to suit this business. After you have modified the accounts, use the balance sheet provided in Appendix A to load the beginning balances using a Journal entry. c. Load beginning balances You also need to set up the account balances for the customers. vendors and inventory. The appropriate balances are given in the subsidiary ledgers for customers (Appendix B), vendors (Appendix C), and inventory products (Appendix D). Inventory Inventory items are shown appendix D. The company would like to use the perpetual weighted average cost method to value inventory. There are two applicable price levels for the company: normal pricing and governmental pricing (the goverment entities get a 2% discount). Note: Set up your price levels (discounts) before you set up your customers. Customers Note: Before you set up your customers and vendors, go in and set the defaults, the software will then pre-fill the default values for certain fields. Terms are 2/10, net 30. All products are subject to state sales tax. The state sales tax rate is 6%. The open invoice method is used for all customers. Govemmental customers get a preferred price (2% discount). In addition, Governmental customers do not pay sales tax. The ship-lo and billing address are the same for all the customers. You should assure some reasonable information for any data fields that you feel are critical, but for which information is not provided. Statements are prepared and sent to each customer at the end of each month. APPENDIX B provides information for the customer subledgers. Vendors The only trade accounts payable with outstanding balances at this time are shown in APPENDIX C. The credit terms for all trade creditors are Net 30 and all product purchases are exempt from sales tax. You should assume some reasonable information for the required fields. Additional vendors will be established as invoices are received for payment. 3. Process transactions Record the transactions for Mary's Sunshine listed on the transaction list for July (See Appendix E) 3. Analyze performance Prepare a one-page memo to Mary's Sunshine's proprietor summarizing your opinions on the company's business performance. Hint: use memo formar (to:,from, subject, etc.). Remember memos must be easy to read. Grammar counts. 3. Prepare package to show your work Prepare the documentation package of items listed in Appendix G. 3. Complete the team point distribution on D2L You have 50 points to distribute between yourself and your partner. If you worked on the project equally then you do not have to complete the print distribution form. Each of you will receive 25 points If you believe you and your partner did not work equally then complete the form as you see fit. I will average you and your partners points and add them to your task points 1. For example, if you believe you did the majority of the work then give yourself 50 and your partner 0. If your partner believes that you worked equally and splits points 25/25, then you will receive 37.5 participation points and your partner will receive 12.5 participation points. a. b. 3. Grading The project will be evaluated using the grading sheet shown in Appendix H. APPENDIX A MARY'S SUNSHINE POOL INCORPORATED BALANCE SHEET June 30 (YEAR OF AUTOMATION) $83,500.00 $83,983.00 $(1,152.00) $54,629.00 $1,029.00 $2,000.00 $223,989.00 Assets Current Assets Cash Accounts Receivable Less: Allow. Dbtful Accts Merchandise Inventory Office Supplies Prepaid Insurance Total Current Assets Property and Equipment Land Buildings Less: Accum. Depr. Office Equipment Less: Accum. Depr. Vehicles Less: Accum. Depr. Total Property and Equipment Total Assets $50,000.00 $140,000.00 $(28,000.00) $15,570.00 $(11,650.00) $42,100.00 $(16,300.00) $191,720.00 $415,709.00 $30,300.00 $67,000.00 $7,380.00 $104,680.00 Liabilities & Owner's Equity. Current Liabilities Accounts Payable Notes Payable Mortgage Notes Payable (current portion) Total Current Liabilities Long-Term Liabilities Mortgage Notes Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Liabilities and Owner's Equity $79,500.00 $184,180.00 $110,000.00 $121,529.00 $415,709.00 APPENDIX B MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS RECEIVABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Customer Date Balance Hill Township Cobb YMCA Girl's Camp Valley and Hill Park Cobb County Parks and Recreation Workout Pool and Spa Invoice number 2289 2437 2440 2444 2450 2525 5/01/XX 5/15/XX 5/21/XX 5/31/XX 6/01/XX 6/05/XX $7,474.00 $6,900.00 $7,836.00 $5,000.00 $2,863.00 $5,700.00 Marietta City School System Hill and Dell Housing Development Park for Kids and Adults WatershipDown Township Chumming YWCA Forsyth County School System Cobb Community College Fulton County Parks and Recreation Water Park Resorts 2526 2598 2621 2651 2655 2662 2777 2788 2789 6/06/XX 6/08/XX 6/10/XX 6/15/XX 6/21/XX 6/22/XX 6/25/XX 6/26/XX 6/30/XX $8,316.00 $7,516.00 $3,500.00 $4,881.00 $7,296.00 $5,064.00 $6,137.00 $2,300.00 $3,200.00 TOTAL ACCOUNTS RECEIVABLE $83,983.00 Terms are 2/10, net/30 for all customers Aside: Add appropriate data such as an address and phone number for the first 3 customers. APPENDIX C MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS PAYABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) APPENDIXC MARY'S SUNSHINE POOL INCORPORATED ACCOUNTS PAYABLE DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Vendor Fennell Chemicals Major Pool Supply Alcoa Auto Alcoa Electric Kennesaw Supply Township Service Jay & Jay Parts John's Supply Cool Pool Supplies Alcoa Service TOTAL ACCOUNTS PAYABLE Invoice number Zf456 745 888779 P55227 94387 S7788 12345 Kkvv1 Cool167 Yy55 Invoice Date 06/15/XX 06/02/XX 06/10/XX 06/20/XX 06/15/XX 06/08/XX 06/30/XX 06/30/XX 06/08/XX 06/30/XX Balance $ 8,900.00 $ 2,300.00 $ 400.00 $ 3,300.00 $ 2,600.00 $ 400.00 $ 1,200.00 $ 6,200.00 $ 3,400.00 $ 1,600.00 $30,300.00 Aside: Add appropriate data such as an address and phone number for the first 3 vendors. APPENDIXD MARY'S SUNSHINE POOL INCORPORATED INVENTORY DATA FROM SUBSIDIARY LEDGER JUNE 30 (YEAR OF AUTOMATION) Item Preferred Vendor Quantity ROP ROQ Avs: Unit Total on Hand Unit Sales Cost $0.80 Price $2.00 Chem. Pool treatment Fennell Chernicals 25,000 lbs SOO 1000 $ 20,000.00 5 10 16'x20x8' vinyl liner 24' x 20'x10' liner 8' diving board 16' pool rope 20' pool rope Poolside lounger Table w/umbrella Water volleyball sets Pump valves TOTAL INVENTORY Major Pool Supply Major Pool Supply Major Pool Supply Major Pool Supply Major Pool Supply Cool Pool Supplies Cool Pool Supplies Cool Pool Supplies Alcoa Service 8 cu 4 ea 13 ea 50 ca 65 ea 14 ea 40 ca 20 ea 1.005 ea 2 5 5 5 15 10 20 5 50 4 5 10 10 10 20 10 100 $325.00 $400.00 $98.00 $25.00 $30.00 $40.00 S525.00 $18.75 $4.00 $750.00 $800.00 $200.00 $50.00 $60.00 $100.00 $800.00) $30.00 $8.00 $2,600.00 $1,600.00 $1,274.00 $1,250.00 $1,950.00 $56.00 $21,000.00 $375.00 $4,020.00 $54,629.00 APPENDIX E TRANSACTIONS LIST Purchases/Cash Disbursements 1. Created a purchase order for 170 Poolside loungers for $37.50,95 Tables with umbrellas for $500.00 and 40 Water volleyball sets for $15.00. 1. Created a purchase order for 15 16'x20'x'' vinyl liners for $300.00, 25 24'x20'x10' liners for $390.00, 20 8' diving boards for $90, 100 16' pool ropes for $20.00 and 50 20' pool ropes for $25.00 3. Record the purchase of the new computer system. It was purchased at Computer World for $10,500.00 including sales tax. This amount should be charged to a Computer Equipment account. $2100.00 is paid on delivery and a no interest note is signed for two installments one on 12/31 of the current year and the second 12/31, a year later. 6. Received goods from Cool Pool as ordered on July 1. 7. Received goods from Major Pool as ordered on July 1. 14. Created a purchase order for 40 long pool ropes @$30.00 and 40 short pool ropes @$25.00. 21. Prepared checks for the following bills: Invoice Number Account Vendor Amount WP200 BSM 333 7704993487 U2 7888 Water and Sewage Mobile phone bill Telephone Utilities Freight Expense County Overchargers Mobilerus SoutheastBell Georgia Utilities Belated Shipping 327.69 129.15 122.51 198.21 5100.25 21. Created a purchase order for 125 Tables with umbrellas at $480 and 25 poolside loungers at $35. 22. Received goods from Major Pool as ordered on July 14 26. Received goods from Cool Pool as ordered on July 22. 31. Record payroll (for July 31). See report from PPP (Appendix F) 31. Pay PPP for payroll services at 10% of gross salaries. Sales/Cash Receipts Sales/Cash Receipts 2. Sold 30 16' pool ropes, 1 diving board, 35 tables with umbrellas and 2 water volleyball sets to Hill Township at list price. 3. Sold 2000 lbs Chem. Pool treatment, 1 16'x20'x8' vinyl liner and 45 Pump valves to Water Park Resorts at list price 3. Sold 2 8' diving boards, 36 20' pool ropes, 10 Poolside loungers, 5 Tables w/umbrellas and 3 Water volleyball sets to Fulton County Parks and Recreation at 2% discount from list price. 7. Sold 1000 lbs Chem. Pool treatment to Cobb County Parks and Recreation at 2% less than list price. 8. Sold 1 24'x20'x10' liners, 2 8' diving boards, 30 16' pool ropes and 20 Pump valves at list to Park for Kids and adults. 9. Sold 1 8' diving board, 20 20' pool ropes, 30 Poolside loungers, 20 Tables w/umbrellas and 2 Water volleyball sets to Hill and Dell Housing Development at list price. 10. Sold 1 24'x20'x10' liners, 16 20' pool ropes, 30 Poolside loungers and 15 Tables w/umbrellas to Workout Pool and Spa at list price. 11. Received check 123 from Hill Township to pay for the goods purchased on July 2. Included in this check as $2,000 to be applied to the remainder of their balance due. 14. Sold 1 24'x20'x10' liners, 16 20' pool ropes, 25 pump valves and 2000 lbs of chemical treatment to Cobb Community College at 2% discount from list price. 15. Received check number 4455 from Valley and Hill Park to pay their balance in full. Adjusting entries for July are as follows: Amount Adjustments 1. Sold two vehicles for $14,000. The vehicles combined had an original cost of $24,500 and accumulated depreciation of $9,500 at the time of the sale. 2. Depreciation on the showroom/office building and the distribution center building (average life is 10 years, no salvage value, straight line depreciation) Per your calculation 3. Depreciation on the office equipment (average life is 5 years, no salvage value, straight line depreciation) Per your calculation 4. Per your Depreciation on the vehicles (average life is 8 years, no salvage value, straight line depreciation) calculation 5. Depreciation on the new computer Per your calculation Mary's Sunshine wants to use straight-line depreciation with a 3-year life and no salvage value. 6. Accrued interest expense on the mortgage $876.25 7. Expired insurance (1 year policy) Per your calculation $200 8. Office supplies remaining 9. Bad Debt Expense .5 % of credit sales $55.00 10. Bank Service Charges 11. Estimate and accrue Corporate Income Tax expense at 15% Per your calculation APPENDIX F REPORT FROM PPP FOR 7/31 PAYROLL Payroll checks created: Name Gross Salary Federal Retirement Charitable Net Pay. Social Security State Income Medical Insurance Income Contribs (FICA). Tax Lauren Allen Paul Barton Ernest Callahan Ted Hill Fred Hill $ 25.00 $ 25.00 $ 300.00 $ 500.00 $ 300.00 Tax $ 225.00 $ 396.00 $ 396.00 $ 56.00 $ 56.00 $1129.00 $1,500.00 $1,800.00 $1,800.00 $ 800.00 $ 800.00 $6,700.00 $ 90.00 $ 108.00 $ 108.00 $ 48.00 $ 48.00 $402.00 $ 75.00 $ 90.00 $ 90.00 $ 40.00 $ 40.00 $335.00 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $286.60 $ 727.68 $623.68 $848.68 $ 598.68 $ 598.68 $3397.40 $1100.00 $50.00 Employer contributions and payroll taxes remitted: Name FUTA Retirement SUTA Social Security Total Medical Insurance Lauren Allen Paul Barton Ernest Callahan Ted Hill Fred Hill (FICA) S 90.00 S 108.00 S 108.00 5 48.00 S 48.00 $402.00 $ 57.32 $ 57.32 $ 57.32 $ 57.32 $57.32 $286.60 S 300.00 S 500.00 S 300.00 0 0 0 $1100.00 S447.32 S665.32 S465.32 $133.32 $133.32 S1844.60 $ 6.40 $6.40 $12.80 $ 21.60 $ 21,60 S43.20 APPENDIXG DOCUMENTATION PACKAGE Prepare a package of the following items to support your work. Please upload your project files to 'Course Project' in Assignments in D2L. Only one group partner should submit the files (please indicate names of all group members in cover sheet below). Be sure each item is clearly identified. 1. Cover Sheet with Names, Course name and date - please upload Word document 2. Project plan - plcase upload your project plan file(s) prepared using software (such as Excel, Project, ctc.) 3. Columnar System Flowchart of the Accounting processes under the Manual System - please upload your flowcharts file(s) prepared using software (such as Excel, Visio. Gliffy, etc.) For items 4-6 below, please upload the .pdf files that are produced directly from Quickbooks. Important: do not alter the files in any way. 4. Print outs of: a. Charts of Accounts b. Customer list c Vendor list d. Products File (An inventory item detail list or price list) S. Example documents: a Sales invoice b. Credit Memo c. Purchase Order d. Check to a vendor c. July AR statement to a customer 6. Reports: a Income Statement (for July) b. Balance Sheet as of July 31 c Cash flow statement d. Aged Accounts receivable as of July 31 e. Accounts payable open balance as of July 31 7. Memo Analyzing Business Performance - please upload Word document APPENDIX H GRADING SCHEME Possible pts 5 25 50 6 9 10 50 25 Item Formatting: Cover sheet with names, all items are clearly identified Project Plan Flowchart Charts of Accounts (numbering makes sense, accounts are relevant to the business and utilized) Master files: Customer list, Vendor list, Products File (An inventory item detail list or price list) Documents: Sales invoice, Credit memo, Purchase order, Check to a vendor, AR statement to a customer Income Statement (for July) (format, net income, complete processing of transactions) Balance Sheet as of July 31st (format, ties to income statement, all accounts have normal balances) Cash Flow statement Aged accounts receivable as of July 31st (format, ties to balance sheet) Accounts payable open balance as of July 31st (format, ties to balance sheet) Memo discussing the business's performance (format, relevance) Neat and Complete Total Plus participation points 5 5 5 75 5 275