Question
Cupcake Co. is a small neighborhood bakery. The owner has determined that the shop has two major cost drivers- the number of cupcakes sold and
Cupcake Co. is a small neighborhood bakery. The owner has determined that the shop has two major cost drivers- the number of cupcakes sold and the number of deliveries made. Data concerning the cupcake's cost appear below:
Fixed Cost per month- Kitchen staff: $6030, Utilites $670, Delivery Vehicle $690, Equipment Depreciation $448, Rent $1990, Miscellaneous $790.
Cost Per Cupcake- Cupcake ingredients $5, Utilities $0.90, Miscellaneous $0.15.
Cost Per delivery- Delivery Person $2.70, Delivery Vehicle $2.10.
In November, the Cupcake Co. budgeted for 1,740 cupcakes at an average selling price of $13 per cupcake box and for 200 deliveries. Data concerning the bakery's operations in November are listed below:
Actual Results: Cupcake orders- $1,840. Deliveries- $180. Revenue- $24,530. Cupcake ingredients $8,290. Kitchen Staff- $5,970. Utilities- $915. Delivery Person- $486. Delivery Vehicle- $998. Equipment Depreciation- $448. Rent- $1990. Miscellaneous- $826.
Complete the flexible budget performance that shows both revenue and spending variances and activity variances for the bakery for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable and "None" for no effect.
Actual Results for Revenue $24,530
Expenses: Cupcake ingredients: 8,290. Kitchen staff: 5,970. Utilities: 915. Delivery Person: 486. Delivery Vehicle: 998. Equipment Depreciation: 448. Rent: 1990. Misc.: 826.
Total Expense: 19,923 Net Operating Income: $4,607.
Provide Revenue and Spending Variances, Flexible Budget, Activity Variances, and Planning Budget.
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