We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
10 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
I need a formula to help in the distribution of the quantities by months according forecast sales and When the quantities of batch ends jumping to the quantities from the next batch to make up
Posted on 2016-10-30
Dear ,
I hope you are doing great
I have a small problem I hope to find a solution for the purpose of facilitating the work, I have two product A&B and there quantities available for sales in the store , the quantities categorized according batch no .
As well, I have information about what are the expected quantities of sales on monthly basis of each product.
Now I need a formula to help in the distribution of the quantities by months according forecast sales and When the quantities of batch ends jumping to the quantities from the next batch to make up the shortfall.
For more clarification i have enclosed my exercise , Please see the attached
Your cooperation is highly appreciated
Thanks
my-exercise.xlsx
I hope you are doing great
I have a small problem I hope to find a solution for the purpose of facilitating the work, I have two product A&B and there quantities available for sales in the store , the quantities categorized according batch no .
As well, I have information about what are the expected quantities of sales on monthly basis of each product.
Now I need a formula to help in the distribution of the quantities by months according forecast sales and When the quantities of batch ends jumping to the quantities from the next batch to make up the shortfall.
For more clarification i have enclosed my exercise , Please see the attached
Your cooperation is highly appreciated
Thanks
my-exercise.xlsx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
7
3
12 Comments
Active today
I try to come out with something to handle all the conditions but it may still need to touch up a bit.
as a start, you probably can refer to attached and amend accordingly.
hope this give you some idea how to do it.
my-exercise_b.xlsx
as a start, you probably can refer to attached and amend accordingly.
hope this give you some idea how to do it.
my-exercise_b.xlsx
Dear Ryan ChongÙˆ
Thank you for your interest and help, Unfortunately not solved properly ,It will seem to you if you change the qty available for product A batch no K120 , if you change the qty to be 3,000 Instead 5,000 you will notice that the distribution for product A batch no K121 not correct ,All quantitative"4000" putted in the month of February 2016.
Try and tell me if there is an update
Thanks , once again
Thank you for your interest and help, Unfortunately not solved properly ,It will seem to you if you change the qty available for product A batch no K120 , if you change the qty to be 3,000 Instead 5,000 you will notice that the distribution for product A batch no K121 not correct ,All quantitative"4000" putted in the month of February 2016.
Try and tell me if there is an update
Thanks , once again
Active 1 day ago
Try attached.
Column D, row 11 and row 18 are hidden with no values, to be able to make a single formula to copy to all cells.
my-exercise-1.xlsx
Column D, row 11 and row 18 are hidden with no values, to be able to make a single formula to copy to all cells.
my-exercise-1.xlsx
Dear Ejgil Hedegaard,
Thanks lot for your response , the formula that used not help , you will discover that if you change the qty for product A batch no K120 to be 1,000TINS
Thanks
Thanks lot for your response , the formula that used not help , you will discover that if you change the qty for product A batch no K120 to be 1,000TINS
Thanks
Active 1 day ago
I did not expect the batch qty to be lower than the monthly qty, so the initial value used the monthly, not the available batch.
Another adjustment made to handle that all batch qty can be below monthly qty.
Here is a revised version.
my-exercise-1.xlsx
Another adjustment made to handle that all batch qty can be below monthly qty.
Here is a revised version.
my-exercise-1.xlsx
Featured Post
![[Webinar] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 18 hours left to enroll
632 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.