Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

image text in transcribed

(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 Zip

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non Specialists

Authors: Eddie McLaney, Peter Atrill

8th Edition

9780273778165

More Books

Students also viewed these Accounting questions