- click here for more information on this paper
Design a Customer Database
Play Around Toys Inc. owns another division known as Play Around Again Toys. This division sells previously used toys. Because this division focuses on keeping costs low, it does not maintain any type of automated customer database. Click here to learn more about Play Around Again Toys and the challenges it is facing.
Submit a report answering the following questions:
- Describe the problem being faced by Play Around Again Toys and its business impact.
- Propose a solution to the above problem, list its objectives, and express its feasibility.
- List the information requirements that the solution will address.
- Create a schedule for building the database.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
- Submit your answers in a one- or two-page MS Word document.
- Font: Arial; 12-point
- Line Spacing: Double
To set the pricing for items, the staff uses information from customers such as original cost, age, and history. The staff combines this information with its own experience and current resale value to determine the price. All consigned items are subject to scheduled markdowns. All consignment contracts are valid for 90 days.
A customer entering the store is greeted by a staff member, who manually fills a form with information such as the customer’s name, address and telephone number, date of visit, items to sell, and where they heard of the company. If the customer decides to sell the items, the staff member fills out a manual agreement. Large yellow tags are placed on each item indicating the date the item came into the shop. As part of their daily routine, staff members are required to check all tags and rotate, reduce pricing, or remove items from the shelves.
Play Around Again Toys does not believe it has enough information about its customers. The company cannot contact customers for repeat business. In addition, managers find that items often stay on the shelves longer than 90 days. The company is forced to purchase the items that are lost. Executive
management cannot easily determine which advertising vehicle is producing the most revenue.