you are required to determine what data will be included in each of the following files to generate the following reports:

Files

Employee Master File

Time Card File

Job File

Report

Pay Checks

W-2 Statements

Job Reports b Customers

PDE ACC 320 Project Instruc X + V X O file:///E:/Accounting%20320/ACC%20320%20Project%20Instructions.pdf . . Copyright @ 2018, 2015, 2012 by Pearson Education, Inc. DATA RECORDS OTHER ELEMENT IN WHICH FIELD PROGRAMS IN OUTPUTS IN WHICH AUTHORIZED DATA NAME DESCRIPTION CONTAINED SOURCE LENGTH FIELD TYPE WHICH USED CONTAINED USERS NAMES Customer Unique identi A/R record Customer 10 Numeric A/R update, customer A/R aging report, cus. No restrictions None number fier of each customer number file update, sales tomer status report, customer record, sales listing analysis update, sales analysis re- analysis record credit analysis port, credit report Customer Complete name of Customer record Initial customer 20 Alphanumeric Customer file up- Customer status No restrictions None name customer order date, statement report, monthly processing statement Address Street, city, state, Customer record Credit 30 Alphanumeric Customer file up- Customer status No restrictions None and zip code application date, statement report, monthly processing statement Credit limit Maximum credit Customer re- Credit Numeric Customer file update, Customer status ro- D. Dean CR_limit that can be cord, A/R application A/R update, credit port, A/R aging re- G. Allen extended to record analysis port, credit report H. Heaton customer Balance Balance due from A/R record, sales Various sales 8 Numeric A/R update, sales A/R aging report, G. Burton Cust bal customer on analysis record and payment analysis update. sales analysis ro- B. Heninger credit purchases transactions statement process- port, monthly state- S. Summers ing, credit analysis ment, credit report For your project you are required to determine what data will be included in each of the following files to generate the following reports Files Reports Employee Master File Pay Checks Time Card File W-2 Statements Job File Job Reports by Customer You should avoid duplication of information in multiple files but ensure that you can generate the three reports. You can have multiple entries of the same type per data entry (e.g. there can be multiple jobs on a time card). You do not have to indicate which data files may allow multiple entries per file. Also realize that numbers can be aggregated to get certain totals (e.g. annual salary for W-2s). Type here to search e 9 S x 1 0 9:55 PM A O ()) 7 5/12/2019AutoSave (. Off) ACC 320 Project - Excel Levanyah Liburd X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share 6 Cut Calibri - 11 AA aD Wrap Text AutoSum . A O Fill - Paste BB Copy Format Painter BIUT - - A - EES Merge & Center $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table Styles Clear Filter * Select Clipboard F Font Alignment Number F Styles Cells Editing C7 X A B C D E F G H J K L M N O P Q R S UI & W Data Files Data Employee Time Master Card Job File File File Employee # Social Security # Emp FirstName 10 Emp LastName 11 Emp Address1 12 Emp City 13 Emp State 14 Emp ZipCode 15 Emp MaritalStatus 16 Emp Exemptions 17 Emp WageRate 18 Time Card # 19 Time Card Date 20 Time Card Hours 21 Job # 22 Job Description 23 Job Hours 24 Customer # 25 Sheet1 + Ready " -- I + 100% S 9:55 PM O Type here to search x ] 0 A O ()) 15/12/2019