Formula help

rshafenberg

New member
Joined
Sep 7, 2019
Messages
1
I have a workbook that I have built in Apple Numbers to track profit and loss. I need help with figuring out the formula to use to determine suggested sale price, suggested shipping charge, and suggested amount to pay for shipping when the cost of the item (to me) is known and I want a profit margin of at least 25%. For example, if I am selling a shirt, and I know that the shirt will cost me $4.33, I want to know the formula for pre-determining how much to sell it for, how much to charge for shipping, and my expected cost for shipping, if I want a 25% profit margin. Thanks
 
As I understand:
You know the cost of an item and cost of shipping. Adding them gives you your total cost.
Adding 25% gives you the total charge (price + shipping). How to split it between price and shipping is up to you. E.g. price = cost + 25%, shipping fee = shipping cost + 25%.
 
Top