• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Machine Loading Plan

A

AVNSH22

New Member
i got a problem .

I want to make a machine loading plan and for that i need to sum till 24 hours cycle time in which various small cycles can be included.

ex+

I have 4 products whose cycle time are:-

A 6 HRS

B 8 HRS

C 18 HRS

D 32 HRS

NOW I WANT TO SUM UP THESE HOURS TILL 24 AND REMAINING HOURS TO BE ADDED FOR NEXT SUM UP I.E.

1ST SUM UP A 6+B 8+C10 =24

2ND SUM UP C 8+D 16 =24

3RD SUM UP REMAINING 16+SO ON

WITH THEIR INDEX NUMBER I.E. INDICATION A, B,C,D


THANKS


DEAR NARAYAN THANKS FOR QUICK RESPONSE


NARAYAN HAS UNDERSTOOD IT CORRECTLY . THAT THE MAIN PROBLEM IS MAKING A BATCH OF 24 HRS AND CARRY FORWARDING THE REST HOURS TO THE NEXT 24 HRS BATCH AND SO ON.


ex

given data


product hr for production

name

a 5

b 20.5

c 1

d 2.5

e 20

f 6

g 20


and the require solution is

1st day a 5

b 19


2nd day b 1.5

c 1

d 2.5

e 19


3rd day e 1

f 6

g 17


4th day g 3
 
Hi AVNSH22,


Welcome to chandoo.org and we glad to have you here.


Your question is not very clear to me. I have understood that:


1)A,B,C,D are the products' name and 6,8,18,32 are the respective cycle time of these products


2)Can you plz clarify what do you mean by "I WANT TO SUM UP THESE HOURS TILL 24 AND REMAINING HOURS TO BE ADDED FOR NEXT SUM UP I.E."?


3)Regarding your first sum; how come 10 hours is coming up for product C because you have given the example of 18 hours for the product C...I do not understand this part.


You may want to explain your requirement bit more clearly in order to get a speedy solution of your problem.


You can also consider uploading your sample workbook here:

http://chandoo.org/forums/topic/posting-a-sample-workbook


Kaushik
 
Hi Kaushik ,


From what I have understood , A + B + C is 6 + 8 + 18 which equals 32 ; since this is more than 24 ( there are 24 hours in a day ) , the output is A and 24 , and the remaining 8 are carried over ; since the next sum , of 8 and 32 is 16 more than 24 , the output is C and 24 , with 16 being carried over this time. So it goes.


Narayan
 
Narayan,


Thanks for clarifying....understood now.


Let me take an other e.g., say today cycle time of four machines(A,B,C,D) are 10,12,5,8 (respectively).


So in the first sum, we are reaching 24 hrs for the first three machines (A,B, and C) and we have remaing 3 hrs for machine C and 8 hrs for machine D.


So, these 3 and 8 hrs will be carried forward in the next sum...right!


But I do not understand how do you come to the conclusion about output when you say A in the first case and C in the socond sum....can you plz explain?


Kaushik
 
Hi Kaushik ,


I think with the detailed outputs given by the OP , everything is clear.


What is required is that each machine centre , along with its output is required ; if we go with the original data , then the output will have to be as follows :

[pre]
Code: 
Day 1
A    6
B    8
C   10    24

Day 2
C    8
D   16    24

Day 3
D   16
.    .
.    .
[/pre]
and so on.


Narayan
 
Hi ,


A similar question has been posed earlier in this forum , here :


http://chandoo.org/forums/topic/break-into-24-hour-schedules


Can you go through this , and see if it is helpful ?


Narayan
 
Doesn't the pattern just repeat after 8 days:

[pre]
Code: 
-	-	24	24	24	24	24	24	24	24
a	6	6		6			6
b	8	8		2	6		8
c	18	10	8		18		2	16
d	32		16	16		24	8	8	24

Total		24	24	24	24	24	24	24	24
[/pre]

`
 
ONE MORE HELP

IS IT POSSIBLE TO ARRANGE THESE SUM BLOCK OF 24 HRS IN SERIES WITH THEIR PRODUCT NAME LIKE


Day 1

A 6

B 8

C 10 24


Day 2

C 8

D 16 24


Day 3

D 16


FOR THIS THE REQUIRED SERIES SHOULD BE

A 6

B 8

C 10

C 8

D 16

D 16
 
it not works for , if data is like that :-

A 3

A 16

B 5

B 2

B 26

F 17


AND CYCLE SHOULD NOT REPEAT AGAIN & AGAIN IE.

AFTER REACHING TO F 17 , IT SHOULD NOT REPEAT BACK TO A 3
 
Hi ,


I did not want to reply , but since you have repeated your post , I am doing so.


You posted 6 times before you mention that the products can repeat with differing cycle times ; and to top it all , you mention "it did not work" !


Any answer that is given on this or any other forum is based on the problem specification given by the person who has posted the question ; can you show me any post of yours where you mention that the products can repeat with differing cycle times ?


Secondly , you mention that you do not want the output cycle to repeat ! Are you serious ? If you do not copy the formula , you will not get the output !


As far as your first question is concerned , all I can say is that the easiest way to tackle this is to introduce a helper column where the duplicate products are given a unique identity , and this is made use of when a lookup is done. Check out the example file here :


http://speedy.sh/DXjCy/Daily-Loading-Plan.xlsx


Narayan
 
You must log in or register to reply here.
Back
Top