As sales manager, Joe Batista was given the following static budget report for selling expenses in the Clothing Department of Soria Company for the month of October.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
As sales manager, Joe Batista was given the following static budget report for selling expenses in the Clothing Department of Soria Company for the month of October.
SORIA COMPANY
Clothing Department Budget Report For the Month Ended October 31, 2020 |
||||||
---|---|---|---|---|---|---|
Difference
|
||||||
Budget |
Actual |
Favorable
Unfavorable Neither Favorable nor Unfavorable |
||||
Sales in units |
7,500
|
9,000
|
1,500
|
Favorable | ||
Variable expenses | ||||||
Sales commissions |
$1,500
|
$2,160
|
$660
|
Unfavorable | ||
Advertising expense |
750
|
630
|
120
|
Favorable | ||
Travel expense |
3,000
|
3,150
|
150
|
Unfavorable | ||
Free samples given out |
1,125
|
990
|
135
|
Favorable | ||
Total variable |
6,375
|
6,930
|
555
|
Unfavorable | ||
Fixed expenses | ||||||
Rent |
1,000
|
1,000
|
–0–
|
Neither Favorable nor Unfavorable | ||
Sales salaries |
1,000
|
1,000
|
–0–
|
Neither Favorable nor Unfavorable | ||
Office salaries |
600
|
600
|
–0–
|
Neither Favorable nor Unfavorable | ||
|
400
|
400
|
–0–
|
Neither Favorable nor Unfavorable | ||
Total fixed |
3,000
|
3,000
|
–0–
|
Neither Favorable nor Unfavorable | ||
Total expenses |
$9,375
|
$9,930
|
$555
|
Unfavorable |
As a result of this budget report, Joe was called into the president’s office and congratulated on his fine sales performance. He was reprimanded, however, for allowing his costs to get out of control. Joe knew something was wrong with the performance report that he had been given. However, he was not sure what to do, and comes to you for advice.
Prepare a budget report based on flexible budget data to help Joe. (List variable costs before fixed costs.)
SORIA COMPANY
Selling Expense Flexible Budget Report Clothing Department For the Month Ended October 31, 2020 |
|||||||
---|---|---|---|---|---|---|---|
Difference
|
|||||||
Budget
|
Actual
|
Favorable
Unfavorable Neither Favorable nor Unfavorable |
|||||
Select an opening flexible budget report item Advertising ExpenseDepreciation—Sale Staff AutosFixed ExpensesFree SamplesOffice SalariesRentSales CommissionsSales in UnitsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravel ExpenseVariable Expenses
|
Enter a number
|
Enter a number
|
|||||
Select an opening line for section one Advertising ExpenseDepreciation—Sale Staff AutosFixed ExpensesFree SamplesOffice SalariesRentSales CommissionsSales in UnitsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravel ExpenseVariable Expenses
|
|||||||
Select a flexible budget report item
|
$Enter a dollar amount
|
$Enter the difference
|
Select an option UnfavorableFavorableNeither 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 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 line 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 line for section two
|
|||||||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option Neither Favorable nor UnfavorableUnfavorableFavorable
|
|||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option Neither Favorable nor UnfavorableUnfavorableFavorable
|
|||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option Neither Favorable nor UnfavorableUnfavorableFavorable
|
|||
Select a flexible budget report item
|
Enter a dollar amount
|
Enter a dollar amount
|
Enter the difference
|
Select an option Neither Favorable nor UnfavorableUnfavorableFavorable
|
|||
Select a closing line for section two
|
Enter a total amount for section two
|
Enter a total amount for section two
|
Enter the difference
|
Select an option Neither Favorable nor UnfavorableUnfavorableFavorable
|
|||
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
|
Trending now
This is a popular solution!
Step by step
Solved in 2 steps