Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data table A B C D E F '1 Water Land Flexible Budget Performance Report: Sales and Operating Expenses 3 For the Year Ended April
Data table A B C D E F '1 Water Land Flexible Budget Performance Report: Sales and Operating Expenses 3 For the Year Ended April 30 Flexible Budget Flexible Volume Master 4 Actual Variance Budget Variance Budget 5 Sales volume {number of pools installed] 5 ? ? ? 4 5 Sales revenue $ 100,000 '9 $ 105,000 ? $ 84,000 7 Operating expenses: 3 Variable expenses 35 62,000 $ 05,000 3 52,000 9 Fixed expenses 25,000 20,300 29,300 10 Total operating expenses ? ? ? ? ? The following is a partially completed performance report for Water Land. (Click the icon to view the information.) - X Requirements Read the requirements. 1. How many pools did Water Land originally think it would install in April? 2. How many pools did Water Land actually install in April? 1. How many pools did Water Land originally think they would install in April? 3. How many pools is the flexible budget based on? Why? 4. What was the budgeted sales price per pool? 5. What was the budgeted variable cost per pool? The that Water Land planned to sell pools in April. 6. Define the flexible budget variance. What causes it? 7. Define the volume variance. What causes it? 2. How many pools did Water Land actually install in April? 8. Fill in the missing numbers in the performance report. The that Water Land installed pools in April. 3. How many pools is the flexible budget based on? Why? Print Done The flexible budget for performance reports is always based on the output for the month. This is done so that managers can compare meaning they can compare to Therefore, Water Land's flexible budget is based on pools . What was the budgeted sales price per pool? (Round your answer to the nearest whole dollar.) The budgeted sales price is per pool. 5. What was the budgeted variable cost per pool? (Round your answer to the nearest whole dollar.)5. What was the budgeted variable cost per pool? (Round your answer to the nearest whole dollar.) The budgeted variable cost is per pool. 6. Define the flexible budget variance. What causes it? As the name suggests, the flexible budget variance is the difference between the and the Since the and the are based on of output, this variance highlights unexpected revenues and expenses that are caused by factors other than 7. Define the volume variance. What causes it? The volume variance is the difference between the and the . The only difference between these two budgets is the V Therefore, the volume variance is caused by differences between 8. Fill in the missing numbers in the performance report. Be sure to indicate whether variances are favorable (F) or unfavorable (U). (Enter the variances as positive numbers. Label each variance as favorable (F) or unfavorable (U). If the variance s 0, make sure to enter in a "0". A variance of zero is considered favorable.)Water Land Flexible Budget Performance Report: Sales and Operating Expenses For the Year Ended April 30 Output units [pools installed} Sales revenue Operating expenses: Variable expenses Fixed expenses Total operating expenses Flexible Budget Flexible Actual Variance Budget Volume Variance Master Budget 5 I I 4 3 100.000 $ 105.000 3 84.000 62.000 I 65.000 I 52.000 25.000 I 29.300 I 29.300
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