Scribd
Upload
43 views2 pages

Description Act 19 % Bud 19 % Act 18: MTD Dec

This document summarizes sales, costs, expenses, and profits for Act 19 versus the budget and previous year. It shows that while sales were down year-over-year, gross profit on merchandise increased. Total gross profit percentage was slightly lower than budget but higher than last year. Expenses were below budget and significantly lower than last year, leading to higher EBITDA that was above budget and the previous year.

Uploaded by

Bagas Prahara
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
43 views2 pages

Description Act 19 % Bud 19 % Act 18: MTD Dec

This document summarizes sales, costs, expenses, and profits for Act 19 versus the budget and previous year. It shows that while sales were down year-over-year, gross profit on merchandise increased. Total gross profit percentage was slightly lower than budget but higher than last year. Expenses were below budget and significantly lower than last year, leading to higher EBITDA that was above budget and the previous year.

Uploaded by

Bagas Prahara
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
You are on page 1/ 2

MTD DEC

Description
Act 19 % Bud 19 % Act 18
Sales 9,407,636 100.0% 10,601,455 100.0% 9,768,708
Cost of Good Sold 7,662,089 81.4% 8,401,152 89.3% 7,864,076
Total Shrinkage (-) -156,305 -1.7% -131,584 -1.2% -175,645
Shrinkage CutOff 41,271 0.4% 131,584 1.2% 78,377
Shrinkage Allowance 14,682 0.2% 0 0.0% 28,181
Damage -100,353 -1.1% -100,353 -0.9% -69,087
Gross Profit Merchandise 1,946,253 20.7% 2,300,655 11.6% 2,042,806
Rebate, Rafaksi, etc - Income 622,700 6.6% 1,125,882 10.6% 734,218
Transportation Cost -177,277 -1.9% -129,302 -1.2% -121,267
Gondola Income 10,085 0.1% 50,911 0.5% 27,860
Marketing Income 266,835 2.8% 857,095 8.1% 307,320
Listing Fee 18,843 0.2% 54,588 0.5% 29,685
Total Gross Profit 2,687,440 28.6% 4,259,829 30.1% 3,020,622
OPEX
Salary & Wages 987,569 10.5% 948,205 8.9% 916,612
Electricity 141,854 1.5% 130,870 1.2% 133,823
Marketing 1,866 0.0% 2,835 0.0% 23,119
Service Purchase 87,711 0.9% 78,901 0.7% 74,811
Supplies 40,261 0.4% 75,547 0.7% 64,084
Others 272,606 2.9% 224,648 2.1% 270,908
Rental 540,341 5.7% 632,422 6.0% 512,879
Service Charge 285,571 3.0% 300,402 2.8% 264,965
Outside Expense / Income -1,527,320 -16.2% 0 0.0% -5,761,000
TOTAL OPEX 830,457 8.8% 2,393,830 22.6% -3,499,800
EBITDA 1,856,983 19.7% 1,865,999 7.5% 6,520,422
Depre & Amortization -463,635 -4.9% -355,114 -3.3% -518,713
EBIT 1,393,348 14.8% 1,510,885 4.2% 6,001,709
% Key Points: vs Bud vs LY
100.0% Sales YELLOW YELLOW
83.6% GP Merch (%) YELLOW YELLOW
-1.8% Total GP (%) YELLOW GREEN
0.8% OPEX RED GREEN
0.3%
-0.7% EBITDA GREEN
17.8%
7.5% Evolution EBITDA
-1.2% Jan 92,074
0.3% Feb 679,872
3.1% Mar 770,727
0.3% Apr 970,938
27.8% Mei 780,284
Jun 211,257
9.4% Jul 110,450
1.4% Aug 202,194
0.2% Sep 660,132
0.8% Oct 249,654
0.7% Nov 119,267
2.8% Dec 1,856,983
5.3% YTD 6,703,832
2.7%
-59.0% *VALUE x100
-35.8%
63.7%
-5.3%
58.3%

You might also like