Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 24,000 2nd Quarter 25,000 3rd Quarter 21,000 4th Quarter 22,000 Budgeted unit sales The company's variable selling and administrative expense per unit is $2.30. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $23,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,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 decimal places.)

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 5PA: Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash...
icon
Related questions
icon
Concept explainers
Question
100%

Please provide the correct values for the row highlighted in red.

Thanks.

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below:
1st Quarter
24,000
2nd Quarter
25,000
Budgeted unit sales
The company's variable selling and administrative expense per unit is $2.30. Fixed selling and administrative expenses include
advertising expenses of $9,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $23,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,600 will be paid in the second quarter.
Budgeted unit sales
Variable selling and administrative expense per unit
Variable selling and administrative expense
Fixed selling and administrative expenses:
Required:
Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2
decimal places.)
Advertising
Depreciation
Executive salaries
Insurance
Property taxes
Total fixed selling and administrative expenses
Total selling and administrative expenses
Less: Depreciation
Cash disbursements for selling and administrative expenses
3rd Quarter
21,000
X Answer is complete but not entirely correct.
Weller Company
Selling and Administrative Expense Budget
1st
2nd
Quarter
Quarter
24,000✔ 25,000✔
2.30 $ 2.30
$ 55,200
57,500
$
$
✔
<3333
✓
4th Quarter
22,000
*333333
9,000✔
23,000✔
44,000✔
4,000
0✔
9,000
23,000✔
44,000✔✓
$
$
3rd
Quarter
21,000✔
2.30
48,300
0✔
8,600✔
84,600✔
80,000✔
55,200 x
57,500 x
23,000✔
23,000✔
$ 112,200 $ 119,100 $ $
43*430033
9,000✔
23,000✔
44,000✔
4,000✔
0✔
80,000✔
48,300 x
23,000✔
105,300
$
$
$
4th
Quarter
22,000✔
2.30 $
50,600✔ $ $
9,000✔
23,000✔
44,000✔
0✔
0✔
76,000 ✓
50,600 X
23,000✔
103,600✔ $
Year
92,000✔
2.30
211,600
36,000✔
92,000✔
176,000
8,000
8,600
320,600
211,600 X
92,000✔
440,200✔
Transcribed Image Text:Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 24,000 2nd Quarter 25,000 Budgeted unit sales The company's variable selling and administrative expense per unit is $2.30. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $23,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,600 will be paid in the second quarter. Budgeted unit sales Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.) Advertising Depreciation Executive salaries Insurance Property taxes Total fixed selling and administrative expenses Total selling and administrative expenses Less: Depreciation Cash disbursements for selling and administrative expenses 3rd Quarter 21,000 X Answer is complete but not entirely correct. Weller Company Selling and Administrative Expense Budget 1st 2nd Quarter Quarter 24,000✔ 25,000✔ 2.30 $ 2.30 $ 55,200 57,500 $ $ ✔ <3333 ✓ 4th Quarter 22,000 *333333 9,000✔ 23,000✔ 44,000✔ 4,000 0✔ 9,000 23,000✔ 44,000✔✓ $ $ 3rd Quarter 21,000✔ 2.30 48,300 0✔ 8,600✔ 84,600✔ 80,000✔ 55,200 x 57,500 x 23,000✔ 23,000✔ $ 112,200 $ 119,100 $ $ 43*430033 9,000✔ 23,000✔ 44,000✔ 4,000✔ 0✔ 80,000✔ 48,300 x 23,000✔ 105,300 $ $ $ 4th Quarter 22,000✔ 2.30 $ 50,600✔ $ $ 9,000✔ 23,000✔ 44,000✔ 0✔ 0✔ 76,000 ✓ 50,600 X 23,000✔ 103,600✔ $ Year 92,000✔ 2.30 211,600 36,000✔ 92,000✔ 176,000 8,000 8,600 320,600 211,600 X 92,000✔ 440,200✔
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,