Question

Data for three business units is shown below. Determine the unknowns. (Round return on sales and investment turnover to 2 dec

0 0
Add a comment Improve this question Transcribed image text
Answer #1

fe =+ROUND(D4/D3,2) D7 D Unit 2 Unit 3 Unit 1 2 Income 10948 46722 79170 3 Investment 273000 47,600 245800 4 Sales 142,800 44B14 A Unit 1 Unit 2 Unit 3 |=+ROUND(C4*C6,0) =+D3*D5 =+C4/C7 10948 2 Income =+B2/B5 =+B3*B7 273000 3 Investment =+ROUND(D2/D6

Add a comment
Know the answer?
Add Answer to:
Data for three business units is shown below. Determine the unknowns. (Round return on sales and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Presented below is selected information for two regional divisions of Yono Company: Divisions North West Sales...

    Presented below is selected information for two regional divisions of Yono Company: Divisions North West Sales $401,800 $538,000 Operating income 61,811 102,968 Average investment 113,000 244,000 Calculate the return on investment for each division and then break it down into the return on sales and investment turnover. (Round Return on sales to 1 decimal places, e.g. 5.2% and other answers to 2 decimal place, e.g. 5.25 or 5.25%.) North Division Return on investment % Return on sales % Investment turnover...

  • Fill in the blanks: (Round "Return on sales" and "Asset turnover" answers to 2 decimal places....

    Fill in the blanks: (Round "Return on sales" and "Asset turnover" answers to 2 decimal places. Division X Y Z Sales $375,000 $600,000 Operating income 37,500 240,000 Investment (assets) 150,000 6,000,000 1,980,000 Return on sales 10.00 % % 0.50 % Asset turnover 2.50 1.70 Return on investment 25.00 % 4.00 % %

  • Miller Company’s most recent contribution format income statement is shown below: Total Per Unit Sales (39,000...

    Miller Company’s most recent contribution format income statement is shown below: Total Per Unit Sales (39,000 units) $273,000 $7.00 Variable expenses 156,000 4.00 Contribution margin 117,000 $3.00 Fixed expenses 49,000 Net operating income $ 68,000 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): (Do not round intermediate calculations. Round your "Per unit" answers to 2 decimal places.) 1. The number of units sold increases by 15%. 2. The selling price...

  • CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below:...

    CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below:   Sales $ 10,640,000   Net operating income $ 744,800   Average operating assets $ 3,800,000 4. value: 1.25 points Required information Required: 1. Compute the company's margin, turnover and return on investment (ROI). (Round your Turnover answer to 2 decimal places. Round your Margin and ROI percentage answers to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)       References eBook & Resources WorksheetDifficulty: 2...

  • Problem 4-14 Culver Tennis Racquet Co. produces and sells three models: Units sold Sales Less variable...

    Problem 4-14 Culver Tennis Racquet Co. produces and sells three models: Units sold Sales Less variable costs Contribution margin Less common fixed costs Profit Smasher 2,000 $160,300 73,800 $86,500 Basher 3,200 $168,100 69,600 $98,500 Dinker 3 ,200 $117,400 35,600 $81,800 Total 8,400 $445,800 179,000 266,800 141,900 $124,900 What is the weighted average contribution margin per unit? (Round answer to 2 decimal places, e.g. 15.25.) Weighted average contribution margins per unit LINK TO TEXT Calculate the break-even point in units assuming...

  • Selected sales and operating data for three divisions of different structural engineering firms are given as...

    Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 7,400,000 $ 11,400,000 $ 10,500,000 Average operating assets $ 1,480,000 $ 2,850,000 $ 2,100,000 Net operating income $ 481,000 $ 1,197,000 $ 393,750 Minimum required rate of return 28.00 % 42.00 % 25.00 % 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover. (Round...

  • Bramble Design Works generated $365,000 in operating income on sales revenue of $2,000,000. The company had...

    Bramble Design Works generated $365,000 in operating income on sales revenue of $2,000,000. The company had $2,520,000 in assets on January 1 and $2,920,000 in assets on December 31 (a) Calculate Bramble's margin. (Round answer to 0 decimal places, e.g. 5%) Bramble's margin % (b) Calculate Bramble's asset turnover. (Round answer to 2 decimal places, e.g. 0.65.) Bramble's asset turnover times Calculate Bramble's return on investment. (Round answer to 2 decimal places, e.g. 512%) Bramble's return on investment %

  • Miller Company’s most recent contribution format income statement is shown below: Total Per Unit Sales (39,000...

    Miller Company’s most recent contribution format income statement is shown below: Total Per Unit Sales (39,000 units) $273,000 $7.00 Variable expenses 156,000 4.00 Contribution margin 117,000 $3.00 Fixed expenses 46,000 Net operating income $ 71,000 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): (Do not round intermediate calculations. Round your "Per unit" answers to 2 decimal places.)     1. The number of units sold increases by 15%. 2. The selling...

  • Mills Manufacturing Inc. had sales for January 2020 of $900,000. The units sold were 18,000, and...

    Mills Manufacturing Inc. had sales for January 2020 of $900,000. The units sold were 18,000, and the expenses for January 2020 were as follows: Variable Fixed Cost of goods sold $171,000 $108,000 Selling expenses 49,500 24,300 Administrative expenses 24,300 28,800 Prepare a detailed CVP income statement for the month ended January 31, 2020. (Round per unit cost to 2 decimal places, e.g. 15.25.) Mills Manufacturing Inc. CVP Income Statement Total Per unit $ Calculate the contribution margin per unit. (Round...

  • The accounting records of Sheridan Company show the following data. Beginning inventory Purchases Sales 3,000 units...

    The accounting records of Sheridan Company show the following data. Beginning inventory Purchases Sales 3,000 units at $6 9,000 units at $8 10,400 units at $11 Calculate average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Average unit cost $ per unit e Textbook and Media List of Accounts Determine cost of goods sold during the period under a periodic inventory system using the FIFO method, the LIFO method, and the average-cost method. (Round answers to 0 decimal...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT