CANDYLOVERSFINAL

CANDYLOVERSFINAL - Candy Lovers Inc Tables 1 Candy Lovers...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Candy Lovers, Inc. Tables 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Candy Lovers, Inc. Employees Table This table will show more detailed information of each employee. The table includes employer ID, which will be the primary key, full name, title, Wages/hr, hours worked, the total hours worked per week and the total wage paid to each individual. The source of this table is mainly from the application that they submitted and based on their title, we assigned them an hourly wage. Their total hours per week are calculated from the store open times daily. The employee table will in turn help produce a monthly Employees Wages Report that will illustrate monthly salary totals for each employee, among having other functions. 2
Background image of page 2
Candy Lovers, Inc. Product Table The product table represents the products that we selling in our company, Candy Lovers Inc. Each product contains the information such as the name, description, re-order level, unit price and lead time. The product name is important information for identification. The product description indicates the appearance, ingredients, and even the taste of the product. The re-order level is based each week and each products must be re-order if found that store inventory is below 20%. The product serial number is another identification to justify the product. The unit price is important because it is the amount that our company well be selling the product to the customers. The lead time is the period of time between the process of production and the completion of the process. 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Candy Lovers, Inc. Pricing Table The pricing table with give us all the information that we need about the price. It includes the product cost-which is the price we pay for the product, the retail price- the price we are selling, as well as the profit margin. We set the product Id number as the primary key because we can easily access all the information about a particular product. We use this table to keep track of our profit and adjust pricing when it is necessary. Therefore, this table is very useful and important for the strategic management because it gives us an overview of our revenue. 4
Background image of page 4
Inventory Purchases Table The Inventory Purchases table contains the unit price, product name, date of the transaction, product item number, and the quantity purchased. This table will be extremely helpful in trend analysis. Thus, Candy Lovers will be able to determine what candies sell better during certain seasons. With this information, Candy Lovers will be able to get the jump on its competition by knowing their key demographics better. In turn, Candy Lovers will be able to use regression or trend analysis to determine the time and reorder quantities for products that will help to increase revenues as well as avoiding overstocking unwanted items. In addition, it provides pertinent information for forming various reports for Candy Lovers. 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 36

CANDYLOVERSFINAL - Candy Lovers Inc Tables 1 Candy Lovers...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online