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

    Ideal consumption

    Sushil Thakur

      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
          Daniel Stanish

          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
            Sushil Thakur

            Hi Dan,

             

            Thanks for your prompt response.

             

            I  explain with an example :--

             

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

             

            IngredientUnitQuantityPack size
            Cheese   GMS501000
            Oil                      ML12.061000
            Onion                         GMS23.581000
            Tomato                        GMS40.521000
            FlourGMS105.851000
            Dough Blend          GMS3.81180
            Italian SeasoningGMS1.161000
            Red Crushed Chilly Sachet     PCS11
            Tomato KetchupGMS6.581000
            Paper NapkinPCS11
            BoxPCS11
            Spicy mix GMS1175
            Pizza SauceGMS17.063000

             

             

            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.

             

             

                                                                              

            FSDOW021Par-Bake Shell 7" GKML            
            RFDAR003Cheese  Thin Shread (PHD)    
            RFFNO004Oil Soya                     
            RFFVG027Onion                        
            RFFVG037Tomato                       
            RFGRC106Flour Ghakimal               
            RFGRC449FB - Pan Dough Blend         
            RPCON001Italian Seasoning 10Kg/Cs    
            RPCON002Italian Seasoning 500Sc/Cs   
            RPCON005Red Crushed Chilly Sachet    
            RPCON011Tomato Ketchup 1Kg           
            RPPKG078Paper Napkin-PHD             
            RPPKG552Lidless Box 7.25 "           
            RPPKG532Pan Box 7"
            RPPKG077Paper Napkin-EDI             
            RFGRD312PHI Spicy mix 175 GM         
            RFGRD311Pizza Sauce 3kg              
            • 3. Re: Ideal consumption
              Daniel Stanish

              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
                Daniel Stanish

                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
                  Sushil Thakur

                  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.

                   

                  Thanks for your help....