Ann Olsson runs a small coffee shop and is analyzing the past 3 months of operations....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
To calculate the flexible budget and overall variance for each line item well first need to determin... View the full answer
Related Book For
Accounting for Decision Making and Control
ISBN: 978-0078025747
8th edition
Authors: Jerold Zimmerman
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
FARR CERAMICS PRODUCTION DIVISION: A BUDGETARY ANALYSIS CASE When Mr. Jamilur Rahman, arrived at his office at FARR Ceramics Production Division on June 4, 2019, he was satisfied to see the month to...
-
(a) lim f(x) X-C+ 5. y 7. Y 9. 2 IT - Limits and Continuity In Exercises 5-10, use the graph to determine each limit, and discuss the continuity of the function. -3+ (4,3), + + 1/2 3 4 (3, 1) (b) lim...
-
Discuss the ten strategies discussed in the video (link given below). Research and find at least three (3) more recommendations needed to organize, fund and introduce a CSIRT. Research and recommend...
-
What are deferred expenses?
-
For each of the following, calculate the standard error of the difference \(\left(s \mathrm{X}^{-} 1-\mathrm{X}^{-} ight.\) \(2)\). a. N = 35, s = 1.50, N = 35, $2 = 3.25 b. N = 4, s = 4.30, N = 4,...
-
Presented below are the 2018 income statement and comparative balance sheets for Santana Industries. Additional information for the 2018 fiscal year ($ in thousands): 1. Cash dividends of $1,000 were...
-
system Solve the problem using two variables and a system of two equations. Solve the system by the method of your choice. Note that the problem could be a dependent or inconsistent A civil engineer...
-
Two power plants are currently emitting 8,000 tons of pollution each (for a total of 16,000 tons) in City A. Marginal pollution reduction costs for Plant 1 are given by MCR 1 = 0.02 Q 1 and for Plant...
-
After a series of state changes the pressure of 2kg of carbon dioxide is doubled while its volume is halved. What is S?
-
Fast Rail Bhd. is a public company engaged in public transportation railway project. Due to the new MRT project, the company plans to raise additional financing with the issuance of RM50 million to...
-
Feceipts tax, of roughly computed in on. The tax base (to which this rate is applied odified gross rexable margin and revenue is one of the following ways: (1) total replied) is the entity's goods...
-
In Year 3, Fay sold 100 shares of Gym Co. stock to her son, Martin, for $11,000. Fay had paid $15,000 for the stock in Year 1. Subsequently in Year 3, Martin sold the stock to an unrelated third...
-
Bill is two times faster than Tracey at processing applications. Bill is two times slower than Kaitlyn at processing applications. How does Kaitlyn's speed compare to Tracey's speed?
-
Two consecutive numbers are multiplied together. The product is 1,482. Each of the numbers is doubled. If these two new numbers are multiplied together, what will the product be?
-
You wish to establish a capital partnership having legal personality to make business on import machines. Which organization type would you prefer? Why, explain with advantages. Write the names of...
-
Find the numerical value of each expression. (a) sech 0 (b) cosh -1 1
-
Ware Paper Box manufactures corrugated paper boxes. It uses a job order costing system. Operating data for February and March are as follows: The factory was closed due to a labor strike prior to...
-
American Cinema shows first-run movies. It pays the company distributing the movies a fixed fee of $ 1,000 per week plus a percentage of the gross box office receipts. In the first two weeks a movie...
-
Blue Sage Mountain produces hinged snowboards. The price charged affects the quantity sold. The following equation captures the relation between price and quantity each month: Selling price = $ 530 -...
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
What is the pressure one mile $(1.6 \mathrm{~km})$ beneath the ocean's surface?
-
A vertical, cylindrical tank with a diameter of $10 \mathrm{~m}$ and a depth of $4 \mathrm{~m}$ is filled to the top with water at $25^{\circ} \mathrm{C}$. If the water is heated to $60^{\circ}...
Ida B And Her Plans To Maximize Fun Avoid Disaster And Save The World - ISBN: 0060730269 - Free Book
Study smarter with the SolutionInn App