All parts of this multi-part (simple, five-line) flexible budget are based upon the same set of data. Thermaltake Company prepared a budget for an anticipated production level of 50,000 units and an anticipated sales level of 50,000 units. That existing budget for the 50,000 unit level showed lines of $500,000 for sales, $250,000 for variable costs, $250,000 for contribution margin, $100,000 for fixed costs, and $150,000 for net income. Actual production and sales levels experienced during the period were 60,000 units. In the flexible budget that reflects adjustments appropriate for the new actual level of 60,000 units,
1. the appropriate dollar amount for sales should be:
2. the appropriate dollar amount for variable costs should be:
3. the appropriate dollar amount for contribution margin should be:
4. the appropriate dollar amount for fixed costs should be:
5. the appropriate dollar amount for net income should be:
a) Amount of sales = 500000/50000*60000 = $600000
b) Amount of variable cost = 250000/50000*60000 = $300000
c) Contribution margin = 600000-300000 = $300000
d) Fixed cost = 100000
e) Net income = 300000-100000 = 200000
All parts of this multi-part (simple, five-line) flexible budget are based upon the same set of...
Brodrick Company expects to produce 20,200 units for the year ending December 31. A flexible budget for 20,200 units of production reflects sales of $545,400; variable costs of $60,600; and fixed costs of $143,000. 1)If the company instead expects to produce and sell 26,700 units for the year, calculate the expected level of income from operations. ------Flexible Budget------ ------Flexible Budget at ------ Variable Amount per Unit Total Fixed Cost 20,200 units 26,700 units Contribution margin $0.00 $0 $0 $0 $0...
Prepare a flexible budget in Excel for Vroom-Vroom. (36 points) Show the flexible budget for December in Contribution Margin Income Statement format. Compare December’s flexible budget to December’s actual results. Specify which line items are favorable or unfavorable and how much. For Ingredient Costs and Packaging Costs, break out the Price and Volume Variances for December. Provide potential explanations Show the flexible budget for January in Contribution Margin Income Statement format. Compare January’s flexible budget to January’s actual results. Specify...
Brodrick Company expects to produce 21,800 units for the year ending December 31. A flexible budget for 21,800 units of production reflects sales of $436,000; variable costs of $65,400; and fixed costs of $141,000. ssume that actual sales for the year are $510,000 (27,800 units), actual variable costs for the year are $113,600, and actual fixed costs r the year are $134,000. repare a flexible budget performance report for the year. BRODRICK COMPANY Flexible Budget Performance Report For Year Ended...
Phoenix Company’s 2017 master budget included the following
fixed budget report. It is based on an expected production and
sales volume of 15,000 units.
Required information Problem 21-1A Preparation and analysis of a flexible budget LO P1 (The following information applies to the questions displayed below.) Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $3,300,000 PHOENIX COMPANY Fixed Budget Report For Year Ended December...
Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $3,300,000 PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales Cost of goods sold Direct materials $915,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation-Plant equipment (straight-line) 330,000 Utilities ($45,000 is variable) 195,000 Plant management salaries 210,000 Gross profit Selling expenses Packaging 90,000 Shipping 90,000 Sales salary (fixed annual amount) 235,000 General...
Phoenix Company's 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $ 3,150,000 unt PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2015 Sales Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation-plant equipment (straight-line) 330,000 Utilities ($60,000 is variable) 180,000 Plant management salaries 190,000 Gross profit Selling expenses Packaging 75,000 Shipping 105,000 Sales salary fixed annual...
Required information Problem 21-1A Preparation and analysis of a flexible budget LO P1 The following information applies to the questions displayed below.] Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $3,300,000 Cost of goods sold Direct materials Direct labor Machinery repairs (variable cost) Depreciation-Plant equipment (straight-line) Utilities ($60,000 is variable) Plant management...
Complete the flexible budget variance analysis by filling in the blanks in the partial flexible budget performance report for 11,000 travel locks for Gianni, Inc. B (Click the icon to view the report) (For variances with a $0 value, make sure to enter "O" in the appropriate cells.) i Data Table Gianni, Inc. Flexible Budget Performance Report (partial) For the Month Ended April 30, 2018 Actual Flexible Budget Results Variance Units 11,000L Sales Revenue S 209,000 Variable Costs 51,900 Contribution...
Match each form to the correct definition Terms a. Flexible budget b. Flexible budget variance c. Sales volume variance d Static budget e. Variance - Definitions 1. A summarized budget for several levels of volume that separates variable costs from foxed costs 2. A budget prepared for only one level of sales 3. The difference between an actual amount and the budgeted amount 4. The difference arising because the company actually earned more or less revenue, or incurred more or...
Part 1 of 2 Required information The following information applies to the questions displayed below) Brodrick Company expects to produce 20100 units for the year ending December 31. A flexible budget for 20,100 units of production reflects sales of $582.900: variable costs of $60,300; and fixed costs of $143,000. If the company instead expects to produce and sell 26,600 units for the year, calculate the expected level of income from operations Flexible Budget Flexible Budget at Total Fixed Variable Amount...