### Weller Company's Budgeted Unit Sales for the Upcoming Fiscal YearThe budgeted unit sales are distributed across four quarters as follows:- **1st Quarter:** 25,000 units- **2nd Quarter:** 26,000 units- **3rd Quarter:** 22,000 units- **4th Quarter:** 23,000 units### Variable and Fixed Expenses- **Variable Selling and Administrative Expense Per Unit:** $2.40- **Fixed Selling and Administrative Expenses Include:** - Advertising Expenses: $10,000 per quarter - Executive Salaries: $44,000 per quarter - Depreciation: $24,000 per quarter- **Additional Payments:** - Insurance: $5,000 in the 1st Quarter and $5,000 in the 3rd Quarter. - Property Taxes: $6,600 in the 2nd Quarter.### Required TaskPrepare the company's selling and administrative expense budget for the upcoming fiscal year. It is advised to round "Per Unit" answers to 2 decimal places.### Budget StructureBelow is the structure for the Weller Company's selling and administrative expense budget, divided by quarters and totaled for the year:#### Table: Selling and Administrative Expense Budget- **Variable Selling and Administrative Expense Per Unit:** - **1st-4th Quarters:** Enter individual unit costs and totals- **Variable Selling and Administrative Expenses:** - Calculated as unit sales multiplied by the per-unit expense- **Fixed Selling and Administrative Expenses:** - Breakdown by category (Advertising, Executive Salaries, Depreciation, Insurance, Property Taxes) for each quarter- **Total Fixed Selling and Administrative Expenses:** - Sum of all fixed expenses- **Total Selling and Administrative Expenses:** - Sum of variable and total fixed expenses- **Cash Disbursements for Selling and Administrative Expenses:** - Record actual cash disbursements, excluding non-cash items such as depreciationThis comprehensive budget helps ensure that Weller Company effectively manages its financial resources across the fiscal year.

