2. Prepare projected Contribution margin-based Income Statement for the fourth quarter of 20Y3 for Denver and Santa Fe Divisions based on the projected data transferred in the Assumption box. Use formula as needed. Do not hardcode. B DO NOT MAKE CHANGES TO ANY LABELS OR TEXT BELOW. ANY CHANGES MADE WILL RESULT IN A LOSS OF POINTS. ASSUMPTIONS 2 Product: Complan Revenue per unit Total Variable Costs of Goods Sold Total Fixed Costs of Goods Sold Total Variable Selling and Administration Expenses Total Fixed Selling and Administration Expenses Quarterly volume of units sold in the fourth quarter 2013 Sales Total Variable costs Contribution margin Total Fixed costs Net income D Denver $30 Santa Fe $30 $900,000 $2,520,000 $1,650,000 $0 $150,000 $200,000 $320,000 $300,000 200,000 200,000 Projected Contribution Margin based Income Statement For Fourth quarter 20Y2 Denver $ Santa Fe $ An

2. Prepare projected Contribution margin-based Income Statement for the fourth quarter of 20Y3 for Denver and Santa Fe Divisions based on the projected data transferred in the Assumption box. Use formula as needed. Do not hardcode. B DO NOT MAKE CHANGES TO ANY LABELS OR TEXT BELOW. ANY CHANGES MADE WILL RESULT IN A LOSS OF POINTS. ASSUMPTIONS 2 Product: Complan Revenue per unit Total Variable Costs of Goods Sold Total Fixed Costs of Goods Sold Total Variable Selling and Administration Expenses Total Fixed Selling and Administration Expenses Quarterly volume of units sold in the fourth quarter 2013 Sales Total Variable costs Contribution margin Total Fixed costs Net income D Denver $30 Santa Fe $30 $900,000 $2,520,000 $1,650,000 $0 $150,000 $200,000 $320,000 $300,000 200,000 200,000 Projected Contribution Margin based Income Statement For Fourth quarter 20Y2 Denver $ Santa Fe $ An

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 5PA: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an...

See similar textbooks

Similar questions

Fill in the blanks in the schedule below for two separate investment centers A and B. Investment Center: Sales Income Average assets Profit margin Investment turnover Return on investment Investment Center A B Investment Turnover: Investment Center A B Return on investment: Investment Center A Use the information in the table above to compute each department's contribution to overhead (both in dollars and as a percent): (Round your final answers to 2 decimal places.) Profit Margin: B Numerator: Numerator: A Numerator: $? $ 584,600 $1,580,000 10% 7 28 B $ 12,200,000 Denominator: Denominator: $? $7 Denominator: 7% 1.3. 13% Profit Margin =Profit margin 10.00 % = Investment Turnover = Investment turnover 1.30 Return on investment = Return on investment. % 13.00 %
Matching graphs with descriptions of cost and revenue behavior. (D. Green, adapted) Given here are a number of graphs. The horizontal axis of each graph represents the units produced over the year, and the vertical axis represents total cost or revenues. Indicate by number which graph best fits the situation or item described (a–h). Some graphs may be used more than once; some may not apply to any of the situations. Direct material costs Supervisors’ salaries for one shift and two shifts A cost-volume-profit graph Mixed costs—for example, car rental fixed charge plus a rate per mile driven Depreciation of plant, computed on a straight-line basis Data supporting the use of a variable-cost rate, such as manufacturing labor cost of $14 per unit produced Incentive bonus plan that pays managers $0.10 for every unit produced above some level of production Interest expense on $2 million borrowed at a fixed rate of interest
Refer to the information for Jasper Company on the previous page.Required:1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for eachline item on the income statement. (Note: Round percentages to the nearest tenth of a percent.)2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the incomestatement created for Requirement 1 to better control costs.
Using the Microsoft 10K for the Fiscal Year ended June 30, 2018 to answer questions: 1. Interpret the results of 2018 "above the line" compared to 2017 "above the line" and then 2017 "below the line" and 2017 "below the line". 2. What is the revenue and cost streams of MSFT using the 10K. How are the costs allocated between the product and service streams? 3. What are the revenue recognition policy of MSFT?4. What are some examples of the revenue recognition for each area as mentioned in the report?5. What is the EBIT and EBITDA for MSFT for 2018 and 2017? How did you calculate this? 6. Using the MSFT financial statements, what is the variance for the balances listed below). The answer must include: % change from 2017 to 2018$ change from 2017 to 2018please state whether it is a favorable or unfavorable variance from 2017 to 2018 Cost of services Selling, general, administration and other Gross Profit of services Gross Profit of products 7. In the financial statement, what is the…
Fill in the blanks for each of the following independent cases. E (Click the icon to view the cases.) (For entries with a $0 balance, make sure to enter "0" in the appropriate cell. Round the contribution margin percentage to the nearest whole percent.) Variable Fixed Total Operating Contribution Case Revenues Costs Costs Costs Income Margin Percentage $ 2,800 $ 500 $ 400 $ 900 $ 1,900 82 % a. b. $ 2,900 2$ 400 2$ 1,200 % - X Data Table Contribution Fixed Costs Margin Percentage Variable Total Operating Income Case Revenues Costs Costs Case a. $ 500 $ 900 $ 1,900 Case b. $ 2,900 $ 400 $ 1,200 Case c. 2$ 1,000 $ 600 $ 1,000 Case d. $ 1,800 $ 400 50% Print Done
Required: 1) Develop a segmented income statement for Rayya Sdn. Bhd. for the coming year using variable costing.
QS 9-14 (Algo) Components of performance measures LO A1, A2 Fill in the blanks in the schedule below for two separate investment centers A and B. Investment Center A B $ ? $ 382,200 $ 1,470,000 $ 11,100,000 $ ? $ ? Sales Income Average assets Profit margin 8% ?% Investment turnover 1.5 Return on investment ?% 12%
a. Present a cost-profit-volume analysis that shows the effect of adding the $8,500 annual premium to the company's fixed costs by showing current and revised CVP Income Statements. Include a column to the right of each income statement where each line item is expressed as a percentage of sales (called a common size income statement). b. Visualize the changes to net income in a chart. c. Advise the company using your quantitative support and qualitative. reasoning as to whether the company should purchase the insurance. A-Float Pools Company Income Statement (Pools Maintenance Div.) For the Year Ended December 31, 2022 In Sales (2,000 clients) Cost of Services Gross profit Operating expenses Selling Administrative Net Income $165,000 $225,000 $1,100,000 627,000 $473,000 $390,000 $83.000
Gallop Corporation prepared the following report for the first quarter of this year: Sales (@ $3,000 per unit) Less: Cost of goods sold Gross margin $8,400,000 3,372,000 5,028,000 Less: Selling expenses Administrative expenses $1,106,000 1,180,000 2,286, 000 $2,742,000 Income Gallop's controller, Nancy Johnstone, studied the costs in detail, particularly focusing on cost behaviour. Her analysis revealed the following: Fixed portion of the cost of goods sold for the quarter amounted to $1,132,000. • Of the selling expenses, 20% was variable with respect to the number of units. All of the administrative expenses were fixed. Required: 1. Express the cost of goods sold and the selling expenses in terms of cost equations. (Round the "Variable cost" to 2 decimal places.) Cost of goods sold Selling expenses per quarter Y3= per quarter
Prepare an absorption-costing income statement for last year. Round to nearest whole number.
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.