0
Apr 24, 2013 at 03:44 AM

BI Integrated Planning (auto compute components with FIXED TOTALs)

74 Views

Hi guyz,

I'm wondering if the scenario given below is possible in BI Integrated Planning. If so, how will I do it?

For example, I have four (4) materials with their corresponding volume (shown below).

Material

Volume

(percentage)

Mat A

40

1. 0.2

Mat B

30

1. 0.15

Mat C

60

1. 0.3

Mat D

70

1. 0.35

TOTAL

200

1

Then, I want to increase the volume of Mat B to 45. However, I want my TOTAL to be fixed hence, the volume of the remaining three (3) materials (Mat A, Mat C, and Mat D) should change so that the total of the four (4) materials will still be 200.

Material

NEW VOLUME

(percentage)

Mat A

35

1. 0.175

Mat B

45

1. 0.225

Mat C

55

1. 0.275

Mat D

65

1. 0.325

TOTAL

200

1

So if I want to decrease the volume of Mat D to 35, the volume of Mat A, B, and C will also change to still have a TOTAL of 200.

Material

NEW VOLUME

(percentage)

Mat A

45

1. 0.225

Mat B

55

1. 0.275

Mat C

65

1. 0.325

Mat D

35

1. 0.175

TOTAL

200

1

Is this possible in BI Integrated Planning? How can it be done? Do I need to use any of the Planning Functions?

Thanks a lot for the help!

<<Text removed by moderator>>

Message was edited by: Matthew Billingham