|
|
Period 3 |
Budget |
Variance |
Variance % |
YTD |
Budget |
Variance |
Variance % |
|
+ |
Sales |
140,949.44 |
306,575.67 |
-165,626.23 |
-54 |
702,733.50 |
870,124.06 |
-167,390.56 |
-19 |
|
|
+ |
BREMHILL |
30,664.67 |
49,726.81 |
-19,062.14 |
-38 |
115,649.80 |
143,837.91 |
-28,188.11 |
-20 |
|
|
|
|
RED WINE SALES BREM
|
10,768.45 |
21,450.00 |
-10,681.55 |
-50 |
53,835.89 |
66,600.00 |
-12,764.11 |
-19 |
|
|
|
|
|
|
WHITE WINE SALES BREM
|
19,896.22 |
27,926.50 |
-8,030.28 |
-29 |
61,813.91 |
76,306.20 |
-14,492.29 |
-19 |
|
|
|
|
|
|
EQUIPMENT SALES BREM
|
0.00 |
350.31 |
-350.31 |
-100 |
0.00 |
931.71 |
-931.71 |
-100 |
|
|
|
|
|
+ |
HARROGATE |
110,284.77 |
256,848.86 |
-146,564.09 |
-57 |
587,083.70 |
726,286.15 |
-139,202.45 |
-19 |
|
|
|
|
PROJECT INCOME
|
0.00 |
85,000.00 |
-85,000.00 |
-100 |
176,871.93 |
250,000.00 |
-73,128.07 |
-29 |
|
|
|
|
|
|
RED WINE SALES HAR
|
31,188.07 |
51,039.50 |
-19,851.43 |
-39 |
106,443.23 |
141,078.60 |
-34,635.37 |
-25 |
|
|
|
|
|
|
WHITE WINE SALES HAR
|
47,014.80 |
79,922.60 |
-32,907.80 |
-41 |
153,155.06 |
219,046.00 |
-65,890.94 |
-30 |
|
|
|
|
|
|
SPARKLING WINE SALES HAR
|
5,447.49 |
5,287.60 |
159.89 |
3 |
14,187.30 |
9,976.46 |
4,210.84 |
42 |
|
|
|
|
|
|
CHAMPAGNE WINE SALES HAR
|
15,096.05 |
26,371.50 |
-11,275.45 |
-43 |
89,011.33 |
80,529.50 |
8,481.83 |
11 |
|
|
|
|
|
|
CASES WINE SALES HAR
|
15,700.20 |
9,227.66 |
6,472.54 |
70 |
46,917.34 |
25,657.60 |
21,259.74 |
83 |
|
|
|
|
|
|
PROMO WINE SALES HAR
|
-5,000.00 |
0.00 |
-5,000.00 |
0 |
-5,000.00 |
0.00 |
-5,000.00 |
0 |
|
|
|
|
|
|
SERVICES SALES HAR
|
838.16 |
0.00 |
838.16 |
0 |
5,497.51 |
0.00 |
5,497.51 |
0 |
|
|
|
|
|
|
DISCOUNTS GIVEN - HAR
|
0.00 |
0.00 |
0.00 |
0 |
0.00 |
-2.01 |
2.01 |
-100 |
|
|
|
|
|
+ |
Cost of Sales |
127,889.21 |
141,263.51 |
-13,374.30 |
-9 |
356,769.32 |
403,790.92 |
-47,021.60 |
-12 |
|
|
+ |
BREMHILL |
31,355.54 |
31,352.70 |
2.84 |
0 |
88,216.68 |
95,152.10 |
-6,935.42 |
-7 |
|
|
|
|
COST OF GOODS SOLD BREM
|
31,355.54 |
31,352.70 |
2.84 |
0 |
88,216.68 |
95,152.10 |
-6,935.42 |
-7 |
|
|
|
|
|
+ |
HARROGATE |
96,533.67 |
109,910.81 |
-13,377.14 |
-12 |
268,552.64 |
308,638.82 |
-40,086.18 |
-13 |
|
|
|
|
RED WINE PURCHASES HAR
|
24,543.99 |
43,296.90 |
-18,752.91 |
-43 |
67,273.07 |
122,871.90 |
-55,598.83 |
-45 |
|
|
|
|
|
|
WHITE WINE PURCHASES HAR
|
34,716.53 |
41,060.10 |
-6,343.57 |
-15 |
98,195.86 |
114,426.40 |
-16,230.54 |
-14 |
|
|
|
|
|
|
SPARKLING WINE PURCHASES
|
3,681.96 |
3,543.76 |
138.20 |
4 |
9,589.20 |
6,629.62 |
2,959.58 |
45 |
|
|
|
|
|
|
CHAMPAGNE WINE PURCHASES
|
17,599.60 |
17,473.20 |
126.40 |
1 |
67,998.83 |
51,862.70 |
16,136.13 |
31 |
|
|
|
|
|
|
CASES WINE PURCHASES HAR
|
11,322.92 |
5,327.30 |
5,995.62 |
113 |
30,089.69 |
15,419.61 |
14,670.08 |
95 |
|
|
|
|
|
|
EQUIPMENT PURCHASES HAR
|
4,139.70 |
0.00 |
4,139.70 |
0 |
-3,935.05 |
0.00 |
-3,935.05 |
0 |
|
|
|
|
|
|
SERVICES PURCHASES HAR
|
750.00 |
0.00 |
750.00 |
0 |
750.00 |
0.00 |
750.00 |
0 |
|
|
|
|
|
|
COST OF SALES LABOUR - HA
|
0.00 |
0.00 |
0.00 |
0 |
-37.50 |
0.00 |
-37.50 |
0 |
|
|
|
|
|
|
DISCOUNTS TAKEN - HAR
|
-221.03 |
-790.45 |
569.42 |
-72 |
-1,371.46 |
-2,571.42 |
1,199.96 |
-47 |
|
|
|
|
|
|
|
|
|
|
Gross Profit |
13,060.23 |
165,312.16 |
-152,251.93 |
-92 |
345,964.18 |
466,333.14 |
-120,368.96 |
-26 |
|
|
|
|
|
+ |
Other Income |
5,700.00 |
5,581.44 |
118.56 |
2 |
17,100.00 |
16,963.20 |
136.80 |
1 |
|
|
+ |
HARROGATE |
5,700.00 |
5,581.44 |
118.56 |
2 |
17,100.00 |
16,963.20 |
136.80 |
1 |
|
|
|
|
RENT RECEIVED - HAR
|
5,700.00 |
5,581.44 |
118.56 |
2 |
17,100.00 |
16,963.20 |
136.80 |
1 |
|
|
|
|
|
+ |
Overheads |
72,161.32 |
72,621.79 |
-460.47 |
-1 |
213,118.36 |
214,053.75 |
-935.39 |
0 |
|
|
+ |
BREMHILL |
14,566.44 |
15,104.78 |
-538.34 |
-4 |
25,704.61 |
26,249.35 |
-544.74 |
-2 |
|
|
|
|
WAGES & SALARIES - BREM
|
4,134.52 |
4,078.84 |
55.68 |
1 |
12,403.56 |
12,281.96 |
121.60 |
1 |
|
|
|
|
|
|
EMPLOYERS N.I. - BREM
|
471.34 |
470.78 |
0.56 |
0 |
1,414.02 |
1,397.77 |
16.25 |
1 |
|
|
|
|
|
|
EMPLOYERS PENSIONS - BRE
|
62.02 |
58.87 |
3.15 |
5 |
186.06 |
179.12 |
6.94 |
4 |
|
|
|
|
|
|
GENERAL RATES - BREM
|
8,953.49 |
9,480.48 |
-526.99 |
-6 |
8,953.49 |
9,480.48 |
-526.99 |
-6 |
|
|
|
|
|
|
ELECTRICITY - BREM
|
61.49 |
69.52 |
-8.03 |
-12 |
186.87 |
197.43 |
-10.56 |
-5 |
|
|
|
|
|
|
GAS - BREM
|
41.68 |
42.51 |
-0.83 |
-2 |
130.94 |
135.95 |
-5.01 |
-4 |
|
|
|
|
|
|
REPAIRS & RENEWALS - BRE
|
53.00 |
55.70 |
-2.70 |
-5 |
53.00 |
55.70 |
-2.70 |
-5 |
|
|
|
|
|
|
POSTAGE & CARRIAGE - BREM
|
26.56 |
28.96 |
-2.40 |
-8 |
70.73 |
76.35 |
-5.62 |
-7 |
|
|
|
|
|
|
OFFICE STATIONERY - BREM
|
15.22 |
17.07 |
-1.85 |
-11 |
40.53 |
44.62 |
-4.09 |
-9 |
|
|
|
|
|
|
TELEPHONE - BREM
|
433.35 |
466.64 |
-33.29 |
-7 |
1,153.79 |
1,258.16 |
-104.37 |
-8 |
|
|
|
|
|
|
FAX - - BREM
|
7.37 |
7.86 |
-0.49 |
-6 |
19.62 |
21.43 |
-1.81 |
-8 |
|
|
|
|
|
|
OTHER COMMS COST - BREM
|
272.00 |
291.04 |
-19.04 |
-7 |
816.00 |
834.35 |
-18.35 |
-2 |
|
|
|
|
|
|
OFFICE MACHINE MAINT - BR
|
0.00 |
0.00 |
0.00 |
0 |
172.80 |
179.71 |
-6.91 |
-4 |
|
|
|
|
|
|
CLEANING - BREM
|
34.40 |
36.52 |
-2.12 |
-6 |
103.20 |
106.32 |
-3.12 |
-3 |
|
|
|
|
|
+ |
HARROGATE |
57,594.88 |
57,517.01 |
77.87 |
0 |
187,413.75 |
187,804.40 |
-390.65 |
0 |
|
|
|
|
WAGES & SALARIES - HAR
|
21,006.15 |
20,332.30 |
673.85 |
3 |
63,018.45 |
61,429.50 |
1,588.95 |
3 |
|
|
|
|
|
|
DIRECTORS REMUNERATION -
|
19,160.88 |
19,054.70 |
106.18 |
1 |
57,482.64 |
56,966.70 |
515.94 |
1 |
|
|
|
|
|
|
WAGES - CASUAL - HAR
|
0.00 |
153.80 |
-153.80 |
-100 |
0.00 |
414.16 |
-414.16 |
-100 |
|
|
|
|
|
|
EMPLOYERS N.I. - HAR
|
4,579.04 |
4,432.15 |
146.89 |
3 |
13,737.12 |
13,296.45 |
440.67 |
3 |
|
|
|
|
|
|
EMPLOYERS PENSIONS - HAR
|
905.81 |
886.08 |
19.73 |
2 |
2,717.43 |
2,658.25 |
59.18 |
2 |
|
|
|
|
|
|
RECRUITMENT EXPENSES - HA
|
96.19 |
100.16 |
-3.97 |
-4 |
262.82 |
273.42 |
-10.60 |
-4 |
|
|
|
|
|
|
SSP/SMP RECLAIMED - HAR
|
338.69 |
354.35 |
-15.66 |
-4 |
338.69 |
354.35 |
-15.66 |
-4 |
|
|
|
|
|
|
WATER RATES - HAR
|
895.94 |
940.74 |
-44.80 |
-5 |
895.94 |
940.74 |
-44.80 |
-5 |
|
|
|
|
|
|
GENERAL RATES - HAR
|
0.00 |
0.00 |
0.00 |
0 |
20,637.39 |
21,488.70 |
-851.31 |
-4 |
|
|
|
|
|
|
ELECTRICITY - HAR
|
157.99 |
165.90 |
-7.91 |
-5 |
462.10 |
470.13 |
-8.03 |
-2 |
|
|
|
|
|
|
GAS - HAR
|
88.25 |
97.93 |
-9.68 |
-10 |
279.08 |
298.41 |
-19.33 |
-6 |
|
|
|
|
|
|
REPAIRS & RENEWALS - HAR
|
0.00 |
0.00 |
0.00 |
0 |
0.00 |
85.33 |
-85.33 |
-100 |
|
|
|
|
|
|
FURNITURE/FITTING DEPRECI
|
294.40 |
297.15 |
-2.75 |
-1 |
883.20 |
906.00 |
-22.79 |
-3 |
|
|
|
|
|
|
FREEHOLD PROPERTY DEPRECI
|
2,744.83 |
2,909.52 |
-164.69 |
-6 |
8,234.49 |
8,581.31 |
-346.82 |
-4 |
|
|
|
|
|
|
PLANT & MACHINERY DEPRECI
|
1,529.66 |
1,560.26 |
-30.60 |
-2 |
4,588.98 |
4,771.28 |
-182.30 |
-4 |
|
|
|
|
|
|
OFFICE EQUIPMENT DEPRECIA
|
199.21 |
202.86 |
-3.65 |
-2 |
597.63 |
616.47 |
-18.84 |
-3 |
|
|
|
|
|
|
PRINTING - HAR
|
0.00 |
0.00 |
0.00 |
0 |
115.00 |
118.13 |
-3.13 |
-3 |
|
|
|
|
|
|
POSTAGE & CARRIAGE - HAR
|
35.04 |
38.14 |
-3.10 |
-8 |
93.30 |
102.78 |
-9.48 |
-9 |
|
|
|
|
|
|
OFFICE STATIONERY - HAR
|
47.55 |
49.27 |
-1.72 |
-3 |
153.36 |
158.61 |
-5.25 |
-3 |
|
|
|
|
|
|
TELEPHONE - HAR
|
1,270.50 |
1,369.63 |
-99.13 |
-7 |
3,382.71 |
3,763.16 |
-380.45 |
-10 |
|
|
|
|
|
|
FAX - HAR
|
17.41 |
19.31 |
-1.90 |
-10 |
46.36 |
49.64 |
-3.28 |
-7 |
|
|
|
|
|
|
OTHER COMMS COST - HAR
|
903.17 |
995.74 |
-92.57 |
-9 |
2,709.51 |
2,865.58 |
-156.07 |
-5 |
|
|
|
|
|
|
CLEANING - HAR
|
46.96 |
48.84 |
-1.88 |
-4 |
140.88 |
144.97 |
-4.09 |
-3 |
|
|
|
|
|
|
SUBSCRIPTIONS - HAR
|
0.00 |
0.00 |
0.00 |
0 |
148.12 |
149.23 |
-1.11 |
-1 |
|
|
|
|
|
|
ROAD FUND LICENCE - HAR
|
0.00 |
0.00 |
0.00 |
0 |
190.12 |
193.92 |
-3.80 |
-2 |
|
|
|
|
|
|
VEHICLE INSURANCE - HAR
|
1,766.60 |
1,890.25 |
-123.65 |
-7 |
1,766.60 |
1,890.25 |
-123.65 |
-7 |
|
|
|
|
|
|
VEHICLE DEPRECIATION - HA
|
1,510.61 |
1,617.92 |
-107.31 |
-7 |
4,531.83 |
4,816.95 |
-285.12 |
-6 |
|
|
|
|
|
+ |
Tax & Finance Charges |
144.26 |
148.72 |
-4.46 |
-3 |
6,791.03 |
-4,986.39 |
11,777.42 |
-236 |
|
|
+ |
HARROGATE |
144.26 |
148.72 |
-4.46 |
-3 |
6,791.03 |
-4,986.39 |
11,777.42 |
-236 |
|
|
|
|
BANK CHARGES
|
18.82 |
19.00 |
-0.18 |
-1 |
56.46 |
57.01 |
-0.55 |
-1 |
|
|
|
|
|
|
CURRENCY CHARGES
|
109.76 |
111.95 |
-2.19 |
-2 |
329.28 |
331.19 |
-1.91 |
-1 |
|
|
|
|
|
|
GAINS/LOSSES ON EXCHANGE
|
0.00 |
0.00 |
0.00 |
0 |
6,355.37 |
-5,435.52 |
11,790.89 |
-217 |
|
|
|
|
|
|
EXCHANGE ROUNDING DIFFERE
|
15.68 |
17.77 |
-2.09 |
-12 |
49.92 |
60.93 |
-11.01 |
-18 |
|
|
|
|
|
|
|
|
|
|
Net Profit |
-53,545.35 |
98,123.09 |
-151,668.44 |
-155 |
143,154.79 |
274,228.98 |
-131,074.19 |
-48 |
|
|
|
|
|
|
|
|
|
|
|
|
| | |