Allocate demand for production

Messi1408

New Member
Joined
May 15, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Please help to advise a formular for this excel file, i want to allocate demand in a week :

397​
166​
65​
65​
59​
22​
20​
ItemQty7/8/20247/9/20247/10/20247/11/20247/12/20247/13/2024
aa​
63​
50​
13​
bb​
82​
70​
12​
cc​
43​
20​
6​
7​
10​
bb​
8​
8​
aa​
14​
6​
8​
bb​
9​
9​
bb​
12​
12​
cc​
29​
13​
16​
dd​
31​
14​
17​
cc​
19​
18​
1​
cc​
19​
19​
dd​
12​
12​
aa​
12​
12​
cc​
8​
8​
dd​
12​
12​
aa​
24​
12​
5​
7​

i have headcount and Efficiency as below :

Headcount​
LineCellHeadcountEfficiencyWorking Hour
2A022A0211045%
10​
2A022A0221250%
10​
2A022A0231245%
10​
2A022A0241245%
10​
2A022A0251247%
10​


please help me advise 1 formulas or any ways to allocate demand , Allocate so that Q'ty of days is equal and efficiency as the table above , thank you so much :

0​
0​
0​
0​
0​
0​
LineCellItemQty07/0807/0907/1007/1107/1207/13
2A022A021
aa​
0
2A022A021
aa​
0
2A022A022
aa​
0
2A022A022
aa​
0
2A022A022
bb​
0
2A022A023
bb​
0
2A022A023
bb​
0
2A022A023
bb​
0
2A022A024
cc​
0
2A022A024
cc​
0
2A022A024
cc​
0
2A022A024
cc​
0
2A022A025
cc​
0
2A022A025
dd​
0
2A022A025
dd​
0
2A022A025
dd​
0
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top