|
Home > Archive > Oracle certifications > June 2002 > Visual Basic.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| tsigam 2002-05-31, 12:33 pm |
| If anyone knows VB, Please help me write the calculations in VB. I have created the inetrface for the program, I'm having a hard time coding the calculations so that it displays the percentage for each soft drink brand.
The problem is to find the advertising expenditure percentage for each soft drink, cola-cola and Pesi for 1995 and 1996 expenditure and display the percentage for each.
1995 Cola-cola=$60.7 and 1996=$121.6
1995 Pepsi-cola=$94.8 and 1996=$83.0
the book says to use this formula to caculate:100 *([1996 expenditure]-[1995 expenditure])/1995 expenditure.
please help!!!!! | |
| Skating Zebra 2002-06-03, 8:09 am |
| Okay, a couple of questions here...
1. Are you trying to compare the percentage difference in advertising dollars spent between the two companies, or are you trying to calculate how much of each company's budget was spent on advertising for each year?
2. What are the numbers you have listed below? Are these the advertising budget amounts in millions of dollars for each year? | |
| tsigam 2002-06-03, 12:37 pm |
| Yes, the amounts are in millions of dollars. it's finding the advertising budget percentage for each soft drink brand. | |
| Skating Zebra 2002-06-03, 7:12 pm |
| Okay, but are the amounts shown the money that was spent on advertising? If so, you need the total budget to compare against.
What EXACTLY are you trying to calculate? The total increase in advertising money spent for each company? The amount of advertising money vs. the whole budget? If you're trying to figure out what percentage of the entire budget was spent on advertising, you need to include figures on the total amount spent for each year for each company. |
|
|
|
|