Copy Of Relative Resource Manager

Spec

A 1

B

Specification sheet

2 3

Title:

Zan1 plc

4 5

Purpose:

6 7

Date Produced:

8 9

Produced by:

10 11

Revision date:

Page 1

Data and Model

A

B

C

1

Data entry

2 3 4 5 6

Month 1 Sales £000 Increment factor Costs (x sales)

7

Model

8 9 10 11 12 13 14 15 16

Zanadu Conglomerate plc Profit Budget For the year to 31 December 2008 Month Sales Less cost of sales Gross profit

D

E

F

G

H

Tuition notes You need to put a number in cell B4 such that placed in the current month's sales cell and mu previous month's sales, will give a figure 10% You need to put dollar signs in the formula in B to B5 so that it copies absolutely: =B14*$B$5

80 ???? 0.55

Jan £000 80 44 36

Page 2

Data and Model

I

J

K

L

M

1

umber in cell2 B4 such that when t month's sales cell and multiplied by the 3 les, will give4a figure 10% bigger. ar signs in the 5 formula in B15 to fix the cell reference es absolutely: 6 =B14*$B$5 7 8 9 10 11 12 13 14 15 16

Page 3