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.
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:
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.
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.
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.
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 van profit margin percentage calculator is available for download in Excel format by following the link below.
Users use this 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.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.