Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Design a spreadsheet that can be used by a school tuck shop.
Member rating: No Rating | Words: | Submitted: Fri Jan 09 2004
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Analysis My task is to design a spreadsheet that can be used by a school tuck shop, which can be used to find the following: * Income * Expenditures * Stock amounts * Popularity of products * The selling price of stock * Profit made * Wages of employees * Whether to order more stock The spreadsheet can be used as a model to predict all of these things throughout the three school terms. The product popularity can be used to see what products are most popular and unpopular in the different seasons. This can then be used to order in more or less of a certain product to get maximum profit. The spreadsheet has been designed to calculate the how much profit you make on each item and how much overall after expenses such as electricity and wages have been paid. IF formulas have been used to tell the owner when he/she needs to buy in more of a...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 150,112 others
