Forum Discussion
Determining the Quantity of Fabric Produced at the Summary Task Level in Microsoft Project
Rajabtex,
The machine resource should be a work type resource, the thread and yarn resources should be material type resource. Your cost resource may or may not be appropriate for what you are trying to do. A cost type resource is independent of the task but might be something like the purchase of a machine. All other costs are related to the work (i.e. $/hr) and/or material cost ($/spool).
Work type resources, whether labor or machine, have limits as defined by the Max Unit value on the Resource Sheet. Material resources do not have a limit. The limit is whatever value you assign to a task.
It isn't clear exactly what you want (or expect) to see at summary level. Work and cost sum up at summary level but quantity does not, unless perhaps described in a custom field. You are correct in that changing the quantity will increase the time, material and work, but that increase is something you as the user must input, Project does not have any way to automatically "scale up" a task. Perhaps a screen shot of what you have set up would help us help you.
As a side observation, unless you need to plan out a schedule for manufacturing the fabric, Project may not be the best application for what you want to do. Excel might be a better choice.
John
thank you for replying
The problem is that working with this amount of machines and raw materials requires planning to prepare the raw materials needed to follow up on manufacturing on time
The problem is in the raw materials for the production of fabrics
The processing time of the color of the threads takes from 2 to 5 days
With the possibility of manufacturing each color from 100 kg to 500 kg, I need 80 colors per season.
If I don't have a good business plan to use the resources properly
1- It is difficult to secure the necessary threads on time
2- Determine the quantity of threads needed for the next week and the remaining ones for the season plan
3- Reducing waste from surplus colors that change at the end of the season
- Rajabtex,
Okay....but I don't see a specific question that we can respond to. If you want to use Project for laying out a plan to manufacture your fabric you will first need to define all the necessary tasks required to produce the fabric. Then lay out those tasks in a logical sequence with dependencies as appropriate (e.g. procure thread > thread lead time > receive thread > load thread onto machine > etc.). Once your rough plan is developed, refine it as necessary to achieve an end result (i.e. finished fabric). Assign resources to each step (task) for a given output (i.e. bolts of fabric).
As I noted previously Project will help you plan out the schedule for your process (i.e. provide a timeline and alert you of resource and/or deadline conflicts), but it can not automatically scale up the process for quantity.
John- Thank you for your help. I have included a table and added arithmetic operations to it, as an initial solution.
- Rajabtex,
You're welcome and thanks for the feedback.
John