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. You can 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 can 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 in the left column.
  • The menu grid will appear and you can select the menu for which you want to generate a BoM.

APICBASE Bill of Materials Menu 1

  • Once the menu is opened, you click the "Bill of Materials"' button in the top grey toolbar. 

APICBASE Bill of Materials Menu 2

  • APICBASE Bill of Materials Menu 3A popup will appear, where you need to select the outlet that will be making the menu.
  • 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.

Apicbase will automatically fill in 10 portions of every dish. You can, however, change the portioning for individual recipes if needed. In this case, we will be only making 9 of de "Chiles en Nogada".



Another possibility 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). 

  • Afterward, click the "Generate Bill of Materials" button.

    You will get a list of the needed ingredients:

      • Ingredient: the name of 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.
      • Choose 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.

    For the ingredients that have enough stock, you see that nothing needs to be ordered.

    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.

    APICBASE Bill of Materials Menu 4

    • Click on the "Export BoM" button, if you want to export the BoM as an Excel.

    The file will be exported to the Exports section in Apicbase. You find the Exports section by clicking on the "Settings button" in the upper right corner. 

    Schermafbeelding 2019-08-27 om 15.21.06

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

    APICBASE Bill of Materials Menu 5

    The orders for this BoM will be shown on the right. 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".