The selling and administrative expense budget is the one which comprises of the budgets of all the…

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,000 22,000 Budgeted unit sales 26,000 23,000 The company's variable selling and administrative expense per unit is $2.40. Fixed selling and administrative expenses include advertising expenses of $10,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $24,000 per quarter. ddition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property axes of $6,600 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 lecimal places.) Weller Company Selling and Administrative Expense Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Variable selling and administrative expense per unit

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,000 22,000 Budgeted unit sales 26,000 23,000 The company's variable selling and administrative expense per unit is $2.40. Fixed selling and administrative expenses include advertising expenses of $10,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $24,000 per quarter. ddition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property axes of $6,600 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 lecimal places.) Weller Company Selling and Administrative Expense Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Variable selling and administrative expense per unit

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Haresh
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: Budgeted unit sales 1st Quarter 32,000 2nd Quarter 34,000 3rd Quarter 4th Quarter 25,000 30,000 The company's variable selling and administrative expense per unit is $3.10. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $50,000 per quarter, and depreciation of $31,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and $4,000 in the third quarter. Finally, property taxes of $8,000 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.) Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: Weller Company Selling and Administrative Expense Budget 1st Quarter 2nd Quarter…
Flexible Budgets and Standard Cost Systems 1317 > Problems Group B P23-30B Preparing a flexible budget performance report Learning Objective 1 Cell Plus Technologies manufactures capacitors for cellular base stations and other communication applications. The company's July 2018 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. 3. Static Bud, Var, for Op. Inc. $22,900 F CELL ONE TECHNOLOGIES Flexible Budget For the Month Ended July 31, 2018 Budget Amounts per Unit Units 8,500 10,000 12,000 Sales Revenue $ 24 $ 204,000 $ 240,000 $ 288,000 Variable Expenses 13 110,500 130,000 156,000 Contribution Margin 93,500 110,000 132,000 Fixed Expenses 57,000 57,000 57,000 Operating Income $ 36,500 $ 53,000 $ 75,000 The company sold 12,000 units during July, and its actual operating income was as follows: CELL ONE TECHNOLOGIES Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 295,000 Variable…
Fairfield Company management has budgeted the following amounts for its next fiscal year: Selling price per unit Variable expenses per unit Total fixed expenses $40.00 per unit $25.00 per unit $832,500 19. Fairfield Company's goal for the month is to earn a target operating income of $285,000. How many units must be sold to achieve this goal? (A)54,000 units (B) 55,500 units (C) 74,500 units (D) 33,300 units (2 marks) If Fairfield can reduce fixed expenses by $41,625, by how much can variable expenses per unit increase and still allow the company to maintain the original breakeven sales in units? 20. (A) (B) $0.75 $2.78 (C) $0.53 (D) $0.25 (3 marks)
Bailee Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2017, the following data are available. 1. Sales: 33,000 units quarter 1; 35,000 units quarter 2. 2. Variable costs per dollar of sales: Sales commissions $33,000 quarter 1; $35,000 quarter 2, delivery expense $13,200 quarter 1 and $14,000 quarter 2, and advertising $19,800 quarter 1 and $21,000. 3. Fixed costs per quarter: Sales salaries $15,000, office salaries $6,000, depreciation $4,200, insurance $1,500, utilities $800, and repairs expense $600. 4. Unit selling price: $20. Instructions: Prepare a selling and administrative expense budget by quarters for the first 6 months of 201
Rooney Company produces two products. Budgeted annual income statements for the two products are provided as follows. Power Lite Total Budgeted Per Budgeted Budgeted Per Budgeted Budgeted Budgeted Number Unit Amount Number Unit Amount Number Amount @ $ 700 @ 380 $ 319,200 (168,000) 151,200 $ 487,200 (259,200) 228,000 (114,000) $ 114,000 Sales 240 $168,000 560 @ $ 570 800 Variable cost (91,200) 76,800 |(19,000) $ 57,800 240 560 @ 300 = 800 %3D Contribution margin 240 320 560 @ 270 800 Fixed cost (95,000) Net income $ 56,200 Required: a. Based on budgeted sales, determine the relative sales mix between the two products. b. Determine the weighted-average contribution margin per unit. c. Calculate the break-even point in total number of units. d. Determine the number of units of each product e. Verify the break-even point by preparing an income statement for each product as well as an income statement for the combined products. f. Determine the margin of safety based on the combined sales…
Sheridan Company has invested 3,420,000 in assets to produce 11,400 units of its finished product. Sheridan's budget for the year is as follows: net income 478,000; variable costs, 2,736,000; fixed costs, 456,000 Compute each of the following: (Round answers to 1 decimal place, e.g. 15.2%.) 1. Budgeted ROI ____% 2. Markup percentage using the total cost approach %
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,400 units. Sales Costa PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,234,000 1,001,000 246,400 46,200 295,000 198,000 231,000 251,000 610,700 193,000 $ 161,700
The budgeted income statement presented below is for Burkett Corporation for the coming fiscal year. Compute the number of units that must be sold in order to achieve a target income of $130,000. Sales (50,000 units) $1,000,000 Costs: Direct materials $ 270,000 Direct labor 240,000 Fixed factory overhead 100,000 Variable factory overhead 150,000 Fixed marketing costs 110,000 Variable marketing costs 50,000 Income 920,000 $ 80,000 O a. 53,165. O b. 81,250. Oc 36,207. O d. 50,000. Oe. 58,621.
Arberg Company’s controller prepared the following budgeted income statement for the coming year: Sales $417,000 Variable cost 287,730 Contribution margin $129,270 Fixed cost 75,950 Operating income $53,320 2. Suppose Arberg’s actual revenues are $29,900 more than budgeted. By how much will operating income increase?
Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 15,000 *16,000 14,000. 13,000 The company's variable selling and administrative expense per unit is $2.50. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $35,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $8,000 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for next year. Note: Round "Per Unit" answers to 2 decimal places
Everly Company’s variable selling and administrative expenses are 12% of net sales. Fixed expenses are $50,000 per quarter. The sales budget shows expected sales of $200,000 and $240,000 in the first and second quarters, respectively. What are the total budgeted selling and administrative expenses in quarter 2?