Assignment 3-Yamato's Big Peace Chocolate Distributors - Expenditure Cycle Due 3/4/2020 at the beginning of class...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment 3-Yamato's Big Peace Chocolate Distributors - Expenditure Cycle Due 3/4/2020 at the beginning of class Background Yamato's Big Peace Chocolate purchases and sells chocolates to malls, local stores, and other customers in the Pacific Rim. They only sell chocolates and have different kinds of chocolates, such as alcohol filled, assorted (truffles, nuts and chews), and specialty chocolates. They have requested you to help them develop a computer system for their expenditure cycle. System Information for the Expenditure Cycle Yamato orders and receives Chocolate as well as supplies and other items. The order process begins after the buyer is informed that more stock or supplies are needed and they issue a purchase order. Each order is assigned a sequential unique number (purchase order #). We want to include which buyer was responsible for the order. The order can be for more than one item of finished goods and is input into the system at the time of the order. Yamato uses the actual negotiated price for purchases and standard costs to calculate purchase variances. The receiving employee receives the items for each order in the receiving department. For orders, partial deliveries are accepted, but only one order will be delivered at a time. Each delivery is assigned a sequential unique number, which will be used as the receiving number. We also want to include which receiving clerk was responsible for the receipt. The receiving clerk enters the information into the system when the goods are received. Most orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Yamato wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type. Requirements for Assignment 3 1) Prepare the REA model (HINTS: includes 1 type and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities. 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many) 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys. Required Attributes Receiving (sequential) number Purchase order number Supplier Name Cash Account Name Beginning inventory on hand Item number Quantity Ordered Receipt Date (Receiving Date) Quantity received Order Date Check date Supplier contact name Cash Account # Buyer's Employee# Buyer's Name (Note 1) Receiving person's employee # Supplier Invoice # Actual purchase price Item type # Check number Bank Unit budgeted sales price Supplier Number Supplier Telephone Number Unit budgeted cost Item description Expected delivery date Amount paid for each invoice Buyer's Telephone # Item type description Cahier employee # Cashier Name (Note 1) Receiving person's name Supplier address (Note 1) Note 1: Usually we would separate first and last name for people and street, city, state and zip for addresses. You can use one attribute for names and addresses. (Note 1) Assignment 3-Yamato's Big Peace Chocolate Distributors - Expenditure Cycle Due 3/4/2020 at the beginning of class Background Yamato's Big Peace Chocolate purchases and sells chocolates to malls, local stores, and other customers in the Pacific Rim. They only sell chocolates and have different kinds of chocolates, such as alcohol filled, assorted (truffles, nuts and chews), and specialty chocolates. They have requested you to help them develop a computer system for their expenditure cycle. System Information for the Expenditure Cycle Yamato orders and receives Chocolate as well as supplies and other items. The order process begins after the buyer is informed that more stock or supplies are needed and they issue a purchase order. Each order is assigned a sequential unique number (purchase order #). We want to include which buyer was responsible for the order. The order can be for more than one item of finished goods and is input into the system at the time of the order. Yamato uses the actual negotiated price for purchases and standard costs to calculate purchase variances. The receiving employee receives the items for each order in the receiving department. For orders, partial deliveries are accepted, but only one order will be delivered at a time. Each delivery is assigned a sequential unique number, which will be used as the receiving number. We also want to include which receiving clerk was responsible for the receipt. The receiving clerk enters the information into the system when the goods are received. Most orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Yamato wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type. Requirements for Assignment 3 1) Prepare the REA model (HINTS: includes 1 type and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities. 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many) 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys. Required Attributes Receiving (sequential) number Purchase order number Supplier Name Cash Account Name Beginning inventory on hand Item number Quantity Ordered Receipt Date (Receiving Date) Quantity received Order Date Check date Supplier contact name Cash Account # Buyer's Employee# Buyer's Name (Note 1) Receiving person's employee # Supplier Invoice # Actual purchase price Item type # Check number Bank Unit budgeted sales price Supplier Number Supplier Telephone Number Unit budgeted cost Item description Expected delivery date Amount paid for each invoice Buyer's Telephone # Item type description Cahier employee # Cashier Name (Note 1) Receiving person's name Supplier address (Note 1) Note 1: Usually we would separate first and last name for people and street, city, state and zip for addresses. You can use one attribute for names and addresses. (Note 1)
Expert Answer:
Related Book For
The Legal Environment Today Summarized Case Edition
ISBN: 978-1305262768
8th Edition
Authors: Roger LeRoy Miller
Posted Date:
Students also viewed these economics questions
-
The Piccolo Mondo Company purchased a computer system for $150,000. The company expects to use the system for five years, at which time it will acquire a larger and faster one. The new system is...
-
USA Corporation hired Jesse to install a computer system for the company and paid him $8,000 for the work. USA soon realized that there were problems with the system and asked Jesse to refund the...
-
USA Corporation hired Jesse to install a computer system for the company and paid him $8,000 for the work. USA soon realized that there were problems with the system and asked Jesse to refund the...
-
On 1/1/22, lmani and Ahmad formed AI Partnership, a limited partnership. lmani will be the general partner and Ahmad will be a limited partner. He will not participate in management of the...
-
Explain the difference between a single- step and multiple- step income statement. Which statement is more transparent?
-
Coldwell AG issued a 100,000, 4-year, 10% note at face value to Flint Hills Bank on January 1, 2019, and received 100,000 cash. The note requires annual interest payments each December 31. Prepare...
-
Fill in the Blank. Laminated structures have ____________ damping.
-
Flying Flags is opening a new theme park in southern Indiana. The park will have six main attractions: (a) animal kingdom, (b) Broadway shows, (c) carousel and other kiddie rides, (d) daredevil...
-
Keesha Company borrows $140,000 cash on November 1 of the current year by signing a 120-day, 10%, $140,000 note. 1. On what date does this note mature? 2. & 3. What is the amount of interest expense...
-
Enter the transactions for Weeks 1 5 into the appropriate Journal for the month of June 2022. Next, post all the Journal transactions to the ledger accounts as specified in the Account System...
-
Last year, the analysts responsible for forecasting sales at PlastiPharm forecasted an increase of 10 percent for the year. They used historical records as well as past economic growth rates to...
-
What similar arguments/articles related to the ECONOMY THE OUTLOOK A Different Take on the U.S. Economy: Maybe It Isn't Really Shrinking? ECONOMY THE OUTLOOK A Different Take on the U.S. Economy:...
-
Discuss Bank of Canada's independence based on these articles below. https://www.bankofcanada.ca/2022/05/bank-canada-matter-trust/...
-
Microeconomics students must present a real-world company or other entity to analyze from a Microeconomics perspective. Grading Rubric : in three equal parts (too short Presentations will have...
-
Inflation affects many facets of the economy, from individual spending power to interest on the national debt. Pent-up demand, supply-chain issues, government spending, and the war in Ukraine pushed...
-
A group of 12 consumers are considering whether to connect to a new social network. Index them as consumer 1, 2, 3, 4, ..., 12. Let n denote the size of the network and vi is value or...
-
You are evaluating Company J and know the following (all data are on an annual basis except where indicated): The marginal corporate tax rate is 35%. The YTM (yield to maturity) on the debt of...
-
9.Consider the reaction 3NO2(g)+H2O=2HNO3(aq)+NO(g) where Delta H=-137 kJ.How many kilojoules are released when 92.3g of NO2 reacts?
-
Under the Foreign Sovereign Immunities Act, in what situations is a foreign state subject to the jurisdiction of U.S. courts?
-
What is the difference between disparate-treatment discrimination and disparate-impact discrimination?
-
What information must be listed on the labels of food products?
-
In an audit of a corporation that has a bond issue outstanding, the trust indenture is reviewed and confirmation as to the issue is obtained from the trustee. List eight matters of importance to the...
-
Robertson Company had accounts receivable of \(\$ 200,000\) at December 31, 200X, and had provided an allowance for uncollectible accounts of \(\$ 6,000\). After performing all normal auditing...
-
Tom Jones, CPA, is auditing the financial statements of a manufacturing company with a significant amount of trade accounts receivable. Jones is satisfied that the accounts are properly summarized...
Study smarter with the SolutionInn App