Question

In: Accounting

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

Tile Co. Income Statement Budget

sales volume, unit: 3,000 Sales: 18.00 Variable product: 6.50 variable selling and admin: 3.50 contribution margin: 8.00 fixed product: 2.00 fixed variable selling and admin: 0.70 operating income: 5.30

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

Solutions

Expert Solution

While preparing the Budgeted Income Statement, one needs to keep in mind that Fixed cost will remain same irrespective of the no of units sold. Variable cost will change depending on the the no of units sold.

Fixed cost is given as $2 per unit when 3,000 units were sold, that means Total fixed cost = 3,000*$2= $6,000.

Likewise, fixed variable selling and admin will be 3000*0.7= $2,100.

Theses will reman same even when 8,000 units are to be produced.

So the Budgeted Income Statement when 8000 units are sold, will be as follows:

Tile Co.
Budgeted Income Statement
Particulars Basis $
Sales (8000 units*$18) 144000
Less: Expenses
Variable Cost (8000 units*$6.5) 52000
Variable Selling and Admin (8000 units*$3.5) 28000
Contribution 64000
Fixed Product (3000*$2) 6000
Fixed variable selling and admin (3000*$0.7) 2100
Budgeted Profit 55900

Therefore, the new budgeted profit will be $55,900.


Related Solutions

LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling...
LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36000 $7 $252,000 Deluxe Abacus 36000 13 468,000 Totals 72,000 - $720,000 LearnCo Production Budget For the Year Ending December 31, 20Y2 Units Basic Units Deluxe Expected units to be sold (from Sales Budget) 36000 36000 Desired ending inventory, December 31, 20Y2 1,000 3,000 Total units available 37000 39000 Estimated beginning inventory, January 1, 20Y2 (1,050) (2,100) Total units...
Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost...
Break-Even Sales Currently, the unit selling price of a product is $380, the unit variable cost is $310, and the total fixed costs are $1,001,000. A proposal is being evaluated to increase the unit selling price to $420. a. Compute the current break-even sales (units). units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant. units
Forecast Sales Volume and One of the major elements of the income statement budget that indicates...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates the quantity of estimated sales and the expected unit selling price.Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 20,055 11,978 Central 4,944 4,018 West 4,224 3,296 Raphael Frame Company Sales Budget For...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates the quantity of estimated sales and the expected unit selling price.Sales Budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" × 10" Frame 12" × 16" Frame East 31,106 15,080 Central 7,676 6,076 West 6,693 5,202 Raphael Frame Company Sales Budget For...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates...
Forecast Sales Volume and One of the major elements of the income statement budget that indicates the quantity of estimated sales and the expected unit selling price.Sales Budget Guardian Framing Inc. prepared the following sales budget for 2016: Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 20,500 $27 $553,500 Central 5,100 27 137,700 West 4,700 27 126,900 Total 30,300 $818,100...
Question. Currently the unit selling price of a product is $200, the unit variable cost is...
Question. Currently the unit selling price of a product is $200, the unit variable cost is $110, and the total fixed costs are $585,000. A proposal is being evaluated to increase the unit selling price to $275. Under the proposed plan, the variable cost per unit and the total fixed cost will not change. Current Scenario [7 Points]: 1) Calculate the contribution margin per unit. 2) Calculate the contribution margin ratio. 3) Calculate the breakeven point in units under the...
Currently, the unit selling price of a product is $7,520, the unit variable cost is $4,400,...
Currently, the unit selling price of a product is $7,520, the unit variable cost is $4,400, and the total fixed costs are $23,400,000. A proposal is being evaluated to increase the unit selling price to $8,000. a. Compute the current break-even sales (units). _____________ units b. Compute the anticipated break-even sales (units), assuming that the unit selling price is increased and all costs remain constant. _______________units
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget –...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget – production budget – direct materials budget – budgeted income statement Who would typically be responsible for the direct material quantity variance? -the production manager -the chief financial officer -the purchasing manager -the human resources manager Which of the following is not a component of the operating budget? -sales budget -selling and administrative budget -Budgeted balance sheet -raw materials purchases budget Top-down budgeting is: -when...
Exercise 5-13 Changes in Selling Price, Sales Volume, Variable Cost per Unit, and Total Fixed Costs...
Exercise 5-13 Changes in Selling Price, Sales Volume, Variable Cost per Unit, and Total Fixed Costs [LO5-1, LO5-4] Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (36,000 units) $ 252,000 $ 7.00 Variable expenses 144,000 4.00 Contribution margin 108,000 $ 3.00 Fixed expenses 49,000 Net operating income $ 59,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 15%? 2. What...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,200 units are planned to be sold in December. The variable selling and administrative expense is $3.10 per unit. The budgeted fixed selling and administrative expense is $60,800 per month, which includes depreciation of $6,720 per month. The remainder of the fixed selling and administrative expense represents current cash flows.Calculate the budgeted cash disbursements for selling and administrative expenses for December. Give your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT