• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding best Outcome

Hello Excel Lovers,

Request to you to help me on the below problem.

I want to develop a solution for a Vegetable and Fruits vendor. The price of the Vegetables & Fruits change and its aging is calculated as Day -5 when it was cut and Day-3 when it gets shop for sorting and placing at store.

I need to find a the optimum sales figure by changing the quantity.

Attached here with a sample data.
 

Attachments

  • Problem.xlsx
    9.8 KB · Views: 6
Hi Avk,

Thanks for the effort, Sorry for not being clear about my requirement.

I need the uniform sales by changing the quantity.

I have update my excel sheet again. Request you to check it once.
 

Attachments

  • Problem.xlsx
    10.1 KB · Views: 8
Hi Avk,

Thanks for the effort, Sorry for not being clear about my requirement.

I need the uniform sales by changing the quantity.

I have update my excel sheet again. Request you to check it once.
Been a while. Do you still need an answer?
 
Back
Top