A Christchurch manufacturer of cables and electronic components reports the 2020 results shown in the table. PROPOSED CHANGES The supply chain manager is working to reduce inventory levels by 30% (given the low inventory turnover rate), but is also concerned that reduced inventories will reduce product availability for fulfilling customer orders. Therefore, a $250,000 investment in new processing equipment will be required. The benefit of this new equipment will be a reduction in COGS to 38% of sales revenue. The new production process will also require a more premium form of transportation for customer delivery so as maintain the current cycle time that customers expect. Transportation costs are expected to rise by 5% over current levels. No other changes are expected. Determine Inventory turnover rate, Asset turnover rate, and ROA for the proposed changes Should the manager move ahead with these plans? Explain your recommendation.

Entrepreneurial Finance
6th Edition
ISBN:9781337635653
Author:Leach
Publisher:Leach
Chapter14: Security Structures And Determining Enterprise Values
Section: Chapter Questions
Problem 8EP
icon
Related questions
Question

BASE CASE

A Christchurch manufacturer of cables and electronic components reports the 2020 results shown in the table.

PROPOSED CHANGES

The supply chain manager is working to reduce inventory levels by 30% (given the low inventory turnover rate), but is also concerned that reduced inventories will reduce product availability for fulfilling customer orders. Therefore, a $250,000 investment in new processing equipment will be required. The benefit of this new equipment will be a reduction in COGS to 38% of sales revenue. The new production process will also require a more premium form of transportation for customer delivery so as maintain the current cycle time that customers expect. Transportation costs are expected to rise by 5% over current levels. No other changes are expected.

  1. Determine Inventory turnover rate, Asset turnover rate, and ROA for the proposed changes

  2. Should the manager move ahead with these plans? Explain your recommendation.

2020 Performance Results
Sales
COGS
Transportation Expenses
Warehousing Expenses
Inventory Carrying Cost Rate
Accounts Receivable
Average Inventory
Other Current Assets
Fixed Assets
Other Operating Costs
$82,500,000
40%
$17,500,000
$9,000,000
20%
$2,500,000
$14,200,000
$7,000,000
$45,000,000
$16,000,000
Transcribed Image Text:2020 Performance Results Sales COGS Transportation Expenses Warehousing Expenses Inventory Carrying Cost Rate Accounts Receivable Average Inventory Other Current Assets Fixed Assets Other Operating Costs $82,500,000 40% $17,500,000 $9,000,000 20% $2,500,000 $14,200,000 $7,000,000 $45,000,000 $16,000,000
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Accounting systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning