Question: Can someone please share the excel file for this problem, The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an

Can someone please share the excel file for this problem,

The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming show. Specifically, they have to determine which set pieces to construct and which, if any, set pieces to rent from another local theater at a predetermined fee. However, the organization has only two weeks to fully construct the set before the play goes into technical rehearsals. The theater has two part-time carpenters who work up to 12 hours a week each at $10 an hour. Additionally, the theater has a part-time scenic artist who can work 15 hours per week to paint the set and props as needed at a rate of $15 per hour. The set design requires 20 flats (walls), 2 hanging drops with painted scenery, and 3 large wooden tables (props). The number of hours required for each piece for carpentry and painting is shown below:

Carpentry Painting Flats 0.5 2.0 Hanging Drops 2.0 12.0 Props 3.0 4.0

Flats, hanging drops, and props can also be rented at a cost of $75, $400, and $250 each, respectively. How many of each unit should be built by the theater and how many should be rented to minimize total costs?

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!