Abstract: The part of Capacity Requirements Planning is an important central linkage connecting the main-producing plans, the materials demanding plans, and workshop workload management. This article studies the rational and principles of combining the inverted order and the lineal order to implement the capacity Requirements planning, and provides declaration forms by Visual Basic and SQL and the partial arithmetic of graphs.