$(1)$

Required Information

Excel Analytics $09-01($Static$)$ Flexible Budget Performance Analysis $[$LO$9-2,$ LO$9-3,$ LO$9-5,$ LO$9-6]$

To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to complete requirements $1$ through $9$ in Part $1$ of this exercise. In Part $2,$ you will upload your completed workbook.

Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then use what you leamed to work directly in Excel to answer the required questions in Connect.

$[$The following information applies to the questions displayed below.$]$

The Munchkin Theater is a nonprofit organization devoted to staging plays for children. The theater has a very small fulltime professional administrative staff. Through a special arrangement with the actors' union, actors and directors rehearse without pay and are paid only for actual performances.

The Munchkin Theater has asked for your help in preparing a Planning budget at the beginning of the year and evaluating actual expenses at the end of the year. The theater expects to put on five different productions with a total of $60$ performances. For example, one of the productions is Peter Rabbit, which had been budgeted for five performances. After interviewing various people affiliated with the theater you have developed the following estimated cost formulas for each of the eight expenses that will be included in your Planning budget:

$\backslash$table$[[,\backslash$table$[[$Per$],[$Production$]],\backslash$table$[[$ost formulas$],[$Per$],[$Performance$]],$Fixed$],[\backslash$table$[[$Actors$\text{'}$ and directors' wages$],[$Stagehands$\text{'}$ wages$],[$Ticket booth personnel and ushers' wages$],[$Scenery$,$ costumes, and props$],[$Theater hall rent$],[$Printed programs$],[$Publicity$],[$Administrative expenses$]],$$$8,600,\backslash$table$[[$$$2,400$