These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 12, 2013

Demand Analysis - Ikaika Bullock

Ikaika Bullock
IS 520
Fall ‘13
Demand Analysis Tool
Final Project write-up

Executive Summary

The Company:
Boeing Commercial Airplanes (BCA) is a business unit of The Boeing Company, committed to being the leader in commercial aviation by offering airplanes and services that deliver superior design, efficiency and value to customers around the world.
BCA offers a family of technologically advanced airplanes, the 737, 747, 767, 777, 777X, 787 Dreamliner and BBJ/VIP aircraft. Of these models one that can seat more than 500 and another that boasts the longest range in the world, at more than 9,300 nautical miles.
BCA employs more than 80,000 people under the leadership of President and CEO Ray Conner. The business unit's revenue in 2012 was $49.1 billion.
Headquartered in the Puget Sound region of Washington state, BCA has operations in more than a dozen cities and countries. The business unit comprises the above listed airplane programs, extensive fabrication and assembly facilities and a global customer support organization.

The Project:
The demand analysis tool was created summer 2013 to support Boeing 787  supplier management teams, specifically for one of the supplier teams of the 787 program. The fabrication division is in charge of placing orders for “emergent demand” parts need for airplanes in final assembly, these are extremely important because they can delay a delivery to the customer. Over the past year daily demand reports had been stored as excel workbooks. The information analyzed and the performance of both Boeing and the supplier to be assessed.

The first version of the tool was crude to say the least; it applied mega functions for filtering need, conditional formatting, and pivot tables. It did give a accounting of key metrics such as time it took to issue a purchase order and the flow time of parts from the supplier to Boeing. Much of the repetitive data scrubbing processes were left to the end user. 

No comments:

Post a Comment

Blog Archive