The purpose of this assignment is to utilize Distribution Requirements Planning (DRP) parameters and inventory data to determine planned order releases in central warehouses. address each problem using full sentences and proper spelling and grammar and submit in an Excel template.

5. The XYZ Company's finance manager is currently studying projected inventory investment for product 101 at the central (plant) warehouse. Quantities of product 101 are shipped from the central warehouse to warehouses \\( A \\) and \\( B \\), based on individual warehouse requirements. The product costs \\( \\$ 100 \\) per unit. Using DRP parameters and inventory information for product 101 in Exhibit A, determine the planned order releases at the central warehouse. Construct a graph indicating projected inventory investment at warehouse A for this product at the beginning and end of each week over the next six-week period. Assume this product's demand is equally divided among the days of each week. \\( U=4 U ; L I=1 ; S S=U \\). \\( Q= \\) lot-tor-lot; \\( L T=1 ; S S=0 \\)