Python script: calculate the maximum volume of possible sales (EXCEL parsing)
20 USD When the request comes to create a list of the goods that are in the warehouse and to issue the number of the maximum amount we can sell, it works the following way:
We go to the APO and look at the volumes.Then we can simulate sales:
We see that approximately 6000 units we can sell and our horizon is just improving.I have a permissible base in Excel:
There are the same formulas for calculation.I would like to have the simulation work done by Piton.It is necessary to exhaust the entire archive and issue the result of permission for each week, as much as we could send on a given week of goods.Simulating should be so that every week is a new calculation and on this week we have to send the maximum.We then "release" the old week and move to the new and re-calculate the amount.Output will be as follows:
Goods // week 39 // week 40 // week 41 // week 42 // week 43 ....
1 // 200 ed // 500 ed // 700 ed // 1000 ed // 300 ed ....
2 // 1200 ed // 200 ed // 450 ed // 498 ed // 300 ed ....
3 //
4 //
5 //
-
3 days20 USD
157 1 0 3 days20 USD
Good day .
Ready for your project but interested in details on the data and volume of data
-
добрый день а откуда берется сколько какого товара продано?
-
Current freelance projects in the category AI & Machine Learning
AI advertising automation - FACEBOOK ADS
150 USD
Hello everyone! We are looking for specialists who have effectively automated the management / launch and analytics of Facebook advertising through AI Claude / GPT / GEMINI. We need to quickly set up automation / launch / exports / analytics. Please share your… AI & Machine Learning, Enterprise Resource Planning (ERP) ∙ 22 hours 18 minutes back ∙ 18 proposals |
Create an offline II that analyzes engineering informationCreate an offline AI that analyzes engineering documentation in text format, PDF files, and spreadsheet formats. The assistant should be able to extract key requirements, identify errors, compare document versions, and assist the engineer in project work. AI & Machine Learning ∙ 2 days 6 hours back ∙ 13 proposals |
Generation and segmentation of the database of drivers and transportation companies in the USA
173 USD
Project Description We are an American company in the HR / transportation recruitment sector. We need a specialist who can use artificial intelligence and available data tools to collect, enrich, and segment a database for our team's further work. What Needs to Be Done A system… AI & Machine Learning ∙ 4 days 1 hour back ∙ 18 proposals |
Technical consultant for hardware optimization and memory stability audit
1200 USD
Hello everyone! I am looking for a hardware specialist or systems engineer who can help me understand the unstable performance of my local server. I built it for work tasks, but it seems my amateur knowledge is not enough to get the most out of it. I would rather pay for an hour… AI & Machine Learning ∙ 4 days 10 hours back ∙ 9 proposals |
Marketing automation through AII'm looking for a person (not a bot) who understands AI agents and knows how to build them. By AI agent, I mean: processing input data, making a request to a 1x LLM or similar AI model, potentially requesting MCP or similar, potentially requesting a RAG system, processing output… AI & Machine Learning ∙ 4 days 11 hours back ∙ 29 proposals |
Estonia