Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 6% of sales 16% of sales $8,000 per month plus 5% of sales $50,000 per month Customer support expenses Research and development expense $25,000 per month plus 33% of sales $79,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. X Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $700,000, and $1,200,000. (Use Exhibit 4 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 Variable cost: Total variable cost Fixed cost: Total fixed cost Total selling and administrative expenses $500,000 $700,000 $1,200,000 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 6% of sales 16% of sales $8,000 per month plus 5% of sales $50,000 per month Customer support expenses Research and development expense $25,000 per month plus 33% of sales $79,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. X Open spreadsheet Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $700,000, and $1,200,000. (Use Exhibit 4 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 Variable cost: Total variable cost Fixed cost: Total fixed cost Total selling and administrative expenses $500,000 $700,000 $1,200,000
Expert Answer:
Answer rating: 100% (QA)
To prepare the flexible selling and administrative expenses budget for Digital Solutions Inc for the ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Nintendo, a game manufacturer, has a new idea for an adventure game. It can either market the game as a traditional board game or as a mobile app. but not both. Consider the following cash flows of...
-
Given s(t) = 2t+4, where s(t) is in miles and t is in hours, find each of the following. a) v(t) b) a(t) c) The velocity and acceleration when t=2 hr d) When the distance function is given by a...
-
Discuss the role of the family in childrens socialization.
-
How do tax rules affect accounting rules and practice in some countries?
-
Where can you obtain information about the responsibilities, compensation, and career potential of a certain job?
-
A spring with a force constant of 3.5 104 N/m is initially at its equilibrium length. (a) How much work must you do to stretch the spring 0.050 m? (b) How much work must you do to compress it 0.050...
-
Additional information accumulated for the budgeting process is as follows. Budgeted data for the year 2003 include the following. To meet sales requirements and to have 2,500 units of finished goods...
-
The following table contains current asset and current liability balances for Microsoft Corporation (MSFT): a. Assume that you are the lead banker for the syndicate of banks that manages Microsoft...
-
Marine Economics: For the following problem, fill in the blanks. The cost per boat is constant at $2,000. The price per pound is $1,000. a. Given this information complete the following table, pay...
-
Water flows at the rate of 0.5 kg/s in a 2.5-cm-diameter tube having a length of 3 m. A constant heat flux is imposed at the tube wall so that the tube wall temperature is 40C higher than the water...
-
Write a function sum_of_rows_columns in a Python file named 1ab12_p2.py that takes a 2D list as a parameter and then returns a tuple containing two lists, the first list containing the sum of each...
-
I would like to see an example code for this project, id like to use it for reference I'm having trouble with my work. Ive included my works aswell so if you have time to take a look andy help with...
-
The manager of UPTOWN hotel wants to yield a total of $10,000 by investing over the next 2 years. How much cash must be invested today at an annual interest rate of 10% compounded semi-annually ?...
-
A segment of a company reports the following loss for the year. All $178,500 of its variable costs are avoidable, and $111,000 of its fixed costs are avoidable. Segment Income (Loss) Sales Variable...
-
Convertible Bond Arbitrage desk managers closely monitor their book delta exposure and dynamically hedge the risk by shorting the related stocks. (1) What is the major reason why the Convertible Bond...
-
A water fall is 70 m high. What is the increase in temperature(in degrees C) of the water at the bottom of the falls if all of the initial potential energy goes into heating of the water? (specific...
-
Gianni is thinking about starting his Social Security retirement benefits early. His PIA is $ 2 , 2 0 0 / month . What would Gianni receive per month if he started the benefits 3 6 months early? A )...
-
A Bloomberg Businessweek subscriber study asked, In the past 12 months, when traveling for business, what type of airline ticket did you purchase most often? A second question asked if the type of...
-
During 2015, Prosperity Oil Company acquired the following leases: In acquiring and exploring these leases, Prosperity Oil Company incurred the following additional costs: Shooting rights, \($3,000\)...
-
Bryant Oil Corporation acquired a lease on October 15, 2015, for \($200,000\) cash. No drilling was done on the lease during the first year. Since Bryant wished to retain the lease, a delay rental of...
-
Railway Oil and Gas Company owned the following unproved property as of the end of 2010: Although no activity took place on Lease A during the year, Railway decided that Lease A was not impaired,...
Study smarter with the SolutionInn App