Prepare the systems flowcharts of the existing system

Assignment Help Database Management System
Reference no: EM131311101

Project

Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main competitors in the industry are other high tech teaching supply companies.

Falcor Supplies started in 2011 with an office in Carbondale, Illinois, initially targeting local universities and colleges. The company realized there was a high demand for reasonably priced equipment and the convenience of using the internet to shop for this type of equipment. After its second year, with a constant increase in customer orders, Falcor decided to focus on selling to more colleges and universities throughout the Midwest. The move has had a positive effect on net profits and demand, supporting the decision to continue the growth of the company. Falcor recently expanded its facility to be able to fulfill a higher demand for its products. Its customer base ranges from areas as close as Southern Illinois University to as far as universities in the surrounding states. As of 2015, there were 60 employees. Their prior year's gross sales were $12 million.

Falcor's market share is on the rise but is not yet comparable to some of the larger school supply wholesalers. However, the corporation's goals for the upcoming years include establishing itself as an industry player through increased customer satisfaction and loyalty. Falcor is also considering the installation of a new information-processing system. This system will reengineer the company's current business functions by reducing loopholes in its internal control problems. It will also make the overall sales process more efficient.

Falcor purchases the products it sells from various wholesale suppliers and distributors, totaling 22 suppliers nationwide. The office has its own warehouse, stores its own merchandise, and is responsible for replenishing the inventory. Falcor has had no substantial problems in the past with their suppliers.

On the other hand, it has encountered problems with excess inventory, stock-outs, and discrepancies with inventory records.

Revenue Cycle

Becoming a customer of Falcor involves calling the toll-free number and speaking with one of the sales representatives, who establishes a new customer account. A customer's account record contains the information about the school including, a contact person's name, address, phone number, previous orders made with the company, and a sequentially assigned unique customer account number. Falcor does not sell directly to teachers, only to the school. All sales are wholesale sales, so no sales taxes apply.

Customers place orders via the Internet. A sales representative then prepares a sales order record. John, in the billing department, reviews the sales orders, adds prices and shipping charges, and prints a copy (invoice) that is sent to the customer. John then records the sale in the sales journal.

Chris, a warehouse employee, verifies the information on the sales order, picks the goods, prints the packing slip, and updates the inventory subsidiary ledger. Chris then prepares the bill of lading for the carrier. The goods are then shipped.

Sandy in AR updates the customer accounts and general ledger control accounts. When customers make a payment on account, they send both the remittance advice (that was attached to the invoice) and a check with the account number on it.

Scott, a mail room clerk, opens all the mail. He separates the checks, cash, and remittance advices and prepares a remittance list, which, along with the checks and cash, is sent to the cash receipts department.

Laura, the cash receipts clerk, reconciles the checks with the remittance list, updates the customer's account and the general ledger, and then deposits the checks in the bank. She sends the deposit slip to Sandy in the accounting department.

Upon receiving the bank receipt, Sandy files it and updates the cash receipts journal to record the amount deposited. The customer has a 15-day grace period, beginning upon the receipt of the equipment ordered. If, at the end of that period, a payment is received, it is understood that the goods have been accepted. If, on the other hand, the customer is dissatisfied with the product for any reason, they can return it to Falcor at no charge. However, to return the equipment, the customer must contact Falcor to obtain an authorization number. When the returned goods arrive, Chris prepares the return record and updates the inventory subsidiary ledger. Printed copies of the return record are sent to John and Sandy. John reviews the return record and updates the sales journal. Sandy credits the customer's account and updates the general ledger to reverse the transaction.

Expenditure Cycle

The purchases system and the cash disbursements system compose Falcor's expenditure cycle. The three departments within the purchasing system are warehouse, purchasing, and accounting. The purchasing function begins in the warehouse, which stores the inventory of equipment. Jim, the warehouse manager, compares inventory records with the various demand forecasts of each week, which the market research analyst team provides, to determine the necessary orders to make. At the end of the week, Jim prepares the purchase requisition record.

Sara, the purchasing clerk, reviews the purchase requisitions, selects the suppliers, and prepares the purchase orders. Copies of the purchase orders are sent to the supplier and to accounting. When the shipment arrives, Chris, the warehouse clerk, working from a blind copy of the purchase order, counts and inspects the goods for damage. He then prepares a receiving report and updates the inventory records.

Upon receipt of the supplier's invoice, Diana, the accounting clerk, compares it to the respective purchase order and receiving report. If the invoice is accurate, Diana creates an AP record, sets a due date for payment, and updates general ledger accounts.

On the due date, Evan, the cash disbursements clerk, closes the AP record, cuts a check, and sends it to the supplier. He then updates the check register and the general ledger.

Required

Assume that the manual system described is to be automated using a relational database system. Perform the following tasks. You may need to make assumptions about how certain automated activities will be performed.

a. Prepare the systems flowcharts of the existing system as described in the narrative.

b. Analyze the physical internal control weaknesses in the current system (both cycles). Model your response according to the six categories of physical control activities specified in the COSO internal control model.

c. Prepare a new set of systems flowcharts for each of the cycles with your recommended changes based on concerns you have with control weaknesses in the current system. Include recommended controls in the new flowcharts. These flowcharts would be your recommendation to Falcor of the way the manual system should be operating.

d. Prepare a data flow diagram for each of the cycles described in the narrative. This DFD will be your understanding of the logical flow of data through the system. Prepare, at a minimum, the Context level, Level 0, and Level 1 diagrams.

e. Prepare the REA model of the new system (both cycles) that you recommend. Show cardinalities for all associations.

