joelkrause57
New member
- Apr 3, 2008
- 26
- 0
- 1
can someone please put this into clearer terms for me, its an i.t project that is super important!
------------------
The proprietors of the Golden Tiger Herbal Emporium, Jock and Agnes McGregor, are looking for a new solution to help them develop a pricing structure for their range of medicinal herbal products. They currently apply a flat rate of markup which evens out the sales tax that applies to some product lines based on the country of origin. They want to develop a pricing structure that will allow for the correct rate of sales tax to be included for each item and an appropriate level of markup to be applied to each item so that they can maintain a pricing structure that will be competitive with opposition companies.
A lookup table will be needed which determines which level of markup will need to be applied to each product. This is a scheme that is based on the cost of the product. The sales tax that is to be applied is based on a figure of 22% for products sourced from outside Australia and 13% for those sourced from within Australia. This amount should be determined through the use of an IF statement. The sales tax is calculated on the cost of the product but is added on after the markup has been added. The result of these calculations needs to be rounded off to the nearest ten cents through use of the ROUND function.
These prices need to be shown on a second worksheet and printed out as a price list for customers. This price list needs to be formatted with care and to include an address, phone number, fax number and email for the company.
The data for this price list is:
CodeProduct DescriptionCost ($)Origin
RG1003Red Ginseng - Tablets9.62Korea
GB0912Gingko Biloba - Capsules6.78China
EC0775Echinacea - Extract5.82USA
GA3060Garlic - Odourless Tablets4.75Australia
VA4029Valerian - Capsules6.87Taiwan
CH0845Chili AntiOxidant Tablets10.20Australia
BY1662Brewers Yeast6.04Australia
SA1827Salix Headache Remedy3.78England
CO6110Comfrey Wound Dressing6.29Australia
BO8765Borage Lactation Stimulant5.07USA
AV9901Aloe Vera Skin Lotion6.10Mexico
SC4428Skullcap - Nighttime Tablets7.04South Africa
The rates of markup depend on the cost and are as follows:
Cost ($)Markup
Under 450%
4 - 5.7947.5%
5.80 - 7.8945%
7.90 - 9.9942.5%
10.00 and over40%
please help, this assignment needs to be handed in, tomorrow morning!
just tell me how to work out all the stuff, then i'll do the rest
cheers everyone!
------------------
The proprietors of the Golden Tiger Herbal Emporium, Jock and Agnes McGregor, are looking for a new solution to help them develop a pricing structure for their range of medicinal herbal products. They currently apply a flat rate of markup which evens out the sales tax that applies to some product lines based on the country of origin. They want to develop a pricing structure that will allow for the correct rate of sales tax to be included for each item and an appropriate level of markup to be applied to each item so that they can maintain a pricing structure that will be competitive with opposition companies.
A lookup table will be needed which determines which level of markup will need to be applied to each product. This is a scheme that is based on the cost of the product. The sales tax that is to be applied is based on a figure of 22% for products sourced from outside Australia and 13% for those sourced from within Australia. This amount should be determined through the use of an IF statement. The sales tax is calculated on the cost of the product but is added on after the markup has been added. The result of these calculations needs to be rounded off to the nearest ten cents through use of the ROUND function.
These prices need to be shown on a second worksheet and printed out as a price list for customers. This price list needs to be formatted with care and to include an address, phone number, fax number and email for the company.
The data for this price list is:
CodeProduct DescriptionCost ($)Origin
RG1003Red Ginseng - Tablets9.62Korea
GB0912Gingko Biloba - Capsules6.78China
EC0775Echinacea - Extract5.82USA
GA3060Garlic - Odourless Tablets4.75Australia
VA4029Valerian - Capsules6.87Taiwan
CH0845Chili AntiOxidant Tablets10.20Australia
BY1662Brewers Yeast6.04Australia
SA1827Salix Headache Remedy3.78England
CO6110Comfrey Wound Dressing6.29Australia
BO8765Borage Lactation Stimulant5.07USA
AV9901Aloe Vera Skin Lotion6.10Mexico
SC4428Skullcap - Nighttime Tablets7.04South Africa
The rates of markup depend on the cost and are as follows:
Cost ($)Markup
Under 450%
4 - 5.7947.5%
5.80 - 7.8945%
7.90 - 9.9942.5%
10.00 and over40%
please help, this assignment needs to be handed in, tomorrow morning!
just tell me how to work out all the stuff, then i'll do the rest
cheers everyone!