Wednesday, May 14, 2014

Enhancements to the 787 spreadsheet

In order to enhance the information that  I present on my spreadsheet, I'm attempting to track the certain metrics to help understand how the 787 program is doing.  It all has to do with time and the amount of it that the 787 spends on being assembled, tested and finally delivered to customers.  I'm tracking the time the aircraft spends in final assembly, the time it spends in pre-flight and the amount of time in production flight tests.

Unfortunately I don't have all the information that I need for all the aircraft particularly the dates that the aircraft loads into final assembly and the date that the aircraft exits final assembly.  If there was traveled work or time needed for change incorporation, that is lumped into the pre-flight time....it's easier that way instead of trying to track when each airframe is where at a particular point in time.

If anyone has any information they can share, it is appreciated.  Please check out the spreadsheet below and you'll see which information I am missing.

Full 787 List

 

11 comments:

johnv777 said...

Uresh, I have copies of your spreadsheet, captured approximately ever 2 weeks apart dating back to May 2010. Using this data you might be able to extrapolate the needed dates, at least within a week or so. If you are interested send me an email and I will send it to you. johnv707@gmail.com

Uresh said...

Thanks but the past spreadsheets won't contain the load or roll out dates.

Trapperpk said...

There are Three important stages in the netrics of the 787. Time in production to roll out, time after roll out to actual delivery, and deliveries per month. The first time line is for the production mangager. The second time is for the completness metrics and the third time frame is for the Financial markets. The last stage absorbs all the lumpiness of the first two stages where it's hard to pin point how many will deliver in a given month. A moving average for 90 day delivery frame captures a snapshot of the Boeing delivery trend for the financial markets. Stage 1 time frame examples production efficiency. Stage two time frame is for problem solving and aircraft testing. The 90 day moving abverage of delivery smooths all Boeing operations into a final result. The simple test od delivery is three months delivery added together divided by 3= equals delivery pacing as a trend with all the efficiencies accounted for from the first two stages as a net sum rate towards the shrinking of the order book. Think about those three stage points when using your metrics that it would be good to appeal to the production types as well with the financial types where you have a large audience.

Piotrek_ said...

Uresh, do you know which 788 production frame will be first with Trent-1000 package C engines like 789s?

Unknown said...

I would like to see the City Location column changed to Build Location so that a comparison of build rates can be seen between Everett and Charleston. The Location column could be used to track current location and disposition (i.e. Delivered). Thanks for the work on this data. Very interesting to peruse.

Fedupjohn said...

Uresh,

I have a spreadsheet that might be useful to you, how do I get it to you?

John

Uresh said...

Thanks John, You can email it to me at onemanwolfpack19@aol.com

Piotrek_ said...

ZA389's reg is B-2788

TurtleLuv said...

the real problem now is there's too much horizontal space used in your chart. to see a lot of info on a 1080p desktop you have to scroll right which makes it hard to see which frame you're looking at because it scrolls off screen to the left.

constructive criticism! :) a lot of the columns could be trimmed down to fix this. you take three columns to show location, which then turns to three redundant proclamations of "delivered". build location could be an E or C. lots of dead space in other columns, sometimes for no reason, sometimes for a special case (two serial numbers for one plane out of the whole list).

Fedupjohn said...

Uresh,
The info in my spreadsheet was extrapolated from your postings, over time, only. So, you can trust it, btw if might be only a day or 2 off, if you were...lol

John, thank you for this site I love it.....

1coolguy1 said...

Interesting the BA plane is listed as Ready for Delivery after only 2 flights. I believe this may be a record low prior to delivery.
Is this typical for the 737 and the 777?