Exercise 25: Product database

Product database

As I mention in Homework 5 Jera’s product list includes over 130 product, however in purposes of learning I limited my stock list to 11 products

Standard Product Database typically include: 

 

Product Code/Number

Product name

Stock Quantity

Unit Price

Stock Sold

Profit 

How to create Product database?

 1.   Start with creating columns including previously mention factors

2.   Fill Product Number, Product name, Stock Quantity, Unit Price, Sold Stock and Sale Price manually

 3.   To calculate Total Cost of each product

In formula bar: =(Stock Quantity*Unit Price)

4.   To calculate Total Sales of each product

In formula bar: =(Stock Sold*Sale Price)

 5.   To calculate Profit of each product

In formula bar: =(Total Cost-Total Sales)

6.   To calculate Total Cost:

In formula bar: =SUM(; then select cells representing total costs; press enter

 

7.   To calculate Total Sales:

In formula bar: =SUM(; then select cells representing total sales; press enter

 

8.   To calculate Total Profit:

In formula bar: =SUM(; then select cells representing profit; press enter