Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The River Valley Orchestra, which is managed by a small number of full - time professional administrative staff, performs ensemble orchestra shows throughout the year.
The River Valley Orchestra, which is managed by a small number of fulltime 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 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 $ Stagehands wages $ Ticket booth personal and ushers wages $ Scenery and wardrobe $ Orchestra venue rent $ Printed programs $ Publicity $ Administrative expenses $ $ $ By the end of the year, The River Valley Orchestra actually put on four productions and a total of performances. The actual expenses incurred during the year were as follows: Amount Conductor and musicians wages $ Stagehands wages Ticket booth personal and ushers wages Scenery and wardrobe Orchestra venue rent Printed programs Publicity Administrative expenses Conductor and musicians wages $ Download the Excel file, which you will use to create some Power BI visualizations that compare the planning budget to the actual results. Upload the Excel file into Power BI by doing the following: Use the attached picture to answer the following questions: Required: Note: 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. Which of the following statements is true with respect to the bar chart that you just created? check all that apply The actual amount of the conductor and musicians' wages exceeds the amount in the planning budget. The actual amount of the conductor and musicians' wages exceeds the amount that would be expected for the actual level of activity. The conductor and musicians' wages in the flexible budget exceeds the corresponding amount in the planning budget. The conductor and musicians' wages in the planning budget exceeds the corresponding amount in the flexible budget. Which of the following statements is true with respect to the bar chart that you just created? check all that apply 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. 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. 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. 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. Which of the following statements is true with respect to the bar chart that you just created? check all that apply 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.unanswered
The River Valley Orchestra, which is managed by a small number of fulltime 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 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 $
Stagehands wages $
Ticket booth personal and ushers wages $
Scenery and wardrobe $
Orchestra venue rent $
Printed programs $
Publicity $
Administrative expenses $ $ $
By the end of the year, The River Valley Orchestra actually put on four productions and a total of performances. The actual expenses incurred during the year were as follows:
Amount
Conductor and musicians wages $
Stagehands wages
Ticket booth personal and ushers wages
Scenery and wardrobe
Orchestra venue rent
Printed programs
Publicity
Administrative expenses
Conductor and musicians wages $
Download the Excel file, which you will use to create some Power BI visualizations that compare the planning budget to the actual results.
Upload the Excel file into Power BI by doing the following:
Use the attached picture to answer the following questions:
Required:
Note: 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.
Which of the following statements is true with respect to the bar chart that you just created?
check all that apply
The actual amount of the conductor and musicians' wages exceeds the amount in the planning budget.
The actual amount of the conductor and musicians' wages exceeds the amount that would be expected for the actual level of activity.
The conductor and musicians' wages in the flexible budget exceeds the corresponding amount in the planning budget.
The conductor and musicians' wages in the planning budget exceeds the corresponding amount in the flexible budget.
Which of the following statements is true with respect to the bar chart that you just created?
check all that apply
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.
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.
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.
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.
Which of the following statements is true with respect to the bar chart that you just created?
check all that apply
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.unanswered
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