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
icon
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   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.)

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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Planning
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
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
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
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 Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College