Scribd
Upload
59 views9 pages

Purchase Analysis

The document details a purchase order made on November 2, 2024, listing various alcoholic and non-alcoholic beverages along with their quantities, costs, and expected profits. A total of 430,900 Naira was spent on the purchase, with a projected profit of 238,100 Naira. Specific items such as 33 Lager Beer, Budweiser, and Heineken were included in the order, with varying quantities and costs.

Uploaded by

adabestieq
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
59 views9 pages

Purchase Analysis

The document details a purchase order made on November 2, 2024, listing various alcoholic and non-alcoholic beverages along with their quantities, costs, and expected profits. A total of 430,900 Naira was spent on the purchase, with a projected profit of 238,100 Naira. Specific items such as 33 Lager Beer, Budweiser, and Heineken were included in the order, with varying quantities and costs.

Uploaded by

adabestieq
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Purchase Date

Date Saturday, November 2, 2024

TOTAL
PURCHASE TOTAL
BOTTLES
CARTONS COST PRICE PURCHASE
S/N ITEM PER
PURCHASED PER COST PRICE
CARTON
CARTON(N) (N)
/CRATE

1 1960 BITTERS (SMALL) 0 0


2 33 LAGER BEER 2.0 7,500 15,000 12
3 AMBER 0 0
4 AMSTEL MALT 0 0 24
5 ANDRE BRUT 0 0 12
6 ANDRE ROSE 0 0 12
7 B&G 0 0
8 BAILEYS (BIG) 0 0 12
9 BAILEYS DELIGHT 0 0 12
10 BEST CREAM (BIG) 0 0 12
11 BEST CREAM (SMALL) 0 0 12
12 BETA MALT 0 0 24
13 BIG STOUT 0 0 12
14 BLACK LABEL (70cl) 0 0 12
15 BLACK LABEL (SMALL) 0 0
16 BUDWEISER 1.0 8,200 8,200 12
17 CAMPARI (BIG) 0 0
18 CAMPARI (SMALL) 0 0
19 CARLO ROSSI 0 0
20 CARLO ROSSI (RED) 0 0
21 CARLO ROSSI (ROSE) 0 0
22 CARLO ROSSI (SWEET RED) 0 0
23 CARLO ROSSI (WHITE) 0 0
24 CASTLE LITE (BIG) 1.0 7,500 7,500 12
25 CHAMDOR WINE (RED) 0 0
26 CHAMDOR WINE (WHITE) 0 0
27 CHI EXOTIC JUICE 1.0 15,000 15,000 10
28 CRANEBERRY JUICE 0 0
29 DESPERADOS 2.0 14,200 28,400 20
30 DON SIMON 0 0
31 DON SIMON GRAPE 0 0
32 DORADO 0 0
33 DROSTDY HOF (BIG) 0 0
34 DROSTDY HOF (SMALL) 0 0
35 DUBIC MALT 2.0 12,000 24,000 24
36 EAGLE LAGER (BIG) 0 0 12
37 EAGLE STOUT (BIG) 0 0 12
38 FALKENBURG RED WINE 0 0
39 FAYROUZ 2.0 9,500 19,000 24
40 FEARLESS ENERGY DRINK 0 0
41 FOUR COUSINS 0 0
42 GLENFFIDDICH 12yrs 0 0
43 GLENFFIDDICH 15yrs 0 0
44 GLENFFIDDICH 18yrs 0 0
45 GORDON DRY GIN (BIG) 0 0
46 GORDON DRY GIN (SMALL) 0 0
47 GRAND MALT 0 0 24
48 GULDER 0 0 12
49 HEINEKEN (BIG) 3.0 10,200 30,600 12
50 HENNESSY (SMALL) 0 0
51 HENNESSY VS 0 0
52 HENNESSY VSOP 0 0
53 HERO BEER 8.0 6,900 55,200 12
54 HOLLANDIA YOGHURT 1.0 15,500 15,500 10
55 JACK DANIEL 0 0
56 JAMESON BLACK 0 0
57 JAMESON GREEN (BIG) 0 0
58 JAMESON GREEN (SMALL) 0 0
59 LEGEND (BIG) 2.0 9,500 19,000 12
60 LIFE BEER 4.0 7,500 30,000 12
61 MALTINA 0 0 24
62 MATEUS ROSE 0 0
63 MCDOWELLS (SMALL) 0 0
64 MEDIUM STOUT 2.0 14,200 28,400 18
65 MINERAL (PLASTIC) 0 0 12
66 ODOGWU BITTERS 0 0
67 ORIGIN BEER 0 0 12
68 ORIGIN BITTERS (SMALL) 0 0
69 PREDATOR 0 0
70 PURE HEAVEN (BOTTLE) 0 0
71 RED BULL 0 0
72 RED LABEL (70cl) 0 0
73 RED LABEL (SMALL) 0 0
74 REMY MARTINS 0 0
75 ROYAL CHALLENGE (SMALL) 0 0
76 SMIRNOFF ICE (BIG) 3.0 10,500 31,500 12
77 SMIRNOFF ICE (SMALL) 2.0 11,500 23,000 24
78 SMIRNOFF ICE DOUBLE BLACK 0 0
79 SMIRNOFF XI (BIG) 0 0
80 SMIRNOFF XI (SMALL) 0 0
81 SNAPP 0 0 24
82 SOUR SOP 0 0
83 STAR 0 0 12
84 STAR RADLER 2.0 10,700 21,400 20
85 TIGER 2.0 12,200 24,400 20
86 TOMA RED GRAPE 0 0
87 TOMA TOMA 0 0
88 TROPHY BEER 1.0 6,900 6,900 12
89 TROPHY STOUT 2.0 8,200 16,400 12
90 VINOGANO BITTERS 0 0
91 VITA MILK 0 0
92 WATER (SMALL) 5.0 0 0 12
93 FLYING FISH 1.0 11,500 11,500 20
430,900
TOTAL
UNIT TOTAL
BAR SALES PROFIT PROFIT
TOTAL PURCHASE SALES PER TOTAL
SELLING PER PER PER
BOTTLES COST PRICE TOTAL ESTIMATED
PRICE PER CARTON BOTTLE CARTON
PURCHASED PER BOTTLE PURCHASED PROFIT (N)
BOTTLE (N) / CRATE (N) (N)
(N) (N)
(N)

