Capacity planning

Import the xpo file for this project into version 3- SP3 system. 

The project is a prototype and is a response to a production scheduling scenario problem posted on Axapta-Knowledge-Village

 It seems the site manufactures to order and has an option to keep the site closed if the weeks target can be achieved in say 4 days. The site also wanted to know the cost of overtime Vs cost of keeping factory running for a full normal day.

 The attached prototype may be the step to solve the above problem:

 There is a new button on InventTable, that allows you to enter number of hours required per work center per 1 unit of the item. You will have to enter the hours even in terms of sub-assemblies.

 After filling in test data. Now right click and run class ‘ReqCalcWrkCtrHours’. This is a very simple class which…

 For all sales lines that are open and status is ‘On order’ a table called ReqProductWrkCtrHours is populated. The computation is very simple, for every wrkctr that you have filled in above it will create requirement per work center for hours as of the delivery date. (not selecting status reserved or picked or delivered for obvious reason with this status there is no need for the client to produce such items).

 The project stops here but you can use this data to create some olap cubes and create some jazzy report for the customer. The customer can then decide whether to shut-down the factory for a day, go in for over time etc etc etc. May be you could write a graph in Axapta that will show total capacity for a work center for a week and sum up the requirements from the above table for the same week.

I know the above discussion is confusing but please take some time to go through the code.

Send mail to harry@systomatics.com with questions or comments about this web site.

Disclaimer: I am working with Microsoft Business Solutions. The code on this site may or may not be related to my official duties with Microsoft. I do not claim in any expertise in modules represented on this website. Essentially there is just one person doing functional specifications (in head), design specifications (in head), coding and some testing. There is no way the project on this site will be free of bugs. The projects are intended as guidelines and may god help you if you decide to implement the projects without making any changes. If you implement any project resulting into data corruption or anything like that then do not even think of suing me because a. I have already warned you and b. I don't have any money. I may or may not respond to your emails about supporting the project. I may or may not upgrade the projects to the next service pack / version.