Question

KPI QUESTION
1 SOLVE THE AVRAGE BILL VALUE
- STORE SALE = 430000
- ABV = *?*
- NO. OF BILL = 502

2 SOLVE THE STORE SALE
- STORE SALE = *?*
- ABV= 2630
- NO. OF BILL = 612

3 SOLVE THE CONVERSION
- CUSTOMER ENTRY = 3200
- CONVERSION = *?*
- NO. OF BILL = 813

4 SOLVE THE NUMBERS OF BILL
- CUSTOMER ENTRY = 1520
- CONVERSION = 30%
- NO. OF BILL = *?*

5 SOLVE THE CUSTOMER ENTRY
- CUSTOMER ENTRY = *?*
- CONVERSION = 45%
- NO. OF BILL = 650

6 SOLVE THE BASKET SIZE
- TOTAL QTY = 5130
- BASKET SIZE = *?*
- NO. OF BILL = 680

7 SOLVE THE TOTAL QTY
- TOTAL QTY = *?*
- BASKET SIZE = 6
- NO. OF BILL = 712

8 SOLVE THE NO. OF BILLS
- TOTAL QTY = 819
- BASKET SIZE = 6
- NO. OF BILL = *?*

9 SOLVE THE ASP
- TOTAL QTY = 613
- TOTAL SALE = 1036500
- ASP. = *?*

10 SOLVE THE TOTAL SALE
- TOTAL QTY = 520
- TOTAL SALE = *?*
- ASP. = 1693​

Answer 1

Given :  Two Datas out of three Store Sale , Acerage Bill Value & number of bills

To find : Third missing Value

Solution:

Formula Used :

Store Sale = Average Bill Value * Number of Bills

Conversion rate % = ( Bill / customer) * 100

1 SOLVE THE AVRAGE BILL VALUE

- STORE SALE = 430000

- ABV = *?*    = 430000/502  = 856.57

- NO. OF BILL = 502

2 SOLVE THE STORE SALE

- STORE SALE = *?*   = 2630 * 612 = 16,09,560‬

- ABV= 2630

- NO. OF BILL = 612

3 SOLVE THE CONVERSION

- CUSTOMER ENTRY = 3200

- CONVERSION = *?*   = 813/3200 * 100  =    25.4 %

- NO. OF BILL = 813

4 SOLVE THE NUMBERS OF BILL

- CUSTOMER ENTRY = 1520

- CONVERSION = 30%

- NO. OF BILL = *?*    = (30/100) 1520  = 456

5 SOLVE THE CUSTOMER ENTRY

- CUSTOMER ENTRY = *?*     = 650 * 100/45  = 1,444

- CONVERSION = 45%

- NO. OF BILL = 650

6 SOLVE THE BASKET SIZE

- TOTAL QTY = 5130

- BASKET SIZE = *?*   = 5130/680 = 7.54

- NO. OF BILL = 680

7 SOLVE THE TOTAL QTY

- TOTAL QTY = *?*   712 * 6  = 4272

- BASKET SIZE = 6

- NO. OF BILL = 712

8 SOLVE THE NO. OF BILLS

- TOTAL QTY = 819

- BASKET SIZE = 6

- NO. OF BILL = *?*   = 819/6  = 136.5

Learn more:

A shopkeeper offers to sell 33% more quantity of a product for a ...

https://brainly.in/question/11366781

a shopkeeper bought 80 apples of rs.50 each he sold some apples ...

https://brainly.in/question/11611105

Answer 2

solve tha bill value

total number of bill = 21

total sale day is = 29400

average bill value =?