Jeffrey G. answered 01/12/21
Spreadsheet Consultant
To be honest, there are a lot of variables that you aren't considering. Generally speaking there are five costs one must account for to look at a pricing and P/L rates:
- Direct materials - this example, candy
- Indirect materials - example - cleaning supplies
- Direct Labor - cost of person to pack and label bags if doing yourself
- Indirect labor - ex. janitor
- Sunk costs - utilities, rent etc.
Generally speaking, 2,4 and 5 are considered overhead costs, which I do not see info for. I do not see labor costs in your question and shipping costs needs to be put separated by when the costs apply, meaning costs for under $30 purchases and those over. getting you a specific answer will be near impossible with the info provided. However, I can provide a guide on how you can take a look at it. Example A is without the shipping cost, add shipping to those that have it
Example A.
Direct materials (Cost per 10oz of candy) * # of bags purchased + (Cost per bag plus logo) * # of bags purchased + indirect costs (all material costs used not directly related to candy and bagging over a weekly period then divided by workdays then work hours for average hourly indirect material rate then charge that rate to # of hour(s) expected to take to make the order of candy) + direct labor rate/time to do task * # of time it takes to complete job + indirect labor (all labor costs used not directly related to candy and bagging over a weekly period then divided by workdays then work hours for average hourly indirect labor rate then charge that rate to # of hour(s) expected to take to make the order of candy) + Sunk charges (all monthly charges you accrue during your business regardless of business flow into an average hourly rate * time it takes to complete order)
shipping would be a direct cost and should added in as such for each instance
Lets look at what we do know:
The purchase will allow you to make 264 bags of candy. $365 cost for candy / 264 bags = $1.38 per bag for candy alone. add in $.61 for a bag and logo and you get $1.99 cost on just the bag. Note: that is only direct material cost and nothing else!
For profit margin, you provided no info on what you are charging the customer so p/l margins are impossible to say.
Emmanuel A.
Hope this helps! Inventory cost = $365 worth of candy 264 bags can be made, if a customer pays $10 per 10oz Cost to make 1 bag will be $(365/264) = $1.38 Direct total cost to make 1 bag 1.38 + 0.61(logo and sticker cost combined) = $1.99 Total revenue expected = $10 x 264bags = $2640 Gross Profit = $2640 - $365 = $2275 Gross Profit Margin = (Revenue - COGS)/Revenue x 100 = (2640 - 365)/2640 x 100 = 86.2%08/08/22