Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 7 % of sales Advertising expense 1 7 % of

Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions 7% of sales
Advertising expense 17% of sales
Miscellaneous administrative expense $10,500 per month plus 4% of sales
Office salaries expense $50,000 per month
Customer support expenses $25,000 per month plus 33% of sales
Research and development expense $78,000 per month
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,000,000.(Use Exhibit 5 as a model.) Enter all amounts as positive numbers.
Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
Total sales $500,000 $800,000 $1,000,000
Variable cost:
Sales commissions
$fill in the blank 3
$fill in the blank 4
$fill in the blank 5
Advertising expense
fill in the blank 7
fill in the blank 8
fill in the blank 9
Miscellaneous administrative expense
fill in the blank 11
fill in the blank 12
fill in the blank 13
Customer support expenses
fill in the blank 15
fill in the blank 16
fill in the blank 17
Total variable cost $fill in the blank 18
$fill in the blank 19
$fill in the blank 20
Fixed cost:
Miscellaneous administrative expense
$fill in the blank 22
$fill in the blank 23
$fill in the blank 24
Office salaries expense
fill in the blank 26
fill in the blank 27
fill in the blank 28
Customer support expenses
fill in the blank 30
fill in the blank 31
fill in the blank 32
Research and development expense
fill in the blank 34
fill in the blank 35
fill in the blank 36
Total fixed cost $fill in the blank 37
$fill in the blank 38
$fill in the blank 39
Total selling and administrative expenses $fill in the blank 40
$fill in the blank 41
$fill in the blank 42

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach Chapters 1-25

Authors: Jeffrey Slater

12th Edition

013277206X, 978-0132772068

More Books

Students also viewed these Accounting questions

Question

What influences peoples choice of values?

Answered: 1 week ago

Question

Th ey have to wait a long time for an appointment?

Answered: 1 week ago