Accounting Analytics - Assignment 1

Business Process Data Modeling Assignment

Tip Top Cleaners Tip

Top Cleaners offers various cleaning services to customers at its retail location in Pentagon City Mall and to commercial organizations, such as H&M, which is located in the same mall. Dry cleaning and laundry services for clothing and household items such as curtains and bed coverings are offered by Tip Top. Some specialty services such as clothing repair, leather cleaning, and shoe repair make up their other services.

Description of the Sales/Collection Process

The sales cycle begins when a customer enters the store with their clothing and other items to be serviced. A cashier records the order directly into the cash register, which is connected to the ERP system, and places the customer items in a canvas bag to be sent to an off-site cleaning facility. The cashier prints two copies of the service order report. One copy of the service order report is provided to the customer. The second copy is attached to the bag containing the customer items.

As the items on the order are cleaned and/or serviced, the packing specialist packages the items from the order together. Depending on the variety of services ordered, the order can have multiple packages. When the ordered services are complete, the packages along with the service order report are returned to the retail store to await customer pickup.

When the customer picks up the items, a cashier uses the cash register to prepare three copies of a delivery receipt. For retail customers, payment is required at the time the customers order is picked up. Regency Cleaners accepts cash, check, or major credit card. For commercial customers, credit is authorized and payment is due within 30 days. One copy of the delivery receipt is filed in the store filing cabinet along with the service order report by order number. Another copy of the delivery slip is provided to the customer as a receipt. The remaining copy is forwarded to the bookkeeper who files it in her office. The payment received is kept in the register.

At the end of each month, the bookkeeper mails customer statements to customers with balances owing. Regency Cleaners accepts installment payments in some cases. When the customer checks are received at the store, the cashier enters the payment information into the cash register and places the checks in the register.

At the end of every day, the store manager prints a copy of the cash collections report from the cash register. After counting the cash and checks in the register (credit card payments are automatically wire-transferred by the credit card companies), the store manager manually prepares a bank deposit slip with one carbon copy. The original deposit slip, along with the cash and checks are dropped off in the night deposit box at the bank. The second deposit slip is filed in the stores filing cabinet by date.

Required:

Conceptual Model (30 points - 3% of overall grade)

Draw a business process data model (REA diagram) with cardinalities for the operating events in the Regency Cleaners sales/collection process described above. Remember to distinguish between operating events and information events. Information events are not captured in the data model; only the operating events. Hint: If an "optional event" for this type of process is explicitly stated in the narrative, you should include it. Also, as this is a cleaner, you do not have to model the Return event.

The data model can be hand-drawn but neatness is required. It does not need to be completed using a computer graphics program, although that is certainly acceptable.

Scan your hand-drawn model or take a good picture of it and save it as a pdf file before uploading it to our course site. Make sure that the model is easily readable for me to grade