Please complete the Selling and Administrative Expense Budget, and show your Excel formulas supporting your...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Please complete the Selling and Administrative Expense Budget, and show your Excel formulas supporting your answer. Thank you
Buff Company expects variable selling and administrative expenses to fluctuate with unit sales volume according to the following rates Sales commissions: $3.30 pr unit sold 1.60 per unit sold Freight-out: $ Buff Company also incurs fixed selling and administrative expenses. The amounts of fixed selling and administrative expenses are already provided in the budget below. Use this information to complete the Selling and Administrative Expense Budget. Buff Company Selling and Administrative Expense Budget For the year ending December 31, 2017 Quarter 4 3,100 Year 9,500 1,400 2,400 Budgeted sales in units Variable expenses 2,600 Sales commissions ($3.30 per unit) Freight-out ($1.60 per unit) Total variable expenses Fixed expenses Advertising Sales salaries Office salaries Depreciation Property taxes and insurance $3,500 $13,300 $6,700 $1,400 $1,800 $3,500 $13,300 $6,700 $1,400 $1,800 $3,500 $13,300 $6,700 $1,400 $1.800 $3,500 $13,300 $6,700 $1,400 $1,800 $14,000 $53,200 $26,800 $5,600 $7.200 Total fixed expenses Total selling and administrative expenses
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
