Manufacturing

R

Randy Galliano

Has anybody used Project to schedule manufacturing processes where you use
People resources, materials, and Labor rates?

Regards,

Randy.
 
S

Steve House [MS Project MVP]

It depends on the type of process. Some manufacturing, especially job
oriented things like custom built boats or aircraft could be considered
projects. Other things than are more continuous in nature, like scheduling
a help desk or an auto assembly line, are more difficult to adapt. Projects
by their nature are closed ended and produce a unique end result, the
completion of which marks the end of the project after which everyone goes
home. Most forms of manufacturing are open ended - once the line starts up
production continues for an indefinite period - and the outcome is
non-unique - one refrigerator coming off the line is pretty much like all of
them.
 
M

Mike Glen

Hi Randy,

Welcome to this Microsoft Project newsgroup :)

I'm sure someone has, but Project is not designed for production. If your
processes meet the definition of a project (a unique undertaking with
clearly defined start and finish dates) then Project will do all you ask.

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :))

Mike Glen
MS Project MVP
 
J

John Sitka

Project = "My year with the team"

Say I have a group of folks that I'm reponsible for
and I build them into my team.
Then I set about assigning tasks to them which are related to enterprise
projects are A and B.
Related is a strong word no doubt. but for instance. A single task in "My
year with the team"
is in a finish before start relationship with a task in ProjectA. That is
the relationship is a managerial
concept, "do this for me"

So as far as ProjectA is concerned. All it knows is that we need the to
assign
a task to the"My year with the team" Project. what goes on in that Project
we don't really care
but we have made a contract between projects that the "My year with the
team" will have exclusive use
of the enterprise resources on their team. ProjectA wants to hear back from
"My year with the team"
when ProjectA's deliverable from the task they assigned to "My year with the
team" is complete.
ProjectA must go through the deliverable produced by "My year with the team"
in order for it's own
completion. ProjectA dosen't really care about what resources are used for
the task it has farmed it out
out "My year with the team" it was already known that these were off
limits. And as far as any scheduling
gyrations that happens within the "My year with the team" Project, ProjectA
really dosen't care and should benefit
from an early completetion by the "My year with the team" Project.

So what advantage is this? It allows the recreation of a new "My year with
the team" Project every year.
This one has no beginning and no end but still constrains the actual
Projects that produce something which
do have an end.
I believe this is a possible approach to some manufacturing environments
because the task creation and resource levelling
that go on within the "My year with the team" Project. need no constraints
Each Project could be laid out like this

SUMMARY TASK for RESOURCE_JOHN DONE
(indent and rollup the below tasks as they complete)
....
TASK1 / RESOURCE_JOHN / 3 hours work
TASK2 / RESOURCE_JOHN / 5 hours work
TASK3 / RESOURCE_JOHN / 12 hours work
TASK4 / RESOURCE_JOHN / 2 hours work
TASK5 / RESOURCE_JOHN / 5 hours work


SUMMARY TASK for RESOURCE_MARY DONE
(indent and rollup the below tasks as they complete)
....
TASK21 / RESOURCE_MARY / 3 hours work
TASK22 / RESOURCE_MARY / 5 hours work
TASK23 / RESOURCE_MARY / 12 hours work


SUMMARY TASK for RESOURCE_JANE DONE
(indent and rollup the below tasks as they complete)
....
TASK2009678/ RESOURCE_JANE / 35 hours work
TASK2009679 / RESOURCE_JANE / 29 hours work
TASK2009680 / RESOURCE_JANE / 10 hours work



TASK22 / RESOURCE_MARY / 5 hours work is the predecessor
to
TASK365 In the Main Project. ProjectA

The idea here is to increase flow through a manufacturing cell.
In this case the cell is scheduled with the "My year with the team" Project.
This is possible once one accepts some of the TOC principals I think.
Truely the early completetion of ProjectA is constrained only at a very few
spots
that cause bottlenecks due to resource contention. That is the Drum,
If you charge the project manager of "My year with the team" with a very
focused set of
resources and a highly undefined set of tasks he can streamline his flow to
the best
advantage by being very adaptable and he can publish and update his traking
at least once
a day easily. With no impact on the grand design of the of ProjectA. It's a
smoke and
mirrors trick and I don't know how extensible it will be yet., but so far
the "My year with the team" Project Manager is really tickled, The first day
he picked
it up he had the ability to see his schedule in a way he hadn't before.
This required two things,
-we eliminated the concept of "finish on dates" and replaced them by merely
dragging
and dropping his tasks to avoid deadlines, move the task up and it moves
earlier
in the order when levelling by ID.
-we truely identifiying what is a unique task and what isn't, he saw every
step of his two
week production schedule materialize in a few hours.

The tracking and levelling are a little tricky to learn.
His web published Excell sheet looked like doom. Project showed all
deadlines way on the horizon.

So I am so sold on the neccesity of the distributed updates and that can't
happen fast enough
for us. But I think we could get to a point where three times daily cell
reschedules could happen.
Project seems to handle it fairly well enough but there are some quirks.
 
M

moradikam

