I need a sales projection spreadsheet created with formulas. There are 24 existing products, plus room for 12 additional products to be added later by my team. The spreadsheet is to have each product separated and detailed - percentages, number of sales, etc. There is also to be running totals - adding all of each products totals into one total - plus this final total will be broken into smaller percentages. As each new product is added or we change one products sales - the running totals will change so we can see what changes in sales will do to the overall sales forcast. I have started the spreadsheet for you so you can see what I intend. The first two products have the formulas to explain what we want - HOWEVER - you should not rely on my formulas for anything except to show you what I want. I do not work extensively in excel and these formulas that I created my not carry through the entire worksheet. There are notes on the first page of the spreadsheet.
page two has the running totals and 3 sections where these totals need to populate from the first pages numbers and formulas - there is a note from each section.
This is a very small and simple project for someone experienced in excel - I have done a lot of the work to show you what needs to be done.
please review the new attachment - I need a 3rd page. Very simple - see the attached with the 3rd page - this page simply carries the sales totals from each product and then gives a series of columns with percentages of these totals - so column A is the product, B is the sales total from page one for that product, C is 1% of the total, B is 2% etc - see the % I want. Please account for this in your bid if you think it is worth extra. Any bids after I post this will be assumed to have looked at this - so no extra will be expected for bids after this update/
35 freelancers are bidding on average $37 for this job
I'm a computer engineer with a good experience in web developpement.I'm interrested by your [url removed, login to view] will allow me to gain your trust in the futur.