Chaffey, Digital Business and E-Commerce Management, 6th edition,
Instructors Manual on the Web
101
1. Cost-saving calculations. Using the input parameters for the two companies in Table 7.4,
develop a spreadsheet model to calculate traditional overall purchasing cost, new overall
purchasing cost, percentage change in cost per order and percentage change in overall
purchasing cost.
Table below shows that much greater savings are possible where there is combination of a large
number of orders and low order value.
Answers for cost-saving calculations for two companies A and B.
Input parameters (Company A) Input parameters (Company B)
Number of orders 25,000 Number of orders 2,500
Traditional cost per order (average) £50 Traditional cost per order (average) £50
2. Profitability calculations. Using input parameters of turnover, traditional purchasing costs,
other costs and a 5% reduction in purchasing costs as shown in Table 7.5, develop a model
that calculates the profitability before and after introduction of e-procurement and also
shows the change in profitability as an absolute (£) and as a percentage.
Table below shows that change in profitability is much greater for a company such as
Company X where purchasing costs are a higher proportion of overall costs. Company X is more
Input parameters for profitability calculations for two companies X and Y.
Input parameters (Company X) Input parameters (Company Y)
£10,000,000
Turnover
£10,000,000
Traditional purchasing costs £5,000,000 Traditional purchasing costs
£1,000,000
Other costs
£4,000,000 Other costs
£8,000,000
% Reduction in purchasing costs
20%
% Reduction in purchasing costs
20%
Before After Before After
Turnover £10,000,000 £10,000,000 Turnover £10,000,000 £10,000,000
3. Analyse the sensitivity of the models to differences in volume of orders and values of
purchases (Table 7.4) and the balance between traditional purchasing costs and other costs
such as salaries and capital by using the parameters (Table 7.5). Explain to the managers