How do I generate a Bill of Materials (BoM) for a menu?

Apicbase makes ordering ingredients very effective by generating your Bill of Materials based on your inventory status. In this article, we learn how to make a BoM for a menu: which will allow you to place orders for all your menus in no time.

In order to use the BoM, it is very important that the menu, recipe and accompanying ingredients information is complete and correct in your library. If not, the orders may contain wrong ingredients, quantities or prices. If you want to learn more about creating recipes or just refresh your memory, read this article. For more information on filling out new ingredients, look here. We also have an article on creating menus that you can read here

  • Start by selecting the "Menu" in the Product module.
    1-Jun-19-2023-11-37-32-4950-AM
  • The menu grid will appear and you can select the menu for which you want to generate a BoM.

2-Jun-19-2023-11-37-56-4684-AM

  • Once the menu is opened, you click the "Bill of Materials"' button in the top grey toolbar. 3-Jun-19-2023-11-39-00-1499-AM
  • A popup will appear, where you need to select the outlet that will be making the menu.
    4-Jun-19-2023-11-40-10-1531-AM
  • You can fill in the menu-wide portioning. Let's say you need 10 portions of every dish. You enter 10 in the menu-wide portioning field.
    5-Jun-19-2023-11-42-05-7181-AM

Apicbase will automatically fill in 10 portions of every dish.

6-Jun-19-2023-12-01-18-0698-PM

You can, however, change the portioning for individual recipes if needed. 

7-Jun-19-2023-12-01-59-0847-PM

Another handy feature in Apicbase is to generate a Bill of Materials of a menu according to your sales events. If sales data is available in your library, you can choose a certain period and import the sales data for that period. Apicbase will generate the Bill of Materials for every item sold during that period (from this specific menu). 

8-Jun-19-2023-12-09-24-0313-PM

Generate a Bill of Materials

After inputting all the correct settings in order to generate the correct BoM, click the "Generate Bill of Materials" button.

9-Jun-19-2023-12-09-12-2400-PM

You will get a list of the needed ingredients:

      • Article: the name of the ingredient.
      • Needed Qt.: the quantity you need to make the necessary portions.
      • Stock Qt.: the available stock quantity.
      • Order Qt.: the quantity you need to order.
      • Packages to Order: This column will give you insight what ingredients you need to order
      • Choose a product: In this column, you can select the product you want to order. Apicbase will automatically select the last ordered ingredient (LO), but you can also order the cheapest product for this order (C) in the dropdown.
      • Total: This column shows the total price of the amount you will order.
        10-Jun-19-2023-12-19-46-4239-PM

    It is possible that you receive the following warning:

    EN-1

    This warning can only have a few reasons:

    For the ingredients that have enough stock, you see "Sufficient Stock" in the Packages to Order Column. 

    11-Jun-19-2023-12-23-14-7651-PM

    If this BoM is correct, you can either export the BoM to an Excel file or generate the order in Apicbase. On the top, you find several other options for exporting or printing the BoM.

    12-Jun-19-2023-12-24-35-6477-PM

    Export BoM

    Click on the "Export BoM" button, if you want to export the BoM as an Excel. The Pop-up message of "Go to Export" 

    13-Jun-19-2023-12-28-12-7656-PM

    You will be redirected to the "Export file" and you can now download the file.

    14-Jun-19-2023-12-29-56-0225-PM

    You can also check and find the Exports section by clicking on the "Settings button" in the upper right corner. 

    15-Jun-19-2023-12-31-13-5092-PM

    Generate Order Documents

    If you push the "Generate Order Documents" button, you will be redirected to the ordering module.

    16-Jun-19-2023-12-35-01-7921-PM

    17-Jun-19-2023-12-34-33-4451-PM

    The orders for this BoM will be shown in your shopping cart. There will be an order form for every supplier you need to order from.

    • Click on the tabs on top to change between orders.
    • You can set a delivery date and delivery time for every order.
    • If you click the "Email Order" button in the lower right corner, you will place the order and receive an affirmation mail per order. This has to be done per supplier.
    • You can also cancel an order by clicking the "Cancel" button.  

    You don't have to place all the orders at this moment. If you leave the screen, your orders will remain in the Procurement tab. You can reach them by clicking on "Create Orders"