• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

This company specialises in cosmetics and started in 1996. Therefore the company is still growing and expanding. It is a small company with only 2 stores located in Essex and the surrounding area. The managing director of both stores is Mrs. Bell.

Extracts from this document...

Introduction

Design Specification Background Information This company specialises in cosmetics and started in 1996. Therefore the company is still growing and expanding. It is a small company with only 2 stores located in Essex and the surrounding area. The managing director of both stores is Mrs. Bell. User requirements Makeup Mania receives discounts for products that they order. The company does not have a wide range of products as they are still expanding. For each order, there are a number of units in each pack. Below are the numbers of units for each product ordered. Product Units per pack Lip Gloss 12 Mascara 20 Foundation 10 Lip Stick 15 Nail Varnish 20 Eye Liner 25 It depends on how many packs that are ordered to how much discount the company receives. The discount will start at 10% for 3 packs and go up to 50% for 10 packs. The Sales Director Mr. Simpson wants a spreadsheet that will show the lists of stock, the current stock level, and whether or not each product needs ordering. ...read more.

Middle

Data capture method I am going to read the data and input it into the spreadsheet using the data form. This is easier to input the data and is done much more quickly. Data processing the output I am going to use several ways to present the output. Firstly I am going to use formulas to show how much stock there is in store by calculating from how much has been sold in the month. I am going to use an IF function to determine whether the user requires to order stock for a particular product or not depending on the level of stock currently in store. I am going to use look-up tables to determine what percentage the company will receive for different products. These averages will be ranked and averaged to enable the user to see which products are receiving the most discount. Aids to help the user In order to make the system easier for the user to use, I will use macros to help the user see how much is being saved for each product. ...read more.

Conclusion

It will enable the user to know what dates they are working with. I will situate the date in the top corner to keep it separate from the data * RANK - Once the amount of discount each product has saved has been recorded, I will use this function to display in number order that has saved the least, to the most. This function will display easily the product that has saved the most, and will save the user time and display it on the spreadsheet for efficiency. * Comment boxes - So that the user is aware of what everything on the spreadsheet does I have included comment boxes to explain what certain cells are. Problem Definition The main aim is to create a system that saves the company time instead of searching manually for discounts. The spreadsheet should be simple for the person to use and display data accurately with any complications clearly noted so that the user is aware of the spreadsheets capabilities. Main objectives To provide a simple user-friendly system available to MakeUp Mania, which allows the company to see details of the discounts they receive from suppliers. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    Advantages: * No need to know how computers work. * No money wasted on training staff how to work it. * No software needs to be purchased Disadvantages: * No security. * Simple for unauthorised access break-in. * Very time-consuming. * Could take up lots and lots of space.

  2. Computer Systems Assignment 2

    Speed is more easily controlled than pressing "x". Task 4 See Fireworks document (background image) See Fireworks document (logo image) Task 5 a) and b) The Toolbar I would recommend increasing the size of everything, by which I mean the zoom on Word, the small icons to large icons and change the resolution so everything appear bigger.

  1. I am going to be looking at Tesco. I will be focusing on what ...

    by all the tills in Tesco can be fed into their main database. Disadvantages are that if someone makes an error using the computer, or there is a malfunction in the database, people could be undercharged or overcharged, and Tesco could involuntarily lose thousands of pounds, but if an alternative

  2. System requirements analysis

    her to write and it was not as awkward as it would have been if she did not have the earphone as she would only have one hand free to type slowing her down. Also I asked her if she had received any kind of training to use the system

  1. Making a mail-merge for the company "mobiles4u".

    Probably the best feature on Microsoft Word would be the copy and paste because then you can copy writing, tables and even pictures on the internet. The table feature is also good because if you want to put some information into a table it would look a lot neater and makes it clearer.

  2. Main aims and functions of Buckingham Bingo.

    supervisor has to then put a new order of stock in which has to be approved by the office. * At the end of each session the money is totalled up and is then handed in to the cash office.

  1. Develop a spreadsheet application for the Ibis Hotel.

    What are the problems in the existing system we will discuss in the section below: The problem I have informed the manager of Ibis hotel (Mr Singh) that information technology is a very major fact in the global marketing world and in day to day life and I have written

  2. Analysis of stock ordering for Henley Ice cream Parlour.

    The data is compiled in an order book. When the ice cream is delivered, the invoices are also kept. 16. What does the system cost to operate? Costs include the wages paid to the employee who counts the ice cream; the price of the phone call and the price of the paper information is recorded on.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work