Please remember to follow all forum rules: Cross-posting
Note : Please do this Assignment in Excel using solver and submit the excel file.
Thapar theatre company needs to determine the lowest cost production budget for an upcoming theatre show. Specifically, they will have to determine the lowest which set pieces to construct and which pieces must be rented from another company at a pre-determined fee. The time available for constructing the set is two weeks after which rehearsals commence. To construct the set, the theatre has two part-time carpenters who work upto 12 hours a week and each at Rs 100 per hour. Additionally, the scene artist can work 15 hours per week at Rs 150 per hour
The set design requires 20 walls, 2 hanging drops with pained scenery and 3 large wooden tables serving as props. The number of hours required for each piece for carpentry and painting is given below.
Flats, hanging drops and props can also be rented at a cost of Rs 750, Rs 5000 and Rs 3500 each.
How many of each unit should be built by the theatre company and how many units should be rented to minimize costs?
Thapar theatre company needs to determine the lowest cost production budget for an upcoming theatre show. Specifically, they will have to determine the lowest which set pieces to construct and which pieces must be rented from another company at a pre-determined fee. The time available for constructing the set is two weeks after which rehearsals commence. To construct the set, the theatre has two part-time carpenters who work upto 12 hours a week and each at Rs 100 per hour. Additionally, the scene artist can work 15 hours per week at Rs 150 per hour
The set design requires 20 walls, 2 hanging drops with pained scenery and 3 large wooden tables serving as props. The number of hours required for each piece for carpentry and painting is given below.
| Carpentry | Painting | |
| Flats | 0.5 | 2.0 |
| Hanging Drops | 2.0 | 3.0 |
| Wooden Tables(props) | 3.0 | 4.0 |
How many of each unit should be built by the theatre company and how many units should be rented to minimize costs?
