Column format answer 
At Disney World in Orlando, Florida there is an outdoor camping facility called Fort Wilderness The Fort sits on a 10,000 wooded-acre site. Disney offers scenic tours around Fort Wilderness using Disney characters. Data for the Fort Wilderness operation appear below: Disney World Amusement Park, Inc. Fort Wilderness Outdoor Facility For the month ended August 31 Actual Results ..50... Flexible Budget .55 Planning Budget Scenic Tours (q)... ....45 $16,200. $14.500 Revenue ($100q)............. $15,000. Expenses: Wages & Salaries ($2,000+$50q)....$7,000.. Gasoline & Oil ($20q)............. ...2,000. Theme Park Tickets ($300+$159).....1,800. Guest Bus Depreciation ($10).........1,000.. Administrative Expenses ($200+$49)....400. Total Expenses...... $12,200 Net Operating Income.. $2,800. $7,800.. .2,200. 2,400. 1,400. 400. $14,200. $2,000. .$6,000 .1,800 ..1,200 .800 .300 $10,100 $4,400 The company measures its activity in terms of scenic tours. Tickets for the scenic tours can be purchased individually, or at a group discount for groups, clubs, etc. Required: 1. Utilizing the format covered in Ch.9, prepare a flexible budget report for August that includes revenue and spending variances and activity variances. (18 points) 2. Which of the variances should be of concern to management? Explain. (2 points) (note: do not spend time re-configuring the flexible budget for "q". Just prepare the columns for the variances.) At Disney World in Orlando, Florida there is an outdoor camping facility called Fort Wilderness The Fort sits on a 10,000 wooded-acre site. Disney offers scenic tours around Fort Wilderness using Disney characters. Data for the Fort Wilderness operation appear below: Disney World Amusement Park, Inc. Fort Wilderness Outdoor Facility For the month ended August 31 Actual Results ..50... Flexible Budget .55 Planning Budget Scenic Tours (q)... ....45 $16,200. $14.500 Revenue ($100q)............. $15,000. Expenses: Wages & Salaries ($2,000+$50q)....$7,000.. Gasoline & Oil ($20q)............. ...2,000. Theme Park Tickets ($300+$159).....1,800. Guest Bus Depreciation ($10).........1,000.. Administrative Expenses ($200+$49)....400. Total Expenses...... $12,200 Net Operating Income.. $2,800. $7,800.. .2,200. 2,400. 1,400. 400. $14,200. $2,000. .$6,000 .1,800 ..1,200 .800 .300 $10,100 $4,400 The company measures its activity in terms of scenic tours. Tickets for the scenic tours can be purchased individually, or at a group discount for groups, clubs, etc. Required: 1. Utilizing the format covered in Ch.9, prepare a flexible budget report for August that includes revenue and spending variances and activity variances. (18 points) 2. Which of the variances should be of concern to management? Explain. (2 points) (note: do not spend time re-configuring the flexible budget for "q". Just prepare the columns for the variances.)
