Answered step by step
Verified Expert Solution
Question
1 Approved Answer
( please solve ASAP) Instructions: Choose one (1) and only one of the following four 2 assignment options. Provide your response back in this document,
(please solve ASAP)
Instructions: Choose one (1) and only one of the following four 2 assignment options. Provide your response back in this document, and SUBMIT it back using Google Classroom once completed Instructions: 1: Download trial version of Sage 50 2. Create a company of your choice 3: create chart of accounts - 5 max see sample below, setup two banks Chart of Accounts Account Type Number Description Financial Statement 1-001 Cash Asset 1-010 Accounts Receivable Asset Balance Sheet Balance Sheet Balance Sheet 1-020 Prepaid Expenses Asset 1.030 Asset Balance Sheet Inventory Fixed Assets Asset Balance Sheet 1-040 1-050 Accumulated Depreciation Asset 1-060 Asset Balance Sheet Balance Sheet Balance Sheet Balance Sheet 2-001 2-010 Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Liability Liability Liability Balance Sheet 2-020 2-030 Liability Balance Sheet 2-040 Balance Sheet Liability Equity 3-001 Common Stock Balance Sheet 3-010 Retained Earnings Equity Balance Sheet Balance Sheet 3-020 Additional Paid in Capital Equity 4-001 Revenue Revenue Income Statement 4-010 Sales returns and allowances Revenue Income Statement Income Statement 5-001 5-010 Cost of Goods Sold Advertising Expense Bank Fees Expense Expense Income Statement Income Statement 5-020 5-030 Expense Expense Expense Income Statement Income Statement 5-040 5-050 Expense Income Statement Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense 5-060 Expense Income Statement 5-070 Expense Income Statement 5-080 Expense Income Statement Accounts receivable 4 Create customers - max 5, create sales invoices, receipts Accounts payable 5 Create Vendors - max 5, create orders and payments Inventory 6 Create inventory list - max 5, assign 3 of the products to a job Payroll 7. Setup employees - max 5, use a time sheet to enter employee's earnings and deductions, taxes, entitlements etc. See sample form below. Colorado Department of Hurrare WEEKLY TIMESHEET FOR FURLOUG WORK WEEKENDENG WAT OVERVE 2011 JEDNOTLE SUTURE POR LA DAV L THE LIBRIS OUT DATHORS COUNT SAT SUN MON TUE FRE re TOTAL HOURS FORTIE WEEK SERTIE LE I would like to see the 5 employees time sheet input Print 3 reports of your in choice in pdf, attached it to your file Deliverable: backup your company and send the backup file to me as an attached zip file. Option 2 2. Database creation Database Creation Create a database project with the following requirements, use any professional principles and standards Create Tables - Minimum of 10 tables to store your data Design forms to view, update and add data into your tables Write Queries to retrieve data from your tables Create reports to print data in specific layout Create a minimum of ten rows of test data in each table. Submit file with the scripts needed to create your tables with keys and the insert test rows, etc, into the tables and submit the Assignment Files tab as Zip. Instructions: Choose one (1) and only one of the following four 2 assignment options. Provide your response back in this document, and SUBMIT it back using Google Classroom once completed Instructions: 1: Download trial version of Sage 50 2. Create a company of your choice 3: create chart of accounts - 5 max see sample below, setup two banks Chart of Accounts Account Type Number Description Financial Statement 1-001 Cash Asset 1-010 Accounts Receivable Asset Balance Sheet Balance Sheet Balance Sheet 1-020 Prepaid Expenses Asset 1.030 Asset Balance Sheet Inventory Fixed Assets Asset Balance Sheet 1-040 1-050 Accumulated Depreciation Asset 1-060 Asset Balance Sheet Balance Sheet Balance Sheet Balance Sheet 2-001 2-010 Other Assets Accounts Payable Accrued Liabilities Taxes Payable Payroll Payable Notes Payable Liability Liability Liability Balance Sheet 2-020 2-030 Liability Balance Sheet 2-040 Balance Sheet Liability Equity 3-001 Common Stock Balance Sheet 3-010 Retained Earnings Equity Balance Sheet Balance Sheet 3-020 Additional Paid in Capital Equity 4-001 Revenue Revenue Income Statement 4-010 Sales returns and allowances Revenue Income Statement Income Statement 5-001 5-010 Cost of Goods Sold Advertising Expense Bank Fees Expense Expense Income Statement Income Statement 5-020 5-030 Expense Expense Expense Income Statement Income Statement 5-040 5-050 Expense Income Statement Depreciation Expense Payroll Tax Expense Rent Expense Supplies Expense Utilities Expense Wages Expense 5-060 Expense Income Statement 5-070 Expense Income Statement 5-080 Expense Income Statement Accounts receivable 4 Create customers - max 5, create sales invoices, receipts Accounts payable 5 Create Vendors - max 5, create orders and payments Inventory 6 Create inventory list - max 5, assign 3 of the products to a job Payroll 7. Setup employees - max 5, use a time sheet to enter employee's earnings and deductions, taxes, entitlements etc. See sample form below. Colorado Department of Hurrare WEEKLY TIMESHEET FOR FURLOUG WORK WEEKENDENG WAT OVERVE 2011 JEDNOTLE SUTURE POR LA DAV L THE LIBRIS OUT DATHORS COUNT SAT SUN MON TUE FRE re TOTAL HOURS FORTIE WEEK SERTIE LE I would like to see the 5 employees time sheet input Print 3 reports of your in choice in pdf, attached it to your file Deliverable: backup your company and send the backup file to me as an attached zip file. Option 2 2. Database creation Database Creation Create a database project with the following requirements, use any professional principles and standards Create Tables - Minimum of 10 tables to store your data Design forms to view, update and add data into your tables Write Queries to retrieve data from your tables Create reports to print data in specific layout Create a minimum of ten rows of test data in each table. Submit file with the scripts needed to create your tables with keys and the insert test rows, etc, into the tables and submit the Assignment Files tab as ZipStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started