Use IT tools to produce management information (P7)
Generate valid, accurate and useful information (M2)
I have produced a management information system for the Stationery Shop for The Nobel School.
The first thing I did to make the management information system is to collect information about the supplier. This tells us where we order the products and how much it cost and how many you get in a pack when you order. I also divided the total amount by the quantity you get in a pack, so it tells me the price per individual. Since schools cannot make profit from this shop, which means that they must sell the products at the same price as they purchased it or less. In this case, the price per individual product is going to be the selling price (a pen will cost 19 pence).
This is then transferred into another tab in the spreadsheet document which has all the information about sales and stock levels over the course of the year. The picture below shows the sales that have been made monthly. It also shows the total amount sold for each product for each month and for the whole year.
The Sales throughout the year is then collected and shown as a line graph to easily identify and compare what is selling the most at what points in the year. This is important to The Nobel School as they cannot make a profit to a student which means they can focus more on what sells the most instead of what makes the most money. This graph represents what The Nobel School needs.
The picture below shows the information about the stocks levels throughout the year. Initially, the school has ordered 500 stock for pens, pencils etc. at the start of the year to see how well each one sells to determine how much they need in a couple of months’ time when the next order batch occurs. The purchase of stock is also reflected in the stock table. The amount of stock that was purchased is calculated and presented in the column next to the purchases of stock. The money spent is calculated by multiplying the purchase of stock with the selling price on the supplier information tab in the same spreadsheet. The total is shown of how much is spent in year 2015 for each product.
The money that has been gained during the sales has been represented below in a table for each month. This has been calculated by multiplying the sales and the selling price together.
The money spent in total in order to purchase the products is listed here in the total spent. The money gained/loss is calculated by adding up the total for each couple of months until it reaches the order batch. The total amount of money gained/loss is shown in bold in the bottom-right corner of the column. As this is highlighted in red, it means that the school has lost money. This is good as the school is unable to make a profit, so if this was highlighted in green, it would mean the school made a profit and someone must have sold something at a higher price than it was listed. The total amount of money gained/loss is calculated by subtracting the total money spent with the sum of the total money gained for each month.