Calculating the easy method

[ufniqdudrig]

Hi & AZUL every one,

i would like to ask a help from any one, the problem is like this:

i have a factory(A) that produces handholes, if the factory (B)
produced already 2 forms.
every(1) form can produce (1) handhole in two days, then the handhole
left for 3 days to be dried, and we suppose that after the first
handhole is produced with in the 2 days, from the first day the
factory (B) can produce every day one new form until i get total 20
forms all together, so that can produce new handholes the same as the
previous one. so i want to know how to calculate or at least present
it in excel file so i can know how many handholes can be
produced( suppose i need total of 1000 handholes), and the period of
time to be produced.

Thanks

 

[John]

Hi & AZUL every one,

i would like to ask a help from any one, the problem is like this:

i have a factory(A) that produces handholes, if the factory (B)
produced already 2 forms.
every(1) form can produce (1) handhole in two days, then the handhole
left for 3 days to be dried, and we suppose that after the first
handhole is produced with in the 2 days, from the first day the
factory (B) can produce every day one new form until i get total 20
forms all together, so that can produce new handholes the same as the
previous one. so i want to know how to calculate or at least present
it in excel file so i can know how many handholes can be
produced( suppose i need total of 1000 handholes), and the period of
time to be produced.

Thanks

ufniqdudr,
This little algebra problem has nothing to do with MS Project. In that
regard you are in the wrong newsgroup. However, this is a nice little
exercise and let me just point you in the right direction and then you
can work out the details.

First, I suggest you take a piece of paper and do a little layout in a
timeline format. For example, we know that the form producer will
produce forms for 18 days. I would label the timescale as 0 through 18.
Second, we know that there are 2 forms to start at time "0". Those two
forms will produce a hole every 2 days (i.e. by the end of day 2, end of
day 4, etc.).

Meanwhile the form factory is busy putting out new forms at the rate of
1 per day. So at the end of day "1" a new form is available. Assuming
that form is immediately available to the hole making factory (probably
an invalid assumption but we'll use it anyway). Since it takes 2 days to
make a hole before the form can be used again, that new form will
produce its first hole at the end of day 3. It will go on to produce
another hole every two days thereafter.

The same scenario occurs at the form factory at the end of days 2
through 18. The above sequence can then be applied for the next 18 days.

In terms of a formula, the first 2 forms produce 18/2*2 holes (18 days /
2 days per interval x 2 holes per interval). The next form produces
(18-1)/2*1 (18 days minus 1 / days per interval x 1 hole per interval).
Now replicate this sequence and you will have the total number of holes
produced in 18 days. Dividing the total desired number of holes (i.e.
1000) by this number will give the number of days. I didn't actually do
all the math, but my guess is that you will not end up with an even
number of days.

Can the formula be generalized? Of course, but that is left as an
exercise for the student

John
Project MVP

 

[ufniqdudrig]

ufniqdudr,
This little algebra problem has nothing to do with MS Project. In that
regard you are in the wrong newsgroup. However, this is a nice little
exercise and let me just point you in the right direction and then you
can work out the details.

First, I suggest you take a piece of paper and do a little layout in a
timeline format. For example, we know that the form producer will
produce forms for 18 days. I would label the timescale as 0 through 18.
Second, we know that there are 2 forms to start at time "0". Those two
forms will produce a hole every 2 days (i.e. by the end of day 2, end of
day 4, etc.).

Meanwhile the form factory is busy putting out new forms at the rate of
1 per day. So at the end of day "1" a new form is available. Assuming
that form is immediately available to the hole making factory (probably
an invalid assumption but we'll use it anyway). Since it takes 2 days to
make a hole before the form can be used again, that new form will
produce its first hole at the end of day 3. It will go on to produce
another hole every two days thereafter.

The same scenario occurs at the form factory at the end of days 2
through 18. The above sequence can then be applied for the next 18 days.

In terms of a formula, the first 2 forms produce 18/2*2 holes (18 days /
2 days per interval x 2 holes per interval). The next form produces
(18-1)/2*1 (18 days minus 1 / days per interval x 1 hole per interval).
Now replicate this sequence and you will have the total number of holes
produced in 18 days. Dividing the total desired number of holes (i.e.
1000) by this number will give the number of days. I didn't actually do
all the math, but my guess is that you will not end up with an even
number of days.

Can the formula be generalized? Of course, but that is left as an
exercise for the student

John
Project MVP- Hide quoted text -

- Show quoted text -

Tanemmirt, Thanks alot

I appreciate your kindness of helping me , again many thanks for your
assist.

 

[John]

Tanemmirt, Thanks alot

I appreciate your kindness of helping me , again many thanks for your
assist.

Tanemmirt,
You're welcome.
John