A company that is engaged in the manufacture and sale of polypropylene caps needs to determine the aggregate production plan for polypropylene caps of various colors used in shampoo bottles. There is an injector for the shampoo caps; This has 2 molds Product No. molds Shampoo In one injection stroke, 8 plugs are produced every 30 seconds. There is a maximum of up to 16 hours per day to work, 3 workers are needed to operate the injection machine. The hourly wage per worker is $120. For the purposes of calculating labor and production, consider that full hours are worked. For the cost of raw material, each plug uses 2.5grs of polypropylene and each kilo costs $25.00. January February March April May June July August September October No. cavities per Cycle mold 2 November December injection/mold in seconds 30 4 The cost of holding inventory per piece is $2.00. The demand data, initial inventory and days available for work are as indicated. Demand forecast Days available per Initial inventory month Find the best aggregate production plan for one year, with the lowest cost, lowest inventory and lowest lost sales. Using excel

A company that is engaged in the manufacture and sale of polypropylene caps needs to determine the aggregate production plan for polypropylene caps of various colors used in shampoo bottles. There is an injector for the shampoo caps; This has 2 molds In one injection stroke, 8 plugs are produced every 30 seconds. There is a maximum of up to 16 hours per day to work, 3 workers are needed to operate the injection machine. The hourly wage per worker is $120. For the purposes of calculating labor and production, consider that full hours are worked. For the cost of raw material, each plug uses 2.5grs of polypropylene and each kilo costs $25.00. The cost of holding inventory per piece is $2.00. The demand data. initial inventorv and davs available for work are as indicated. Find the best aggregate production plan for one year, with the lowest cost, lowest inventory and lowest lost sales. Usingexcel