Sunday, July 24, 2011

KFC Food Price List

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