Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cummings Corp. has three business segmentsthe Plumbing Parts division, Small Tools division, and Design Printing division. Carol Jenkins (Cummings' CFO) and William Samuels (head of

Cummings Corp. has three business segmentsthe 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.

A B
1

Partial productivity ratio (for iron)

2

Total factor productivity ratio (for all raw materials)

PART II: For the Small Tools division, determine the dollar or percentage variance for 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.

A B C D
1

Financial Scorecard Category

Variance ($ or % as Applicable)

SBU

Overperformed or Underperformed?

2

Total revenue

Revenue SBU

3

Total costs

Cost SBU

4

Net income

Profit SBU

5

Return on assets

Investment SBU

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

Here are the price and usage results from August for our Plumbing Parts division:

Price of iron purchased $6.10/lb.
Price of copper purchased $9.60/lb.
Number of pipes/elbows produced 12,000 units
Pounds of copper used 750 lbs.
Pounds of iron used 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.

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 $850,000 Cost of capital 9 percent Net operating profit after taxes $125,000 Net income $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.

Small Tools Division
(Dollars in thousands)
Actual 3 Months Ended 8/31 Budget 3 Months Ended 8/31
Revenue
Consumer sales $ 34,785 $ 33,000
Industrial sales 99,663 102,250
Production costs
Raw materials 32,268 31,108
Direct labor 64,224 66,949
Manufacturing overhead 12,900 13,500
Scrap (unsold) 500 -
Other costs
Management salaries 2,500 2,500
Promotional 300 426
Net income 21,756 20,767
Assets 198,975 188,400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Alnoor Bhimani, Srikant M. Datar, Charles T. Horngren, Madhav V. Rajan

7th Edition

1292232668, 978-1292232669

More Books

Students also viewed these Accounting questions

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago