KPI Excel
KPI MONITORING SHEET
–– BUDGET ––
₱0.00
₱50,000.00
₱200,000.00
₱250,000.00
₱300,000.00
₱0.00
₱200,000.00
₱50,000.00
₱40,000.00
SEEDLINGS
₱80,000.00
₱85,000.00
SEEDS
₱80,000.00
₱85,000.00
SEEDLING TRAY
₱30,000.00
₱32,000.00
₱50,000.00
₱18,000.00
₱20,000.00
₱15,000.00
ORNAMENTALS
₱30,000.00
₱25,000.00
ORNAMENTALS
₱50,000.00
₱56,000.00
ORCHARD
₱30,000.00
₱21,000.00
ORCHARD
₱50,000.00
₱48,000.00
POTS
₱30,000.00
₱33,500.00
GARDEN TOOLS
₱80,000.00
₱77,000.00
POTS
₱20,000.00
₱12,000.00
₱50,000.00
₱40,000.00
GARDEN TOOLS
GOAL
₱400,000.00
ACTUAL
GOAL
–– BUDGET TOTAL ––
ACTUAL
₱1,750,000.00
₱2,000,000.00
₱350,000.00
VERMICAST
₱88,000.00
₱1,500,000.00
₱150,000.00
₱0.00
₱1,250,000.00
₱13,000.00
₱1,000,000.00
₱25,000.00
₱750,000.00
₱75,000.00
₱500,000.00
VERMICAST
₱250,000.00
₱800,000.00
₱1,000,000.00
ACTUAL
₱1,000,000.00 ₱2,000,000.00 ₱3,000,000.00 ₱4,000,000.00 ₱5,000,000.00 ₱6,000,000.00 ₱7,000,000.00 ₱8,000,000.00 ₱9,000,000.00 ₱10,000,000.00
₱550,000.00
₱153,000.00
₱569,500.00
₱246,000.00
GOAL
ACTUAL
–– PROFIT MARGINS ––
100%
90%
80%
70%
60%
50%
40%
30%
20%
VERMICAST
SEEDLINGS
SEEDS
SEEDLING TRAY
ORNAMENTALS
GROSS
PRODUCTS
BUDGET
₱1,200,000.00
–– REVENUE TOTAL ––
₱100,000.00
GOAL
₱0.00
₱600,000.00
₱150,000.00
₱153,000.00
VERMICAST
₱75,000.00
SEEDLINGS
SEEDLING TRAY
–– REVENUE ––
₱150,000.00
₱100,000.00
VERMICAST
SEEDS
₱100,000.00
NET EXPENSES
NET
PROFIT
MARGINS
REVENUE
NO.
ITEM DESCRIPTION
GOAL
ACTUAL
REMAINDER
ADDITIONAL
TOTAL
GOAL
ACTUAL
REMAINDER
GROSS
NET
-
VERMICAST
SEEDLINGS
SEEDS
SEEDLING TRAY
ORNAMENTALS
ORCHARD
POTS
GARDEN TOOLS
₱100,000.00
₱50,000.00
₱50,000.00
₱20,000.00
₱30,000.00
₱30,000.00
₱20,000.00
₱50,000.00
₱350,000.00
₱75,000.00
₱40,000.00
₱18,000.00
₱15,000.00
₱25,000.00
₱21,000.00
₱12,000.00
₱40,000.00
₱246,000.00
₱25,000.00
₱10,000.00
₱32,000.00
₱5,000.00
₱5,000.00
₱9,000.00
₱8,000.00
₱10,000.00
₱104,000.00
₱13,000.00
₱2,358.00
₱3,600.00
₱1,935.00
₱2,245.00
₱1,500.00
₱3,265.00
₱4,586.00
₱32,489.00
₱88,000.00
₱42,358.00
₱21,600.00
₱16,935.00
₱27,245.00
₱22,500.00
₱15,265.00
₱44,586.00
₱278,489.00
₱150,000.00
₱80,000.00
₱80,000.00
₱30,000.00
₱50,000.00
₱50,000.00
₱30,000.00
₱80,000.00
₱550,000.00
₱153,000.00
₱85,000.00
₱85,000.00
₱32,000.00
₱56,000.00
₱48,000.00
₱33,500.00
₱77,000.00
₱569,500.00
₱3,000.00
₱5,000.00
₱5,000.00
₱2,000.00
₱6,000.00
(₱2,000.00)
₱3,500.00
(₱3,000.00)
₱19,500.00
51%
53%
79%
53%
55%
56%
64%
48%
46%
42%
50%
75%
47%
51%
53%
54%
42%
42%
ORCHARD
POTS
GARDEN TOOLS