Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:
Vulcan Flyovers | ||||||
Operating Data | ||||||
For the Month Ended July 31 | ||||||
Actual Results |
Flexible Budget |
Planning Budget |
||||
Flights (q) | 60 | 60 | 58 | |||
Revenue ($345.00q) | $ | 16,500 | $ | 20,700 | $ | 20,010 |
Expenses: | ||||||
Wages and salaries ($3,300 + $88.00q) | 8,544 | 8,580 | 8,404 | |||
Fuel ($33.00q) | 2,144 | 1,980 | 1,914 | |||
Airport fees ($820 + $32.00q) | 2,590 | 2,740 | 2,676 | |||
Aircraft |
540 | 540 | 522 | |||
Office expenses ($240 + $1.00q) | 468 | 300 | 298 | |||
Total expense | 14,286 | 14,140 | 13,814 | |||
Net operating income | $ | 2,214 | $ | 6,560 | $ | 6,196 |
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.)
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- Wages and salaries Jake's Roof Repair provided the following data concerning its costs: Cost per Repair-Hour $ 15.00 Fixed Cost per Month $ 21,100 Parts and supplies $ 7.40 Equipment depreciation $ 2,750 $ 0.55 Truck operating expenses $ 5,730 $ 1.70. Rent $ 4,690 Administrative expenses $ 3,850 $ 0.70 For example, wages and salaries should be $21,100 plus $15.00 per repair-hour. The company expected to work 2,600 repair-hours in May but actually worked 2,500 repair-hours. The company expects its sales to be $47.00 per repair-hour. Required: Compute the company's activity variances for May. Note: 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. Required: Compute the company's activity variances for May. Note: 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…arrow_forwardVaughn Security Inc. provides security guard services to shopping malls. Data related to Vaughn's overhead costs for the current year are as follows: Head Office Activity Total Overhead Cost Supervision Technology fees Rent/Utilities/Taxes Total Cost Driver Activity. $133000 # of employees 70 62000 computer hours 2000 40000 direct labour hours 160000 $235000 During the year, Vaughn provided security services to the Cullumber Creek Mall including 3 employees, 120 computer hours and 10400 labour hours. Overhead applied to the Cullumber Creek Mall job for the year using ABC is O $9420.00. ○ $6320.00. ○ $12020.00. ○ $1931.25.arrow_forwardThe Cheyenne Hotel in Big Sky, Montana, recorded its total electrical costs and number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month January February March April May June July August September October November December Occupancy- Days 3,250 3,470 3,660 1,760 1,350 4,350 3,280 1,610 700 1,300 1,640 2,220 Electrical Costs $ 9,660 $ 10,185 $ 10,360 $ 6,160 $ 4,725 $ 11,575 $ 9,765 $ 5,635 $ 2,450 $ 4,550 $5,740 $ 7,770 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. Note: Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount. Variable cost of electricity Fixed cost of electricity X Answer is complete but not entirely correct. $ 3.50 x per…arrow_forward
- answer in text form please (without image)arrow_forwardScatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Will County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations: Month April May June July August September October Miles Mowed Labor and Cleaned Costs 350 $4,000 300 3,750 400 4,500 250 2,750 375 4,250 200 2,500 100 2,400 Use the information from the high- and low-volume months to develop a cost-estimating equation for monthly labor costs. Monthly labor costs = $ 1,700 + $ 7 X Plot the data on a scatter diagram. Using the information from representative high- and low volume months, use the high-low method to develop a cost- estimating equation for monthly labor costs. Monthly labor costs $ 0 + $ ox Adjust the equation developed in requirement (b) to…arrow_forwardYou have collected the following information about activity and costs - Activity - Machine Cost - Utilities Month Hours 2,400 2,600 $18,500 $19,750 March April May 2,900 $23,740 $25,500 $18,350 $17,290 $17,150 $25,200 $24,100 June 3,100 July August September 1,950 3,150 2,100 1,900 October November 3,000 Using the High-Low method, calculate the variable cost per machine hour to the nearest penny.arrow_forward
- B-You is a consulting firm that works with managers to improve their interpersonal skills. Recently, a representative of a high-tech research firm approached B-You's owner with an offer to contract for one year with B-You to improve the interpersonal skills of a newly hired manager. B-You reported the following costs and revenues during the past year (before the proposed contract). B-YOU Annual Income Statement Sales revenue $ 560,000 Costs Labor 260,000 Equipment lease 42,000 Rent 35,000 Supplies 30,000 Officers' salaries 160,000 Other costs 20,000 Total costs $ 547,000 Operating profit (loss) $ 13,000 If B-You decides to take the contract to help the manager, it will hire a full-time consultant at $85,500. The equipment lease will increase by 20 percent. Supplies will increase by an estimated 10 percent and other costs by 15 percent. The existing building has space for the new consultant. No new offices will be necessary for this work.arrow_forwardNaper Inc. manufactures power equipment. Naper has two primary products-generators and air compressors. The following report was prepared by the controller for Naper's senior marketing management for the year ended December 31: Generators Air Compressors Total $ 4,200,000 (2,940,000) $ 1,260,000 $ 3,000,000 $ 7,200,000 (5,040,000) $ 2,160,000 (610,000) $ 1,550,000 Revenue Cost of goods sold Gross profit Selling and administrative expenses Operating income (2,100,000) $ 900,000 The marketing management team was concerned that the selling and administrative expenses were not traced to the products. Marketing management believed that some products consumed larger amounts of selling and administrative expense than did other products. To verify this, the controller was asked to prepare a complete product profitability report, using activity-based costing. The controller determined that selling and administrative expenses consisted of two activities: sales order processing and post-sale…arrow_forwardNeed help with this problem (number 27). Need help with the blank data. Thanks!arrow_forward
- 44) Same information as before - You have collected the following information about activity and costs - Activity - Machine Cost - Utilities Month Hours March 2,400 $18,500 2,600 $19,750 April May 2,900 $23,740 $25,500 $18,350 $17,290 June 3,100 July August September 1,950 October 2,100 1,900 $17,150 3,150 $25,200 November 3,000 $24,100 Using the High-Low method and your answers from the two previous questions, what is the estimated cost for December if the machines run for 2,550 hours ?arrow_forwardThe Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 3,180 $ 6,510 February 2,920 $ 6,261 March 3,780 $ 7,392 April $ 5,569 May $ 1,820 June 2,050 $ 5,261 July 4,050 $ 7,829 August 4,070 $ 7,896 September 1,780 $ 4,984 October 570 $ 1,596 $4,424 $5,908 Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. 2,160 650 November 1,580 December 2,680arrow_forwardOnly typed solutionarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education