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

I am designing a data system for a 3D ICT company that sells and makes a wide range of equipment to make 3D packages for other business and websites.

Extracts from this document...

Introduction

ICT COURSEWORK SYSTEM FOR A SMALL BUISNESS I am designing a data system for a 3D ICT company that sells and makes a wide range of equipment to make 3D packages for other business and websites. The business ahs been going well over the last year where we first opened our doors to the public, sales are up and the company needs to have a better hold on its finances and stock. The systems I will need to look at: 1. The sales of products by type 2. Employees cost 3. Fixed and variable costs (e.g. rental and electricity) 4. Stock which is selling well and not selling well 5. Stock level 6. Materials need to make products 7. Machinery that cost money or labour 8. Maintenance THE SALES OF PRODUCTS BY TYPE The products, which my company sells will be listed in order of alphabetical order or order, of which they are selling so the best selling items at the top and the worst selling items at the bottom. Also on this the information would also tell me the level of stock, which my warehouses and shops have, which also links to point 5. ...read more.

Middle

because the items could be listed in order of type, e.g. products for web sites or products for computers. STOCK LEVEL The stock level would be done on a database and it would tell me the level of stock which I am holding, this would be helpful because it would notify me what items I need restock on, and tell me when I need to order the products before I have none left to sell which could leave my company losing customers as the customers may go else were. MATERIALS NEED TO MAKE PRODUCTS The materials need to make products would also be listed in a database and would interact what materials I am low on so that I no when I am making my products what would stop me from not having enough stock in. With this PROBLEMS Some of the problems, which my company are having, are that my company are finding it hard to work out how much we are having to pay our staff and fill that we could be over or under paying are staff. A solution which my company could use to resolve this is by have a spreadsheet which will contain all the employees names and will have how much they get paid by ...read more.

Conclusion

This is what it looks like on Microsoft excel. To make sure that only the correct person can use the spread sheet I will protect it with a password. To do this I will go to the "Tools" on the toolbar and go to protection, which will allow give me 3 options, * Unprotect Sheet * Protect Workbook * Protect and share workbook The Protect Workbook option will give me a box which allows me to protect the spreadsheet from be changed. This will not help as it means that no one can use it with out knowing what the password is. This protect sheet option asks you to have a password which you enter each time you want to edit or use the spreadsheet. If I use the Protect and share workbook option it will give me a different box than the Protect Workbook option. The protect and share workbook gives me the option of protecting my document, meaning that no one can change the spread sheet, but they can still use it to find the wages. This is the best option for me as it means no one could change the details on the spreadsheet but use it only to get the wages need. ...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 People in Business 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 People in Business essays

  1. Leaving? A question all employers ask of their staff if they leave the company ...

    and retail trade has the highest turnover in the UK - at 56% the wholesale and retail trade lead the labour turnover table' It is also possible to look at the retail industry closer and break down the turnover rate into occupational classes.

  2. Report: Type of ownership of J-Sainsbury

    The boss may be called by his/her first name. A business, which has a flat structure, is likely to be good at responding quickly to new ideas or specific customer requests. Also a business with a flat structure will have good communication, in that it is easy to speak to other people and find out what you want to know.

  1. As a short-term business Consultant, I have been hired by Alton Towers PLC to ...

    a uniform, this is to make the park into a more magical place along with making them stand out so they can be identified. Below is an example of what new employees to the park are told: > To behave professionally > Wear the appropriate uniform > Maintain standards of appearance The theme park cares for its staff.

  2. Analysis of a Company: Boots Chemist

    This would include: - > Safe environment. > Safe premises. > All firms must provide all necessary safety equipment free of charge. > Protective clothing e.g. face masks, hair tied back, overalls, eye goggles. Boots is a company, which provides a chemist service and provides a lot of cosmetic products.

  1. unit 2 business coursework - M&S a company overview

    1959 - We became the first retailer to introduce No Smoking rules in our stores. 1961 - Dogs, with the exception of Guide Dogs, were banned from our stores to ensure hygiene at the food counters. 1964 - Simon Marks died after 56 years service to the Company and Israel Sieff took over as Chairman.

  2. Manchester Airport unit 2 theme d level 2

    will attract the widest and most diverse audience possible to ensure that a lot of people get to know about the vacancy, this would result in more applicants and therefore a better chance of getting a more skilled employee. After receiving the application forms I would reduce the number of

  1. unit 2 business coursework

    The business previous names are Vectone Telecom Centres Limited and Gnanam Telecom Centre Limited. Vectone Gnanam liked to do their business at an international level because there is a larger profit outside the United Kingdom in addition they advertise their products through leaflets and they mostly receive payments in cash rather than credit.

  2. Strategic Solution for Next

    The people of Germany spend this time of the day indoors away from the sun and tend to go to sleep for a couple of hours until they are able to face the sun. However this is not the case in France.

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