Question

In: Accounting

A community playhouse needs to determine the​ lowest-cost production budget for an upcoming show. They have...

A community playhouse needs to determine the​ lowest-cost production budget for an upcoming show. They have to determine which set pieces to construction and which to rent. The organization has only two weeks to construct the set. The theater has two carpenters who work up to 12 hours a​ week, each at ​$12 an hour.​ Additionally, the theater has a scenic artist who can work 15 hours per week to paint as needed at ​$14 per hour. The set needs 20 flats​ (walls), two hanging​ drops, and three wooden tables​ (props). The number of hours required for each piece for carpentry and painting is shown below.​ Flats, hanging​ drops, and props can also be rented at a cost of ​$75​, ​$500​, and ​$400 ​each, respectively. How many of each unit should be built by the theater and how many should be rented to minimize total​ cost?

Carpentry

Painting

Flats

0.5

2.0

Hanging Drops

3.0

12.0

Props

2.0

4.0

The optimal integer solution is to build __ flat(s) and rent __ ​flat(s); build __hanging​ drop(s) and rent __hanging​ drop(s); build __prop(s) and rent__ prop(s). This solution gives the ▼(minimum, maximum) ​cost, which is ​$__.

Solutions

Expert Solution

Firstly, the decision has to be taken whether it has to be taken on rent or to be constructed. Since, there are both time as well as workforce constraints we have to decide whether it would be constructed or to be taken on rent.

Particulars Flats Hanging Drops Props
Taken on rent 75 500 400
If constructed
Carpenter Cost 6 36 24
Painting Cost 28 168 56
Total Cost (if Constructed) 34 204 80
Savings 41 296 320

Since, in all the above coonstruction leads to lowest cost, we have to go for construction.

Computation of Carpentary Hours required (If all are constructed)
Particulars No of units required Hrs required per Unit Total Hours
Flats 20 0.5 10
Hanging Drops 2 3 6
Props 3 2 6
Total 22

Available is 12hrs*2person*2weeks = 48 Hours. So, this is not a constraint

Computation of Painting Hours required (If all are constructed)
Particulars No of units required Hrs required per Unit Total Hours
Flats 20 2 40
Hanging Drops 2 12 24
Props 3 4 12
Total 76

Available is 15hrs*1person*2weeks = 30hrs. Therefore, painting is a constraint resource. So we have to use this constraints in a beneficial manner by computing per unit savings of constraint hour if construced. Computation is as follows:

Particulars Flats Hanging Drops Props
Savings if constructed 41 296 320
Painting hours required/unit 2 12 4
Savings / painting hour 20.5 25 80
Ranking based on constraint 3rd 2nd 1st

Alloction of Constraint Resources

Total Painting Hours available 30
Utilized for Props (4*3) 12
Balance 18
For Hanging Drops (N-1) 12
Balance 6
For Flats (2*3) 6
Balance 0

N-1. 18hrs cannot be sufficient for 2 hanging drops. So one can be constructed and the other will be taken on rent. For the balance of 6 Hrs, 3 flats can be constructed. Therefore Solution is as follows:

Particulars Constructed Rent Cost for constructed units* Cost for rented units* Total cost
Flats 3 17 102 1275 1377
Hanging Drops 1 1 204 500 704
Props 3 0 240 0 240
Total Cost 546 1775 2321

* per unit cost taken from 1st table.

Lowest Cost for upcoming show is $. 2321


Related Solutions

The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming...
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...
The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming...
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...
5. The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an...
5. 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...
Thapar theatre company needs to determine the lowest cost production budget for an upcoming theatre show.
  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...
Would a firework show pass a cost benefit analysis for a community? The cost of fireworks...
Would a firework show pass a cost benefit analysis for a community? The cost of fireworks would be around $900 dollars. Explain. The decision will be voted on.
The treasurer of Parkland Community Hospitals needs to determine the present value of a one-time $1,200,000...
The treasurer of Parkland Community Hospitals needs to determine the present value of a one-time $1,200,000 investment at the end of year 7. The discount rate is 3% compounded annually, what is the present value? $109,400 $882,000 $821,780 $975,710 A B&B Health Plan divisional project has the following financial information: Revenue: $240,000 Variable Costs: $95,000 Avoidable Fixed Costs: $110,000 Unavoidable Fixed Costs: $60,000 How much is the project's Product Margin? $35,000 -$15,000 $55,000 -$25,000 The Chief Financial Officer of UTSW...
) The Blue Ridge Company is preparing its 3rd Quarter budget. Its production budget show that...
) The Blue Ridge Company is preparing its 3rd Quarter budget. Its production budget show that the           required production in unit is:                July              40,000              August         50,000                September    30,000                October       20,000 Each unit of finished goods requires 3 lbs. of direct materials. Each pound of material cost $5.00 per lbs. The company’s policy for ending inventory for direct materials is that the end-of-the-month inventory levels for direct materials will...
You have conducted Community Needs Assessment (Community Diagnosis) in Sunyani West District. After prioritizing the problems...
You have conducted Community Needs Assessment (Community Diagnosis) in Sunyani West District. After prioritizing the problems with the community members, high HIV prevalence rate of 2.5% became a priority health problem in the community. You went further to conduct Knowledge, Attitude and Practice (KAP) study on HIV/AIDS in the district. Now you intend to prepare a one-year Health Promotion Programme to tackle the problem. As part of the planning process and based on some assumptions of findings in your KAP...
COST OF CAPITAL ASSIGNMENT STEPHANIE’S CAJUN FOODS, INC NEEDS TO DETERMINE THEIR COST OF CAPITAL FOR...
COST OF CAPITAL ASSIGNMENT STEPHANIE’S CAJUN FOODS, INC NEEDS TO DETERMINE THEIR COST OF CAPITAL FOR CAPITAL BUDGETING PURPOSES. THEY HAVE ASSEMBLED THE FOLLOWING INFORMATION: MARKET PRICE OF OUTSTANDING BONDS                                                                         95 COUPON RATE – SEMI-ANNUAL PAYMENTS                                                               11.0% MATURITY VALUE                                                                                                             $ 1,000 YEARS TO MATURITY                                                                                                              25 FLOTATION COSTS                                                                                                                  2% CORPORATE TAX RATE                                                                                                        21% MARKET PRICE OF OUTSTANDING PREFERRED                                                       $      50 PAR VALUE                                                                                                                          $      25 DIVIDEND...
COST OF CAPITAL ASSIGNMENT STEPHANIE’S CAJUN FOODS, INC NEEDS TO DETERMINE THEIR COST OF CAPITAL FOR...
COST OF CAPITAL ASSIGNMENT STEPHANIE’S CAJUN FOODS, INC NEEDS TO DETERMINE THEIR COST OF CAPITAL FOR CAPITAL BUDGETING PURPOSES. THEY HAVE ASSEMBLED THE FOLLOWING INFORMATION: MARKET PRICE OF OUTSTANDING BONDS                                                                        95 COUPON RATE – SEMI-ANNUAL PAYMENTS                                                              11.0% MATURITY VALUE                                                                                                            $ 1,000 YEARS TO MATURITY                                                                                                             25 FLOTATION COSTS                                                                                                                  2% CORPORATE TAX RATE                                                                                                        21% MARKET PRICE OF OUTSTANDING PREFERRED                                                       $      50 PAR VALUE                                                                                                                         $      25 DIVIDEND (PERCENTAGE OF PAR)                                                                                   10%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT