For Stage 1 (already completed) here is K Cannon Inc.\'s explanation: K Cannon,

Question

For Stage 1 (already completed) here is K Cannon Inc.'s explanation:

K Cannon, Inc., is a manufacturer of portable MP3 players. The company purchases raw materials such as plastics and computer chips for its conversion cycle. The following describes K Cannon’s purchases and payment procedures.

John, the purchasing department clerk, monitors raw material inventory levels and prepares purchase requisitions when purchases are necessary. Purchase requisitions are sent to the purchasing agent, who prepares six copies of a purchase order. Two copies are sent directly to the vendor. One is placed in an open purchase order file in the purchasing department, and one is used to post to the purchases journal. Each week, the purchasing department clerk prepares a journal voucher from the purchase journal and sends it to the general ledger department for posting.

Upon receiving the raw materials, the receiving department clerk creates five copies of the receiving report. One copy is sent to the AP department. Two copies are sent to the purchasing department, where one is filed and one is used to update the inventory records. The final copy is filed in the receiving department with the purchase order and packing slip. Suppliers send their invoices to the AP department, where they are used to update the AP subsidiary ledger.

In the cash disbursements department, Larry receives the information from the AP department, such as the purchase requisition, purchase order, receiving report, and invoice. He then prepares and signs the checks for the suppliers. After preparation of the checks, the supporting documents are sent back to the AP department. Each week, Larry prepares a journal voucher and sends it to the general ledger department for posting.

Requirements:

The second stage of the project requires students to develop a set of tables to implement the REA diagram in a relational database.

Examine the first stage solution for K Cannon, Inc.’s purchase cycle. Use the provided solution (REA Diagram posted as the picture above) as a starting point for this stage.

Create the MS Access tables on the basis of the tables you developed. In each table, define the primary key and foreign keys. For each attribute, define the data type, provide a field description, and define the field properties.

Populate your tables with fictitious data entries; you should sufficiently populate your tables so that you can demonstrate your design (about 20 rows for events and 10 for agents and resources).

Establish relationships between all the tables you created (based on your design). Make sure that you enforce the referential integrity in all your relationships.

Write queries needed to answer the following questions.

a. Who are “Cash Disbursement Clerk” in K Cannon?

b. How many different kinds of inventory items does K Cannon hold?

c. What was the total purchase amount?

d. What was the average purchase amount?

e. To which supplier K Cannon placed the most purchase order (display supplier name)?

f. To which supplier K Cannon paid the largest amount of cash?

g. What is the difference between quantity received and quantity ordered for each inventory item?

FIGURE 13-1 Context Diagram of the Expenditure Cycle Goods and services Revenue cycle Invoices Suppliers urchave Expenditure Purchase orders cydlechone need Various and cycle 379

Explanation / Answer

First of all thanks for posting the question.

Initially it depends on which model your company is using to build the project.

if its Agile then you have to make the changes as per client's requirements.

Second, if all the requirements are already closed then you can ask for time to your Project Manager because changes have been made. Right now you can contact your PM and Client for the Same they will help you.

Don't get stressed because things will not work properly if you do so.

If you can work extra hours (which should be billable), just do that.

Make the record of all changes that client is making and show it to PM so that he/she will get to know about it and will give you more time to develop.

Keep in Mind following things for your future:-

Start with the intention to develop a healthy relationship with your client

Educate your client about the real purpose of a revision.

Don't jump into doing a revision right after the client has provided their initial comments.

Clearly, define when change requests will be considered extra work and how this will be billed

Don't forget to show your goodwill and flexibility.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.