Production sheet with ingredients Example

RJLasap Printed 31/05/16 17:36 By Administrator                
                                                                        Page : 1
Production sheet for Tuesday 31 May 2016 - all deliveries
                                        
Code      Description                       Quantity       Cased
--------  ------------------------------  ----------  ----------
BEE001    BEEF AND HORSE SANDWICH                 39                
BEE901    BEEF AND HORSERADISH FLATPACK          463                
BEE101    BEEF AND HORSERADISH ROLL              463                
BEE201    BEEF AND HORSERADISH BAGUETTE           43                
CHI001    CHICKEN SALAD S/WICH                   133                
CHI901    CHICKEN SALAD FLATPACK                  13                
CHI101    CHICKEN SALAD ROLL                       3                
CHI201    CHICKEN SALAD BAGUETTE                  33                
CHI002    CORONATION CHICKEN S/WICH               33                
CHI102    CORONATION CHICKEN ROLL                 33                
CHI202    CORONATION CHICKEN BAGUETTE             13                
CHI003    CHICKEN CAESER S/WICH                    3                
CHI103    CHICKEN CAESER ROLL                      4                
CHI203    CHICKEN CAESER BAGUETTE                 33                
CHI004    CHICKEN AND PESTO SANDWICH              33                
CHI104    CHICKEN AND PESTO ROLL                   3                
CHI204    CHICKEN AND PESTO BAGUETTE               3                
HAM001    HAM AND TOMATO SANDWICH                 74          38    
HAM901    HAM AND TOMATO FLATPACK                  3                
HAM002    HAM SALAD SANDWICH                     141          38    
HAM902    HAM CHEESE AND TOMATO FLATPACK          13                
HAM003    HAM CHEESE AND TOMATO TRIPLE            33                
BLT001    BACON LETTUCE TOMATO SANDWICH          133                
BLT101    BACON LETTUCE TOMATO ROLL               33                
BLT201    BACON LETTUCE TOMATO BAGUETTE          473                
CHE001    CHESSE AND ONION                       537          41    
CHE901    CHEESE AND ONION FLAT PACK               3                
CHE101    CHEESE AND, ONION ROLL                   4                
CHE002    CHEESE AND TOMATO SANDWICH             146           3    
CHE003    CHEESE AND HAM SANDWICH                103                
CHE203    CHEESE AND HAM BAGUETTE                463                
CHE004    CHEESE AND PICKLE SANDWICH               3                
CHE005    CHEESE SALAD SANDWICH                  100                
CHE105    CHEESE SALAD ROLL                      463                
CHE205    CHEESE SALAD BAGUETTE                    3                
CHE006    CHEESE AND BACON S/WICH                107           3    
EGG001    EGG MAYONNAISE S/WICH                  563                
EGG901    EGG MAYONNAISE FLAT PACK               463                
EGG101    EGG MAYO ROLL                            3                
EGG201    EGG MAYO BAGUETTE                       13                
EGG002    EGG SALAD SANDWICH                     103                
PRA001    PRAWN COCKTAIL SANDWICH                133                
PRA101    PRAWN COCKTAIL ROLL                     33                
TUN001    TUNA MAYONNAISE SANDWICH               133                
TUN901    TUNA MAYONNAISE FLATPACK                13                
TUN101    TUNA MAYONNAISE ROLL                   103                
TUN201    TUNA MAYONNAISE BAGUETTE                33                
PIE001    STEAK AND KIDNEY PIE                   453                
PIE002    MEAT AND POTATO PIE                      3                
PIE003    STEAK AND ONION PIE                     13                
PIE004    CHICKEN AND MUSHROOM PIE                 3                
PIE005    CHICKEN TIKKA PIE                        3                
PIE006    CORNISH PASTY                           13                
PIE007    CHEESE AND ONION PASTY                  13                
PIE008    GIANT PORK PIE                          13                
JUI001    JUICY ORANGE JUICE                     463                
JUI009    LARGE ORANGE JUICE                       3                
JUI002    JUICY APPLE JUICE                       33                
JUI003    JUICY BLACKCURRANT JUICE                 3                
JUI004    JUICY STRAWBERRY JUICE                   3                
JUI005    JUICY PINEAPPLE JUICE                    3                
JUI006    CHERRY JUICE                             3                
JUI007    JUICY APPLE & MANGO JUICE                3                
JUI008    JUICY TOMATO JUICE                       3                
                                          ----------
                                   Total        6807
