Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please complete the selling and administrative exp

Please complete the Selling and Administrative Expense Budget, and show your Excel formulas supporting your...

70.2K

Verified Solution

Question

Accounting

Please complete the Selling and Administrative Expense Budget, and show your Excel formulas supporting your answer. Thank you

image

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

To determine the effectiveness of learning a cartwheel by watching a video, a gymnastics teacher randomly...

Basic Math
Q

A 0.50-μF and a 1.4-μF capacitor (C1 and C2, respectively) are connected in series to a...

Physics
Q

CTLs...binds to an Ag-MHCI complex on the surface of cells that are infected with viruses...

Biology
Q

In a cross of AaBb x AaBb what fraction of the offspring can be expected...

Biology
Q

The U S Weather Bureau has a station on Mauna Loa in Hawaii that has...

Basic Math
Q

The Mosquito Abatement Commission is a newly organized federal agency with three primary programs: coordinating...

Accounting
Q

On January 1, Boston Company completed the following transactions (use a 7% annual interest rate...

Accounting
Q

Determining cash from operations and reconciling with accrual net income (LO 4-5, LO 4-8) The...

Accounting
Q

Payback; ARR Portsmouth Port Services creates and maintains shipping channels at various ports around the...

Accounting
Q

Havana Hats makes the world's best hats. Information for the last elght months follows: Suppose...

Accounting
Q

Lana Company purchased treasury shares with a cost of $40,000 during 2020. During the year,...

Accounting
Q

Principle of Finance 1. Fanny received a credit card with 18% nominal interest rate. With...

Finance