Required information

Background:

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 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

BBB works closely with local fabric vendors to determine the color themes for each season's 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 UML class model and corresponding table 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. Prepare 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. Clickhereto access the Attribute Listing for BBB to be used for this exercise.

2. Based on the preceding information, prepare 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. An Excel spreadsheet with the BBB information needed for this Exercise can be accessedhere. Create 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 BBB's total purchases of fabric in the second quarter (April to June)?
2. What is BBB's 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?

ConnectRequirements

Complete the Chapter 6 Comprehensive Exerciseusing 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 completedExercise Requirement 3.

rev: 11_14_2018_QC_CS-147947

Each question should be attempted after you have completed Exercise Requirement 3. Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Answers in dollars should be rounded to two decimal places. Differences in rounding may produce slightly different totals, so select the closest answer when your exact answer is not shown in multiple choice scenarios. When you summarize information by store, be sure to include all stores and convert and blanks (NULL values) to zeroes.

Continuing with this query, return to Design View. Use the Expression Builder to compute Accounts Payable April 15 as Total Purchases minus Total CD Amount. Go to Datasheet View. What is the Accounts Payable amount? (Save this query as "AP as of April 15th.")

Multiple Choice

• $287,807.67
• $472,731.42
• None of these
• $401,031.92
• $295,307.67