Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Delicioso Burritos operates a food truck in Nogales, Arizona and prepares monthly performance reports for planning and control purposes. Delicioso Burritos operates a food truck
Delicioso Burritos operates a food truck in Nogales, Arizona and prepares monthly performance reports for planning and control purposes.
Delicioso Burritos operates a food truck in Nogales, Arizona and prepares monthly performance reports for planning and control purposes 1 It uses the number of burritos sold as its revenue and cost driver 0228 19 The monthly planning budget amounts for the month of July are given in the table below and its revenue and cost functions (formulas) are given in the left-hand column. You should use this performance report template to help you answer the question given below the template. Your first step (if completing the template sent to you by e-mail) is to fill in the "Actual Results" column (for July). Actual Results Revenue & Spending Variances Flexible budget Activity Variances Total Variance Planning (Static) Budget 20.000 Burritos sold (0) 19,000 $79.000 $80,000 Revenue $4.00) Expenses Actual Results Revenue & Spending Variances Flexible- budget Activity Variances Planning (Static) Budget Total Variance Burritos sold (9) 19,000 20,000 $79,000 $80,000 ? Revenue ($4.009) Expenses: $31,000 $30,000 $16.000 $18,000 COGS ($1.509) Wages and salaries ($8.000 +$.50q) $4,600 $5,000 Supplies ($.259) $2,100 $2.000 Insurance ($2.000) $5.400 $6.000 Miscellaneous costs ($.300) Total expenses $59.100 $61.000 Net operating Income $19.900 $19.000 Income Calculate the "Total Varlance" for "Revenue" $19.900 $19.000 Net operating Income Calculate the "Total expenses" "revenue & spending" varlance (.e. the sum of all expense "spending" variances). Income Assume the company reports the following in the month of August (the next month), with the Revenue and COGS functions formulas) the same as given in the template Le the "Revenue formula is $4.00q and the COGS formula is $1.500) planning budget quantity actual number of units sold actual results for Sales actual results for COGS 21,000 22,000 $83,600 $32.560 Calculate the "revenue and spending variance for "COGS" (the $1.50q line) Step 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