TY - GEN AU - Manal Abd El kader Abd El fattah AU - Ali Hamid Elbastawisy , AU - Ibrahim Farag , TI - Solving Planning Problems using Dimensional Modeling / PY - 2005/// CY - Cairo : PB - Manal Abd El kader Abd El fattah , KW - planning KW - Problems KW - Solving N1 - Thesis (M.Sc.) - Cairo University - Institute Of Statistical Studies and Research (ISSR) - Department Of Computer and Information Sciences; Issued also as CD N2 - Today Egyptian industry has been affected by many problems that caused industry obstacles that have significant impact on the Egyptian economy One of basic common problems to all manufactures is planning Planning types contain long - range planning , medium - range planning , and short - range planning ; each of them is complex by nature and need to be decomposed into smaller sub problems that are less complex , more structured and easier to be solved Capacity Requirements Planning (CRP) is one of the medium - range planning problems CRP is a detailed comparison of the capacity required by production plans versus the available production capacity and it determines how much labor and machine resources are required to accomplish the production plans If adequate capacity cannot be established , corrective actions should be taken When available capacity is insufficient despite corrective actions , the production planner reviews relative priorities and , working with marketing and production responsible , makes the difficult decisions required in revising the schedul ER -