Flexible budget for selling and administrative expenses for
a service company
Digital Solutions Inc. uses flexible budgets that are
based on the following data:
This information has been collected in the Microsoft Excel
Online file. Open the spreadsheet, perform the required analysis,
and input your answers in the question below.
Open spreadsheet
Prepare a flexible selling and administrative expenses budget
for October for sales volumes of $500,000, $800,000, and
$1,200,000. (Use Exhibit 5 as a model.) Enter all amounts
as positive numbers.
CashOffice salaries expenseSales commissionsSupplies
expenseWages expense
Advertising expenseCashOffice salaries expenseSupplies
expenseWages expense
Miscellaneous administrative expenseOffice salaries
expensePrepaid insuranceRent expenseWages expense
Customer support expensesRent expenseResearch and development
expenseSupplies expenseWages expense
Insurance expenseMiscellaneous administrative expenseRent
expenseSupplies expenseWages expense
Insurance expenseOffice salaries expensePrepaid insuranceRent
expenseWages expense
Customer support expensesInsurance expenseRent expenseSupplies
expenseWages expense
Insurance expenseRent expenseResearch and development
expenseSupplies expenseWages expense
Flexible budget for selling and administrative expenses for a service company Digital Solutions Inc. uses flexible budge
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am