Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill in the chart. excel is ok!! Flight Caf prepares in-flight meals for airlines in its kitchen located next to a local airport. The company's
fill in the chart. excel is ok!! 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 Cafe 18,000 $ 81, Planning Budget For the Month Ended: July 31 Budgeted meals (9) Revenue (54.56) Expenses: Raw materials (52.489) Wages and salaries (55,200 - 50.300) utilities ($2,400 + $0.059) Facility rent (54,380) Insurance (52,300) Miscellaneous (5680 + $0.189) Total expense Net operating income 43,200 10.600 3,389 4,300 2,300 2,480 66,180 $ 14,820 In July, 17,800 meals were actually served. The company's flexible budget for this level of activity appears below: W 17,800 $ 80,100 Flight Caf Flexible Budget For the Month Ended Duly 31 Budgeted meals (9) Revenue ($4.589) Expenses: Raw materials ($2.469) Wages and salaries ($5,200 + $0.309) Utilities ($2,400 + $0.059) Facility rent ($4,300) Insurance ($2,300) Miscellaneous ($680 + $0.109) Total expense Net operating income 42,720 10,540 3,290 4,300 2,300 2,460 65,610 $ 14,490 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.) Flight Cat Activity Variances For the Month Ended July 31 s 4,000 F 66,700 12,200 Revenue Expenses Raw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating income 3,550 3,600 2,700 3,800 92,550 23,450 $
fill in the chart. excel is ok!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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