Group Totals
BAGU      BAGUETTE                              1110
JUIC      JUICE                                  517
PIE       PIE                                    514
ROLL      ROLL                                  1145
SAND      SANDWICH                              3521
                                          ----------
                             Grand Total        6807
Premix Requirements for all deliveries on Tuesday 31 May 2016                 
                                                                        Page : 2
                                         Printed 31/05/16 17:36 By Administrator

CODE      DESCRIPTION                     QUANTITY REQUIRED                         USAGE                          
--------  ------------------------------  ----------------------------------------  -------------------        
EGG900    EGG MAYONNAISE MIX                      53 KG           890.000 GRAMMES 
Requires...
CHE002    PARMESAN FLAKES                          0 KG            66.500 GRAMMES       66.500 GRAMMES             
EGG001    EGG                                      3 BUCKET       116.700 EGG         1616.700 EGG                 
MAY001    MAYONNAISE                              24 KG           409.000 GRAMME     20747.650 GRAMME              
PEP001    PEPPER                                  16 100G          16.700 GRAMMES     1616.700 GRAMMES             
PRA900    PRAWN MAYONNAISE MIX                     7 KG           388.889 GRAMMES 
Requires...
MAY001    MAYONNAISE                               4 KG           346.405 GRAMME      3325.000 GRAMME              
PRA001    PRAWNS                                   3 KG           972.521 GRAMMES     3325.000 GRAMMES             
SAL001    SALAD MIX                                2 KG           310.000 GRAMMES 
Requires...
CAE001    CAESER DRESSING                          0 2.5KG        231.000 GRAMMES      231.000 GRAMMES             
LET001    LETTUCE                                  2 KG           310.000 GRAMMES     1155.000 GRAMMES             
ONI001    ONION                                    0 KG           385.000 GRAMMES      346.500 GRAMMES             
TOM001    TOMATO                                   0 KG           614.362 GRAMMES      577.500 GRAMMES             
WED001    LIDDED WEDGE                             0 BOX            2.310 WEDGE          2.310 WEDGE               

Ingredient Requirements for all deliveries on Tuesday 31 May 2016                 
                                                                        Page : 3
                                         Printed 31/05/16 17:36 By Administrator

