Selecting Information

Selecting Information

Order processing

I processed data into the order processing part of Excel I did this by inputting, outputting and selecting data. I input data into the order processing on Excel; I input the order code, date, customer code, product code and the quantity. I selected the customer code from a drop down menu however rather than putting in in manually.

The output of this information was the customer name, product name, product cost and the total cost of the order. This new information will be used to see who will be purchasing the jam to see if they are an existing customer and also see the total cost of the order. This will show me how much money the total cost of the order will be and therefore I can also see which one is the most popular product name.

I can use it in my business and to also see what customer orders the most jam so I could send them offers or discounts on the jam they buy. For example I put ‘ORD006’ into the order processing part of Excel so I knew what the order was called so I could identify it however the ‘Strawberry Jam’ came up without me entering data as Excel already knew what the product name was from the product code; the product name will let the customer know what the name of the product the customers are buying are called and also the people working in the stockroom as they need the name so they can get it off the shelf and send it to the customer. The total cost of order will tell the finance within the business how much money is coming in.

Stock control

I went onto the stock table on Excel and input the 40 more on the ‘Stock out’ column with the product code of ‘GJ0027’. I entered this data to make sure the numbers on my stock control where up to date so that the stock never runs out and can be re ordered when needed.

The output of this was that the ‘Reorder message’ changed with is an output of my action alongside the amount of ‘Closing stock’ at the end of the day. This changes the closing stock at the end of the day meaning that I will be able to assess how many products I have sold within the day to see if my business is meeting its targets and therefore if it is not I will be able to make changes to my advertisement or the price of my products for example so this is important for my business.

This new information supports the business decision of when to reorder stock in to the company if it is too low for example below ‘50’. This helps the business to be advanced on when to re stock this way the customers will always be able to buy a product from my company.

Purchasing

I entered the purchase order code, the product code and the quantity in which I needed of my product into Excel ‘Purchasing tab’. I input ‘PO9006’ and ‘GJ0027’ and ’50, this was all manually done. I input this by entering it using the keyboard manually rather than using the option of a drop down tabs available.

As I input this the output was the computer worked out the supplier, unit cost and the total cost of the jam. This came up without me entering anything into the columns/rows that’s why it was an output; this is why it helps the business by making the purchasing part of the business quicker and therefore less work for the company like in this example the Jam.

I can use this in my business when I want to find out how much the total cost of the order might be. For example in the business if I wanted to know how much it would cost to get 40 jars from the supplier ‘Greenwoods’ it would say the total cost ‘£1,080.00’. I can also use this to see which of my supplier the best value is for money therefore I will be able to use them regularly and cut my costs. This would be a quicker way to do so. This therefore speeds up the process and means I won’t need as many employees to do the financial side of my business for me as I can work it out through Excel.