Selling Price |
Create the excel file shown above and perform the following operations,
Q1. What is the price of large size original chicken fry including VAT?
Q2. What type of juice item is available in the list and what is the price of that item including VAT?
Q3. Find the name of item in the list which has highest value.
KFC Price List | ||||||
Name | Type | Size | Price | |||
Chicken Fry | Original | Regular | TK | 65 | ||
Chicken Fry | Original | Large | TK | 120 | ||
Chicken Fry | Crispy | Regular | TK | 65 | ||
Burger | Chicken | medium | TK | 160 | ||
Juice | Strawberry | normal | TK | 120 | ||
Selling price will be calculated with | 15% | VAT | ||||
Answer to the Q1. | ||||||
Price of large size original chicken fry: | TK | 120 | ||||
15% VAT: | TK | 18 | ||||
Total: | TK | 138 | ||||
Answer to the Q2. | ||||||
Available Juice item is: | Strawberry | |||||
Price: | TK | 120 | ||||
15% VAT: | TK | 18 | ||||
Total: | TK | 138 | ||||
Answer to the Q3. | ||||||
Item containing highest price value is: | Burger |
No comments:
Post a Comment