Exercise 9-1 (Algo) Prepare a Flexible Budget (L09-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) 250 $105,000 Revenue ($420.009) Expenses: Wages and salaries ($11,000 + $128.009) Supplies ($3.009) Equipment rental ($2,400 + $23.009) Insurance ($4,000) Miscellaneous ($530 + $1.509) Total expense Net operating income 43,000 750 8,150 4,000 905 56,805 $ 48,195 During May, the company's actual activity was 240 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 Total expense Net operating income 56,805 $ 48,195 During May, the company's actual activity was 240 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 0 $ 0 2 Exercise 9-2 (Algo) Activity Variances [LO9-2] Flight Caf prepares in-flight meals for airlines in its kitchen located next to a local airport. The company's planning budget for July appears below: Flight Caf Planning Budget For the Month Ended July 31 Budgeted meals (9) Dok 28,000 ant $112,000 int ences Revenue ($4.00) Expenses: Raw materials ($1.909) Wages and salaries ($6,200 + $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,500) Insurance ($2,300) Miscellaneous ($600 + $0.109) Total expense Net operating income 53,200 11,800 3,300 3,500 2,300 3,400 77,500 $ 34,500 In July, 29,000 meals were actually served. The company's flexible budget for this level of activity appears below: Flight Cafe Flexible Budget For the Month Ended July 31 Budgeted meals (9) 29,000 $116,000 Revenue ($4.009) Expenses: Raw materials ($1.909) Wages and salaries ($6,200+ $0.209) Utilities ($1,900 + $0.059) 55,100 12,000 3,350 2 Expenses: Raw materials ($1.909) Wages and salaries ($6,200+ $0.209) Utilities ($1,900 + $0.059) Facility rent ($3,500) Insurance ($2,300) Miscellaneous ($600 + $0.109) Total expense Net operating income 55,100 12,000 3,350 3,500 2,300 3,500 79,750 $ 36,250 ok int nt Required: 1. Calculate the company's activity variances for July. (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.) ences 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