Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 10% of sales 17% of sales $10,000 per month plus 6% of sales $49,000 per month $21,000 per month plus 33% of sales $73,000 per month Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense 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.
Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 10% of sales 17% of sales $10,000 per month plus 6% of sales $49,000 per month $21,000 per month plus 33% of sales $73,000 per month Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense 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.
Accounting Information Systems
10th Edition
ISBN:9781337619202
Author:Hall, James A.
Publisher:Hall, James A.
Chapter8: Financial Reporting And Management Reporting Systems
Section: Chapter Questions
Problem 5P
Related questions
Question
answer in text form please (without image)
![Flexible Budget for Selling and Administrative Expenses for a Service Company
Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions
Advertising expense
Miscellaneous administrative expense
Office salaries expense
Customer support expenses
Research and development expense
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.
X
Open spreadsheet
Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $800,000, and $1,100,000. (Use
Exhibit 4 as a model.) Enter all amounts as positive numbers.
Total sales
Variable cost:
10% of sales
17% of sales
$10,000 per month plus 6% of sales
$49,000 per month
$21,000 per month plus 33% of sales
$73,000 per month
Sales commissions
Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
$400,000
Advertising expense
Miscellaneous administrative expense
Customer support expenses
Total variable cost
Fixed cost:
Miscellaneous administrative expense
Office salaries expense
Customer support expenses
Research and development expense
Total fixed cost
Total selling and administrative expenses
40,000
75,000 X
8,000 X
$800,000
80,000
$1,100,000
110,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F43c74623-d722-4277-b33e-b02f0ab0d49d%2F4ca80f40-4699-4471-b297-58de29d7e76b%2F619a5o_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Flexible Budget for Selling and Administrative Expenses for a Service Company
Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions
Advertising expense
Miscellaneous administrative expense
Office salaries expense
Customer support expenses
Research and development expense
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.
X
Open spreadsheet
Prepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $800,000, and $1,100,000. (Use
Exhibit 4 as a model.) Enter all amounts as positive numbers.
Total sales
Variable cost:
10% of sales
17% of sales
$10,000 per month plus 6% of sales
$49,000 per month
$21,000 per month plus 33% of sales
$73,000 per month
Sales commissions
Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
$400,000
Advertising expense
Miscellaneous administrative expense
Customer support expenses
Total variable cost
Fixed cost:
Miscellaneous administrative expense
Office salaries expense
Customer support expenses
Research and development expense
Total fixed cost
Total selling and administrative expenses
40,000
75,000 X
8,000 X
$800,000
80,000
$1,100,000
110,000
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College