Question: Required information table [ [ , A , B , C , D , E ] , [ 1 , Chapter 9 : Applying

Required information
\table[[,A,B,C,D,E],[1,Chapter 9: Applying Excel,,,,],[2,,,,,],[3,Data,,,,],[4,Revenue -,,,$ 16.50,q],[5,Cost of ingredients,,,$ 6.25,q],[6,Wages and salaries,$ 10,400,,,],[7,Utilities,$ 800,+,$ 0.20,q],[8,Rent,$ 2,200,,,],[9,Miscellaneous,$ 600,+,$ 0.80,q],[10,,,,,],[11,Actual results:,,,,],[12,Revenue,$ 30,235,,,],[13,Cost of ingredients,$ 11,075,,,],[14,Wages and salaries,$ 10,615,,,],[15,Utilities,$ 1,140,,,],[16,Rent,$ 2,200,,,],[17,Miscellaneous,$ 2,055,,,],[18,,,,,],[19,Planning budget activity,1,700,meals served,,],[20,Actual activity,1,800,meals served,,]]
Chapter 9: Applying ExcelDataRevenueCost of ingredientsWages and salariesUtilitiesRentMiscellaneousActual results:RevenueCost of ingredientsWages and salariesUtilitiesRentMiscellaneousPlanning budget activityActual activityMeals servedRevenueExpenses:Cost of ingredientsWages and salariesUtilitiesRentMiscellaneous$10,400Total expenses$800Net operating income$2,200$600Enter a formula into each of the cells marked with a ? belowReview Problem: Variance Analysis Using a Flexible Budget$27,920$11,110Construct a flexible budget performance report$10,130$1,080$2,200$2,2401,800meals served1,700 meals servedActualResultsRevenueandSpendingVariances??$16.50 q$6.25q$0.20 q$0.80qFlexibleBudget??????ActivityVariances?2??PlanningBudget???
a. What is the activity variance for revenue?
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).
Answer is complete and correct.
\table[[The amount of the activity variance for revenue,$,1,650
Required information \ table [ [ , A , B , C , D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!