Business Finance
There are several data information. Requirement: You could just talk
about certain variables that the company might take a look at in the
future. For example, talk about on hand inventory, inventory related
costs, shipping/handling costs from the data. Basically just talk about
what we might measure, but mention that we still aren’t 100% sure
There are some information might help: (you can rewrite this in another way.)
From our team’s understanding, the end result is to hopefully reduce on hand inventory (in some cases), increase velocity and decrease overall costs for the manufacturing facilities depending on which parts they order.
However, this is where our team’s train-of-thought comes to a
crossroad. Given the number of customers in Caterpillar’s North American
MPN Network and the time allotted to us to complete the project (~3
months), the way we see it, there are two ways to move forward with the
project:
- Analyze all (or a large majority) of the
customers/parts in North America, as shown in the Excel documents you
shared with us. This option would provide analysis that covers a lot of
ground and lead to results that are less detailed and would probably not
be as refined as they could be.
- Analyze a selective,
representative group of customers for the scope of the project (the
specific number can be discussed, we feel that focusing on 10-15 of
Caterpillar’s biggest customers is ideal). These customers would be
chosen based on certain factors, such as: revenue generated, unique
number of parts they order, lead time and geographic location. The
representative group would include customers that are currently
classified as ZPUL, ZSCH and ZCOM.
Our team believes option
(2) would be more optimal for various reasons: Narrowing our sights on a
select group of customers would increase the variety and veracity of
information (turnover rate, capacity, costs etc.) gathered.
Additionally, we want to explore the option of contacting the customers
to inquire more about inventory carrying costs, transportation costs,
ordering method transformation costs, etc; this would likely not be
achievable to a great degree of detail if we were to analyze every
customer in the North American MPN Network. Even though you have
provided us with a price range for each unique part (in one of the Excel
documents), our team believes that any results achieved from utilizing
these numbers would be inconclusive because the price ranges are too
vague.
Our team believes option (2) would lead to an analysis that is more detailed and would provide the groundwork
for Caterpillar going forward in identifying optimal ordering methods
for its other customers.
There are several data information. Requirement: You could just talk about certain variables that the company might take a look at in the future. For example, talk about on hand inventory, inventory related costs, shipping/handling costs from the data. Basically just talk about what we might measure, but mention that we still aren’t 100% sure
There are some information might help: (you can rewrite this in another way.)
From our team’s understanding, the end result is to hopefully reduce on hand inventory (in some cases), increase velocity and decrease overall costs for the manufacturing facilities depending on which parts they order. However, this is where our team’s train-of-thought comes to a crossroad. Given the number of customers in Caterpillar’s North American MPN Network and the time allotted to us to complete the project (~3 months), the way we see it, there are two ways to move forward with the project:
- Analyze all (or a large majority) of the customers/parts in North America, as shown in the Excel documents you shared with us. This option would provide analysis that covers a lot of ground and lead to results that are less detailed and would probably not be as refined as they could be.
- Analyze a selective, representative group of customers for the scope of the project (the specific number can be discussed, we feel that focusing on 10-15 of Caterpillar’s biggest customers is ideal). These customers would be chosen based on certain factors, such as: revenue generated, unique number of parts they order, lead time and geographic location. The representative group would include customers that are currently classified as ZPUL, ZSCH and ZCOM.
Our team believes option (2) would be more optimal for various reasons: Narrowing our sights on a select group of customers would increase the variety and veracity of information (turnover rate, capacity, costs etc.) gathered. Additionally, we want to explore the option of contacting the customers to inquire more about inventory carrying costs, transportation costs, ordering method transformation costs, etc; this would likely not be achievable to a great degree of detail if we were to analyze every customer in the North American MPN Network. Even though you have provided us with a price range for each unique part (in one of the Excel documents), our team believes that any results achieved from utilizing these numbers would be inconclusive because the price ranges are too vague.
Our team believes option (2) would leadto an analysis that is more detailed and would provide the groundwork
for Caterpillar going forward in identifying optimal ordering methods
for its other customers.
Looking for this or a Similar Assignment? Click below to Place your Order
