Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear 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 BBBs business processes. She acknowledged that she doesnt 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. BBBs 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 BBB works closely with local fabric vendors to determine the color themes for each seasons products. When BBB has received enough 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.

Exercise Requirements

1. Based on the preceding information and the following attributes list, prepare a UML class model and corresponding table listing describing BBBs 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. 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. Click hereto access the Attribute Listing for BBB to be used for this exercise.

2. Based on the preceding information, prepare a BPMN activity model that describes BBBs 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. An Excel spreadsheet with the BBB information needed for this Exercise can be accessed here. 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:

1. What were BBBs total purchases of fabric in the second quarter (April to June)?
2. What is BBBs accounts payable balance for each fabric as of April 15?
3. Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15?

Connect Requirements

Complete the Chapter 6 Comprehensive Exercise using the instructions and resources listed above. For your Connect assignment, Sections 1 and 2 should be attempted after you have completed Exercise Requirement 2 listed above. Section 3 should be attempted after you have completed Exercise Requirement 3.