Please answer this question by considering the changes to the original question that was 4 departments by 4 time frames. In this table its 3 departments by 3 time frames. Please don't copy and paste answers not related to this question requirements.

A single period production Mix: - An electric company specialized in producing PVC electrical wire cables, produces three types of electrical wires: cables for electric panels, power cables, and fire resistance cables. Wires are produced over four production departments, which are: drawing, coating, and packaging. The times each product needs, along with the capacity in (hours) for various departments, in addition to the selling price and the cost per unit are shown via the table below: The factory has some deficiencies in the drawing, and coating departments. Where in each department, produced items can be good, or has to be scrapped. From the previous history, the following table provides the average scrap rate per department: The company has received firm orders for its products. If the demands per product as required by the contract are not met, a penalty ( $ / unit) is imposed. The following table shows the order quantities for each type, and the penalty (in $/ unit): Requirements: - - Formulate a linear program that attempts to determine the product mix that will maximize the company's profit. In your work, please provide the following: - - A clear written linear program formulation with the proper notation. - Solve using a solver or any other computer software and provide a snapshot of the software solution. - Write a simple statement at the end specifying the production mix, and any other concern that has to be emphasized. A single period production Mix: - An electric company specialized in producing PVC electrical wire cables, produces three types of electrical wires: cables for electric panels, power cables, and fire resistance cables. Wires are produced over four production departments, which are: drawing, coating, and packaging. The times each product needs, along with the capacity in (hours) for various departments, in addition to the selling price and the cost per unit are shown via the table below: The factory has some deficiencies in the drawing, and coating departments. Where in each department, produced items can be good, or has to be scrapped. From the previous history, the following table provides the average scrap rate per department: The company has received firm orders for its products. If the demands per product as required by the contract are not met, a penalty ( $ / unit) is imposed. The following table shows the order quantities for each type, and the penalty (in $/ unit): Requirements: - - Formulate a linear program that attempts to determine the product mix that will maximize the company's profit. In your work, please provide the following: - - A clear written linear program formulation with the proper notation. - Solve using a solver or any other computer software and provide a snapshot of the software solution. - Write a simple statement at the end specifying the production mix, and any other concern that has to be emphasized