Expected duration: 3 - 4 weeks
I have a client who wants me to forecast a business model based on manufacturing. They have ran extensive cost calculations for the manufacturing process on a custom ERP system. We have an example spreadsheet in hand that's blank and ready for data.
Data. I have access to hundreds pages of hundreds of columns PDF sheets, broken down into days, which need monthly averages over a 12 month period of the test run and current business model.
Due to unexpected ERP limitations with reporting, the best way of extracting this 365 day data was only by PDF.
I don't have enough characters here to explain, why, but that's the only format available at this scale.
We need someone with AI handling tools with a huge capacity for handling large file sizes. As this is a one-off project, the client is refusing to pay an annual subscription to online software. A custom ERP system is being built, based on the data we provide. You see the chicken and the egg?
You have the solution for a one time use with an agreed period of aftercare support (10 working days? No idea)
Use AI to extract all the data to populate the blank spreadsheet we have worked on over the festive period.
To be considered for this project, type "I understand you only have PDFs" at the bottom of your bid (before your name).
My clients want me to build a team around me with specialists in their field for marketing. The end result is number crunching the hourly cost of the freelancer, taking into consideration the number of hours per month per freelancer.
The end result is to help forecast marketing investment required, projected over a 3 year business plan.
We think the spreadsheet will display the following and your initial input is required with any suggestions for improvement and refined functionality and vlookup. Or whether it's fit for purpose and we can go ahead with the data population. A paid test run will protect us both, an NDA will be provided to the chosen freelancer. We'd love to find one person to take us through this new year and deliver by the end of January 2025.
- 3 year salary costs
- Current manufacturing volume vs maximum capacity
- Raw material cost, processing, packaging, logistics to give a base price
- Suggest a finance model to calculate how many months of marketing will it take (up to 36) to reach capacity, therefore enabling a franchise model, or expansion on site
- Overall cost breakdown for each product and variation, working loosely on a 80-100% markup to be divided into percentages of marketing costs, company costs and a net profit.
Hourly rate a placeholder. Thank you. |
