Fluent Essays

Fairfax Bread CompanyFairfax Bread Company (FBC) is a national bread company focused on using high quality ingredients with retail locations in Fairfax, Washington DC, Baltimore and Philadelphia.  The company was started by a father and son who each have an entrepreneurial spirit and a love of warm bread.  In order to manage the various locations and maintain consistent product quality between those locations, ingredients for each location are ordered from thecorporate office headquarters in Fairfax.  The orders are based on input from each store manager and shipped directly to each store location.  Description of the Acquisition ProcessThe Fairfax Bread Company acquisition cycle begins when the store manager reviews the ingredient inventory on a daily basis to determine what is needed.  If the review shows an order is needed, the store manager creates a purchase requisition in the system using the inventory and purchase requisition files.  Once the purchase requisition for their store location is entered, the store manager prints one copy of the purchase requisition which is filed in the store manager’s office by date.A purchasing agent at corporate prints the day’s purchase requisition requests entered for each location from the system.  Based on the purchase requisition form and contact with vendors, the purchase agent enters the information into the company database to create a purchase order.  The purchase agent pays for goods at the time of order using the company credit card.  In order to take advantage of possible price discounts, the purchase agent may negotiate costs with the vendor if necessary.  The purchase agent may also combine purchase requisitions to achieve volume discounts.  Since each vendor does not supply all ingredients, multiple purchase orders are often needed in order to fulfill each request.  The computer process accesses the vendor and inventory files and updates the purchase order and cash disbursement files.  Three copies of the purchase order are subsequently printed.  One copy is sent to the vendor, one copy is sent to store receiving and one copy is filed with the purchase requisition by date in the purchasing department.   As a general corporate policy, FBC requires disclosure of related party transactions and in an attempt to avoid kickback schemes, this policy applies to vendor and purchasing department employees.  If a related party is identified, the accounting manager will determine how best to maintain arms-length transactions. A receiving clerk at each location is responsible for receiving, inspecting and recording each delivery for correct items, quantity and quality.  When a delivery comes in, a receiving clerk reviews the goods and compares them to the purchase order document received from purchasing.  If there is a difference between received goods and the purchase order, the store manager resolves the discrepancy.  Sometimes the difference is because the vendor allows items to be backordered and has only sent the items available at that time.  The receiving clerk keys the data into the system to update the inventory file and the received goods file and prints 2 copies of the receiving report.  Then the receiving clerk files the purchase order form and receiving report part 1 together by vendor name and sends part 2 of the receiving report to Accounting.  Fairfax Bread Company may need to return ingredients to vendors if the items were sent incorrectly or do not meet quality standards.  The receiving clerk will contact the vendor and arrange for the return of goods.Required: 1.Conceptual Model:  Draw an REA model with cardinalitiesfor the operating events in the acquisition process described above.  Make sure you differentiate between the operating events and the information events.2.Logical Model:  List each database table required, complete with key attributes (primary keys), foreign keys, and non-key attributes.  Label each keys. Fairfax Bread Company Fairfax Bread Company (FBC) is a national bread company focused on using high quality ingredients with retail locations in... Fairfax Bread Company Fairfax Bread Company (FBC) is a national bread company focused on using high quality ingredients with retail locations in Fairfax, Washington DC, Baltimore and Philadelphia. The company was started by a father and son who each have an entrepreneurial spirit and a love of warm bread. In order to manage the various locations and maintain consistent product quality between those locations, ingredients for each location are ordered from thecorporate office headquarters in Fairfax. The orders are based on input from each store manager and shipped directly to each store location. Description of the Acquisition Process The Fairfax Bread Company acquisition cycle begins when the store manager reviews the ingredient inventory on a daily basis to determine what is needed. If the review shows an order is needed, the store manager creates a purchase requisition in the system using the inventory and purchase requisition files. Once the purchase requisition for their store location is entered, the store manager prints one copy of the purchase requisition which is filed in the store manager’s office by date.A purchasing agent at corporate prints the day’s purchase requisition requests entered for each location from the system. Based on the purchase requisition form and contact with vendors, the purchase agent enters the information into the company database to create a purchase order. The purchase agent pays for goods at the time of order using the company credit card. In order to take advantage of possible price discounts, the purchase agent may negotiate costs with the vendor if necessary. The purchase agent may also combine purchase requisitions to achieve volume discounts. Since each vendor does not supply all ingredients, multiple purchase orders are often needed in order to fulfill each request. The computer process accesses the vendor and inventory files and updates the purchase order and cash disbursement files. Three copies of the purchase order are subsequently printed. One copy is sent to the vendor, one copy is sent to store receiving and one copy is filed with the purchase requisition by date in the purchasing department. As a general corporate policy, FBC requires disclosure of related party transactions and in an attempt to avoid kickback schemes, this policy applies to vendor and purchasing department employees. If a related party is identified, the accounting manager will determine how best to maintain arms-length transactions. A receiving clerk at each location is responsible for receiving, inspecting and recording each delivery for correct items, quantity and quality. When a delivery comes in, a receiving clerk reviews the goods and compares them to the purchase order document received from purchasing. If there is a difference between received goods and the purchase order, the store manager resolves the discrepancy. Sometimes the difference is because the vendor allows items to be backordered and has only sent the items available at that time. The receiving clerk keys the data into the system to update the inventory file and the received goods file and prints 2 copies of the receiving report. Then the receiving clerk files the purchase order form and receiving report part 1 together by vendor name and sends part 2 of the receiving report to Accounting. Fairfax Bread Company may need to return ingredients to vendors if the items were sent incorrectly or do not meet quality standards. The receiving clerk will contact the vendor and arrange for the return of goods. Required: (Turn in two pieces of paper, unstapled, with your name on the top of both pages.) 1.Conceptual Model: Draw an REA model with cardinalitiesfor the operating events in the acquisition process described above. Make sure you differentiate between the operating events and the information events. 2.Logical Model: List each database table required, complete with key attributes (primary keys), foreign keys, and non-key attributes. Label each keys.