Required information

Skip to question

[The following information applies to the questions displayed below.] The River Valley Orchestra, which is managed by a small number of full-time professional administrative staff, performs ensemble orchestra shows throughout the year. Its conductor and musicians rehearse without pay and are only paid for actual performances. The River Valley Orchestra 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 orchestra plans to have one production for each season (Spring, Summer, Winter, and Fall) with a total of 22 performances. For example, for the Summer production (a focus on classical music in films) they plan on having six performances. After interviewing various people affiliated with the orchestra you have developed the following cost formulas for each of the eight expenses that will be included in the planning budget:

	Cost Formulas
	Per Production	Per Performance	Fixed
Conductor and musicians wages		$ 6,600
Stagehands wages		$ 850
Ticket booth personal and ushers wages		$ 410
Scenery and wardrobe	$ 9,400
Orchestra venue rent		$ 1,800
Printed programs		$ 425
Publicity	$ 4,500
Administrative expenses	$ 1,400	$ 96	$ 39,500

By the end of the year, The River Valley Orchestra actually put on four productions and a total of 26 performances. The actual expenses incurred during the year were as follows:

	Amount
Conductor and musicians wages	$ 175,700
Stagehands wages	20,200
Ticket booth personal and ushers wages	11,200
Scenery and wardrobe	40,900
Orchestra venue rent	44,700
Printed programs	10,700
Publicity	21,600
Administrative expenses	46,300
Conductor and musicians wages	$ 371,300

Download the Excel file, which you will use to create some Tableau visualizations that compare the planning budget to the actual results.

Upload the Excel file into Tableau by doing the following:

1. Open the Tableau Desktop application.
2. On the left-hand side, under the Connect header and the To a file sub-header, click on Microsoft Excel.
3. Choose the Excel file and click Open.
4. Since the only worksheet in the Excel File is Performance Report it will default as a selection with no further import steps needed

Create a bar chart that compares the actual expenses to the planning budget and the flexible budget:

• Double click on new sheet at the bottom of the workbook and change the name of the newly created Sheet 1 to Actual vs. Budgeted Expenses
• On the left-hand side under Dimensions (sometimes labeled as Tables), double-click on Expense
• On the left-hand side under Measures, double click on Actual Results
• On the left-hand side under Measures, double click on Flexible Budget
• On the left-hand side under Measures, double click on Planning Budget
• In the upper right-hand corner, click on Show Me and choose the Side-by-side (bars) option in the 3rd column third row down.
• To better see the labels, in the top row of buttons, choose the Swap Rows and Columns button ()
• Right-click on the x-axis where it says Value and choose Edit Axis
  • In the Axis Titles section modify the title from Value To Amount and then close out of the window
• To improve viewing, locate the Standard dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose Entire View.
• Your visualization should appear as follows:

Required: (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 1a. Which of the following statements is true with respect to the bar chart that you just created?

check all that apply 1

• The actual amount of the conductor and musicians wages exceeds the amount in the planning budget.unanswered
• The actual amount of the conductor and musicians wages exceeds the amount that would be expected for the actual level of activity.unanswered
• The conductor and musicians wages in the flexible budget exceeds the corresponding amount in the planning budget.unanswered
• The conductor and musicians wages in the planning budget exceeds the corresponding amount in the flexible budget.unanswered

1b. Which of the following statements is true with respect to the bar chart that you just created? check all that apply 2

• The scenery and wardrobe expense in the flexible budget equals the corresponding amount in the planning budget, thereby suggesting that the cost driver for this expense is number of productions.unanswered
• The scenery and wardrobe expense in the flexible budget equals the corresponding amount in the planning budget, thereby suggesting that the cost driver for this expense is number of performances.unanswered
• The scenery and wardrobe expense in the flexible budget equals the corresponding amount in the planning budget, thereby suggesting that the cost drivers for this expense include number of productions and number of performances.unanswered
• The scenery and wardrobe expense in the flexible budget equals the corresponding amount in the planning budget, thereby suggesting that this expense is a fixed cost.unanswered

1c. Which of the following statements is true with respect to the bar chart that you just created? check all that apply 3

• The actual amount of ticket booth personnel and ushers wages is greater than the planning budget, but less than the flexible budget.unanswered
• The actual amounts of stagehands wages and printed programs are both greater than the amounts expected according to the flexible budget.unanswered
• The actual amounts of orchestra venue rent and publicity both exceed their corresponding amounts in the flexible budget.unanswered
• The administrative expenses is the only one of eight expenses where the actual amount of the expense is less than the planning and flexible budgets.