Food Truck Profit Margin Percentage Calculator

Each type of product sold by a food truck has a gross profit margin which is the difference between the selling price and the cost of the products. This food truck profit margin percentage calculator provides a quick and easy method to estimate the weighted average gross margin generated by a food truck business.

The gross profit margin percentage generated by the calculator can be used in our Financial Projections Template for inclusion in a food truck business plan.

food truck profit margin percentage calculator
Food Truck Profit Margin Percentage Calculator

 

Using the Food Truck Profit Margin Percentage Calculator

The Excel food truck profit margin calculator, available for download below, calculates the gross profit margin percentage for the food and drink products sold by the business, and then weights these in proportion to the sales mix of each product. The calculator is used by entering details as follows:

  1. Enter Food Product Details

    For each food product enter a description (e.g. sandwiches, crepes) , sales mix %, price, and cost. The sales mix % is the percentage that product is of the total sales of the business, not the percentage of food sales. The price of the product is the unit price at which the product is sold to customers excluding sales tax. The cost of the product is the unit cost of the product to the business.

    The food truck profit margin percentage calculator works out the weighted average unit price, cost and gross profit margin percentage for food products.

  2. Enter Drinks Product Details

    For each drinks product enter a description (e.g. coffee, tea), sales mix %, price, and cost. The sales mix % is the percentage that product is of the total sales of the business, not the percentage of drinks sales. The price of the product is the unit price at which the product is sold to customers excluding sales tax. The cost of the product is the unit cost of the product to the business.

    The profit margin percentage calculator works out the weighted average unit price, cost and gross profit margin percentage for drinks products.

  3. Enter Other Product Details

    The other products section is to allow for non food and drinks items to be included in the calculator. For each product enter a description (e.g. T shirts), sales mix %, price, and cost. The sales mix % is the percentage that product is of the total sales of the business, not the percentage of other sales. The price of the product is the unit price at which the product is sold to customers excluding sales tax. The cost of the product is the unit cost of the product to the business.

    The food truck profit margin percentage calculator works out the weighted average unit price, cost and gross profit margin percentage for other products.

  4. Finally the calculator calculates the weighted average unit price, cost, and the gross margin percentage for all products combined. The gross margin percentage calculated can be used in the financials projections template as an estimate of the gross margin percentage for the food truck business.

Food Truck Profit Margin Percentage Calculator Download

The food truck profit margin percentage calculator is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this food truck profit margin percentage calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a food truck profits margin template that you might use when preparing financial projections in Excel. It is purely illustrative of a catering truck profit margin calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the kitchen truck gross margin percentage template, please let us know and we will try to fix it.
Food Truck Profit Margin Percentage Calculator November 18th, 2016Team

You May Also Like