Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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 7% of sales Advertising expense 15% of sales Miscellaneous administrative expense $10,500 per month plus 4% of sales Office salaries expense $55,000 per month Customer support expenses $18,000 per month plus 32% of sales Research and development expense $73,000 per month This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your weathe question below X HL Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000 $900,000, and $1.200.000 Enter all amounts as positive numbers Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, 5900,000, and $1,200,000. (Use Exhibit 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 $900,000 Variable cost: $1,200,000 Sales commissions 35,000 $ 63,000 84,000 Advertising expense 75,000 135,000 180,000 Miscellaneous administrative expense 30,500 x 46,500 x 58,500 x Customer support expenses 178,000 X 306,000 X 102,000 x Total variable cost 318,500 X 550,500 X 5 724,500 X Fixed cost: Miscellaneous administrative expense 10,500 10,500 5 10,500 Office salaries expense 55,000 55,000 55,000 18,000 Customer support expenses 18.000 18,000 73,000 Research and development expense 71000 73,000 156,500 156,500 156,500 Totalfixed cost 475,000 X 707.000 x 1.000 x Total selling and administrative expenses

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

A History Of Accountancy In The United States

Authors: Gary John Previts, Barbara Dubis Merino

98th Edition

0814207286, 978-0814207284

More Books

Students also viewed these Accounting questions