Excel file that calculate product profit/loss
Budget: $10 – $30 USD
I am looking for someone to create an Excel file that can calculate the profit/loss for my products.
Requirements:
- The Excel file should include sales, expenses, and inventory data.
- I have current sales data that needs to be included in the file.
- The file should be able to calculate the profit/loss for each product.
Ideal Skills and Experience:
- Advanced Excel skills
- Experience with creating financial models
- Knowledge of inventory management
- Attention to detail and accuracy in calculations
MY REQUIREMENTS HERE
I need a excel that I can use for everyday of the month to record
1. How much % on the dollar I paid for the unit
2. How much % it sold for
3. I need 10 or so fields
4. I need it to auto calculate the profit
5. If any loss occurs I need to be able to change the % of how much it was purchased for so its automatically deducted from the daily profit
Requirements:
- The Excel file should include sales, expenses, and inventory data.
- I have current sales data that needs to be included in the file.
- The file should be able to calculate the profit/loss for each product.
Ideal Skills and Experience:
- Advanced Excel skills
- Experience with creating financial models
- Knowledge of inventory management
- Attention to detail and accuracy in calculations
MY REQUIREMENTS HERE
I need a excel that I can use for everyday of the month to record
1. How much % on the dollar I paid for the unit
2. How much % it sold for
3. I need 10 or so fields
4. I need it to auto calculate the profit
5. If any loss occurs I need to be able to change the % of how much it was purchased for so its automatically deducted from the daily profit