calculating cost

Originally Posted by teylyn

so. Looking at this now. I'm afraid I can't make much of the Word file in your first attachment.

Please explain what you want to do. Work out manually what the result for the first three vehicles on Sheet 2 should be and explain how you arrived at these results.

Ok, pretty much what it does is:

I have a heading called Type, under that is two sub headings one State (for state newspaper advertising) and one Local (for local newspaper advertising). Need it to lookup the category for each car e.g Sedan (has 3lines in local and 3 lines in state) Need a formula that will display either 3 line, 5 line or pictorial for the state and local coloums.

Additional Costs column looks up if there are any costs in the Website Advertising costs or Magazine advert columns in sheet 1.




Duration is how many times in a week it is showed, the car is put in for a 2 week add, so if the add is showed twice a week, in total it is showed 4 times.

Advertising will then do:

"commercial” car category, to be sold for $27,990, the total advertising cost should come out
to be $1125."

Explaining that:

Commercial = Web Advertising Cost ($100) + Magazine Advert($225) + (leader($50)+times($60)) *2 + (age($80) + herald($65)) * 4

further explaing:

(leader($50)+times($60)) *2

Commercial is a 5line advertisment therefore the 50 + 60, * 2 because 110(50+60) is the price for a 1 week add. we need 2 weeks)

(age($80) + herald($65)) * 4

Commercial is a 5line advertisment therefore the 80 + 65, *4 is because the 80+65 is the price for one add, this add is run twice a week, wee need it to run for 2 weeks, therefore 4 adds in total

That formula there will give me $1125

I have updated the Advertising Sheet, take a look. NEW