Microsoft Excel Functions For Purchasers
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Microsoft Excel Functions For Purchasers as PDF for free.
More details
- Words: 165
- Pages: 3
Supplier William Smith Enterprises AJ Company Alfred and Sons Company
Total £850.00 £950.00 £785.00
Bid Comparison £1,000.00 £900.00 £800.00 £700.00 £600.00 £500.00 £400.00 £300.00 £200.00 £100.00 £-
Total
William Smith Enter-
AJ Company
Alfred and Sons Company
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
Category Raw Materials Direct Supply Indirect Supply Marketing and Advertising Infrastructure
Annual Spend £54,000,000.00 £15,200,000.00 £5,000,000.00 £3,300,000.00 £28,000,000.00
Spend Analysis 26.54%
51.18%
3.13% 4.74% 14.41%
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
Raw Materials Direct Supply Indirect Supply Marketing and Advertising Infrastructure
Month January February March April May June July August September October
Agreed Lead Time In Days
Actual Lead Time In Days 7 7 7 7 7 7 7 7 7 7
6 5 4 4 5 5 6 6 7 8
Month
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
O cto ber
Au gus t
July
June
May
Apri l
Actual Lead Time In Days Agreed Lead Time In Days M arch
15 12.5 10 7.5 5 2.5 0
Janu ary
Days
Supplier Performance Analysis
Total £850.00 £950.00 £785.00
Bid Comparison £1,000.00 £900.00 £800.00 £700.00 £600.00 £500.00 £400.00 £300.00 £200.00 £100.00 £-
Total
William Smith Enter-
AJ Company
Alfred and Sons Company
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
Category Raw Materials Direct Supply Indirect Supply Marketing and Advertising Infrastructure
Annual Spend £54,000,000.00 £15,200,000.00 £5,000,000.00 £3,300,000.00 £28,000,000.00
Spend Analysis 26.54%
51.18%
3.13% 4.74% 14.41%
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
Raw Materials Direct Supply Indirect Supply Marketing and Advertising Infrastructure
Month January February March April May June July August September October
Agreed Lead Time In Days
Actual Lead Time In Days 7 7 7 7 7 7 7 7 7 7
6 5 4 4 5 5 6 6 7 8
Month
By Oluchi Nwaiwu - http://www.oluchinwaiwu.com
O cto ber
Au gus t
July
June
May
Apri l
Actual Lead Time In Days Agreed Lead Time In Days M arch
15 12.5 10 7.5 5 2.5 0
Janu ary
Days
Supplier Performance Analysis
Related Documents
Microsoft Excel Functions For Purchasers
June 2020 5
Microsoft Excel Functions
November 2019 14
Microsoft Excel Functions
May 2020 9
Microsoft Excel Functions Examples
May 2020 14
Microsoft Excel Functions And Formulae.
April 2020 10