he actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (a) Prepare a flexible budget performance report for March, assuming that March sales were $173,000. Variable costs and their percentage relationship to sales are sales commissions 6%, advertising 6%, traveling 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,500, Depreciation on delivery equipment $7,400, and insurance on delivery equipment $1,100. (List variable costs before fixed costs.)
he actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (a) Prepare a flexible budget performance report for March, assuming that March sales were $173,000. Variable costs and their percentage relationship to sales are sales commissions 6%, advertising 6%, traveling 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,500, Depreciation on delivery equipment $7,400, and insurance on delivery equipment $1,100. (List variable costs before fixed costs.)
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
Related questions
Question
The actual selling expenses incurred in March 2020 by Fallon Company are as follows.
Variable Expenses
|
Fixed Expenses
|
|||||
---|---|---|---|---|---|---|
Sales commissions | $11,180 | Sales salaries | $35,500 | |||
Advertising | 10,530 | 7,400 | ||||
Travel | 6,920 | Insurance | 1,100 | |||
Delivery | 3,580 |
(a) Prepare a flexible budget performance report for March, assuming that March sales were $173,000. Variable costs and their percentage relationship to sales are sales commissions 6%, advertising 6%, traveling 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,500, Depreciation on delivery equipment $7,400, and insurance on delivery equipment $1,100. (List variable costs before fixed costs.)
FALLON COMPANY
Selling Expense Flexible Budget Report For the Month Ended March 31, 2020 |
|||||||
---|---|---|---|---|---|---|---|
Difference
|
|||||||
Budget
|
Actual
|
Favorable
Unfavorable Neither Favorable nor Unfavorable |
|||||
Select an opening flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
$Enter a dollar amount
|
$Enter a dollar amount
|
|||||
Select an opening name for section one AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
|||||||
Select a flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
$Enter a dollar amount
|
$Enter a dollar amount
|
$Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a closing name for section one
|
Enter a total amount for section one
|
Enter a total amount for section one
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select an opening name for section two
|
|||||||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a closing name for section two
|
Enter a total amount for section two
|
Enter a total amount for section two
|
Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
|||
Select a closing flexible budget report item
|
$Enter a total dollar amount
|
$Enter a total dollar amount
|
$Enter the difference
|
Select an option FavorableUnfavorableNeither Favorable nor Unfavorable
|
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College