Assignments

In this project you will be the manager of a small store. In this store you will sell 10 items of your choosing, and track the store's progress for a yearly quarter.

For an idea of how this will be graded, see the grade sheet.

Part 1 (56 pts) - Excel

Copy the Excel spreadsheet project.xlsx from the common/assignments/project directory in the E 115 course locker. You will be expected to use cell names where appropriate throughout this spreadsheet.

Items

In the items section you will give the items your company sells, and your profit expected from each item. The profit values should be reasonable for the item you choose.

Tracking Sales

A normal item will sell 25 units a week. During each month, two of your items will be "hot" items. Hot items will sell twice as much. Also each month three of your items will be "lame" items. These items will only sell 10 units a week. Each week you will also pick two items to go on sale. An item on sale will sell 20% more than usual, but at a 15% reduced profit. On the spreadsheet you will put the status of each of your items in the status column for the corresponding week. To determine the number of items sold and profit for each week you will need to use conditional logic.

Using formulas you will find your most and least profitable weeks in each month, as well as your total profit. Using conditional logic you will find out how many items will need additional units to be ordered for each week.

Graph

You will create a line graph. This graph will have each of your weeks' profits as data points, to show how your profit changes throughout the quarter.

Part 2 (44 pts) - XHTML

You will design a website for your prospective customers. The site will include 3 pages. All of the pages should have a common banner and footer. In the banner you will have your company name and logo, as well as the links to the other pages of your site. In the footer you will need to include contact information in case a customer needs it.

These files should not go directly in your ~/www/ folder, but in the folder ~/www/project/ (remember that the web servers are case-sensitive).

index.html

This will be the first page a visitor to your site will see. It should contain information about your business. You should have two paragraphs. The first paragraph should be a short summary about your store; what you sell. The second paragraph should have history for your store; how it was founded, any awards it may have one in the past.

products.html

This page will have a table of the items you sell. You will choose one week from the spread sheet to advertise. The table should include the following columns: item name, price, any status it may have, a brief description, and a picture. Remember that this page represents items that your company sells, so you want it to be easy to read and eye catching to customers.

ordering.html

You will make an ordered list with reasons why someone should buy from your company, each reason having a bulleted list of key points. At the bottom of this page you will link a mail in order form for your customers to download. This should be a .pdf file and should be made by you, not borrowed from another source.

Submit each .html file along with project.xlsx in order to receive full credit.