Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BACKGROUND You have been hired to help a small business located in San Diego, California. Peppers Beach Wear sells swimwear and related products to specialty

BACKGROUND You have been hired to help a small business located in San Diego, California. Peppers Beach Wear sells swimwear and related products to specialty stores throughout the United States. It also sells its products to individuals from its company website. Patty Peppers founded PBW several 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 PBW has a large following of customers who want to be able to mix and match to find their ideal swimsuit. Currently, PBW products are carried in more than 1,000 specialty swimwear boutiques and online retailers. During an initial interview with Patty, she outlined PBW'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 PBW for substantial further growth. In this case, you will examine PBW's fabric purchases. PBW's production staff selects the fabric and materials for the swimsuits. You will also examine PBW purchases of miscellaneous supplies and services. The instructions in this exercise are targeted toward those with some familiarity with Microsoft Access, making use of concepts covered in the course. If you are familiar with Access, you may have preferred techniques for completing the requirements. Feel free to use these techniques where appropriate, but make sure your resulting database is fully functional and follows the guidelines presented in these instructions.

PBW Fabric Purchases PBW works closely with local fabric vendors to determine the color themes for each season's products. When PBW has received enough orders from the retailer customers to estimate the quantity of swimsuits and products to manufacture, PBW then orders the required quantities of fabric and related materials from the fabric vendors. PBW 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.

Fabric Purchase Process Details The Production supervisor places an order for fabric, based on internal estimates of production quantities (the estimates are outside the scope of this project). Fabric vendors ship fabric in bulk to PBW, usually within 2 weeks of the order. A Shipping and Warehouse employee receives the bulk fabric and verifies quantities received.

Miscellaneous Purchases PBW 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. PBW pays its miscellaneous suppliers at the end of the month for all purchases during the month.

Cash Disbursements PBW assigns sequential numbers to each check issued. All checks for purchases (both fabric and miscellaneous) are written on its main bank account.

QUESTION: Based on the information presented above, and the list of attributes (Appendix A), prepare a UML class model that describes PBW's purchases and payments process. Keep in mind that the class model will become a guideline for building the Access database. Be sure to use the R-E-A approach when creating your UML class model. Also, indicate type images on your class model with a brief text annotation. Just below your UML class model, list the names of the linking tables that will be required based on your class model. Show how you might model a way to differentiate among the types of vendors.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles Volume I

Authors: Kermit Larson, Tilly Jensen, Heidi Dieckmann

16th Canadian edition

978-1260305821

Students also viewed these Accounting questions

Question

4 How do you see the future of integrative approaches to coaching?

Answered: 1 week ago