Just Questions 1&2

COMPREHENSIVE EXERCISE: BAER BELLY BIKINIS' PURCHASES OF FABRIC As outlined in Chapter 5, Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear. Page 180 and related products to specialty stores throughout the United States. It also sells its products to individuals over a company website. Paige Baer founded BBB almost 10 years ago after she graduated from the Fashion Institute of Design and Merchandising. She recognized the need for swimsuits sold as separates. Her business has grown rapidly, and now BBB has a large following of customers who want to be able to mix and match to find their ideal swimsuit. Currently, BBB products are carried in more than 1,000 specialty swimwear boutiques and online retailers. During an initial interview with Paige Baer, she outlined BBB's business processes. She acknowledged that she doesn't know much about accounting and information technology. As the business grew, her accounting suffered and information systems were added piecemeal. So, she is looking forward to an assessment of her requirements and recommendations that would position BBB for substantial further growth. This case examines BBB purchases of fabric. BBB's production staff selects the fabric and materials for the swimsuits. This case also examines BBB purchases of and miscellaneous supplies and services. BBB Purchases of Fabric orders from the retailer customers to estimate the quantity of swimsuits and products to manufacture, BBB then orders the required quantities of fabric and related materials from the fabric vendors. BBB pays each fabric vendor at the end of the month for all purchases during the month. For each fabric order, there is one receipt. For each receipt of fabric, there is one order. Consequently, the order and purchases (receipts) can be modeled as one event. Details of the Fabric Purchase Process 1. The Production supervisor places an order for fabric according to internal estimates of production quantities (the estimates are not part of the project). 2. Fabric vendors ship fabric in bulk to BBB usually within 2 weeks of the order. 3. A Shipping and Warehouse employee receives the bulk fabric and verifies quantities received. BBB Miscellaneous Purchases BBB also purchases miscellaneous services and supplies, such as electricity, water, sewage, garbage, phone, and janitorial services. It also pays monthly rent on the building, purchases office supplies, hires photo shoot models and photographers, and so on. BBB pays its miscellaneous suppliers at the end of the month for all purchases during the month. BBB Cash Disbursements BBB assigns sequential numbers to each check issued. All checks for purchases (both fabric and miscellaneous) are written on its main bank account. Cash Account Balance Beginning (April 1) Cash Account Description Check# Check Amount Check Pay Date Employee# Employee Address Employee City Employee Department Employee First Name Employee Hire Date Employee Last Name Employee Pay Amount Employee Phone Employee Salary/Wage Employee Zip Fabric Color Code Fabric Color Name Fabric Cost per Yard Fabric Inventory Quantity on Hand Fabric Purchase Date Received Fabric Purchase Order# Fabric Purchase Order Date Fabric Purchase Quantity in Yards Fabric Purchase Received By Fabric Purchase Total Amount Fabric Vendor# Fabric Vendor Address 1 Fabric Vendor Address 2 Fabric Vendor Company Fabric Vendor Item Number Fabric Vendor State Fabric Vendor Type Fabric Vendor Zip Miscellaneous Purchase# Miscellaneous Purchase Amount Miscellaneous Purchase Date Miscellaneous Purchasing Employee# Miscellaneous Vendor# Miscellaneous Vendor Address 1 Miscellaneous Vendor Address 2 Miscellaneous Vendor Company Miscellaneous Vendor Item Number Miscellaneous Vendor State Miscellaneous Vendor Zip Order Employee# Pay Employee# Vendor Type Exercise Requirements 1. Based on the preceding information and the following attributes list, prepare a UML class model and corresponding table Page 181 listing describing BBB's purchases and payments process. List the tables in the following order: resources, events, agents, type images, and linking tables. Identify the primary keys and foreign keys in each table. [optional] Prepare a second UML model that combines the fabric and miscellaneous purchases events and the fabric and miscellaneous vendor agents. Show how you might model a way to differentiate among the types of vendors. 2. [optional] Based on the preceding information, prepare a BPMN activity model that describes BBB's purchases and payments process. The model should begin with BBB placing orders with its vendors and end when BBB makes payments for the purchases to the vendors. 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a new Access database, and import each worksheet in the spreadsheet into the database. Set appropriate primary keys. 4. After importing all the data, create relationships among tables to implement your data model. 5. Prepare queries to answer the following questions: a. What were BBB's total purchases of fabric in the second quarter (April to June)? b. What is BBB's accounts payable balance for each fabric as of April 15? c. Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? Attribute Listing for BBB Bank Name Cash Account# COMPREHENSIVE EXERCISE: BAER BELLY BIKINIS' PURCHASES OF FABRIC As outlined in Chapter 5, Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear. Page 180 and related products to specialty stores throughout the United States. It also sells its products to individuals over a company website. Paige Baer founded BBB almost 10 years ago after she graduated from the Fashion Institute of Design and Merchandising. She recognized the need for swimsuits sold as separates. Her business has grown rapidly, and now BBB has a large following of customers who want to be able to mix and match to find their ideal swimsuit. Currently, BBB products are carried in more than 1,000 specialty swimwear boutiques and online retailers. During an initial interview with Paige Baer, she outlined BBB's business processes. She acknowledged that she doesn't know much about accounting and information technology. As the business grew, her accounting suffered and information systems were added piecemeal. So, she is looking forward to an assessment of her requirements and recommendations that would position BBB for substantial further growth. This case examines BBB purchases of fabric. BBB's production staff selects the fabric and materials for the swimsuits. This case also examines BBB purchases of and miscellaneous supplies and services. BBB Purchases of Fabric orders from the retailer customers to estimate the quantity of swimsuits and products to manufacture, BBB then orders the required quantities of fabric and related materials from the fabric vendors. BBB pays each fabric vendor at the end of the month for all purchases during the month. For each fabric order, there is one receipt. For each receipt of fabric, there is one order. Consequently, the order and purchases (receipts) can be modeled as one event. Details of the Fabric Purchase Process 1. The Production supervisor places an order for fabric according to internal estimates of production quantities (the estimates are not part of the project). 2. Fabric vendors ship fabric in bulk to BBB usually within 2 weeks of the order. 3. A Shipping and Warehouse employee receives the bulk fabric and verifies quantities received. BBB Miscellaneous Purchases BBB also purchases miscellaneous services and supplies, such as electricity, water, sewage, garbage, phone, and janitorial services. It also pays monthly rent on the building, purchases office supplies, hires photo shoot models and photographers, and so on. BBB pays its miscellaneous suppliers at the end of the month for all purchases during the month. BBB Cash Disbursements BBB assigns sequential numbers to each check issued. All checks for purchases (both fabric and miscellaneous) are written on its main bank account. Cash Account Balance Beginning (April 1) Cash Account Description Check# Check Amount Check Pay Date Employee# Employee Address Employee City Employee Department Employee First Name Employee Hire Date Employee Last Name Employee Pay Amount Employee Phone Employee Salary/Wage Employee Zip Fabric Color Code Fabric Color Name Fabric Cost per Yard Fabric Inventory Quantity on Hand Fabric Purchase Date Received Fabric Purchase Order# Fabric Purchase Order Date Fabric Purchase Quantity in Yards Fabric Purchase Received By Fabric Purchase Total Amount Fabric Vendor# Fabric Vendor Address 1 Fabric Vendor Address 2 Fabric Vendor Company Fabric Vendor Item Number Fabric Vendor State Fabric Vendor Type Fabric Vendor Zip Miscellaneous Purchase# Miscellaneous Purchase Amount Miscellaneous Purchase Date Miscellaneous Purchasing Employee# Miscellaneous Vendor# Miscellaneous Vendor Address 1 Miscellaneous Vendor Address 2 Miscellaneous Vendor Company Miscellaneous Vendor Item Number Miscellaneous Vendor State Miscellaneous Vendor Zip Order Employee# Pay Employee# Vendor Type Exercise Requirements 1. Based on the preceding information and the following attributes list, prepare a UML class model and corresponding table Page 181 listing describing BBB's purchases and payments process. List the tables in the following order: resources, events, agents, type images, and linking tables. Identify the primary keys and foreign keys in each table. [optional] Prepare a second UML model that combines the fabric and miscellaneous purchases events and the fabric and miscellaneous vendor agents. Show how you might model a way to differentiate among the types of vendors. 2. [optional] Based on the preceding information, prepare a BPMN activity model that describes BBB's purchases and payments process. The model should begin with BBB placing orders with its vendors and end when BBB makes payments for the purchases to the vendors. 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a new Access database, and import each worksheet in the spreadsheet into the database. Set appropriate primary keys. 4. After importing all the data, create relationships among tables to implement your data model. 5. Prepare queries to answer the following questions: a. What were BBB's total purchases of fabric in the second quarter (April to June)? b. What is BBB's accounts payable balance for each fabric as of April 15? c. Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? Attribute Listing for BBB Bank Name Cash Account#