f. List all tables necessary for the REA model. (include any linking tables)

  • List all attributes for each table
  • Identify the primary and foreign keys.

g. Using Access, implement the tables listed in f. above.

  • List all attributes in the Access tables
  • Identify the primary keys in the Access tables
  • Enter a minimum of five rows of sample data in each table
  • Create the relationships for the Access tables

h. BONUS: Create a few queries to retrieve or analyze data you stored in the tables in your Access DBMS.

Verified Expert

Please find the enclosed word file with the required changes with access database attached. In the second comment by student, i have marked yellow to the text which is related to case study. I have developed various flow charts as per the requirement. There are two types of process in the case study - one is revenue cycle which is related to customer orders and other one is expenditure cycle which is related to supplier order. If the inventory is less than the customer orders, then it needs to be ordered from desired supplier so that it can have regular check. Once the customer places the order, an invoice needs to be generated and then goods are shipped at desired location.

Reference no: EM131311101

Questions Cloud

How do lans on a fully private internet communicate : Host A and host B use IPSec in the transport mode. Can we say that the two hosts need to create a virtual connection-oriented service between them? Explain.
What factors influence the demand : What factors influence the demand for this product? What factors influence the supply of this product? How have these changes in supply and demand affected the equilibrium price of this product?
Discuss about the managing channel conflict : Channel conflict is inevitable given the complexities of today's markets. What are some of the underlying causes of channel conflict? Discuss some of the means available to the channel manager for detecting and managing channel conflict.
Do we mean message authentication or entity authentication : If Alice and Bob are continuously sending messages to each other, can they create a security association once and use it for every packet exchanged? Explain.
Prepare the systems flowcharts of the existing system : ACCT360 Final Project. Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. Prepare the systems flowcharts of the..
Why is there no need for a security association with ssl : Should the handshaking in SSL occur before or after the three-way handshaking in TCP? Can they be combined? Explain.
Competitive market analysis of potential success : You have been given the responsibility of working with your organization's CEO to do a competitive market analysis of the potential success of one of their existing products.
Appropriate for staffing group-ethnocentric model : Which model will be most appropriate for staffing each group: ethnocentric model, polycentric model, or global model? Explain your reasoning for each case.
Analyze strategy used to negotiate new managed care contract : Analyze strategies used to negotiate new managed care contracts. Support your analysis with research. Describe a way to structure your follow-up staff in terms of effectiveness. How can you ensure that structure will be effective?

Reviews

inf1311101

5/2/2017 5:27:44 AM

Thanks for creating the access database, and primary keys as well as developed relationships. I have got the screenshot of same as well which shows the codes are perfect. Primary keys are also mentioned in that relationship. Also, thanks for taken the screen shot of first flow chart where payments by customers have been mentioned. Good work.

inf1311101

5/2/2017 5:22:10 AM

Hello, I am interested in purchasing this solution, but I would first like to know the cost and what exactly is included in the solutions. Are all parts included (access portions, cycles, DFD's, etc.? I have been trying to make a payment, but the transaction has been unsuccessful. Do you know what could be the cause? Could it be due to the fact that I have not yet verified my account? I have not received an email to verify my account and I have tried the resend option, but still I have not received an email. I would really like to make the purchase as soon as possible. Please advise. Thank you, this link worked and I have made my payment. Is there anything I need to do further? There are a couple of things that concern me. 1. The first systems flowchart you've provided does not appear adequate. It does not cover the entire narrative. There are many missing elements and 2. You've only provided definitions of the physical internal control weaknesses. The requirement asked to analyze these physical internal control weaknesses of Falcor. Can your team make appropriate changes? oh i did not know it is part work only, sorry for that.

Write a Review

 

Database Management System Questions & Answers

  Explain evaluating a proposal for acquisition and sourcing

When evaluating a proposal for acquisition and sourcing, are there considerations that are unique in the case of an IT project versus a non-IT project

  What problems could be caused by not having indexes

What problems could be caused by not having appropriate indexes and what problems could be cause by having too many indexes?

  What are the typical departments in a data center

What techniques would you use to effectively manage a team of system administrators (network, database, application, etc.) working in your data center?

  Implement the query find total number of orders submitted

Find the total number of orders submitted in 2015. List all distinct customer IDs (O_C_ID) who submitted the largest number of orders in 2014. Find the total number if orders submitted by each customer.

  Provide explanation about each of the applied techniques

In the assignment report provide explanation about each of the applied techniques. In your Excel workbook file place the results in separate columns in the corresponding spreadsheet.

  Write a query that will show how may bookings have been made

Display the names of guests that have stayed at the hotel more than 10 times - Display details of the room(s) with the most bedrooms in the hotel.

  What is candidate key and database is a set of one or more

question 1a candidate key isrequired to be unique.used to represent rows in relationships.a candidate to be the primary

  Which is not a factor to consider in software evaluation

Peer reviewers are the key participants in which activity?

  What amounts will be require for ordering supplies

Design a spreadsheet that will enable you to request the required funds from your team's finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village.

  Describing the select statement

Data processing needs taking or receiving the data from a source and doing something with it. The same can be said about the transaction processing. When working along with a file, whether it be a fixed length.

  Describe database backup

This paper will be 5 pages total: (a) Describe Database Backup. (b) Describe Disaster Planning. (c) Highlight the importance of the integration of both backups and disaster planning and the impact if both are not effectively executed.

  Insert several records into the xml field in this new table

Once these have been added, modify the structure of XML inside of your XML typed field to add another tag of , Within the Features tag, use the "modify" function to make this happen.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd