Question

In: Accounting

Accounting Information systems Lakers Athletics is an online store that sells athletic gear for LA Lakers’...

Accounting Information systems

Lakers Athletics is an online store that sells athletic gear for LA Lakers’ fans. Lakers Athletics uses the Internet to take customers orders and deliver the goods. Lakers Athletics operates in Pomona and provides delivery to precertified customers.

Lakers Athletics uses a website to post the merchandise they offer. Customers can view the website to see the catalog of inventory items that are available. The sales process is triggered by a customer accessing Lakers Athletics’ inventory catalog and deciding what and if to order. If the customer sees an item they would like to order, they post a customer order within Lakers Athletics’ sales database.

Periodically, throughout the day, Lakers Athletics’ sales manager accesses the sales database and reviews customer initiated customer orders. The sales manager checks customer credit by reviewing the customer database. The sales manager keys in either an acceptance or denial of the customer order, entering a sales order into the sales database when approved. The customer is notified electronically through a transmission from the sales system. If the order is accepted, this transmission takes the form of an electronic sales order; if it is rejected, the transmission is simply an electronic mail message of denial.

Goods are shipped to the customer within 3 days, a printout of the authorized sales order is attached, acting as a packing slip. The shipping department keys the sales order information into the sales database to make sure the shipment is authorized. They then record the sales order as shipped in the sales database. Goods are at times not available—thus out of stock. If the warehouse crew is unable to locate the item requested by the customer, or a suitable substitute, no shipment takes place. The customer receives an email asking them if they wish to wait for the item to arrive from the supplier and be shipped to them.

At the beginning of the following day, the cash receipts officer connects to the sales database to review the shipped goods, and updates the accounts receivable balances. Per agreement with customers, all payments are due within 30 days after receipt of shipped athletic goods. Customers epay for merchandise by credit card or bank transfers. When a customer pays by credit card (or bank transfer), they email their credit card (or bank) information to Lakers Athletics on a credit card (or bank) authorization form. Lakers uses this information to request payment from the National Credit Card Bank (or customer bank). When approved, a monetary transfer is received from the National Credit Card Bank (or customer bank) to Lakers Athletics’ local bank. A confirmation number is received from the local bank, and the cash receipts officer enters the confirmation number into the sales database. This event serves to confirm completion of the payment from the customer.

Requirement: You Need to find Entities and Activities, and along with a chronological table with groups !! Thank you

Solutions

Expert Solution

MAJOR ENTITIES AND THEIR ACTIVITIES

LAKERS ATHLETICS: An online store that sells athletic gear for LA Lakers’ fans. They uses the Internet to take customers orders and provides delivery to pre certified customers.

CUSTOMERS: Set of people who order products through website of Lakers Athletics.

SALES MANAGER: Accesses the sales database and reviews customer initiated customer orders. He checks customer credit by reviewing the customer database. The sales manager accept or deny the customer order during entering a sales order into the sales database when approved.

WAREHOUSE CREW: Locate the item requested by the customer, or a suitable substitute and making ready for shipment

CASH RECEIPT OFFICER: At the beginning of every day he connects to the sales database to review the shipped goods, and updates the accounts receivable balances. After the payment confirmation number receives from the local bank ,cash receipt officer enters it into the sales database.

CUSTOMER BANK(national credit card bank): route the payment of customer and upon the request of payment transfer the money to the local bank

LOCAL BANK: Receipt of payment by customer bank and sent confirmation number to the client(Lakers Athletics).

CHRONOLOGICAL TABLE

LAKERS ATHLETICS POST MERCHANDISE IN WEBSITE .

CUSTOMER POST ORDER .

ONLINE IN SALES DATA BASE   .

        

SALES MANAGER ACCESS THE DATABASE AND REVIEW CUSTOMER INITIATED ORDERS.

CHECK CUSTOMER DATA BASE AND CONFIRM CUSTOMER CREDIT.

ACCEPT OR DENY CUSTOMER ORDER(If the order is accepted, this transmission takes the form of an electronic sales order; if it is rejected, the transmission is simply an electronic mail message of denial).

GOODS ARE SHIPPED(within 3 days).

SHIPPING DEPARTMENT RECORD THE SALES ORDER AS SHIPPED IN THE SALES DATA BASE.

THE CASH RECEIPTS OFFICER CONNECTS TO THE SALES DATABSE TO REVIEW THE SHIPPED GOODS

THE CASH RECEIPTS OFFICER UPDATES THE ACCOUNT RECIEVALBLE BALANCES.

PAYMENTS WILL DUE IN 30 DAYS AFTER RECIEPT OF SHIPMENT.

CUSTOMER EPAY BY CREDIT CARD OR BANK TRANFER.

CUSTOMER EMAIL THEIR CREDIT CARD /BANK INFORMATION TO LAKERS ATHLETICS ON AUTHORIZATON FORM.

LAKERS REQUEST NATIONAL CREDIT CARD BANK/CUSTOMER BANK UPON THOSE INFORMATION.

IF REQUEST APPROVED MONEY WILL BE TRANSFERED TO LAKERS ATHLETICS LOCAL BANK.

CONFIRMATION NUMBER WILL BE SENT FROM THE LOCAL BANK.

CASH RECIEPT OFFICER ENTER CONFIRMATION NUMBER INTO SALES DATA BASE.

CONFIRM THE PAYMENT FROM CUSTOMER.


Related Solutions

Ed’s Athletics sells bicycles and other sports and athletic equipment. Sales and expected warranty claims for...
Ed’s Athletics sells bicycles and other sports and athletic equipment. Sales and expected warranty claims for the year are as follows: Item Unit Sales Expected Warranty Claims Cost per Claim for Warranty Period Mountain bikes 300 3 claims per 100 sold $30 Racing bikes 120 1 claims per 20 sold 75 Snowboards 650 2 claim per 100 sold 20 Required: 1. Prepare the entry to record warranty expense for Ed’s for the year. 2. Conceptual Connection: Why does Ed’s have...
57. Your company wants to expand the specialized market to which it sells athletic gear. The...
57. Your company wants to expand the specialized market to which it sells athletic gear. The general public may be drawn to your items because they are attractive and popular, but most people will balk at the high price tag for features they consider superfluous. You decide to contact strategic partners who can recommend your product, and help explain the concept behind workout gear that regulates body temperature, and why that feature is not only valuable but worth the extra...
Accounting Information Systems Our store, store name is a “gray market” distributor of software license keys....
Accounting Information Systems Our store, store name is a “gray market” distributor of software license keys. This means we are reselling software keys for popular software from reputable vendors, including but not limited to Microsoft, Adobe and SAP. The licenses may or may not be directly obtained from the original vendor. For example, we may be selling Windows 10 keys many times cheaper than their retail price. For example, the level of validity that we can attest to a software...
An online backpack store sells many products that are popular with elementary school children. The store...
An online backpack store sells many products that are popular with elementary school children. The store knows some children under 10 subscribe to the store's coupon service. Is the store subject to the Children's Online Privacy Act?
what are the types of accounting information systems?
what are the types of accounting information systems?
Superman Store has two support departments, Information Systems and Personnel. The Information Systems Department costs are...
Superman Store has two support departments, Information Systems and Personnel. The Information Systems Department costs are allocated on the basis of hours used.  The Personnel Department costs are allocated based on the number of employees.  Data on information systems hours used and number of employees are as follows:             Information Allocation Bases:                                  Systems            Personnel            Fruit               Nut Total cost                                             $120,000          $30,000           $60,000           $90,000 Information systems hours used                600                   600                   720                480 Number of employees                               10                     20                     40                 120 a.  Write the equations needed to allocate support department costs using the reciprocal method. b.  Solve for the total cost to be allocated under...
Describe how accounting information systems have assisted businesses in developing their cost accounting systems.
Describe how accounting information systems have assisted businesses in developing their cost accounting systems.
in regards to accounting information system, What is the difference between accounting information systems and management...
in regards to accounting information system, What is the difference between accounting information systems and management information system?
information related to improper assumptions concerning accounting information systems.
information related to improper assumptions concerning accounting information systems.
Database design of cothing Online Shopping System. Schema represents minimal information required to store information of...
Database design of cothing Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wish-list / watchlist is needed, the schema can be simply extended. Enjoy. SQL and methodology.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT