5 Replies Latest reply on Dec 14, 2018 12:37 AM by Sushil Thakur

# Ideal consumption

Hi All,

Need help to calculate the ideal consumption of an ingredient of a recipe if i have number sold of the product.

• ###### 1. Re: Ideal consumption

Good day Sushil.

Can you provide sample data you would want this calculation performed on? Also.. can you talk a bit about what you see as ideal consumption?

Best regards,

-Dan

• ###### 2. Re: Ideal consumption

Hi Dan,

I  explain with an example :--

to make 1 pizza we need Below mention  Quantity of  ingredients, Like

 Ingredient Unit Quantity Pack size Cheese GMS 50 1000 Oil ML 12.06 1000 Onion GMS 23.58 1000 Tomato GMS 40.52 1000 Flour GMS 105.85 1000 Dough Blend GMS 3.81 180 Italian Seasoning GMS 1.16 1000 Red Crushed Chilly Sachet PCS 1 1 Tomato Ketchup GMS 6.58 1000 Paper Napkin PCS 1 1 Box PCS 1 1 Spicy mix GMS 1 175 Pizza Sauce GMS 17.06 3000

Now if i sell 1000 Pizza  Then as per the recipe  how much ingredients used is called Ideal consumption.

So I have recipe in System and number sold in system.

 FSDOW021 Par-Bake Shell 7" GKML RFDAR003 Cheese  Thin Shread (PHD) RFFNO004 Oil Soya RFFVG027 Onion RFFVG037 Tomato RFGRC106 Flour Ghakimal RFGRC449 FB - Pan Dough Blend RPCON001 Italian Seasoning 10Kg/Cs RPCON002 Italian Seasoning 500Sc/Cs RPCON005 Red Crushed Chilly Sachet RPCON011 Tomato Ketchup 1Kg RPPKG078 Paper Napkin-PHD RPPKG552 Lidless Box 7.25 " RPPKG532 Pan Box 7" RPPKG077 Paper Napkin-EDI RFGRD312 PHI Spicy mix 175 GM RFGRD311 Pizza Sauce 3kg
• ###### 3. Re: Ideal consumption

Good day Sushil.

So is the idea that you would enter the number of pizzas and you would want to know the quantity of each ingredient needed to produce that many? Is there more than one recipe at one time?

Best regards,

-Dan

• ###### 4. Re: Ideal consumption

Good day Sushil.

Is this what you're thinking of? I've used a parameter to be the number of pizzas, and a calculation field with the parameter and the quantity to calculate the total number of ingredients needed for the particular quantity.

Does this help?

Best regards,

-Dan

• ###### 5. Re: Ideal consumption

Hi Dan,

Exactly this is what i am looking for.

i have more then 50 recipe at a time  and almost all ingredient are common.