0 Required information Chapter 6 Comprehensive Exercise: Baer Belly Bikinis' Purchases of Fabric 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 Palge 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 plecemeal . So, she is looking forward to an assessment of her requirements and recommendations that would position B8B for substantial further growth This case examines Bee purchases of fabric. Bee'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. B88 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 madeled 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. B88 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. Bes 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 5 Part 3 ot 5 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 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 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: 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? + Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? Print 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. Section 3, Question 4 Euch 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 scenes When you summarize information by store, be sure to include all stores and convert and blanks (NULL values) to zeroes. Open the purchases query In Design View. Change the Criteria constraining the Date Received field to show purchases on or before April 15, 2022. Go to Datasheet View. How many records frows) are shown in the query? (Save this query as "Fabric Purchases before April 15th) coder 0 Required information Chapter 6 Comprehensive Exercise: Baer Belly Bikinis' Purchases of Fabric 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 Palge 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 plecemeal . So, she is looking forward to an assessment of her requirements and recommendations that would position B8B for substantial further growth This case examines Bee purchases of fabric. Bee'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. B88 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 madeled 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. B88 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. Bes 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 5 Part 3 ot 5 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 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 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: 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? + Based on the information available, what is the quantity on hand in yards for each fabric color code as of April 15? Print 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. Section 3, Question 4 Euch 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 scenes When you summarize information by store, be sure to include all stores and convert and blanks (NULL values) to zeroes. Open the purchases query In Design View. Change the Criteria constraining the Date Received field to show purchases on or before April 15, 2022. Go to Datasheet View. How many records frows) are shown in the query? (Save this query as "Fabric Purchases before April 15th) coder