Question: Form Excel file/files that include production timetable. Modify your Python model that you have developed in part b so that it imports production timetable from

Form Excel file/files that include production timetable. Modify your Python model that you have developed in part b so that it imports production timetable from Excel files. ( I only need the Excel part, not the Python part. But it would be nice to know if Excel meets the requirements to be used by Python.)
A firm is concerned with what mix of 4 products they should produce during the upcoming week. The products 1, 2, 3 and 4 requires production time in 3 different sectors (A,B,C). Each sector has the following production time per week. Production time per unit in hours Production Products time available per week in hours Sectors 1 3 4 A 1.5 1.3 2.2 27 B 1.3 1.3 2.6 C 1.9 1.2 1.1 25 34 24 33 Profits per unit($) Formulate an LP model to find an optimal product mix Clearly define all decision variables Explain all the constraints clearly 2 2.2 2.5 1.6 232 33Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
