Question

Tile Co. Income Statement Budget sales volume, unit: 3,000 Sales: 48,000 Variable product: 21,000 variable selling...

Tile Co. Income Statement Budget sales volume, unit: 3,000 Sales: 48,000 Variable product: 21,000 variable selling and admin: 10,500 contribution margin: 16,500 fixed product: 5,100 fixed variable selling and admin: 3,300 operating income: 8,100

Tile Co. is budgeting for next year. Their initial budget is shown above. If they wish to budget for 7,000 units, what would the new budgeted profit be? Enter as a whole number, no commas and no dollar signs.

Homework Answers

Answer #1

Number of units sold = 3,000

Sales = $48,000

Selling price per unit = Sales/Number of units sold

= 48,000/3,000

= $16

Variable product = $21,000

Variable product per unit = Variable product/Number of units sold

= 21,000/3,000

= $7

Variable selling and admin = $10,500

Variable selling and admin per unit =  Variable selling and admin/Number of units sold

= 10,500/3,000

= $3.5

Budgeted income statement

Sales (7,000 x 16) 112,000
Variable product (7,000 x 7) - 49,000
Variable selling and admin (7,000 x 3.5) - 24,500
Contribution margin 38,500
Fixed product - 5,100
Fixed selling and admin - 3,300
Budgeted profit 30100

Budgeted profit = 30100

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Contribution Income Statement Sales (12,000 units) ……………………….. 72,000 Variable expenses ……………………… 48,000 Contribution Margin ………………… 24,000...
Contribution Income Statement Sales (12,000 units) ……………………….. 72,000 Variable expenses ……………………… 48,000 Contribution Margin ………………… 24,000 Fixed expenses ………………………… 10,000 Net Operating Income ………………. 14,000 Jackpot company sells a single product, has provided its contribution format income statement for June. Required: Prepare Contribution Income Statement assuming that the business expects an increase in its total sales (total revenue) by $3,000 and decrease in variable cost per unit by 10%.
Below is the variable costing income statement for South Bend Co.:          Sales, 6,000 units                    &nbsp
Below is the variable costing income statement for South Bend Co.:          Sales, 6,000 units                                                                    $210,000 Total variable costs:          Beg. inventory,           680 units             $13,600          Variable manufacturing cost of          goods manufactured,    ? units           + 132,000          Ending inventory,     1,280 units           - (25,600)          Variable manufacturing cost of goods $120,000          Variable selling & admin. exp.             + 24,900     ($144,900) Contribution margin                                                                $65,100 Total fixed costs:          Fixed factory overhead                ...
Walton Company has provided the following 2018 data: Budget Sales $ 505,000 Variable product costs 195,000...
Walton Company has provided the following 2018 data: Budget Sales $ 505,000 Variable product costs 195,000 Variable selling expense 45,000 Other variable expenses 3,200 Fixed product costs 16,500 Fixed selling expense 23,900 Other fixed expenses 1,700 Interest expense 720 Variances Sales 8,300 U Variable product costs 4,900 F Variable selling expense 1,500 U Other variable expenses 1,100 U Fixed product costs 270 F Fixed selling expense 430 F Other fixed expenses 170 U Interest expense 150 F Required a. &...
The information below is for Wendell Co. Product sales 3,000 units at $15 each Variable manufacturing...
The information below is for Wendell Co. Product sales 3,000 units at $15 each Variable manufacturing costs $9.50 per unit Fixed manufacturing overhead $3,200 Variable selling and administrative costs $2.50 per unit Fixed selling and administrative costs $1 per unit sold Units budgeted and produced 3,200 units Beginning inventory 0 units Wendell’s ending inventory under absorption costing is A. $600 B. $2,300 C. $2,100 D. $1,900
Exercise 8-6 Selling and Administrative Expense Budget [LO8-7] Weller Company's budgeted unit sales for the upcoming...
Exercise 8-6 Selling and Administrative Expense Budget [LO8-7] Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 18,000 22,000 17,000 16,000 The company’s variable selling and administrative expense per unit is $1.70. Fixed selling and administrative expenses include advertising expenses of $11,000 per quarter, executive salaries of $38,000 per quarter, and depreciation of $17,000 per quarter. In addition, the company will make insurance payments of...
Assume a company’s sales budget for July estimates 16,300 units sold. The variable selling and administrative...
Assume a company’s sales budget for July estimates 16,300 units sold. The variable selling and administrative expense used for budgeting purposes is $4.00 per unit sold. The total budgeted cash disbursements for selling and administrative expenses in July is $132,000. The total fixed selling and administrative expenses included in the selling and administrative expense budget for July is $93,000. What is the amount of depreciation included in the selling and administrative expense budget for July? Multiple Choice $14,700 $39,300 $27,800...
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs,...
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $111,000 Accounts Receivable 196,500 Finished Goods 41,300 Work in Process 27,500 Materials 45,200 Prepaid Expenses 3,300 Plant and Equipment 576,100 Accumulated Depreciation—Plant and Equipment $247,700 Accounts Payable 157,200 Common Stock, $10 par 350,000...
Gilley Inc. sells a single product. Gilley's most recent income statement is given below: Sales (Sold...
Gilley Inc. sells a single product. Gilley's most recent income statement is given below: Sales (Sold 4,000 units) $120,000 Variable costs: Variable manufacturing costs (48,000) Variable selling and general costs (20,000) Contribution margin 52,000 Fixed costs: Fixed manufacturing costs (30,000) Fixed selling and general costs (10,000) Operating income $12,000 How many units must be sold to achieve net income (after tax) of $15,000? Assume income tax rate of 40%. Compute the new "break-even point" in units if fixed manufacturing costs...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):      Sales $ 23,900       Variable expenses 13,300       Contribution margin 10,600       Fixed expenses 7,632       Net operating income $ 2,968         Required: What is the degree of operating leverage Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range...
Data for Hermann Corporation are shown below: Per Unit Percent of Sales Selling price $ 80...
Data for Hermann Corporation are shown below: Per Unit Percent of Sales Selling price $ 80 100 % Variable expenses 44 55 Contribution margin $ 36 45 % Fixed expenses are $76,000 per month and the company is selling 2,500 units per month. rev: 06_04_2020_QC_CS-205709, 06_18_2020_QC_CS-216765, 07_14_2020_QC_CS-216765 Required: 1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $8,100 and monthly sales increase by $14,400? 1-b. Should the advertising budget be increased?