Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all questions, not just the first three questions 5. Hampton Muffins sells its muffins to restaurants and coffee houses for an average selling
Please answer all questions, not just the first three questions
5. Hampton Muffins sells its muffins to restaurants and coffee houses for an average selling price of $35 per case. The following information relates to the budget for Hampton Muffins for this year (all figures are annual totals unless otherwise noted): 1(Click the icon to view the budget information.) During the year, Hampton Muffins actually sold 9,500 cases, resulting in total sales revenue of $340,500. Actual expenses (in total) from this year are as follows: 2(Click the icon to view the actual expenses.) Requirement Construct a flexible budget performance report for Hampton Muffins for the year. Be sure to indicate whether each variance is favorable (F) or unfavorable (U). (Enter the variances as positive numbers. Label each variance as favorable (F) or unfavorable (U). If the variance is 0, make sure to enter in a "0". A variance of zero is considered favorable.) Hampton Muffins Flexible Budget Performance Report - Sales and Operating Expenses For the Year Ended December 31 Flexible Flexible Master Actual Volume Budget Variance Budget 9,500 cases Budget 8,900 cases 9,500 cases Variance Sales revenue (1) (2) ($35 per case) Variable operating expenses: (3) (4) Packaging expense ($5 per case sold) (5) (6) Shipping expense ($3 per case sold) (7) (8) Sales commissions (1% of sales price) Fixed operating expenses: (9) (10) Salaries (11) (12) Office rent (13) (142 Depreciation (15) (16) Insurance expense (17) (182 Office Supplies expense (19) (20) Total operating expenses 1: Data Table 8,900 cases Budgeted sales in cases Packaging cost per case .......$ Shipping expense per case $ 5 3 Sales commission expense 1% of sales price Salaries expense.. $ 6,600 Office rent $ 3,400 Depreciation. . $ 3,000 Insurance expense $ 1,800 Office supplies expense.. $ 1,100 2: Data Table $ 47,800 Packaging cost. Shipping expense... Sales commission expense... $ 30,900 $ 3,405 Salaries expense.. $ 8,100 Office rent .. $ 3,400 3,000 $ Depreciation Insurance expense Office supplies expense $ 1,000 $ 1,700 (1) (2) (3) (4) (5) (6) (7) (8) (9) (11) (12) of (13) F 000 (10) O F F F 0 0 0 OF OF OU OF OU OF OU ogo_ F U U U U U U U U U 063 008 (14) O (18) O (19) O (20) (15) O F (16) O F OU (17) O F OU C Ooo C 000 c U UStep 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