Answered step by step
Verified Expert Solution
Question
1 Approved Answer
asap plz 1 BTA 9 - 300 C Hudgeted Expenses for SETU ---- 60 DO Y.. ATCI 1 Fixed Expenses . Hinti Allo e 1
asap plz
1 BTA 9 - 300 C Hudgeted Expenses for SETU ---- 60 DO Y.. ATCI 1 Fixed Expenses . Hinti Allo e 1 Hintharel 10 per + Expense Type 1 in Kind Donations (The sandwiches from Russo Farma 2. Royalty fees Black box 4 One time setup fee 5 Sound system 6 Sound system overrun 7 Church rental 8 Advertising 9 Printing cost 10 Samosas c Budgeted Amount $300 $200 51.000 $30 $300 $200 5300 $360 5150 5275 53,115 Hintave the "Acta 10 12 11 Total Fored Expenses 13 VE Variable Expensets Per Show Expense Type Technical support and lighting fees 25ound technician 3 Stare Manager Budget Amount $30 530 560 $150 18 Total Variable Expenses. Per Show 30 5356 TH Total Expenses Per Show Total Expenses For 3 Shows Total Expenses for 4 Shows 53,715 21 IT 10 0 Fixed Income Budgeted Amount 2 3 4 5 6 7 Income Type 1 In-Kind Donations 2 Cash Donations Total Fixed Income $300 $200 $500 Variable Income Budgeted Amount Income Type 1 Income from Adult Ticket Sales 2 Income from Student and Senior Ticket Sales 0 $1.575 $594 $2,169 10 Total Variable income 11 12 13 14 15 16 Total Ticket Income Per Show Total Ticket Income for 3 Shows Total Ticket Income for 4 Shows $2,169 $6,507 $8,676 17 18 19 20 21 22 23 24 25 Percent of Tickets Sold Per Show Break Even Point In Dollars 2b 2c. 2d. 2e. Break Even Point in Tickets Assuming 4 shows Assuming 3 shows Assuming 4 shows with $500 Income donation Assuming 3 shows with $500 income donation 2a is what you did in all of Case 1a. You don't need to worry about doing that one since you already did it. That's why there is nothing on this Excel Worksheet explictly asking for those answers that you will need to calculate for this one so keep the actual case handy and give it a second read 21 Comment on the feasibility of the required number of ticket sales computed from above, keeping in mind the nature of the play, that it is staged by a community theater organization, and the ethnicity aspect. Suggest ways for SETU to achieve the necessary amount of ticket sales, Is all your text on one single line stretching out forever? Click the "wrap text" button to make it fit into the cell. Otherwise it will look like this cell and the text will spill out for Where is the "wrap text" button? See the white drop down menu at the top center of the "home" tab of Excel? it probably says "General" in it, but it might say something else like "Accounting. The wrap text button says "abc" with an arrow on it. It's directly to the left of the white drop down menu on the most current version of Excel. The button location can differ depending on your version though. If you type "wrap text into the help box Excel will help you find the button. If you click "wrap text"Your answer will be in a nice little paragraph like this cell Excel doesn't spell check automatically like word does' - to spell check your answer click tools" at the top and then click "spelling I don't grade for spelling, but also don't want you to turn in an answer that's so full of typos I can't understand what you are trying to say. Plus there are four of your one of you can proofread it! :) Expenses Expense Type 2 Budgeted Amount Please notel You are on your own here. Uoll Total Fired Expenses SO 36. Total Expenses Per Show Total Expenses For 3 Shows Total Expenses for 4 Shows Break Even Point in Tickets Percent of Tickets sold Per Show Break Even Point In Dollars 3c. Revised Answers for b E d Please explain if your calculations in 3c are feasible for the theatre company in this box 3c. C D Occupancy 65% 50% 80% Calculate breakeven Number of tickets sold Total box office and facility fee per ticket Weighted average contribution margin per ticket needed without $500 income donation Weighted average price per ticket needed without $500 Income donation Weighted average contribution margin per ticket needed with $500 income donation Weighted average price per ticket needed with donation with S500 Income donation 1 BTA 9 - 300 C Hudgeted Expenses for SETU ---- 60 DO Y.. ATCI 1 Fixed Expenses . Hinti Allo e 1 Hintharel 10 per + Expense Type 1 in Kind Donations (The sandwiches from Russo Farma 2. Royalty fees Black box 4 One time setup fee 5 Sound system 6 Sound system overrun 7 Church rental 8 Advertising 9 Printing cost 10 Samosas c Budgeted Amount $300 $200 51.000 $30 $300 $200 5300 $360 5150 5275 53,115 Hintave the "Acta 10 12 11 Total Fored Expenses 13 VE Variable Expensets Per Show Expense Type Technical support and lighting fees 25ound technician 3 Stare Manager Budget Amount $30 530 560 $150 18 Total Variable Expenses. Per Show 30 5356 TH Total Expenses Per Show Total Expenses For 3 Shows Total Expenses for 4 Shows 53,715 21 IT 10 0 Fixed Income Budgeted Amount 2 3 4 5 6 7 Income Type 1 In-Kind Donations 2 Cash Donations Total Fixed Income $300 $200 $500 Variable Income Budgeted Amount Income Type 1 Income from Adult Ticket Sales 2 Income from Student and Senior Ticket Sales 0 $1.575 $594 $2,169 10 Total Variable income 11 12 13 14 15 16 Total Ticket Income Per Show Total Ticket Income for 3 Shows Total Ticket Income for 4 Shows $2,169 $6,507 $8,676 17 18 19 20 21 22 23 24 25 Percent of Tickets Sold Per Show Break Even Point In Dollars 2b 2c. 2d. 2e. Break Even Point in Tickets Assuming 4 shows Assuming 3 shows Assuming 4 shows with $500 Income donation Assuming 3 shows with $500 income donation 2a is what you did in all of Case 1a. You don't need to worry about doing that one since you already did it. That's why there is nothing on this Excel Worksheet explictly asking for those answers that you will need to calculate for this one so keep the actual case handy and give it a second read 21 Comment on the feasibility of the required number of ticket sales computed from above, keeping in mind the nature of the play, that it is staged by a community theater organization, and the ethnicity aspect. Suggest ways for SETU to achieve the necessary amount of ticket sales, Is all your text on one single line stretching out forever? Click the "wrap text" button to make it fit into the cell. Otherwise it will look like this cell and the text will spill out for Where is the "wrap text" button? See the white drop down menu at the top center of the "home" tab of Excel? it probably says "General" in it, but it might say something else like "Accounting. The wrap text button says "abc" with an arrow on it. It's directly to the left of the white drop down menu on the most current version of Excel. The button location can differ depending on your version though. If you type "wrap text into the help box Excel will help you find the button. If you click "wrap text"Your answer will be in a nice little paragraph like this cell Excel doesn't spell check automatically like word does' - to spell check your answer click tools" at the top and then click "spelling I don't grade for spelling, but also don't want you to turn in an answer that's so full of typos I can't understand what you are trying to say. Plus there are four of your one of you can proofread it! :) Expenses Expense Type 2 Budgeted Amount Please notel You are on your own here. Uoll Total Fired Expenses SO 36. Total Expenses Per Show Total Expenses For 3 Shows Total Expenses for 4 Shows Break Even Point in Tickets Percent of Tickets sold Per Show Break Even Point In Dollars 3c. Revised Answers for b E d Please explain if your calculations in 3c are feasible for the theatre company in this box 3c. C D Occupancy 65% 50% 80% Calculate breakeven Number of tickets sold Total box office and facility fee per ticket Weighted average contribution margin per ticket needed without $500 income donation Weighted average price per ticket needed without $500 Income donation Weighted average contribution margin per ticket needed with $500 income donation Weighted average price per ticket needed with donation with S500 Income donation Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started