Vulcan FlyoversOperating DataFor the Month Ended July 31 Actual ResultsFlexible BudgetPlanning BudgetFlights (q)484850Revenue ($320.00q)$ 13,650$ 15,360$ 16,000Expenses:   Wages and salaries ($4,000 + $82.00q)8,4307,9368,100Fuel ($23.00q)1,2601,1041,150Airport fees ($650 + $38.00q)2,3502,4742,550Aircraft depreciation ($7.00q)336336350Office expenses ($190 + $2.00q)460286290Total expense12,83612,13612,440Net operating income$ 814$ 3,224$ 3,560   The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.   Required: 1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Please donot provide solution in image format provide solution in step by step format and fast solu

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
icon
Related questions
icon
Concept explainers
Question

Vulcan Flyovers offers scenic overflights of Mount Saint Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:

 

Vulcan FlyoversOperating DataFor the Month Ended July 31 Actual ResultsFlexible BudgetPlanning BudgetFlights (q)484850Revenue ($320.00q)$ 13,650$ 15,360$ 16,000Expenses:   Wages and salaries ($4,000 + $82.00q)8,4307,9368,100Fuel ($23.00q)1,2601,1041,150Airport fees ($650 + $38.00q)2,3502,4742,550Aircraft depreciation ($7.00q)336336350Office expenses ($190 + $2.00q)460286290Total expense12,83612,13612,440Net operating income$ 814$ 3,224$ 3,560

 

The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.

 

Required:

1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Please donot provide solution in image format provide solution in step by step format and fast solution

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning