[SOLVED] the Sales/Collections AIS for the company

[SOLVED] the Sales/Collections AIS for the company

Project 1 – REA Database – 80 pts

Points Allocation
Relationship 10pt
Tables 20pt
10 Queries 50pt
Grand Total 80pt

(**Completion of the above does not guarantee full credit. Accuracy is also considered.
If the final product looks like the Access Homework, it doesn’t look good enough. **)
Sales/Collections Business Process
1. Suppose you are running a retail company, and you are going to design the Sales/Collections AIS for the company. Given the UML model below, implement your UML model completely into Access. The multiplicities and model should match the ones in Access. If the multiplicities on model do not match the Access
implementation, the project receives no credit. (Note: you can gather the data for
your database here:
https://www.generatedata.com/ or
https://www.kaggle.com/datasets) —10 pt
2. Design data in all tables. — 20pt
a. Access should include the following tables:

Tables At least
Inventory 200 records
Sales 150 records
Cash Receipt 100 records
Customers 100 records
Salesperson 50 records
Cashier 10 records
Cash 3 records

b. Refer to Chapter 5 for guidance as to table attributes (Chapter 5 –
Table5.2) Ensure the mock data simulate real world.
3. Query — 50pt
a. At least 10 queries
b. Ask questions that will help you run the business efficiently. Queries should answer accounting questions such as A/R, A/R turnover, gross profit, net profit, cost of goods sold, sales return percentage, operating
income, most profitable item, etc. Your project must use data to do sales/collection accounting calculations, such as total A/R at a point in time, aging of A/R, sales return ratio, ending inventory per item, average
number of days in receivables, ending cash balances, etc. (Use Chapter 4
Problem 8 and 9 as reference)

Are you overwhelmed by your class schedule and need help completing this assignment? You deserve the best professional and plagiarism-free writing services. Allow us to take the weight off your shoulders by clicking this button.

Get help

Who Will Write your Paper

Writer avatar

Rating: 4.9/5    Reviews 377

Success rate 98%

Completed projects: 545

I am an experienced writer offering professional services across diverse fields. I provide quality work with strict adherence to the deadline.

Writer avatar
Tutor_Dr. Edith

Rating: 4.8/5    Reviews 381

Success rate 99%

Completed projects: 490

I am an experienced writer with great research and analytical skills. Original quality paper and on-time delivery are guaranteed. Let's do this!

Writer avatar

Rating: 4.7/5    Reviews 316

Success rate 98%

Completed projects: 398

I am a professional writer with more than 8 years of experience. My mission is to provide you with high-quality paper in a timely fashion.

Writer avatar

Rating: 4.8/5    Reviews 371

Success rate 96%

Completed projects: 432

Hi, I deliver quality papers on time following all the instructions provided. Client's satisfaction is my priority. Welcome for plagiarism-free papers.

Writer avatar
Tutor_Prof. Allan

Rating: 4.8/5    Reviews 400

Success rate 96%

Completed projects: 487

With over half a decade of academic experience, I'm committed both to efficiency and punctuality. If it's quality you're looking for, then I'm here to provide!

Writer avatar
Tutor_Prof. Gabie

Rating: 4.9/5    Reviews 447

Success rate 100%

Completed projects: 546

A quality-driven, skilled writer with over 5 years of experience in various disciplines. I deliver plagiarism-free papers and content of impeccable quality, always original and always before the deadline!

Writer avatar

Rating: 4.9/5    Reviews 427

Success rate 96%

Completed projects: 567

I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients. Try me today!

Writer avatar

Rating: 4.9/5    Reviews 305

Success rate 96%

Completed projects: 404

I am a proficient writer with knowledge across a wide range of academic disciplines. I guarantee quality, timely and original content.

Writer avatar

Rating: /5    Reviews 419

Success rate 100%

Completed projects: 506

Hi, count on me to deliver quality and exemplary papers. I will pay attention to all your instructions, and meet all your expectations.