Harbor Chemicals

assigning 5 sheet Harbour Chemicals Sheet Harbour Chemicals (SHC) manufactures chemics apply in the create industry. The process involves three departments. Chemical A, which is purchased for $3 per liter, is touch on through Department 1 in atomic reactores of blow liters. Each fortune of chemics bear upon through Department A earns 70 liters of chemical B and 30 liters of chemical C. Chemical B is exchange for $10 per liter. Chemical C is used in Department 2 to incur chemicals D, E, and F. Department 2 processes chemical C in batches of 200 liters.Each batch processed through Department B produces 100 liters of chemical D, 60 liters of chemical E, and 40 liters of chemical F. Chemical D is sell for $12 per liter. Chemical E is a waste w atomic number 18 that is donated to the local municipality to be spread on gravel roadstead to keep down dust. Chemical F is a hazardous waste product that must be disposed of at a cost of $6 per liter. Alternatively, chemical F can be processed through Department 3 to produce chemical C. Department 3 processes chemical F in batches of 40 liters.For individually batch of chemical F processed, 20 liters of chemical C be produced. In the past, this operation has had a tendency to install up stocks of chemical C. The maximum shop capactiy for chemical C is 1,000 liters. The accompanying diagram summarizes the issue activities at SHC. The sales theater director indicates that sales of chemical B cannot pass off 35,000 liters in the upcoming period, and sales of chemical D cannot exceed 10,000 liters. The production coach-and-four advises that 7,000 labor-hours are available for the upcoming period. Workers are paid $10 per hour worked.The production manager indicates that the labor-hours required for each batch in Departments 1,2, and 3 are 10, 15, and 10, respectively. Moreoever, because of constraints relating to the mix vats and storage, the maximum number of batches in Departments 1, 2, and 3 are 600 , 80, and 40, respectively. The estimated variable overhead be per batch in Departments 1, 2, and 3 are estimated as $250, $750, and $100. 2 Required 1. theorise an LP to determine the optimal production protrude at SHC for the upcoming period. 2. Using Excel, authorise the LP formulated in requirement 1 to determine the optimal plan.