Cummings Corp. has three business segmentsthe Plumbing Parts division, Small Tools division, and Design Printing division....
Fantastic news! We've Found the answer you've been seeking!
Question:
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/02/63eb742582184_07763eb74256d54c.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/02/63eb74267745d_07863eb742668da6.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/02/63eb74274e4d2_07963eb74273dcdb.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/02/63eb74284dded_08063eb74283cd7b.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/02/63eb742950fa8_08163eb742940aa1.jpg)
Transcribed Image Text:
Cummings Corp. has three business segments—the Plumbing Parts division, Small Tools division, and Design Printing division. Carol Jenkins (Cummings' CFO) and William Samuels (head of Production) would like to analyze the performance of each division using financial and nonfinancial measures. Using the information contained in the exhibits, complete the sections below. The information in the Analytics Definitions exhibit must be used for all financial ratio calculations. PART I: For the Plumbing Parts division, calculate the partial productivity ratio (PPR) for iron material used and the total factor productivity (TFP) ratio for all raw materials used to produce the division's plumbing pipes and elbows during August. Insert answers in table below. 1 Partial productivity ratio (for iron) 2 Total factor productivity ratio (for all raw materials) 1 A PART II: For Small Tools division, determine the dollar or percentage variance each financial scorecard category, inserting the variance as a positive amount in the table below. Also, indicate whether each SBU (revenue, cost, profit, investment) underperformed or overperformed on the head of Production's financial scorecard, based on the results of the variance analysis. Category Financial Scorecard Variance ($ or % as Applicable) 2 Total revenue 3 Total costs A 4 Net income 5 Return on assets B C SBU B 123 Revenue SBU 123 Cost SBU 123 Profit SBU 123 Investment SBU 123 123 D Overperformed or Underperformed? # PART III: For the Design Printing division, calculate the economic value added of the new investment and insert the correct answer in the table provided below. Economic value added 123 Memo: August Production Data Memo: August Production Data Memo To: All Cummings Corp. From: James Blake, manager-Plumbing Parts division Date: September 20, Year 3 Re: August production data and future forecasts Here are the price and usage results from August for our Plumbing Parts division: Price of iron purchased Price of copper purchased Number of pipes/elbows produced Pounds of copper used Pounds of iron used $6.10/lb. $9.60/lb. 12,000 units 750 lbs. 4,800 lbs. As you know, our division manufactures specialized pipes and elbows primarily for industrial/institutional facilities. The raw materials used for these related products are iron and copper, with iron the primary production input. Over the last few months, we have negotiated price reductions from our suppliers and expect per-pound prices for iron and copper to fall by 10 cents and 15 cents, respectively. These price reductions should begin to take effect next month. E-mail Financial Data Small Tools Div. E-mail Financial Data Small Tools Division Tuesday, September 18, Year 3 10:26 a.m. Abrams, Shane (manager, Small Tools division-Cummings Corp.) Small Tools division—Financial data quarter ended 8.31 Samuels, William (head of Production-Cummings Corp.) To: Hi Will, Please see the screen shot below, which reflects the quarterly performance for Small Tools-actuals to budget. Small Tools Division (Dollars in thousands) S.A. Revenue Consumer sales Industrial sales Production costs Raw materials Direct labor Manufacturing overhead Scrap (unsold) Other costs Management salaries Promotional Net income Assets Actual 3 Months Ended 8/31 $ 34,785 $ 99,663 32,268 64,224 12,900 500 2,500 300 21,756 Budget 3 Months Ended 8/31 198,975 33,000 102,250 As always, if you have any questions, please do not hesitate to call me. 31,108 66,949 13,500 2,500 426 20,767 188,400 Excerpt From Production Manager Meeting Excerpt From Production Manager Meeting Production meeting: September 17, Year 3 Attendees: Carol Jenkins, William Samuels, James Blake, Shane Abrams, Kelly Blanton First presenter is Kelly Blanton, manager for the Design Printing division. Notes from Kelly's presentation At the beginning of the fiscal year, they purchased a state-of-the art printing machine. Information regarding this purchase and other financial data for the 12 months ending on August 31 of the current year: Cost of printing machine Cost of capital Net operating profit Net income axes $850,000 9 percent $125,000 $100,000 Per Kelly, they are also considering several other capital equipment purchases that will likely occur in October or November. The expected cost for these total approximately $1.2 million. Cummings Corp. has three business segments—the Plumbing Parts division, Small Tools division, and Design Printing division. Carol Jenkins (Cummings' CFO) and William Samuels (head of Production) would like to analyze the performance of each division using financial and nonfinancial measures. Using the information contained in the exhibits, complete the sections below. The information in the Analytics Definitions exhibit must be used for all financial ratio calculations. PART I: For the Plumbing Parts division, calculate the partial productivity ratio (PPR) for iron material used and the total factor productivity (TFP) ratio for all raw materials used to produce the division's plumbing pipes and elbows during August. Insert answers in table below. 1 Partial productivity ratio (for iron) 2 Total factor productivity ratio (for all raw materials) 1 A PART II: For Small Tools division, determine the dollar or percentage variance each financial scorecard category, inserting the variance as a positive amount in the table below. Also, indicate whether each SBU (revenue, cost, profit, investment) underperformed or overperformed on the head of Production's financial scorecard, based on the results of the variance analysis. Category Financial Scorecard Variance ($ or % as Applicable) 2 Total revenue 3 Total costs A 4 Net income 5 Return on assets B C SBU B 123 Revenue SBU 123 Cost SBU 123 Profit SBU 123 Investment SBU 123 123 D Overperformed or Underperformed? # PART III: For the Design Printing division, calculate the economic value added of the new investment and insert the correct answer in the table provided below. Economic value added 123 Memo: August Production Data Memo: August Production Data Memo To: All Cummings Corp. From: James Blake, manager-Plumbing Parts division Date: September 20, Year 3 Re: August production data and future forecasts Here are the price and usage results from August for our Plumbing Parts division: Price of iron purchased Price of copper purchased Number of pipes/elbows produced Pounds of copper used Pounds of iron used $6.10/lb. $9.60/lb. 12,000 units 750 lbs. 4,800 lbs. As you know, our division manufactures specialized pipes and elbows primarily for industrial/institutional facilities. The raw materials used for these related products are iron and copper, with iron the primary production input. Over the last few months, we have negotiated price reductions from our suppliers and expect per-pound prices for iron and copper to fall by 10 cents and 15 cents, respectively. These price reductions should begin to take effect next month. E-mail Financial Data Small Tools Div. E-mail Financial Data Small Tools Division Tuesday, September 18, Year 3 10:26 a.m. Abrams, Shane (manager, Small Tools division-Cummings Corp.) Small Tools division—Financial data quarter ended 8.31 Samuels, William (head of Production-Cummings Corp.) To: Hi Will, Please see the screen shot below, which reflects the quarterly performance for Small Tools-actuals to budget. Small Tools Division (Dollars in thousands) S.A. Revenue Consumer sales Industrial sales Production costs Raw materials Direct labor Manufacturing overhead Scrap (unsold) Other costs Management salaries Promotional Net income Assets Actual 3 Months Ended 8/31 $ 34,785 $ 99,663 32,268 64,224 12,900 500 2,500 300 21,756 Budget 3 Months Ended 8/31 198,975 33,000 102,250 As always, if you have any questions, please do not hesitate to call me. 31,108 66,949 13,500 2,500 426 20,767 188,400 Excerpt From Production Manager Meeting Excerpt From Production Manager Meeting Production meeting: September 17, Year 3 Attendees: Carol Jenkins, William Samuels, James Blake, Shane Abrams, Kelly Blanton First presenter is Kelly Blanton, manager for the Design Printing division. Notes from Kelly's presentation At the beginning of the fiscal year, they purchased a state-of-the art printing machine. Information regarding this purchase and other financial data for the 12 months ending on August 31 of the current year: Cost of printing machine Cost of capital Net operating profit Net income axes $850,000 9 percent $125,000 $100,000 Per Kelly, they are also considering several other capital equipment purchases that will likely occur in October or November. The expected cost for these total approximately $1.2 million.
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep workings for the questions in Part I II and III Part I 1 Partial productivity ratio PPR for iron material used in Plumbing Parts division PPR measures the efficiency in which a ... View the full answer
Related Book For
Concepts In Federal Taxation
ISBN: 9780324379556
19th Edition
Authors: Kevin E. Murphy, Mark Higgins, Tonya K. Flesher
Posted Date:
Students also viewed these accounting questions
-
The supply chain director would like to analyze the relationship of the variables in the dataset with customer delivery satisfaction score a. derive a regression model. a. Develop an appropriate...
-
A mortgage specialist would like to analyze the average mortgage rates for Atlanta, Georgia. He studies the following sample APR quotes. These are the annual percentage rates (APR) for 30-year fixed...
-
A social scientist would like to analyze the relationship between educational attainment and salary. He collects the following sample data, where Education refers to years of higher education and...
-
(a) Let k be any real number and a < 1. Show that the function (1+x)k has the following power series representation (1 + x) = (h)a = 1+ kx + ? -x + k(k-1) 2! n=0 The above series is called the...
-
Consider the residuals from Exercise 5b. a. Make a box plot of these values. b. Describe the information about the residuals that is shown in the box plot.
-
What are the positives and negatives associated with being an international business traveler?
-
What does the sample correlation coefficient r measure? Which value indicates a stronger correlation: or Explain your reasoning.
-
You are a real estate agent thinking of placing a sign advertising your services at a local bus stop. The sign will cost $5000 and will be posted for one year. You expect that it will generate...
-
Record $3,600 paid for 12 months of rent beginning January 1. Record as an asset. Note: Enter debits before credits. Date General Journal Debit Credit January 02
-
Parent Co, a U.S. firm, paid $525,000 cash to acquire all of the stock of the British Trm sub Co when the book value of Sub's net assets was equal to fair value. This business combination occurred on...
-
14. Consider two mutually exclusive projects X and Y with identical initial outlays of $600,000 and useful lives of 5 years. Project X is expected to produce an after-tax cash flow of $180,000 each...
-
Noeleen AutoMall, Ltd. recently completed an initial public offering(IPO) for$23,000,000 by listing its common shares on the New York Stock Exchange. Prior to itsIPO, Noeleen was a privately held...
-
Process Costing- increased units, FIFO method Answer in good form 25 26 Illustrative Problem-Cost of Production Report using Treatment by Neglect Dept 1-100% of materials are added at the beginning....
-
Write a C++ program that prompts the user to enter a letter and encrypt it using the following method: if the letter is an upper-case letter the program replaces the letter by the 7th letter in the...
-
Turn this information into an excel sheets with the excel formulas being shown P12.4 (LO 1) (Payroll Tax Entries) The following is a payroll sheet for Otis Imports for the month of September 2025....
-
What is the major factor preventing women of the Indian diaspora from engaging in elaborate rituals? Group of answer choices Lack of motivation or devotion Because rituals are tied to a place and...
-
Multiple Product Break-Even Analysis Joe's Tax Service prepares tax returns for low-to middle-income taxpayers. Its service operates January 2 through April 15 at a counter in a local grocery store....
-
What are the six activities involved in the physical supply/distribution system?
-
Alleys automobile dealership, which has an adjusted basis of $400,000, is destroyed by a hurricane in the current year. Alleys receives $600,000 from its insurance company to cover the loss. Alleys...
-
Nina is the auditor for Geiger Construction, a local builder. Geiger recently renovated a historic building in downtown Kingston. The building, which consists of 5 shops, is owned by the Restoring...
-
The Showgate Hotel Casino is an accrual basis taxpayer and maintains its records on a calendar year. It has 3,000 slot machines, one of them a progressive machine whose jackpot increases based on the...
-
At various points inthisbook, Dell,Inc.,thecomputer manufacturer, hasbeenhighlighted. The firm's 2008 financial statements are reproduced in Exhibit 2.1 in Chapter 2 and its reformulated balance...
-
E10.10. Free Cash Flow for Kimberley-Clark Corporation (Medium) Below are summary numbers from reformulated balance sheets for 2007 and 2006 for Kimberly-Clark Corporation, the paper products...
-
E10.8. Free Cash Flow and Financing Activities: General Electric Company (Easy) The following summarizes free cash flows generated by General Electric from 2000-2004 (in millions of dollars). 2000...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App