Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Thanks for the help! This is all apart of ONE question so you can answer all parts. (It's not 720 btw) Please don't answer if
Thanks for the help! This is all apart of ONE question so you can answer all parts.
(It's not 720 btw)
Please don't answer if you're not going to answer ALL parts, if answer has only some parts I WILL down vote, however, if the answer consists all parts, I will up vote :)
Exercise 9-1 Prepare a Flexible Budget (LO9-1) Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the Month Ended May 31 Budgeted diving-hours (9) 358 $154,00 Revenue ($440.809) Expenses: Wages and salaries ($11,880 + $128.809) Supplies ($4.899) Equipment rental ($2,500 + $24.99) Insurance ($3,900) Miscellaneous ($520 + $1.449) Total expense 56, 600 1,400 19,900 3,9ee 1.824 73,824 $ 88,176 Net operating income During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) Puget Sound Divers Flexible Budget For the Month Ended May 31 Revenue Expenses: Wages and salaries Supplies Equipment rental Insurance Miscellaneous Total expense Net operating income S (720) Flight Caf prepares In-flight meals for airlines in its kitchen located next to a local alrport. The company's planning budget for July appears below: Flight Caf Planning Budget For the Month Ended July 31 Budgeted meals (9) 21,200 $92,400 Revenue ($4.489) Expenses: Raw materials ($1.999) Wages and salaries ($6,388 + $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,700) Insurance ($2,200) Miscellaneous ($700 + $0.109) Total expense Net operating income 39.900 10,500 2,950 3,709 2,200 2,800 62.50 $30, 350 In July, 22,000 meals were actually served. The company's flexible budget for this level of activity appears below: Flight Caf Flexible Budget For the Month Ended July 31 Budgeted meals (9) 22,000 $96,800 Revenue ($4.489) Expenses: Raw materials ($1.999) Wages and salaries ($6,388+ $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,700) Insurance ($2,200) Miscellaneous ($780 + $0.199) Total expense Net operating income 41,800 10,700 3,000 3,700 2, 2ee 2,900 64,300 $32,500 Required: 1. Calculate the company's activity varlances for July. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Flight Caf Activity Variances For the Month Ended July 31 Revenue Expenses: Raw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating income Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,200 pounds of oysters in August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (9) 7,200 $ 29,880 Revenue ($4.159) Expenses: Packing supplies ($0.259) Oyster bed maintenance ($3,480) Wages and salaries ($2,288 + $0.409) Shipping ($0.759) Utilities ($1,290) Other ($450 + $0.019) Total expense Net operating income 1,800 3,4ee 5,080 5, 4ee 1,290 522 17,492 $ 12,388 The actual results for August appear below: Quilcene Oysteria Income Statement For the Month Ended August 31 Actual pounds 7,200 $ 27,000 Revenue Expenses: Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense Net operating income 1,970 3,260 5.499 5,130 1,100 1, 142 18,092 $ 8.98 Required: Calculate the company's revenue and spending varlances for August. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Quilcene Oysteria Revenue and Spending Variances For the Month Ended August 31 Revenue Expenses: Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense Net operating income Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] 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 61 Flexible Planning Budget Budget 61 59 Flights (9) $ 16,200 $ 21,655 $ 20,945 Revenue ($355.00) Expenses: Wages and salaries ($3,588 + $87.289) Fuel ($33.899) Airport fees ($830 + $35.809) Aircraft depreciation ($18.889) Office expenses ($218 + $1.889) Total expense 8,773 2,177 2,860 610 439 14,859 1,341 $ 8,807 8,633 2, 013 2,013 1,947 2,9652,895 610 598 271 269 14,666 14,334 6,989 $ 6,611 $ Net operating income 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 varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Vulcan Flyovers Flexible Budget Performance Report For the Month Ended July 31 Flexible Budget Actual Results Planning Budget Flights Revenue $ 16.2001 21,655 20,945 Expenses: Wages and salaries Fuel 8.773 2,177 8,633 1.947 2.860 2,895 Airport fees Aircraft depreciation 8,807 2,013 2,965 610 271 14,866 6,989 500 610 439 14,859 1,341 | Office expenses Total expense 269 14,334 6,611 Net operating income $ $ $ Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has Identified two cost drivers-the number of cruises and the number of passengers-that It uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 86 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Cruise $ 477.88 Cost per Passenger $ 3.20 Vessel operating costs Advertising Administrative costs Insurance Fixed cost per Month $ 6,500 $ 2,400 $5,300 3.300 $ 39.89 $ 1.50 For example, vessel operating costs should be $6.500 per month plus $477.00 per cruise plus $3.20 per passenger. The company's sales should average $32.00 per passenger. In July, the company provided 59 cruises for a total of 3.150 passengers. Required: Prepare the company's flexible budget for July Alyeski Tours Flexible Budget For the Month Ended July 31 Revenue Expenses: Vessel operating costs Advertising Administrative costs Insurance Total expense Net operating income Exercise 9-1 Prepare a Flexible Budget (LO9-1) Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the Month Ended May 31 Budgeted diving-hours (9) 358 $154,00 Revenue ($440.809) Expenses: Wages and salaries ($11,880 + $128.809) Supplies ($4.899) Equipment rental ($2,500 + $24.99) Insurance ($3,900) Miscellaneous ($520 + $1.449) Total expense 56, 600 1,400 19,900 3,9ee 1.824 73,824 $ 88,176 Net operating income During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) Puget Sound Divers Flexible Budget For the Month Ended May 31 Revenue Expenses: Wages and salaries Supplies Equipment rental Insurance Miscellaneous Total expense Net operating income S (720) Flight Caf prepares In-flight meals for airlines in its kitchen located next to a local alrport. The company's planning budget for July appears below: Flight Caf Planning Budget For the Month Ended July 31 Budgeted meals (9) 21,200 $92,400 Revenue ($4.489) Expenses: Raw materials ($1.999) Wages and salaries ($6,388 + $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,700) Insurance ($2,200) Miscellaneous ($700 + $0.109) Total expense Net operating income 39.900 10,500 2,950 3,709 2,200 2,800 62.50 $30, 350 In July, 22,000 meals were actually served. The company's flexible budget for this level of activity appears below: Flight Caf Flexible Budget For the Month Ended July 31 Budgeted meals (9) 22,000 $96,800 Revenue ($4.489) Expenses: Raw materials ($1.999) Wages and salaries ($6,388+ $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,700) Insurance ($2,200) Miscellaneous ($780 + $0.199) Total expense Net operating income 41,800 10,700 3,000 3,700 2, 2ee 2,900 64,300 $32,500 Required: 1. Calculate the company's activity varlances for July. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Flight Caf Activity Variances For the Month Ended July 31 Revenue Expenses: Raw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating income Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,200 pounds of oysters in August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (9) 7,200 $ 29,880 Revenue ($4.159) Expenses: Packing supplies ($0.259) Oyster bed maintenance ($3,480) Wages and salaries ($2,288 + $0.409) Shipping ($0.759) Utilities ($1,290) Other ($450 + $0.019) Total expense Net operating income 1,800 3,4ee 5,080 5, 4ee 1,290 522 17,492 $ 12,388 The actual results for August appear below: Quilcene Oysteria Income Statement For the Month Ended August 31 Actual pounds 7,200 $ 27,000 Revenue Expenses: Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense Net operating income 1,970 3,260 5.499 5,130 1,100 1, 142 18,092 $ 8.98 Required: Calculate the company's revenue and spending varlances for August. (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Quilcene Oysteria Revenue and Spending Variances For the Month Ended August 31 Revenue Expenses: Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense Net operating income Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4] 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 61 Flexible Planning Budget Budget 61 59 Flights (9) $ 16,200 $ 21,655 $ 20,945 Revenue ($355.00) Expenses: Wages and salaries ($3,588 + $87.289) Fuel ($33.899) Airport fees ($830 + $35.809) Aircraft depreciation ($18.889) Office expenses ($218 + $1.889) Total expense 8,773 2,177 2,860 610 439 14,859 1,341 $ 8,807 8,633 2, 013 2,013 1,947 2,9652,895 610 598 271 269 14,666 14,334 6,989 $ 6,611 $ Net operating income 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 varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts as positive values.) Vulcan Flyovers Flexible Budget Performance Report For the Month Ended July 31 Flexible Budget Actual Results Planning Budget Flights Revenue $ 16.2001 21,655 20,945 Expenses: Wages and salaries Fuel 8.773 2,177 8,633 1.947 2.860 2,895 Airport fees Aircraft depreciation 8,807 2,013 2,965 610 271 14,866 6,989 500 610 439 14,859 1,341 | Office expenses Total expense 269 14,334 6,611 Net operating income $ $ $ Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has Identified two cost drivers-the number of cruises and the number of passengers-that It uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 86 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Cruise $ 477.88 Cost per Passenger $ 3.20 Vessel operating costs Advertising Administrative costs Insurance Fixed cost per Month $ 6,500 $ 2,400 $5,300 3.300 $ 39.89 $ 1.50 For example, vessel operating costs should be $6.500 per month plus $477.00 per cruise plus $3.20 per passenger. The company's sales should average $32.00 per passenger. In July, the company provided 59 cruises for a total of 3.150 passengers. Required: Prepare the company's flexible budget for July Alyeski Tours Flexible Budget For the Month Ended July 31 Revenue Expenses: Vessel operating costs Advertising Administrative costs Insurance Total expense Net operating incomeStep 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