Creating a Weekly Sales Table



Creating a Weekly Sales Table

You have been hired by "Chocolates Are Us" to design a weekly sales record for customer orders. You will create your table in Microsoft Excel. Open Microsoft Excel and choose New Document to bring up a new document window.

• Create a table showing:

o Items For Sale

o Cost of Item

o Number Sold For:

▪ Monday

▪ Tuesday

▪ Wednesday

▪ Thursday

▪ Friday

o Total Sold for the Week

• Use the table below as an example:

|Gift Item |Cost of Item |# Sold M |

 

• At the clear document screen, create the table shown above by completing the following steps:

o Set Page Setup to Landscape:

▪ Click File on the Menu Toolbar

▪ Select Page Setup

▪ Click the Landscape Radio Button

▪ Click OK to close the Page Setup Dialog Box

• Title your page in Row 1

• Key in the column and row headings (see example above for assistance) and make them stand out:

o Gift Item

o Cost of Item

o # Sold M

o # Sold T

o # Sold W

o # Sold TH

o # Sold F

o Total Sold for Week

• Use the tables below of your sales items and then the amount of sales for each day to key in your data

o Key in short names to keep spacing at a minimum for gift names (example: chocolate cell phone could be listed just as phone)

o Key in the price of each gift under its appropriate column heading

|Gift Item: |Price: |

|Chocolate Cell Phone: |$ 7.95 |

|[pic] | |

|1 Dozen Chocolate Long Stem Roses:: |$ 39.95 |

|[pic] | |

|Chocolate Pizza: |$ 6.95 |

|[pic] | |

|Chocolate CD: |$ 11.95 |

|[pic] | |

|Chocolate Baby Shoes: |$ 9.95 |

|[pic] | |

|Chocolate Computer: |$ 11.95 |

|[pic] | |

• You will now enter the number of each gift items sold per day. Use the table below to find the fictitious numbers you will enter as sold per day.

|Number Sold on Monday |

|Gift Item |Number Sold |

|Chocolate Phone |12 |

|Dozen Long Stem Roses |5 |

|Chocolate Pizza |20 |

|Chocolate CD |35 |

|Chocolate Baby Shoes |52 |

|Chocolate Computer |18 |

|Number Sold on Tuesday |

|Gift Item |Number Sold |

|Chocolate Phone |23 |

|Dozen Long Stem Roses |11 |

|Chocolate Pizza |20 |

|Chocolate CD |28 |

|Chocolate Baby Shoes |26 |

|Chocolate Computer |12 |

|Number Sold on Wednesday |

|Gift Item |Number Sold |

|Chocolate Phone |30 |

|Dozen Long Stem Roses |16 |

|Chocolate Pizza |28 |

|Chocolate CD |26 |

|Chocolate Baby Shoes |32 |

|Chocolate Computer |33 |

|Number Sold on Thursday |

|Gift Item |Number Sold |

|Chocolate Phone |35 |

|Dozen Long Stem Roses |15 |

|Chocolate Pizza |45 |

|Chocolate CD |55 |

|Chocolate Baby Shoes |24 |

|Chocolate Computer |28 |

|Number Sold on Friday |

|Gift Item |Number Sold |

|Chocolate Phone |30 |

|Dozen Long Stem Roses |15 |

|Chocolate Pizza |22 |

|Chocolate CD |42 |

|Chocolate Baby Shoes |38 |

|Chocolate Computer |22 |

• You should now input formulas that will calculate the number of each item sold for the week of Valentine’s and the amount of sales (or money) you’re your business took in on that item for the week.

• Finally, you will also need to calculate total sales for the week in a dollar figure that represents the sales of ALL products sold this week.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download