Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUARTER 1 U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters

image text in transcribed
image text in transcribed
image text in transcribed
QUARTER 1 U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States. Conada, and Europe. You have collected the following data relating the value of inventory in the U.S. Airfilter supply chain: QUARTER 2 QUARTER 4 (JANUARY (APRIL THROUGH (OCTOBER JUNE) All amounts in millions of 1.5 dollars Sales (total quarter): United states Canada Europe QUARTER 3 (JULY THROUGH SEPTEMBER) THROUGH MARCH THROUGH DECEMBER) 520 120 55 558 95 36 580 161 41 594 96 22 Cost of goods sold (total quarter) 516 596 678 621 56 72 23 160 126 126 155 Raw materials at the Louisville plant (end-of-quarter Work-in-process and finished goods at the Louisville plant (end of quarters Distribution center inventory (end of quarter) United states Canada Europe 26 12 7 43 15 39 25 7 35 17 8 a. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) o. What is the average inventory turnover for the firm? (Round your answer to 3 decimal places.) Average mventory tumaver b. If you were given the assignment to increase inventory turnover, who would you focus on? Reduce the amount of inventory or reduce sales or both O Increase the amount of inventory or increase sales or both Reduce the amount of inventory or increase sales or both c. The company reported that it used $6297M worth of raw material during the year On average, how many weeks of supply of raw material are on hand at the factory? (Round your answer to 2 decimal places.) c. The company reported that it used $6297M worth of raw material during the year. On average, how many weeks of supply of rew material are on-hand at the factory? (Round your answer to 2 decimal places.) Works of supply

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

Bank Performance, Risk And Firm Financing

Authors: P. Molyneux

1st Edition

0230313353, 9780230313354

More Books

Students also viewed these Accounting questions

Question

In Problem find A -1 and A 2 . -5 4 -9- -6 5

Answered: 1 week ago

Question

Understand the goals of succession planning

Answered: 1 week ago