读《数据仓库工具箱：维度建模的完全指南》之第四章调拨案例学习开篇

Procurement Case Study

Demand planning drives efficient materials management. Once demand is

forecasted, procurement’s goal is to source the appropriate materials/products

in the most economical manner. Procurement involves a wide range of

activities from negotiating contracts to issuing purchase requisitions and purchase

orders (POs) to tracking receipts and authorizing payments. The following

list gives you a better sense of a procurement organization’s common

analytic requirements:

__ Which materials or products are purchased most frequently? How many

vendors supply these products? At what prices? In what units of measure

(such as bulk or drum)?

__ Looking at demand across the enterprise (rather than at a single physical

location), are there opportunities to negotiate favorable pricing by consolidating

suppliers, single sourcing, or making guaranteed buys?

__ Are our employees purchasing from the preferred vendors or skirting the

negotiated vendor agreements (maverick spending)?

__ Are we receiving the negotiated pricing from our vendors (vendor contract

purchase price variance)?

__ How are our vendors performing? What is the vendor’s fill rate? On-time

delivery performance? Late deliveries outstanding? Percent of orders

backordered? Rejection rate based on receipt inspection?

 

 

调拨案例学习

 

需求计划驱动高效物料管理。一旦需求被预计到，调拨的目标就是以最节约的方式获得适当的

物料或产品来源。调拨包括从合同谈判到发出购买需求和采购订单到跟催收款和统一支付的一系列宽广广泛的活动。以下列表给大家提供了对调拨组织的共同的分析需求的很好的感性认识。

 

 

--什么物料或产品被经常购买？多少供应商提供这种产品？什么价格？什么度量单位？

 

--着眼于贯穿企业的需求，这些机会是与稳定供应商协议的有利价格，单一来源或是作出的有保证的购买。

 

--我们的雇员从首选的供应商购买还是热衷于同供应商谈判购买。

 

--我们是否接受供应商的定价

 

--我们的供应商的履行职责的情况如何？供应商的满意率如何？准时交付的能力如何？延迟交付情况是否严重？后补订单的比例如何？基于收款验收的拒绝率如何？