Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ann Olsson runs a small coffee shop and is analyzing the past 3 months of operations. Using the data below, prepare a flexible budget
Ann Olsson runs a small coffee shop and is analyzing the past 3 months of operations. Using the data below, prepare a flexible budget based on the actual results, and then calculate the overall variance for each line item. (You will first need to calculate and enter the rate for Supplies.) The average customer spends $7 per visit. Wages and the variable portion of Utilities are budgeted based on the number of employee hours. Supplies and Cost of Goods Sold are budgeted based on the number of customers. Employee Hours Worked Number of Customers Sales Variable Costs: Cost of Goods Sold @ $4.50 Wages @ $8.00 Utilities @ $0.80 Supplies @ Total VC Contribution Margin Fixed Costs: Leases and Rents Utilities - base costs Total FC Net Income Static Budget 1,200 2,400 $16,800 10,800 9,600 960 1.200 $11,760 $ 5,040 $ 1,800 40 $ 1,840 $ 3,200 Actual Results 1,250 2,350 $17,200 10,900 10,800 925 1,250 $12,255 $ 4,945 $ 1,900 40 $ 1,940 $ 3,005 Flexible Budget Variance For U
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To calculate the flexible budget and overall variance for each line item well first need to determin...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