U.S. Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air
Posted: Thu May 05, 2022 11:07 am
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, Canada, and Europe. You have collected the
following data relating to the value of inventory in the U.S.
Airfilter supply chain:
b. If you were given the assignment to
increase inventory turnover, what would you focus on?
Reduce the amount of inventory or increase sales or both
Reduce the amount of inventory or reduce sales or both
Increase the amount of inventory or increase sales or both
c. The company reported that it used
$579.4M 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.)
Sales (total quarter): United states Canada Europe Cost of goods sold (total quarter) Raw materials at the Louisville plant (end-of-quarter) Work-in-process and finished goods at Distribution center inventory (end-of-quarter): United states Canada Europe the Louisville plant (end-of-quarter) QUARTER 4 QUARTER 2 QUARTER 3 (JULY (OCTOBER QUARTER 1 (JANUARY THROUGH MARCH) (APRIL THROUGH JUNE) THROUGH SEPTEMBER) THROUGH DECEMBER) All amounts in millions of U.S. dollars 422 480 460 376 91 125 101 94 74 35 41 18 417 456 432 352 67 44 82 83 108 121 141 191 60 39 46 15 17 6 7 3 660 RRR 16 10 52 58 867 26
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, Canada, and Europe. You have collected the
following data relating to the value of inventory in the U.S.
Airfilter supply chain:
- U S Airfilter Has Hired You As A Supply Chain Consultant The Company Makes Air Filters For Residential Heating And Air 1 (99.89 KiB) Viewed 30 times
increase inventory turnover, what would you focus on?
Reduce the amount of inventory or increase sales or both
Reduce the amount of inventory or reduce sales or both
Increase the amount of inventory or increase sales or both
c. The company reported that it used
$579.4M 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.)
Sales (total quarter): United states Canada Europe Cost of goods sold (total quarter) Raw materials at the Louisville plant (end-of-quarter) Work-in-process and finished goods at Distribution center inventory (end-of-quarter): United states Canada Europe the Louisville plant (end-of-quarter) QUARTER 4 QUARTER 2 QUARTER 3 (JULY (OCTOBER QUARTER 1 (JANUARY THROUGH MARCH) (APRIL THROUGH JUNE) THROUGH SEPTEMBER) THROUGH DECEMBER) All amounts in millions of U.S. dollars 422 480 460 376 91 125 101 94 74 35 41 18 417 456 432 352 67 44 82 83 108 121 141 191 60 39 46 15 17 6 7 3 660 RRR 16 10 52 58 867 26