Blog

Your average on hand inventory is $5M (million), your annual…

Your average on hand inventory is $5M (million), your annual cost of goods sold is $20M, and your annual revenue is $30M. You pay your suppliers 20 days after you receive your goods, and your customers pay you 15 days after you sell them the goods. Therefore, your cash conversion cycle is ______ days.  Write answer as an integer (e.g. 70). Assume a 360-day year for calculation purposes. No periods/decimals/quotes.

Two tables (Driver and Delivery Route) are joined together i…

Two tables (Driver and Delivery Route) are joined together in a normalized database because they have a column (Driver ID #) in common. In the Driver table, Driver ID # is the unique record identifier with each ID # only appearing once, but in the Delivery Route table, the same Driver ID # appears in multiple records since some Drivers cover multiple routes. In this table relationship, Driver ID# is what kind of key in the Driver table?