Last answered:

01 Oct 2024

Posted on:

30 Sept 2024

0

Production Volume for a Restaurant

Hi,
I'm trying to make a budget for a restaurant. Could you please guide me on how to handle the target warehouse level, beginning inventory and ending inventory? I believe it's different because the inventory isn't finished goods, but rather raw materials, as opposed to the case study of Henry's hats. The restaurant hasn't started business yet, so I'm budgetting 3 years based on best guesses and assumptions. 
Thanks
3 answers ( 0 marked as helpful)
Instructor
Posted on:

01 Oct 2024

0
Hi Jacobo,It is indded a different case because you're dealing with raw materials such as food ingredients rather than finished goods.
Try the following please:
Target Warehouse Level: Estimate based on the average consumption of raw materials, adjusted for perishability and delivery schedules.
Beginning Inventory: For the first period, it will be zero. For subsequent periods, it equals the previous period's ending inventory.
Ending Inventory: Plan to maintain a sufficient amount for the next period’s needs, balancing perishability and storage capacity.
Each estimate will depend on your projected usage and ordering frequency.
Best,
Ned
Posted on:

01 Oct 2024

0
Thank you for your answer. I would like to understand a little bit more. Consider the following scenario:
Even though it's in Spanish, it is the same "Volume Production" sheet we used in the course examples. In this case, I treat the sales volume at the very top as the amount of families/groups of people I will serve in a given quarter. This means every "sale" is a full meal for 2 or more people, not just a single serving. How would you translate the meaning of my "ending inventory" and "production volume" in this case? I don't know if the following picture helps, but this is my "Direct Materials" sheet, which depends on the "Production Volume" one:
Here what I'm doing is stating how many pounds/units of each kind of ingredient is needer, on average, for a full meal (sale). Then I include the cost per unit of each and proceed to calculate the cost of the direct materials. Do you know a good way of estimating the target warehouse level? Is there a benchmark I can use for reference in the restaurant industry?
Thanks in advance
Posted on:

01 Oct 2024

0
Also, would seasonality affect the decision of keeping more or less things in inventory? Q3 is high season while Q2 is low season.

Submit an answer