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

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 33

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!