Corwin LTD is a business supply company in Phoenix, Arizona. Corwin’s current liabilities consist almost entirely of accounts payables to its suppliers (vendors). In an effort to better understand its accounts payable and supplier relationships, management has asked you to analyze one month’s purchasing data.
1. Using the dataset for Corwin LTD, perform analyses to answer the following questions:
a. How many days on average does it take to receive an order from each supplier?
b. How many partial orders do we receive from each supplier?
c. How many orders do we return from each supplier?
d. How many orders are back-ordered from each supplier?
2. How can Corwin LTD use these analyses to improve or change its supplier relationships?