User Manual - Agritrop
Contents
1. The Creation modification of a scenario window is displayed as follows Ae To create a scenario Seles Marne Date 11 07 2005 Comment om os J 2 The scenario name is an obligatory field There must only be one The scenario creation date is the current date but it can be modified The Comment section gives details on the scenario It is not obligatory 2 To duplicate a scenario From the Scenario definition window choose the scenario to be duplicated then select Duplicate in the Scenario menu All of the scenario parameters are duplicated and the new scenario appears in the list To delete a scenario 3 To delete a scenario 10 To delete an existing scenario select the scenario to delete select the Delete option in the Scenario menu and then confirm the deletion by clicking OK Attention suppression Are you sure you want to delete Beauchamptest 7 Cancel 4 To import a data file in an existing scenario From the Scenario definition window select Import in the Scenario menu Choose your data file and then click Open Look inside E MAGI_Donn es 4a ey E why recent Ebd _magi documents Jeu de donn es FORMAT 2 Jeu de donn es Sezela 2000 86 Jeu de donn es Sezela 2000 Bis y documents gs orking station re File name Open networks kind file Cancel me The Imports window is displayed as follows 11 ay Imports2. 18 The following window 1s displayed ma To create a route DER supply chain Production unt Coastal Intermediate Operators Hater the intermediate operators in ihe cane routing order List of types List of operators Selected operators Hauler Unitrans HE D 2 amp Serela mill 2 4 To create a route select a production unit in the drop down menu there can only be one route per production unit Then select an intermediate operator in the list of the operators the first list located on the left makes it possible to filter the intermediate operators by type The gt button is used to transfer the selected operator to the final list This 1s process carried out for each operator while strictly respecting the cane routing order An operator can be deleted by clicking the button while having previously selected it in the list of selected operators 2 To parameter the season period Select Definition of season period in the Parameter menu in the Scenario definition window 19 fay Definition of season period ue Serela Default season length fweeks Calculated season length weeks Calculated season start 25703 1999 Desired end of season 2070172000 The green season length and season start fields are calculated fields o The determination of the season period in weeks takes into account the total tonnage of cane to be milled in the season as est
3. ay planning of delivery allocations Seles Delivery allocations Week Delivery allocation 225 12 225r 12 225 le 2257 12 2257 12 2297 12 2257 12 229r 12 225 12 229r le 2257 12 2257 12 2297 12 2767 1 Magi proposes various delivery allocation calculation methods a Manual input Delivery allocations are entered individually for each week of the season A check procedure verifies that potential flows of the successive supply chain links are not exceeded b Default value Delivery allocations Delivery allocation 13 SE 12 A default value may also be entered and assigned to every week of the season 26 c Uniform throughout the season The Uniform throughout the season option is selected to obtain an identical maximum value for each week of the season DA Total Tonnage PU Season period In this case the two constraints Delivery of total PU tonnage and Weekly mill capacity not exceeded are usually automatically taken into account d Uniform throughout periods Delivery periods during the season period in which delivery allocations are constant may also be determined The objective in this case is to ask each PU to deliver over a certain period according to a uniform weekly delivery allocation For every PU it is thus necessary to determine the week of the beginning and end of delivery during the season period and to calculate the weekly delivery allocations according to the followin
4. User Manual MACI S mulation tool for sugarcane mill supply organization Contacts Sandrine AUZOUX data processing specialist sandrine auzoux cirad fr Caroline Lejars agronomist caroline lejars cirad fr Pierre Yves Le Gal agronomist pierre yves le_gal cirad fr Contents AOC HO RS RS en ee dc don 4 Computer modelling of mill supply areas ss 5 L SOM ANC UON a n an bee eee tien be etes 8 As WII SU DPI area OPUONS RAR ice eal her ae laitier 8 I FO Create a new mill supply AR Assis en en nent 8 2 To delete an existing mill supply area 9 3 To simulate a scenario for an existing mill supply area 9 B conan OONO openers ee net mente a ee mr nt ide te one 9 k Worcreate OF modiy A SCONAMO ic os cece wists eve MR MR de ete 9 2s TOdupli Cate a SCCNANIO SERA An nn ia entente 10 Je TOC IELE AS CON AIO NS eu rene An one et ne 10 4 To import a data file in an existing scenario cccccecccccceceeseesseccceeeeecaaeeseeeeeeeenaas 11 WISH CCU ccsssasescieeostexsisactackvaastesesdesccacueadteza oacdecnedancuaactecnss sat a A O A 12 D Cute capacity SINC CU eea den eee 13 ek Pransloadme CAPACITY SOL ie ed ie eee 13 dy Quality VAI shee ed neo nee Menton one 13 Ch Delivery AN OC AION SINCE aeea a ue 13 Cy VO parameter ASCENATO sata miennes 14 1 To parameter the mill supply area structure 14 a NH II CRArACIeTISUCSE SENS Lu Re A Rd nu he heats 14 D Prod uctionunmteharacteri ties S
5. fe o061 047 45 14240234 6533768903 a4 64212646 4514240234 o4 64212646 67 1361607 17 18 r2 00616977 45 1 4240234 6533768903 a4 64212646 4514240234 54 64212646 67 71361607 ET 13 f2 o061 amp 45142400 65 33 60 o4 6421 2 45 142400 4 B42 at 67 136 51 30429075 Quality Average 81 30429075 113 8130429075 T a1 30429075 i5 a1 30429075 E 8130429075 E PTE 8130429075 119 A 5 ezela lt 59 56566659 108 6896396 108 689639E 105 6096396 105 6896396 105 6096396 1086896296 108 64 33 The first table represents the loading rates of the production units with the arithmetic average for the season given in the second column The second table represents the loading rates of the intermediate operators The third table represents the loading rate for the mill crushing capacity and the last table represents the loading rate for the quality The loading rates are calculated by dividing the quantities collected transferred or milled by the capacities calculated by type of operator They are expressed in e g 95 T 100x L up Where Lj delivery of PU 1 in week j Cr harvest capacity of PU 1 100 xT Toi Ct l Where T cane quantity transferred from IO p in week j Ct transfer capacity of IO p 100x Lu u ee Cbh J Where Lu cane quantity delivered to the mill in week J Cbh mill c
6. 26425012 15 34965 37 229r l2 12414 16 Erri ar 6425 02 15 2enr l2 bf Flo 4739555 6425 02 16 34909 37 220r 12414 16 Erria 6425 02 16 2257 12 Brel ar 4739953 A423 02 17 34955 37 2257 12 1241416 Erri ar pE420 Oe 17 2257 12 Sire eo 47399 53 n6428 02 18 34905 37 229r 12 12414716 Erria n6420 0z 18 22512 bf fl se 4739953 B42 Oe 19 34985 37 225712 1241476 Brel 26425012 13 225 12 BFF Toe 4739953 EE 428 02 The first table PU gt mill represents the weekly cane deliveries of each production unit with the total and the remainder to be delivered total produced total delivered given in second and last column The last row represents the total for all units The second table IO gt mill represents weekly cane flows of each intermediate operator with the total given in the second column and the total for all intermediate operators given in the last row 2 Capacities ay Simulation results ey Options Help Delivery allocations Capacities Quality Loading rate Sugar production Capacities Crush Capacity Average 13 14 15 16 1 18 19 20 W 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 lt li gt Average 13 14 15 T6 17 18 REE 20 A F8332 69995 1051105775 1034044918 9702074579 9631960082 9372090699 9532799966 92146 19673 85723 14 15 EE 117 18 13 2a 4 6624735407 51916 65335 55015 22
7. Hill Imports Breakdown Fates Weekly Working Period Hourly Crushing Capicity Losses M aa N T O FF NE Production Units Imports PL teszt Fi Cutting Capacity Deliveries Allocation ca FF i ia Iv Fa w M a a Coastal Inland 55G Jaq ARRETE daala Diversion i Select a column intemeiate TE Imports You can import all of the data or select only those which interest you In the first two tables the All column enables the user to deal with a whole row In the production units table it is also possible to deal with the columns by using the drop down menu and one of the two buttons located just below The two buttons under the intermediate operators table also makes it possible to deal with the column transfer capacity Click OK once your choice is made Data is imported from an Excel file in a preset format The FORMAT_En xls file is an example of the MAGI importation file format It can be found in the directory C Program Files CIRAD Mag12004 This file is presented in the form of five sheets to fill in a Mill sheet a EW Jeu de donn es FORMAT En Ri Weekly Breakdown Rate hi Weekly Working Period iti Hourly Lapacities ith SS Ss SS co 4 alaale The y uf Y 4 4 M Mill Usine CapOfCut CapDeCoupe CapOfTransfer CapDe lf 12 The blue cells must be filled in b Cutting capacity sheet 3 Je
8. Picture 25 Season period definition window Picture 26 Dialog box to enter the weekly crushing capacity Picture 2 Tab PU COURS ADAM a a EERTE ERESSE rE ESITE Picture 28 Tab IO Transloading capacity Picture 29 Dialog box to enter the QUAMEV 2 2 0 esse Picture 30 Tab PU Quality indicators 5 2 sacs esse Picture 31 Dialog box to enter the delivery allocation Picture 32 DC e AR ee ee ETE EE E A EEE Picture 33 Season period creation window ee tnees Pict re 34 Error MSE WRC VICW sondern et D do rite Picture 35 Simulation results option eee e een eaas Picture 36 Results window Tab Deliveries eee eaes Picture 37 Results window Tab Capacities 0 Picture 38 Results window Tab Quality eensaaeeteseeeeeeeenaas Picture 39 Results window Tab Loading rate Picture 40 Results window Tab Sugar production Picture 41 Export to Excel option ccs cudccsanaeededeeetsadsadad beveewdeaddadudiceensesctaapccncdeasiiawed Picture 42 Language settings Menu ics sien no sega saties tavewtawediee tovemduiiion Reus PSE oe ECS eee eee Introduction This software was developed under a CIRAD research project carried out in coll
9. capacity module Txp breakdown rate in e g 3 6 value obtained from the Mill module Chox hourly capacity for the quality variable of index k t h value obtained from the Mill module Qu weighted averages for the quality variable of index k in week Third step calculation of the weekly capacities minima for week jJ Che min Che Che Che or Che min Che dis 31 3 Quality A simulation results 9 Options Help Indicateur Synth tique ICT 17 18 19 ag u Coastal 5 156145 6 561 01 2 6506055 BBs i 6 992597 T 45603 7 011575 903 4i sil i gt 19 1010928 11 0385 11 22956 11 47945 11 3926 11 85201 19 Coastal 3 116155 2 930175 2 936 06 2 970919 2 906457 2 510559 2 505039 4 ill 18 13 Coastal 16 448716 16 22016 15 60908 15 62158 15 40513 16 35315 16 10459 ESS indicateur Moyenne 13 14 15 16 17 18 Indicateur Sy 10 77700860 5955693538 6357351206 7092548696 7062133324 4 2960644 7 2 594581 6 063 ai IT The first four tables of this tab represent a weekly summary of the quality variables for each production unit The last column gives the weighted average for the season The fifth table represents the quality of the mill supply area Data from the Quality module are used for the qualities per PU and week without further calculation The seasonal average per PU is calculated by weighting the weekly quality values by th
10. concerning the mill 14 The Weekly average crushing capacity is automatically computed with the Weekly working period the Hourly average crushing capacity and the Breakdown rate Green shading means that it is a computed field that cannot be manually modified To modify all other variables select Modify in the Options menu b Production unit characteristics ly area structure gay Options P Help RE ScenariaRet Modify Delete jaduction Units Intermediate operators Structure di cor Area ha Diversion Yield trha Tonnage delivered 1504371 t From the Options menu it is possible to create modify or remove a production unit after having selected it in the list Eg Suppl area structure ghh Options gt Help create fiw Modify ee Delete Intermediate operatore Structure list of production units Print Inland supply area SSG Diversion 15 The following window appears ba To create a production unit Seles Scenanaket Choose an existing Production Coastal v rit Or enter a name of production unit rea Yield Delivered tonnage Two possible creation options gt Choose an existing production unit in another scenario gt Enter a new name Delivered tonnage is a computed field which corresponds to the product of the area by the yield Howe
11. 27 12 Capacit hebdo de l usine 54840 Semaine 19 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLSemaine 56427712 Capacit hebdo de l usine 54840 Semaine 20 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLSemaine 5642712 Capacit hebdo de l usine 54840 Semaine 21 La somme hebdomadaire de tous les DL d passe la capacit hebdomadaire de broyage de l usine 28 D Obtaining scenario simulation results From the Scenario definition window select Simulation results in the Scenario menu if S Caso p eri D d defiriti Ot idp cenario id wA Farameter Create Modify Duplicate Delete Import Simulation results The window includes five tabs 1 Deliveries ay Simulation results amp Options P Help cenarios 7 Help Delivery allocations Capacities Cluality Loading rate Sugar production Delivery allocations 7 Pu Total 1504370 957 97056 16503 A33008 586 7 291168 9150 2426404923 Coastal Diversion Inland Total 97056 16503 291168 9150 20381 79 643 24764049253 13 34955 37 229r le 12414 16 Erri ar 56428 02 13 225 12 bf fl ae 4739953 5E4285 02 14 34985 37 225712 12414 16 Birla nb420 02 14 229r 12 Erria 4 399 53
12. 321 5460616679 5366648453 5457568365 6151220689 6044267830 63289 154 16 17 18 19 20 6662259927 69065 gt ww 14 15 16 EE 18 13 20 Li 6326711291 5191665335 5601522321 54506 16679 5266640453 5457558955 6151220689 6044267830 63289 El i 5 This tab represents the weekly mill capacities The first table gives the crushing capacity the three following tables give the calculated weekly capacities relative to the three quality variables while the last gives the minima of the three previous values The average is given in the first column of each table The crushing capacity is the same for the entire season period cf capacity calculated on the mill screen 30 The weekly capacities related to indices 1 2 and 3 are calculated as follows First step calculation of the weekly average quality values for the mill supply area for week jJ and index K Qui Where ke 1 23 m number of PUs QU weighted average of the quality of index k in week J Qi value of the quality of index k for PU 1 in week j Lij delivery of PU 1 for week Jj Qi Were entered in the Quality module 2nd step calculation of the weekly capacities for week j and index k Chex relative to the three quality variables and corresponding to the three lines of the table Indices 1 2 and 3 Cie Dfe x 100 Txp x Cho Qu Where Def the effective mill working period for week J value obtained from the Weekly mill
13. aboration with INRA on supply organization in agro industrial processing units It is based on a simulation model focused on weekly management of cane flows from the field to the mill This model can be used to study impacts on sugar production reorganization of mill supply areas modifications in delivery planning rules as well as variations in the supply chain capacity and quality Unplanned delivery or processing events can occur at various supply chain levels By simulating these unplanned events the response capacity of a scenario can be tested with respect to disruptions in the planning system Magi is a support tool for negotiations between growers and industrial millers as it specifies possible ways of boosting total value while addressing all parties objectives and constraints Computer modelling of mill supply areas Based on the weekly management of cane flows from a production unit to a mill MAGI provides a representation of the mill supply process throughout a sugar season The model provides a spatial representation of sugarcane flows to the mill It s based on partitioning of the mill supply area at three levels 1 e mill intermediate operators and production units and also on the characterization of the routes of each production unit to the mill A production unit PU is an elementary entity postulated or treated as being homogeneous with respect to the delivered cane quality and rules applied to this cane by the mil
14. an Sn ne Ne nn man 15 c Intermediate operator characteristics cccccccccssssessseccccccceaeenseeeccceeeeeuseseseeeeess 16 CIN OURS SR oem ee een imate 18 2 FO DAtae ter INE SCASON D O En anne at unes 19 Ss TO Parameter Weck y CAPAC lle S crete nn nn tr he 21 4 TO parameter Quality irc Secrest a Sawin apudeeeaneataaenenetoests 23 Loparameterdehvery allOCatOns semi nine e raO EE E 25 De UE ATUL a OAS 26 B Derav US aa T a te vacetetnidciseet wanda scene tay ere taccadete 26 c Uniform throughout the season hernie 2 d UiifOrmrmthrou snout periods En E E 21 D Obtaining scenario simulation results ee cceeessssseeeeceeeeceaeeeeeeeceeceeaaeeeeeeeeeeeeeeaaas 29 Mes NONE VIS TCS ee enn eee eee tea 29 23 Capace S nent NRA Une e lo Rae uen 30 J OUa ene E E E EE tate eens 32 do LoadinNe tales eoni R A ieee 33 D S s DEOQUCHONE RSR dt EE caline 35 6 Exporting the results to an Excel 2002 file 0 0 eccccccccccceeeeseeeececeeeeeasaenseeeeeees 36 E Conie iaioe E N 36 le Choice Ol TAMU ACCS a E E en ea 36 2e H a E T 3T Table of illustrations Picture 1 Pyramidal representation of the mill supply area structure Picture 2 Structure of the application cece eeeeeeneeeaaees Pico W CIC OIC SCI Cll E ond aeaueiqentenne ete EE EE R RS Picture 4 Mill creation dialog DOX saccvavsccrctasncdtaas wiewabasweduaivesancpeiaueyduaveiseuevatananeneddedoveeebaleses Pi
15. ate a new mill supply area Select To create a new mill supply area and then click OK Language settings 7 All selection Performed selected mill to create a new mill eo simulate an existing scenario starting from the selected mill to delete an existing mill The following window is displayed Enter a name of the mill supply area usually the mill name and click OK by New Mill _ OX Enter a name forthe new mill pO 2 To delete an existing mill supply area Select To delete an existing mill supply area and confirm the deletion by clicking OK in the following dialog box ATTENTION YOU are about to remove the supply area and all associated scenarios PUS and Os Do you want to continue Cancel 3 To simulate a scenario for an existing mill supply area Select To choose an existing mill supply area then click OK The scenario definition window is then displayed on the screen oa Definition of a scenario KAB ip Scenario Sf Parameter P Help Existing Scenarios i Information 09 05 2005 Scenanohet Comment B Scenario options 1 To create or modify a scenario From the scenario definition window select Create or Modify in the Scenario menu ay Definition of a scenario ME Scenario SA Parameter a 4 Help Create Modify Pare Duplicate SSS Delete Import P Mame Simulation results Date
16. cture 5 Validation window to remove a mill supply area Picture 0 Scenario de UOM WINGO ME a a eee se en non ot ce tee PIC CUS 7 SCM at AE D Picture 8 Scenario creation dialog box n eee e cece eee eeeeeeeeeanes Picture 9 Validation window to remove a mill Pict re 10 Open file dialog DOK crc sa an de a ae ete Do Picture 11 Data import Wall ON ee ee ei eus Picture 12 Mill sheet in MAGI import format Picture 13 Cutting capacity sheet nee e cece eee eeeeeeneeennas Picture 14 Transloading capacity sheet PC Ce 13 Quality AO AO SR t 200ctcatectaceatie cee ENSE Picture 16 Delivery allocation sheet a Picture 17 Parameter MENU a ai hacer Picture 18 Mill supply area structure definition window Tab M ill Picture 19 Mill supply area structure definition window Tab PU Picmre 20 ODHOIS TONU ee ad nd da de tie Picture 22 Production unit creation dialog box Picture 21 Mill supply area structure definition window Tab 10 Picture 22 10 Cr ation dialog BOX ocsscracasiewsanceccdoodwedsonechadeveerebecenes adder eeaeiexaie Picture 23 Mill supply area structure definition window Tab Routes Picture 24 Route Creation dialog DOK ix 8 denied lasers
17. eir effective deliveries Q Q xL DL j l j l Where Q weighted average quality of PU 1 for the season Q quality of PU 1 in week Lij deliveries of PU 1 in week J 32 The average weighted qualities per delivery for the mill supply area for week j Qu are calculated by the following formula Where QU 29 x L gt i l i l Q quality of PU i in week j Lij deliveries of PU 1 in week j And the average weighted qualities per delivery are thus obtained for the mill supply area and for the entire season Qu Where Q quality of PU 1 in week j Lij deliveries of PU 1 in week j n number of weeks m number of PUs ay Simulation results ey Options F Help il m 270 Ss oa _ RSR DES ES TERRE CNE ECR Er Delivery allocations Capacities Quality Loading rate Sugar production Loading rate PU Coastal Average Average fe 00618977 45 14240234 66 33 68003 a4 6421 2646 4514240234 84 6421 2646 6771361607 Average 13 r2 00610977 45 14240234 63 33 boos o4 64212646 4514240234 94 6421 2646 6771261607 13 4 Loading rates 14 r2 00610977 45 1 4240234 65 32 boos o4 64212646 45 1 4240254 o4 64212646 B f 1361607 44 15 Fe 00616977 4514240234 6533768903 a4 6421 2646 45 1 4240254 o4 64212646 67 1361607 E 5 16 fe oo61 ao 4514240234 63 33 boos o4 64212646 4514240234 84 64212646 6771261607 EF i
18. ent patterns during the season period and then assessing the potential advantages of this new organization in terms of final sugar production gains Lastly it is possible to test whether each new delivery allocation would involve redimensioning the harvesting transporting storing and milling equipment At exit Magi displays some tables of weekly deliveries for each intermediate operator and production unit some tables of weekly crushing mill capacities and weekly capacities related to the three quality variables some tables of weekly quality variable values for each production unit some tables of loading rates at all mill supply area levels and obviously some tables of the weekly sugar production for each production unit and at the mill gate Structure of the application Welcome To delete mill supply area Contiquratian To create mill supply area To choose mill supply area To define scenario The choice of languages Scenario To create To modifs To duplicate o delete To import Resuts Deliveries Capacities Loading rates Guality Sugar production E Structure of mill supply area ER Production units Intermediate operators Moving Crushing Loading ACutting Transfert Losses Indices of quality To modify To create To modifs To create To modify To creste To modifs To delete To delete To delete Allocation deliveries I Software tutorial A Mill supply area options 1 To cre
19. g formula DA PU Total Tonnage PU Delivery period PU Delivery Period weeks week of end of delivery week of beginning of delivery 1 The Total PU tonnage delivery constraint is automatically taken into account It is essential that the calculated delivery allocation does not exceed the harvest capacity of the production unit considered otherwise an error message will be displayed The user must then extend this delivery period so as to remain under the harvest capacity The Weekly mill capacity not exceeded constraint must be checked once all the delivery allocations are defined For certain weeks the sum of the PU deliveries may exceed this capacity When exiting a scenario a listing of these weeks is thus displayed with the percentage exceeding the capacity calculated according to the formula o Oe Dh 100x X Toh Where Dlij deliveries of PU 1 in week j Cbhj weekly mill crushing capacity in week Jj 21 The period creation window 1s displayed as follows a To create periods Definition of the period Diversion Mumber of periods o Created periods Date of start Date of end Tonnage rate Coms 2 beginning week and an ending week along with a tonnage rate in are entered and then the period 1s entered by clicking To delete a period select it and then click The number of periods is calculated automatically In this case the delivery allocations will be the
20. imated by growers and the average weekly milling capacity of the sugar refinery estimated by the millers gt Te m i l Cbhm Where Tg delivered tonnage of PU 1 Cbhm average weekly crushing capacity of the mill n number of PUs o The season start is calculated from the length of the season period and the season ending date Magi takes the first Season period field into account for the calculation of weekly flows Its default value corresponds to the computed value However it is possible to modify its theoretical value to determine the exact time of the season period 20 3 To parameter weekly capacities Select Weekly capacity in the Parameter menu in the Scenario definition window ay Weekly capacity il Production units Intermediate operators Real weekly crush capacity Real Crush Capacity A 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 69403 5 Canann C In the Mill tab the real weekly crushing capacity is calculated from the effective working period EWP The weekly working period of the mill is calculated in two times Initially we calculate a working period without breakdowns according to the following general formula DFHP 168h maintenance time planned breakdowns closing for leave etc Then we calculate the effective working period after integration of an a
21. k 24 ay Quality DEX nn Will Production units List of production unita Inland 55G Diversion week Fa 14 15 16 1 18 19 20 2 ee 23 24 JF fe test 3 995764 10 1092755 11 0388 11 2295615 11 4794534 11 39261 11 5520117 12 561 205 12 5871 398 134090509 13 757 78 13 9150219 14174271 Enter a default value test 317615515 24381 64 243570566 2978916793 2 906457 2 51 055804 2 66663427 2 45800613 24522406 24 501 2 256749 2 261 931 4 771 70COF 4 tests 16 4497564 16 2201576 15 609081 16 6218615 15 4051323 16 35315 16 104887 15 366688 15 599711 73 153280547 14 9235706 14 8560753 1 4 CCFTCCIC Ind Synth 619614864 556101227 6 506095 6 634477 699239656 T 45603 7611575 9 07 398 4 099153 9 688015 10 214366 10 367648 10 700000 weekly indications of quality Choice of quate indrearar Fat a The second Production units tab relates to the cane quality variables The columns Ind1 Ind2 Ind3 correspond to weekly quality index values entered in the Mill tab on the mill supply area structure definition level The synthetic indicator corresponds to the sugar content of the cane A default value can be entered as a specific value for a given week 5 To parameter delivery allocations Select Delivery allocations in the Parameter menu in the Scenario definition window 25
22. l for the management of cane supply planning and piloting processes For example a section of a mill a group of farms a homogeneous agroclimatic zone or a category of growers can define production units The partitioning choices depend on the chosen simulation objectives Intermediate operators IO are entities who incorporate the contributions of various production units Depending on their type they are characterized by their transferring transporting or loading capacity The mill is the third representational level of the mill supply area structural organization It represents a request quantified by the cane milling capacity Routes represent pathways via which cane is hauled from the field to the mill They are characterized by the dimensioning features of the transloading and transport facilities A pyramidal structure was adopted consisting of N entities through which cane flows transit Production units which deliver to intermediate operators are positioned at the base of the pyramid There can be several operator levels but each entity can only deliver to one higher ranking entity A simulation scenario is built only one mill The user creates a library of scenarios for each studied mill Intermediate operators g J Production units A scenario combines a set of assumptions concerning the supply organization in a mill supply area In Magi it is based on only one mill and a library of scenarios is compiled for each studied mi
23. ll Magi can thus be used to test various supplying scenarios with the aim of increasing sugar production at the mill gate of taking full advantage of sugar content peaks Mill and minimizing losses to enhance the quality while ensuring sufficient operating margins so as to be ready for unplanned events mill shutdowns conveyor breakdowns bad weather etc The first step involves creating a mill with one or more associated scenarios Then the PU and IO are characterised and the routes defined Finally the delivered cane tonnages are quantified The model makes intermediate calculations on the mill weekly working period crushing capacities and season period at the intermediate operator level concerning incoming and outgoing cane flows and at the production unit level concerning delivery allocations The model can also be used to carry out simulations based on assumptions not concerning the attribution of growers cane delivery rights For example the supply schedules date and tonnage can be adjusted so as to optimally take advantage of the spatiotemporal variability in sugar content of cane in a mill supply area If maximum sugar content periods differ between production units the model can calculate the gains that could be achieved by changing the delivery allocation On the mill supply area scale this involves determining homogeneous cane ripeness zones determining delivery schedules per zone so as to optimally exploit sugar cont
24. nization of the supplying in the agro industrial units of transformation It is based on a simulation model centered on the weekly management of flows of canes from the field to the mill This model allows to study the impacts on the sugar production the reorganization of a mill supply area modifications of the rules of planning of the deliveries variation of the capacity and quality of the supply chain Unplanned events of delivery or transformation can be generated at various levels of the supply chain To simulate these unplamed events allow to test the capacity of response of a scenario at the disturbances of the planning system This tool is a support of assistance to the negotiations between growers and industrialists insofar as it specifies the possible ways of creation of total value in comparison with the objectives and constraints of each one oe The Contents are listed on the left under headings and subheadings From the Index users can view specific Help pages from keywords The Search function displays a list of pages containing the entered keywords A Preview of the selected page is displayed in the right pane 38
25. rans M 13 5000 HE 14 S000 15 S000 16 5000 17 S000 15 S000 19 S000 20 S000 21 S000 22 S000 23 FOOD 24 S000 29 S000 7c Bann In the Intermediate operators tab the transfer capacity can be entered as explained previously i e by giving a default value or by a manual entry for a week given 4 To parameter quality Select Quality in the Parameter menu in the Scenario definition window 23 ay Quality Enter a default value D weekly deterioration 6 Choice ofiosses fo enter Calcul KJ i Week Losses Losses Totallosses Ta 0 j 2 14 15 16 1 18 19 20 2 ee 23 ed JF LENS ES PES i ie ie ie a a Do ee ee De D me ue D me 2 Mh Po MM Po Fi To Po Fi Po Mo The Mill tab concerns weekly sugar losses In Reunion Losses 1 relate to the technical difference between the sample obtained at the weigh scales and that obtained at the mill entrance Losses 2 represent the losses due to the milling process Total losses are calculated automatically as the sum of Losses 1 and Losses 2 for one week by clicking Calculation In South Africa there is no sampling done outside of the mill so total losses can thus be entered directly by entering a default value if the losses do not vary throughout the season period or by manually entering the values for each wee
26. rushing capacity in week jJ 100 x Lu L J where Lu cane quantity delivered to the mill in week Che mill crushing capacity relative to the quality in week jJ 34 ay Simulation results ey Options Help Delivery allocations Capacities 5 Sugar production Quality Loading rate Sugar production Sugar production PU 556 Total Coastal Diversion Inland Tatal Total 160674 1101 10365 02934 D9702 3425 30691 7 9664 261513 2796 13 1814 393261 153 17075685 995 6289156 300 5506640 3360 680029 Choice of mill produ ction calculation as 113 14 15 1945 540761 157 00r6464 1030 640646 404 5441 796 3od0 61 3154 EF 2262030130 3293466426 3526 640551 22r 6 181406 144 5253710 1134 489657 447 1884375 4002 184902 45 16 2321 056406 154 2182812 1085 108046 426 599375 32955 022109 17 2446 490761 162 9204003 1146 925671 460 5039843 4216 843037 Afrique du Sud Afrique du Sud 5922141204 3906321667 4132 506961 18 606 591 dbo 153 5336667 1122193543 475 9753125 4360 528 30 4273 318155 119 ef aed 176 5050 1154 0501 456 391 4 4550 255 R union 44g 2 gt This tab is divided into two tables The first represents the weekly sugar production of each production unit with the total for the season period given in the second column The last row gives the total for all production units The second table represent
27. s the mill production with the total given in the second column A drop down menu makes it possible to select a method for calculating this production which differs for Reunion and South Africa Sugar production calculation In the Reunion case the sugar content corresponds to the total quantity of sugar contained in the cane and the technical variation represents losses due to cane quality as well as losses due to the efficiency of the extraction process thus giving the following sugar production formula S ProdTot gt DI x Q Pu s i l Where s 1 S season weeks Pus total mill losses in s Di delivery allocation of PU 1 in week s Qis quality for PU 1 in week s 35 In the South African case the technical variation concerns only losses due to the efficiency of the extraction process The sugar content corresponds to the potentially extractable quantity of sugar for a given cane quality RV The weekly sugar production is calculated according to the following formula S m ProdTot gt 1 Pu gt Dl x Q i l Where s 1 S season weeks Pu Total mill losses in week s Di delivery allocation of PU 1 in week s Qis quality for PU 1 in week s 6 Exporting the results to an Excel 2002 file The results can be exported to an Excel file by selecting Export to Excel in the Options menu in the Simulation results window bay Simulation results i Options 2 Help Analysis E
28. same for each week of the period and proportional to the tonnage rate Click and 2 to scroll down the list of created periods Once the periods are defined validate them by clicking OK When certain constraints are not respected a summary listing is displayed with an explanation on each value exceeded per week The following is an example fay Error list Cer Pi Listing des erreurs apr s affectation des OL de l achemnement n1 Semaine 13 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLSemaine 56447 12 Capacit hebdo de l usine 54840 Semaine 14 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLoemaine 6427 12 Capacit hebdo de l usine 54880 Semaine 15 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeOLSenane 56427712 Capacit hebdo de l usine 54840 Semaine 16 La somme hebdomadaire de tous les OL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLS emane 56427 12 Capacit hebdo de l usine 54680 Semaine 17 La somme hebdomadaire de tous les DL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLSemaine 5642712 Capacit hebdo de l usine 54840 Semaine 18 La somme hebdomadaire de tous les DL d passe la capacit hebdomadaire de broyage de l usine gt sommeDLSemaine 564
29. u de donn es FORMAT En 4 F L pa I4 M Mill Usine CapOfCut CapDeCoupe CanOfTransfer Ce 4 vf c Transloading capacity sheet EI Jeu de donn es FORMAT En Dox E Py E M 4 H CapOfTransfer CapDeTransfert Indice f Indice in d Quality variable sheet 5 Jeu de donnees FORMAT En 4 H Indice Indice f Indices RVv Indicateur Synthetique e Delivery allocation sheet 13 C To parameter a scenario ah Definition of a scenario QF Scenario A Parameter P Help Supply area structure Definition of season length auchambtes weekly capacity Quality Delivery allocation 1 To parameter the mill supply area structure Select Supply area structure in the Parameter menu in the Scenario definition window a Mill characteristics ay supply area structure gay Options Help Production Units Intermediate operators Structure Breakdown rate gt gt FR dy Hourly average crushing capacity hs aan i ae weekly working period Weekly average crushing capacity Average crushing Capacity with Quality gauge 1 test Quality gauge 2 teste Qualite gauge 3 testi The Mills tab gives all information
30. ver it can also be entered manually by the user c Intermediate operator characteristics EJ Supply area structure EF Options 9 Help Create Scenariaket Modif Delete oduction Units Intermediate operators Structure Haulier 16 As mentioned concerning production units it is possible to create modify or delete an intermediate operator from the Options menu The following window 1s displayed fay Create an intermediate operator Seles To choose an existing operator Intermediate operator name Type Haulier Two possible creation options gt Choose an existing intermediate operator in an existing scenario gt Enter a name and then a type To delete a type it should first of all be selected in the drop down menu then click all Similarly to add one just click i The 7 button on the right of the field validates the new type l l OK To register the current operator click at the bottom of the form 17 d Routes ay Supply area structure gay Options P Help reale ScenarioRet Modify Delete laduction Units Intermediate operators Structure Print i la supply chains Production unit Diversion List of intermediate operators D MAT Sezela As mentioned concerning production units it is possible to create modify or delete a route from the Options menu
31. verage breakdown rate EWP DFHP 1 breakdown rate For each week S the weekly capacity of the mill is given by the following formula Weekly capacity 168 weekly maintenance time 1 breakdown rate hourly capacity 21 Note that the hourly capacity of the mill when it varies 1s calculated from an objective extraction rate and quality of the cane that enters the mill according to a yet to be determined formula A default EWP value can be entered and can be allocated for each week of the season period by clicking OK It is also possible to modify the EWP values individually for each week aj Weekly capacity Sees h M Enter default value Des List of production units Cutting capacity Week Harvest capacity 13 48000 556 14 48000 Diversion 15 Agnon 16 48000 17 43000 18 48000 19 48000 20 48000 21 48000 Ze 48000 23 48000 24 48000 24 45000 JF AB In the PU tab as noted previously a default cutting capacity value can be given per week to the PU selected in the list Moreover a cutting capacity can be modified manually for a given week 22 ay Weekly capacity E Eg 5 Pie i TE Tape etn eters ree mm Mill Production units Intermediate operators oo E M Enter a default value ji Be List of intermediate operators Transloading capacity BL Week Transfer capacity Unit
32. xport to Excel Delivery allocations Capacities l Quality Loac Simply name your file and then open it in Excel E Configuration 1 Choice of languages The software is currently available in two languages French and English To switch language select the Configurations menu in the Welcome window of the application and click on the desired language Depending on future applications the software could eventually be translated into Spanish 36 om Welcome Language settin French Spanish Portuguese Settings to create a new mill ot simulate an existing scenario starting frorn the selected mill 2 Help In each window of the application users can get help by typing F1 on the keyboard or by clicking the button or the menu with the following icon 7 Help is also available directly in the application directory C Program Files CIRAD Magi2004 AideMagi chm A shortcut is available in Start all programs MAGT2 The online Help window is as follows E aide lex SE ai Masquer Imprimer Options NE A ns Simulation tool of organization of sugar cane supplying to the mill Presentation Sommaire Index Rechercher 2 Mill supply area The scenarios 2 Choice of the Language 2 About help 2 Tutorial This software falls under a research project carried out in collaboration by the CIRAD and the INRA on the orga
Download Pdf Manuals
Related Search