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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Step 1 Introduction

Inventory Turnover Ratio :— It is the ratio between cost of goods sold and average inventory. 

 

Asset Turnover Ratio :— It is the ratio between net sales and total assets.

 

Return on assets (ROA) :— It is calculated by dividing net income by total assets.

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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education