0 0 0
24 625 900 10,800 21,600 275 3,300 6,600
0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0
12 683 1,000 12,000 12,000 317 3,800 3,800
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
12 625 900 10,800 10,800 275 3,300 3,300
0 0 0
0 0 0
10 1,500 2,000 20,000 20,000 500 5,000 5,000
0 0 0
40 710 1,200 24,000 48,000 490 9,800 19,600
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
48 500 700 16,800 33,600 200 4,800 9,600
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0
48 396 700 16,800 33,600 304 7,300 14,600
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 0 0 0 0
0 0 1,000 12,000 0 1,000 12,000 0
36 850 1,200 14,400 43,200 350 4,200 12,600
0 0 0
0 0 0
0 0 0
96 575 900 10,800 86,400 325 3,900 31,200
10 1,550 2,500 25,000 25,000 950 9,500 9,500
0 0 0
0 0 0
0 0 0
0 0 0
24 792 1,200 14,400 28,800 408 4,900 9,800
48 625 900 10,800 43,200 275 3,300 13,200
0 0 700 16,800 0 700 16,800 0
0 0 0
0 0 0
36 789 1,200 21,600 43,200 411 7,400 14,800
0 0 0 0 0 0 0
0 0 0
0 0 1,200 14,400 0 1,200 14,400 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
36 875 1,200 14,400 43,200 325 3,900 11,700
48 479 900 21,600 43,200 421 10,100 20,200
0 0 0
0 0 0
0 0 0
0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0
40 535 800 16,000 32,000 265 5,300 10,600
40 610 900 18,000 36,000 290 5,800 11,600
0 0 0
0 0 0
12 575 800 9,600 9,600 225 2,700 2,700
24 683 900 10,800 21,600 217 2,600 5,200
0 0 0
0 0 0
60 0 300 3,600 18,000 300 3,600 18,000
20 575 800 16,000 16,000 225 4,500 4,500
669,000 238,100
238,100
NUMBER NUMBER TOTAL
OF OF PROFIT
BOTTLES CARTONS EXPECTED
AVAILABLE AVAILABLE (N)

0
0.0 6,600
0
0.0 0
0.0 0
0.0 0
0
0.0 0
0.0 0
0.0 0
0.0 0
0.0 0
0.0 0
0.0 0
0
0.0 3,800
0
0
0
0
0
0
0
0.0 3,300
0
0
0.0 5,000
0
0.0 19,600
0
0
0
0
0
0.0 9,600
0.0 0
0.0 0
0
0.0 14,600
0
0
0
0
0
0
0
0.0 0
0.0 0
0.0 12,600
0
0
0
0.0 31,200
0.0 9,500
0
0
0
0
0.0 9,800
0.0 13,200
0.0 0
0
0
0.0 14,800
0.0 0
0
0.0 0
0
0
0
0
0
0
0
0
0.0 11,700
0.0 20,200
0
0
0
0.0 0
0
0.0 0
0.0 10,600
0.0 11,600
0
0
0.0 2,700
0.0 5,200
0
0
0.0 18,000
0.0 4,500
238,100

You might also like