CODE      DESCRIPTION                     QUANTITY REQUIRED                      USAGE                          
--------  ------------------------------  -------------------------------------  -------------------        
BREAD
BAG001    BAGUETTE                           1107 EACH           0.000 EACH        1107.000 EACH                
BRE001    THIN WHITE SLICED BREAD             373 LOAF           3.333 SLICE       6717.000 SLICE               
BRE002    WHOLEMEAL BREAD                      17 LOAF          18.000 SLICE        358.000 SLICE               
PEP001    PEPPER                                5 100G          63.563 GRAMMES      563.563 GRAMMES             
ROL001    WHITE ROLL                         1145 EACH           0.000 EACH        1145.000 EACH                
WED004    OUTER CASING                          0 BOX           38.000 EACH          38.000 EACH                
DAIRY
CHE001    CHEDDAR CHEESE                       89 KG           610.526 GRAMMES    85130.000 GRAMMES             
CHE002    PARMESAN FLAKES                       0 KG           230.000 GRAMMES      230.000 GRAMMES             
EGG001    EGG                                   0 BUCKET        33.000 EGG           33.000 EGG                 
SPR001    SUNFLOWER SPREAD                     25 KG           940.000 GRAMMES    23346.000 GRAMMES             
FISH
PRA001    PRAWNS                                0 KG           887.097 GRAMMES      825.000 GRAMMES             
TUN001    TUNA IN BRINE                         1 12.5KG      6927.083 GRAMMES    18650.000 GRAMMES             
LABOUR
LAB101    LABOUR                               90 HOUR          55.000 MINUTE      5455.000 MINUTE              
MEAT
BAC001    BACON                                29 KG           527.778 GRAMMES    26575.000 GRAMMES             
BEEF001   BEEF                                 63 KG           537.500 GRAMMES    50830.000 GRAMMES             
CHI001    PLAIN CHICKEN BREAST                  5 2.5KG       2400.000 GRAM       14900.000 GRAM                
HAM001    HAM                                  30 KG           405.000 GRAMMES    30405.000 GRAMMES             
PACKAGING
LAB001    LABEL                                 0 BOX         4840.000 EACH        4840.000 EACH                
WED001    LIDDED WEDGE                          2 BOX          550.000 WEDGE       2550.000 WEDGE               
WED002    ROLL WEDGE                           11 BOX           45.000 EACH        1145.000 EACH                
WED003    BAGUETTE BAG                          0 CASE         637.000 BAG          637.000 BAG                 
SAUCE
CAE001    CAESER DRESSING                       0 2.5KG        430.000 GRAMMES      430.000 GRAMMES             
COR001    CORONATION SAUCE                      0 KG           790.000 GRAMMES      790.000 GRAMMES             
HOR001    HORSERADISH                           8 KG           765.217 GRAMMES     8064.000 GRAMMES             
MAY001    MAYONNAISE                           21 KG            65.882 GRAMME     17906.000 GRAMME              
PES001    PESTO SAUCE                           0 KG           390.000 GRAMMES      390.000 GRAMMES             
PIC001    PICKLE                                0 KG            26.087 GRAMMES       24.000 GRAMMES             
VEGETABLE
LET001    LETTUCE                              31 KG           488.000 GRAMMES    15744.000 GRAMMES             
ONI001    ONION                                12 KG           870.000 GRAMMES    11583.000 GRAMMES             
SWE001    SWEETCORN                             0 4KG TIN     1655.000 GRAM        1655.000 GRAM                
TOM001    TOMATO                               13 KG           965.957 GRAMMES    13128.000 GRAMMES             

                
                              RJLasap  PRODUCT SPECIFICATION    Printed 20/04/16 14:13 By Administrator    Page : 1
CODE      DESCRIPTION                       UNIT    QUANTITY KG WEIGHT   TOLER            IS MIX
--------  -------------------------------  ------  --------- ---------   -----            ------
PRA001    PRAWN COCKTAIL SANDWICH         Active     
--------  ------------------------------  -----------
BRE001    THICK OATMEAL SLICED BREAD      SLICE        2.000     0.076 +/-  2g                
LAB001    LABEL                           EACH         1.000     0.001 +/-  0g                
LAB101    LABOUR                          MINUTE       1.000     0.000 +/-  0g                
LET001    ICEBERG LETTUCE 4.5 BOX 12      GRAM        10.000     0.010 +/-  0g                
PRA001    PRAWNS 2.5KG                    GRAM        40.000     0.040 +/-  0g                
PRA900    PRAWN COCKTAIL MAYONNAISE MIX   GRAM        30.000     0.030 +/-  0g               *
SPR001    SUNFLOWER SPREAD                GRAM         4.000     0.004 +/-  0g                
WED001    LIDDED WEDGE                    WEDGE        1.000     0.004 +/-  0g                
                                                             ---------      --   
                                        Ingredients  Weight      0.160 +/-  2g 
                                          Packaging  Weight      0.005 +/-  0g 
                                             Target  Weight      0.165 +/-  2g 
                                            Minimum Weight       0.163 
                                            Maximum Weight       0.167 
Nutritional Info - Calculated   :       Per    100gm       Pack
            E Kj                :            1111.43    1778.28 
            E Kcal              :             265.64     425.02 
            Protein             :              11.07      17.71 
            Carbohydrate        :              23.07      36.91 
                of which sugars :               0.00       0.00 
            Fat                 :              15.41      24.65 
             of which saturates :               0.00       0.00 
            Fibre               :               1.85       2.96 
            Sodium              :               0.71       1.14 
             equivalent as salt :               1.78       2.86 
Allergens : 
--------  ------------------------------
01       CEREALS CONTAINING GLUTEN     
03       EGGS AND PRODUCTS THEREOF     
04       FISH                          
07       MILK  AND PRODUCTS THEREOF