HPP CALCULATOR

DATE 1 Mei 2024 COST DISTRIBUTION

SERVICE Cuci Coin 0% 0%

HARGA JUAL Rp10,000

TOTAL COST Rp1,890,002
100%
COST MARGIN % 18900.02
NET PROFIT -Rp1,880,002

FIXED COST
Product Name Qty. Cost Total Cost
(per month)
Gaji 1 Rp1,500,000 Rp1,500,000
Air 1 Rp30,000 Rp30,000
Ops 1 Rp360,000 Rp360,000
TOTAL Rp1,890,000

BAHAN UTAMA
Qty Cost
Product Name Total Cost
Gm Kg/Lt
Listrik 1 Rp10 Rp0
Air 0.5 Rp4 Rp0 FIXED COST:
1.5 Rp4 Rp0 - Air Rp 30.000
- Internet Rp 150.000
- Kebersihan Rp 60.000
- Keamanan Rp 150.000
VARIABEL COST:
- Gas
- Listrik
- Deterjen
- Softener
- Parfum
TOTAL Rp0 - Isolasi
- Nota
UTILITY AND PREP. COST - Plastik
Name Total Cost - Gaji
Preparation Rp2
Gas Rp0CUCI COIN:
- mesin cuci
Electricity Rp0- listrik
Water Rp0- air
TOTAL Rp2 - deterjen
- softener

Prepared By Approved By

Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved

 Occupation Occupation

Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved

 0% 0%

100%

FIXED COST:
- Air Rp 30.000
- Internet Rp 150.000
- Kebersihan Rp 60.000
- Keamanan Rp 150.000
VARIABEL COST:
- Gas
- Listrik
- Deterjen
- Softener
- Parfum
- Isolasi
- Nota
- Plastik
- Gaji
CUCI COIN:
- mesin cuci
- listrik
- air
- deterjen
- softener

Inventory Templates by Spreadsheet123 © 2013 Spreadsheet123 LTD. All rights reserved

Help
Primary Products

1. In the cell "Name" enter the name of the primary product of the dish (Steak, Cod Fish, Pie etc.)
2. In the cell "Quantity" enter the number of units for a single dish (one piece of Steak or two slices of fish)
3. In the cell "Price" enter the price of your primary product per single unit of measure (1 steak - $2.00)
4. The cell "Total Price" calculates cost of a single unit multiplied by number of units in one portion.

Secondary Products

1. In the cell "Name" enter the name of the secondary product for your recipe (pasta, chips, new potatoes etc.)
2. In the cell "Quantity" enter the quantity of the secondary product needed for preparation in Grams (100 Gm, 200 Gm)
3. In the cell "Price" enter the price of secondary product per 1 Kilo or Liter ($10.00 per Kg or Lt)
4. The cell "Total Price" calculates cost of secondary product by multiplying cost of product per amount of weight,
used in your recipe.

Total Cost

Cell "Total Cost" calculates total of Primary and Secondary Products

Selling Price

In the cell "Selling Price" put the price of the dish as per your menu or the price that this dish will
sell for.

Food Margin

Cell "Food Margin" calculates proportion between cost of the dish and generated revenue.
(30% of the costs involved in preparation of the dish should generate 70% of profit)

Generated Revenue

Cell "Net Profit" calculates potential Net Profit, which your recipe can generate.
 Pie etc.)
two slices of fish)
steak - $2.00)
ne portion.

ps, new potatoes etc.)

on in Grams (100 Gm, 200 Gm)
g or Lt)
ct per amount of weight,

dish will

e.