Solving Planning Problems using Dimensional Modeling / Manal Abd El kader Abd El fattah ; Supervised Ibrahim Farag , Ali Hamid Elbastawisy

Thesis (M.Sc.) - Cairo University - Institute Of Statistical Studies and Research (ISSR) - Department Of Computer and Information Sciences

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

Issued also as CD