answer in text form please (without image) Flexible Budget for Selling and Administrative Expenses for a Service CompanyDigital Solutions Inc. uses flexible budgets that are based on the following data:Sales commissionsAdvertising expenseMiscellaneous administrative expenseOffice salaries expenseCustomer support expensesResearch and development expenseThis information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input youranswers in the question below.XOpen spreadsheetPrepare a flexible selling and administrative expenses budget for October for sales volumes of $400,000, $800,000, and $1,100,000. (UseExhibit 4 as a model.) Enter all amounts as positive numbers.Total salesVariable cost:10% of sales17% 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 monthSales commissionsDigital Solutions Inc.Flexible Selling and Administrative Expenses BudgetFor the Month Ending October 31$400,000Advertising expenseMiscellaneous administrative expenseCustomer support expensesTotal variable costFixed cost:Miscellaneous administrative expenseOffice salaries expenseCustomer support expensesResearch and development expenseTotal fixed costTotal selling and administrative expenses40,00075,000 X8,000 X$800,00080,000$1,100,000110,000

The costs incurred are classified as fixed and variable costs. The variable costs change with change…

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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Fill out the missing column
Hello question is attached, thanks.
please help me with part E.
can you please write your solution out and not use excel.
Explain how the E-R diagrams is used to prepare database tables. Also, include explanation of cardinalities.
Can you include the explanation and computation please
Select the letter of the item below that best matches the definitions that follow. a. Data Files CD ________ b. Lists ________ c. Forms ________ d. Registers ________ e. Reports and graphs ________ f. Restoring a backup ________ g. Icon bar ________ h. Home page ________ i. Backing up a file ________ 1. One click access to QuickBooks Accountant Centers and Home page. 2. The process of rebuilding a backup file to a full QuickBooks Accountant file ready for additional input. 3. Electronic representations of paper documents used to record business activities such as customer invoices, vendor bills, and checks. 4. A big-picture approach of how your essential business tasks fit together organized by logical groups such as customers, vendors, and employees. 5. Groups of names such as customers, vendors, employees, items, and accounts. 6. Contains backups of all the practice files needed for chapter work and completion of assignments. 7. The process of creating a copy of a…
Explain an example of source documents.
Give an application for a partitioned database.
Describe the elements of an e-mail address.
1
Prepare journal entries using NAS