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:
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...
-
Anew Italian restaurant called the Olive Grove is opening in several locations in the Memphis area. The marketing manager for these stores has a budget of $150,000 to use in advertising and...
-
Mode Inc. bought 40% of Mean Co. on January 3, 2024, for $576,000. The equity method of accounting was used. The book value and fair value of the net assets of Mean Co. on that date were $1,440,000....
-
A certain 10-year bond is currently selling for \(\$ 920\). A friend of yours owns a forward contract on this bond that has a delivery date in 1 year and a delivery price of \(\$ 940\). The bond pays...
-
Refer to the data in the previous problem for Peterson Pipes. Peterson expects its first-quarter opening balances in cash, accounts receivable, and accounts payable to be $75,000, $125,000, and...
-
On April 1, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company's first month. April 2 Nozomi invested $30,000 cash and computer...
-
Skylar and Walter Black have been married for 25 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Skylar is a stay-at-home parent and Walt is a high school teacher. His W-2...
-
Harry Mazzola has the utility function U ( x 1 , x 2 ) = min{ x 1 + 2 x 2 , 2 x 1 + x 2 }. He has $40 to spend on corn chips and french fries. If the price of corn chips is $3 per unit and the price...
-
What are three characteristics that make a given stimulus more likely to be selected for attention?
-
What does it mean to recognize diversity in an ethical manner?
-
Define and give examples of the open, hidden, blind, and unknown areas of the Johari window.
-
What does it mean to say that some words are more concrete than others?
-
How can online meeting software facilitate a productive interaction in an online meeting?
-
The rival firm did not default - so your demand is back to the original values (Region 1: 25, Region 2: 95, and Region 3: 80). The management of Plant 2 has suggested they may use some of the...
-
Proposals have been made to ?sail? spacecraft to the outer solar system using the pressure of sunlight, or even to propel interstellar spacecraft with high-powered, Earth-based lasers. Sailing...
-
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...
-
Apple stock is selling for \($120\) per share. Call options with a \($117\) exercise price are priced at \($12.\) What is the intrinsic value of the option, and what is the time value?
-
Refer to Problem 14.9. What would the loss of the seller of the put option be if, at expiration, XLB is trading at \($20?\) What would the profit of the seller be if, at expiration, XLB is trading at...
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
Study smarter with the SolutionInn App