hi dear
i my self use msp for manufacturing planning and contoroling.
is good but important weakness at msp is this:
if you have 2 machine"M1" &"M2" for do task "A" you can deffine that
max unit of resource is 200% but actualy we must deffine what machine?
when? do what?
THIS IS MY PROBLEM WHIT MSP.CAN ANY BODY SOLVE IT BY VBA MACRO FOR ME?
 
S

Steve House [MS Project MVP]

List each machine separately in the resource sheet and assign them 100%
each. No VBA required.
 
R

Randy Galliano

Thank you for this reply.

Would it be possible for me to acquire an example of how you actually set up
planning and controlling?

We will be scheduling batches of widgets to be produced. They will go
through various steps in the process. I don't expect to plan things like
step a (sanding) can output 5 units/hour in batch, then it feeds into step b
(spraying) which is a continuous process of 2 units every 5 min, and
figuring out what the most efficeint mechanism is. I would leave that up to
a product like Great Plains Manufacturing. However, it seems to me that I
should be able to schedule resources, materials, and other items into each
step for a given run and calculate necessary resources. Am I off base?

Regards,

Randy.
 
S

Steve House [MS Project MVP]

That's not the sort of thing Project does. Project is a work scheduling
tool where each task has a specific start and stop time. It is designed to
do precisely what you say you don't want to do - schedule step a to step b
to step c, with exact durations for each step. Only once the discrete tasks
have been identified and sequenced does resource assignments, material
utilization, etc come into play. To do this in Project you would need to
break it down like 100 widgets to produce, step 1 will take 100/5 or 20
hours, then the batch can move on to step 2, etc
 
D

danstanford

Steve, I think I understand your response but want to be sure. My
manufacturing process is full of projects with defined end dates and I have a
set of resources with which to accomplish them. I would like to run a big
continuous master project into which I insert new projects with resource
demands and completion date requirements and have MSP help me to make it
work. I have downloaded the demo version and see how it will work exactly the
way I want it to but for only one project at a time. I am building custom
kitchens which from a manufacturing perspective look very similar and so I
would set them up as templates. Ideally I would dump a bunch of these
projects in along with the desired dates and let MSP identify the bottlenecks
and then I would go in and start solving them. This is manufacturing but not
in the assembly line way, is this product suitable for the use? Dan.
 
J

John Sitka

Very interesting Dan, I can identify with your situation very well.
I had a long evaluation of master project sub/project stucture here
when I was trying to identify what other third party schedule tools could
offer over
Project. The list is long and conceptual. I've become pretty convinced that
what is a crucial part
of the equation is the concurrency and frequency of the actuals recorded
from the various machine
or operational cells. Not many believe me yet.

How to go about getting those actuals is the challenge? There are actuals
that reprsent new projects, new tasks
that become part of the flow load through your operations; and the
collection of progress on those tasks
as well a system of dispatch sheets that need to be directed at operational
cells to make sure they are working
on the correct task at each moment. A sophisticated ERP vendor would present
solutions to those within the
context of a work order system and then maybe a barcoding system. It becomes
a very big animal that effects
every level of the company. But many say it is a necessity for true
production management. I approached it
in the way that the schedule should be a separate tool for resource
management, that the actual resource scheduling
will always be a manual operation rather than one that was derived from a
convergence of what sales activities are
or a rules based schedule or optimization.

I can imagine in a custom kitchen environment you have large saws that
operate in conjunction with a nesting program
to maximize cuts of raw materials, some router operations etc. Each of these
machines and operators must be kept busy
at the scheduled task and must be very flexible. In order for the sub
schedules to be responsive to the demands put on
resources there is a large amount of rescheduling that must be done. This
carries alot of overhead as traditionally each
production plan in project is fully constrained.

You mention bottlenecks and that is a key concept and one which I propose is
best addressed with a hybrid
critical path / critical chain approach. Once one believes that the
effective management of the bottlenecks is the
best goal, then you can actually fully constrain the production plan
subprojects and simply optimise the constraining
resources. The tasks that are not to be accomplished by the bottleneck
resources have an inhereint flexibility to them
as they are not critical constraining resources. Manage the big saws or
staining booths for example and all the other
tasks will be easy to schedule and will not limit delivery in a bad way, for
example you can always hire more folks to
install drawer slides if it becomes an issue that we can't meet deliveries
because we have too many drawer slides to install.

If you are interested in really attacking your bottlenecks the best
reference would
probably be http://www.focusedperformance.com/. I'm trying a sneak approach
at my company by
showing the benefits of 100% flow optimization at the critical constraining
resources(CCR). Using Project
resource levelling can provide that effectively reducing the CCR buffer to
zero, That 100% is impossible without
extrememly frequent updates of actuals? Other wise I think it would be vary
hard to present some of the concepts
described on that site as fitting in with the way things are done now and in
the past. Maybe kitchens are different than building
custom machines but I know our factory could not operate if the scheduling
was as ridgid as a widget production line, there
is too much hands on craftsmanship required at many of the tasks, even if we
could predict with huge historical accuracy
how long each task would take. Fixing a fully constrained production plan to
those estimates would never allow us to
exceed them without a very responsive system of collecting actuals and
reponding to them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top