Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Decision Making and Control

Authors: Jerold Zimmerman

8th edition

78025745, 978-0078025747

More Books

Students also viewed these Finance questions