Production Plan spare capacity

[PoohsMate]

I've looked through the baord but none of the posts have the answer so can someone please see if they can help me.

We have 10 production machines (enclosing mail packs).

We have a list of regular jobs with an estimated time per job per machine.
We run 3 shifts over 24 Hrs (our day starts at 7am).

I am trying to show the sequence of jobs per day per machine with any spare capacity. At the moment I have only been able to put each job on a seperate line in a stacked horizontal chart

Can anyone help to show me how I can get all jobs on one line and show any spare capacity?

I could then get all 10 machines with their jobs on the same chart?
Our Production Planner and account managers could then see what free capacity there is available to book jobs into.

Thanks in advance.

Bernard

Production plan.xls
	A	B	C	D	E	F	G
1	Monday	32/10/05
2	MachineNo	1	(EachDaystartsat7am)3Shiftsystem.EachShift=6.25Hrsworkingtimeperday.
3	JobName	Start	JobRunning	JobMakeReady	Restarts	Finish	(Hrs)
4	KaysStmts	7	1.25	0.25	1	9.5
5	GUSStmts	9.5	1.75	0.25	0.25	11.75
6	ChoiceStmts	11.75	1	0.25	0.25	13.25
7	AboundStmts	13.25	0.75	0.25	1	15.25
8	AdditionsStmts	15.25	0.5	0.25	0.5	16.5
9					Bookedtomachine	16.5	Hrs
10					Potential	18.75	3x6.25HrShifts
11					Available	2.25
12					Less1xMake-Ready	2	Hrs
Plan1

 

[PoohsMate]

The following illustrates the type of production capacity report format I am trying to achieve with a chart.
(Based on an example from Mr Walenbachs site).
Regards
Bernard

Production plan.xls
	A	B	C	D	E	F	G	H
4	Machines	Potential	Actual	Under\Over	Available	Under	MachineCapacity	Over
5	1	300,000	350,000	50,000	16.67%		1	nn
6	2	300,000	300,000	0	0.00%		2
7	3	90,000	300,500	210,500	233.89%		3	nnnnnnnnnnnnnnnnnnnnnnn
8	4	300,500	300,000	-500	-0.17%		4
9	5	300,200	200,000	-100,200	-33.38%	nnn	5
10	6	30,000	100,000	70,000	233.33%		6	nnnnnnnnnnnnnnnnnnnnnnn
11	7	200,000	200,000	0	0.00%		7
12	8	200,000	300,100	100,100	50.05%		8	nnnnn
13	9	300,100	100,000	-200,100	-66.68%	nnnnnnn	9
14	10	100,000	90,000	-10,000	-10.00%	n	10
CapacityAtAGlance