On my own trying to work out the solution. I'd be happy to hear from anyone who can give me a start (I've managed the importing etc and one =sum formula) and I would reciprocate when I get any further.

Has anyone thoughts on the significance of the Ratings in the Sales worksheet? Any clues on how to set the Wholesale price in the Summary sheet, other than trial and error within the price range of the Survey? I am no Spreadsheet expert, so can't see how to perhaps set the price while relating it...

In the Summary worksheet, is the Cost of Bottles in B9, solely the cost of the bottles at 80p each, or to include the cost of the ingredients? I know the costs below in B12 should include the ingredients. How is anyone arriving at how to deduce the wholesale price (cell B5 and then filled across)? I...

I have a solution that make in the region of £7 million profit. I have lots of resources including a sample completed Excel workbook with comments and also exemplar questions for the probable activity 2 and 3. I will email them to you. Please do not distribute the workbook to students as I am not sure...

I recieved the files this morning and the first steps - importing, formulas for totals, profits, etc, seem fine. But, after that, what is the logic, bar trial and error, for the units to be built, save there can be no more than 200 of any type. How will the margin be set? How will we work out what features...

HI all, I'm an ICT teacher, working on Uint 3 (January 2008). I am scared to mention that I have not yet got the data files (practice .xls and .txt) except the scenario, I and my examinations officer for the centre tried several times though! When I click on the link pre-release material in Applied...