Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CellBase Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2024 flexible budget shows output levels of 8,500, 10,000, and
CellBase Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2024 flexible budget shows output levels of 8,500, 10,000, and 12,000 units. The static budget was based on expected sales of 10,000 units. The company sold 12,000 units during July. Its flexible budget and actual operating income was as follows: Requirement 1. Prepare a flexible budget performance report for July. (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank.) CellBase Technologies Flexible Budget Performance Report For the Month Ended July 31, 2024 - X - X 2 3 5 Data table Data table (1) - (3) (3) - (5 ) Budget Flexible Sales CellBase Technologies Flexible Static CellBase Technologies Amounts Actual Budget Volume Flexible Budget Income Statement Per Unit Results Variance Budget Variance Budget For the Month Ended July 31, 2024 For the Month Ended July 31, 2024 Units Budget Amount Sales Revenue $ 247,000 Sales Revenue per Unit Variable Expenses 149,200 Variable Expenses Units 8,500 10,000 12,000 Contribution Margin 97,800 Contribution Margin Sales Revenue $ 20 $ 170,000 $ 200,000 $ 240,000 58,500 Fixed Expenses Variable Expenses 12 102,000 120,000 144,000 Fixed Expenses $ 39,300 Operating Income Contribution Margin 68,000 80,000 96,000 Operating Income Fixed Expenses 57,000 57,000 67,000 $ 11,000 $ 23,000 $ 39,000 Operating Income 10 Print Done Print Done Requirement 2. What was the effect on CellBase's operating income of selling 2,000 units more than the static budget le Selling 2,000 units more than the static budget level of sales CellBase's operating income by Requirement 3. What is CellBase's static budget variance for operating income? CellBase's static budget variance is , meaning that its operating income is than expected per the static budget. Requirement 4. Explain why the flexible budget performance report provides more useful information to CellBase's managers than the simple static budget variance. What insights can CellBase's managers draw from this performance report? Choose two reasons why the flexible budget performance report provides CellBase's managers with more information than the simple static budget variance. These variances suggest that the marketing department did a | |job. They sold | | units than expected and sold them at a | price than expected
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