I can help you with that. Here is a rewritten version of the PeoplePerHour brief for an Excel professional, based on your request:
**Project Title:** Create a Professional Excel Pricing & Margin Calculator
**Project Description:**
I need an Excel spreadsheet to help me calculate pricing and margins for approximately 10 products. I'm not an Excel expert, but I can do the basics. I've started a file, but it needs to be more professional and easier to use.
**Key Requirements:**
* **Clear and Organized Layout:** The spreadsheet should be well-structured and easy to navigate. * **Currency Conversion:** I buy products in US dollars ($) and sell them in British pounds (£). The spreadsheet should be able to handle this conversion. * **Pricing Calculations:** I need to calculate the selling price to different customer types (distributors, wholesale, trade, and retail). * **Margin and Markup Calculations:** I need to easily see the profit margins and markups for each product. For example, if I buy a product for £3.00, I want to be able to quickly calculate the selling price with a 30% margin or a 40% markup. * **Flexibility:** I need to be able to easily adjust the cost price, margin, and markup percentages to see how it affects the selling price. * **Freight Costs:** The spreadsheet should include a way to factor in freight costs.
**Deliverables:**
* A professionally formatted Excel spreadsheet that meets the requirements above. * Clear instructions on how to use the spreadsheet.
**Additional Information:**
I have already started working on a file that I can share with you. This will give you a clearer idea of what I'm looking for.
**Please note:**
I am looking for someone who can create a user-friendly and visually appealing spreadsheet.
**In your proposal, please include:**
* Your experience with creating Excel spreadsheets for pricing and margin calculations. * Examples of similar work you have done. * Your estimated timeframe for completing this project. * Your hourly rate or fixed price for the project.
I look forward to hearing from you!
Ideally i would like first version back today - 19th January 2025
