Customers Sales Information

Evidence:

Quiz: #CF104-1L

Time: 25 min

Marks: 15 

Sales Chart

Create the above excel document and fill up the following blank 

fields based on following criteria:

For Discount 1: a) If total items cost is greater than or equal to 5000 and less than 10000 then discount

                                 will be 5%.

                            b) If total items cost is greater than or equal to 10000 and less than 20000 then discount

                                 will be 8%.

                            c) If total items cost is greater than or equal to 20000 then discount will be 10%.

For Discount 2:  Customer will get the membership discount if he/she has membership card.

Special discount: After deducting discount 1 and discount 2 if the total cost is greater than or equal to

                               20000 then customer will get extra 2% discount.

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

Mathematical Equation Table and Chart

Graphical View

Pass records of Board Exam

Exam Charts

	Participant	Passed	Percentage of Pass
2003	600000	405800	67.63
2004	800000	726540	90.82
2005	750000	457000	60.93
2006	900000	428060	47.56

 

 

 

Need to know as a manager

a)     What is Management?

            Answer:

“Management is what a manager does”

Or

“Management is get the things done by others”

b)    What does a manager?  OR Function of Management

Answer:

1.     Planning: Planning is a trap to capture the future

(What is to be done? By whom is to be done? When is to be done? How is to  be done?)

2.     Organising : Organising/Organisation is a system of Co-operative activities of two or more persons

3.     Directing : The executive function of direction embraces those activities which are related to guiding & supervising sub-ordinates

4.      Staffing: (New Selection of staff, Training, Promotion, Transfer, demotion)

5.     Co-ordinating: (It is the orderly arrangement of group effort to provide unit of action in the pursuit of a common purpose)

6.      Motivation: Performance = Ability X Motivation

7.      Controlling: (Verification of performance)

Note: Controlling looks back, planning looks forward.

Slide Masters and insert picture

What is a slide masters?

Slide masters contain the underlying content and formatting information used by a slide within a presentation. You can easily edit your slide masters. If you have a company logo, you could edit the slide master within your presentation so that the logo is embedded within the slides and each time you create a new slide, that slide will automatically display your company logo.

Inserting a picture into a master slide:

Open a presentation called Slide master- Clipart:

Click on the View tab and from within the Presentation Views section, Click on the Slide Master icon.

You will now see the Slide master as illustrated below

We can now insert an item from the Clipart gallery. 

 To do this click on insert tab and from within the Illustrations section, click on the Clip Art icon. This will display the Clip Art Pane down the right side of the Screen.