calculating cost

**teylyn** · 04-12-2010, 04:53 AM

It's getting clearer now.

By the way, "mate" is actually "china plate".

So, in your newly uploaded "Advertising Cost.xls" you have the advertising cost on one sheet. On Sheet2 you have a list of cars with reggo, category and sales price.
Two column are empty.

I assume the point of this exercise is to fill these two columns with data that has some connection to the other file you uploaded.

Question 1: What is "Type" and what do you want to see in that column for each vehicle? Can you give an example of the expected result?

Question 2: What is "Additional Cost" and what do you want to see in that column for each vehicle? Can you give an example of the expected result?

Are there any other calculations that you want to perform? If so, give examples of the expected result and explain the logic that would lead to the result in plain words.

**coccoster** · 04-12-2010, 05:28 AM

I assume the point of this exercise is to fill these two columns with data that has some connection to the other file you uploaded.

Think there are a few other coloums like "Advertising Costs" (forgot to put that one in)

Question 1: What is "Type" and what do you want to see in that column for each vehicle? Can you give an example of the expected result?

I presume type to mean 3lines or 5lines in regards to State or Local Newspapers(defined in Sheet 1) I have no examples to give you other then the one provided a few posts back, sorry.

Question 2: What is "Additional Cost" and what do you want to see in that column for each vehicle? Can you give an example of the expected result?

Additional costs are one of costs that occur if the advertisment is a web add, e.g The web advertising costs in sheet 1.

Are there any other calculations that you want to perform? If so, give examples of the expected result and explain the logic that would lead to the result in plain words.

Again the only expected results i have been giving is the one i posted a few posts ago,

Thanks for helping out, really do appreciate it