Fourteen SKUs with weekly sales, cover and a reorder flag computed in Excel. Buyers pick a supplier and type quantities in validated, unlocked cells; everything else is protected.

schema.ts

SplitCodeSheet

Reorder planA1:X18, frozen at D4

click a cell to inspect it

Code Sheet

fx

ABCDEFGHIJKLMNOPQRSTUVWXYZAA

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

Weekly reorder plan · week 44

Units sold per week

Purchase order (edit the yellow cells)

SKU

Product

Category

Warehouse

W36

W37

W38

W39

W40

W41

W42

W43

Trend

On hand

Inbound

Avg / week

Weeks of cover

Lead time

Supplier

Order qty

Unit cost

Order value

Status

LIG-1040

LED panel 60×60 4000K

Lighting

Lyon

26

23

43

26

27

27

41

40

54

0

32

1.7

14 d

Orient Components

0

€38.00

€0

Reorder

LIG-1047

LED strip 5 m warm

Lighting

Rotterdam

31

28

50

47

42

51

41

41

106

184

41

7.1

14 d

Orient Components

0

€14.00

€0

OK

LIG-1054

Track spot 12 W

Lighting

Lyon

91

76

80

80

99

88

98

116

199

0

91

2.2

42 d

Orient Components

0

€22.00

€0

Reorder

LIG-1061

Emergency exit sign

Lighting

Lyon

104

130

117

133

131

131

137

158

946

0

130

7.3

14 d

Kessler GmbH

0

€41.00

€0

OK

POW-1068

Driver 40 W dimmable

Power

Rotterdam

121

130

132

137

147

144

145

150

828

274

138

8.0

28 d

Kessler GmbH

0

€19.00

€0

OK

POW-1075

Driver 75 W DALI

Power

Lyon

122

115

118

126

129

153

139

160

134

0

133

1.0

14 d

Orient Components

0

€46.00

€0

Reorder

POW-1082

Power supply 24 V 150 W

Power

Lyon

58

71

69

79

74

80

78

93

131

146

75

3.7

28 d

Lumen Supply Co.

0

€33.00

€0

Reorder

SEN-1089

Motion sensor ceiling

Sensors

Lyon

123

135

128

134

155

142

164

171

1,025

0

144

7.1

21 d

Nordic Parts AB

0

€27.00

€0

OK

SEN-1096

Daylight sensor

Sensors

Leipzig

112

121

121

120

126

143

134

150

349

0

128

2.7

28 d

Nordic Parts AB

0

€31.00

€0

Reorder

SEN-1103

Presence detector PIR

Sensors

Leipzig

125

123

136

132

124

132

158

157

559

270

136

6.1

14 d

Lumen Supply Co.

0

€24.00

€0

OK

MOU-1110

Suspension kit 1.5 m

Mounting

Rotterdam

88

91

95

122

116

126

112

127

266

0

110

2.4

14 d

Lumen Supply Co.

0

€9.00

€0

Reorder

MOU-1117

Surface frame 60×60

Mounting

Rotterdam

33

35

23

34

27

41

29

40

58

140

33

6.0

28 d

Lumen Supply Co.

0

€17.00

€0

OK

MOU-1124

Recessed clip set

Mounting

Lyon

50

64

57

57

58

58

66

66

407

0

60

6.8

42 d

Orient Components

0

€4.00

€0

OK

MOU-1131

Track rail 2 m

Mounting

Rotterdam

65

73

62

82

68

77

76

90

205

316

74

7.0

28 d

Kessler GmbH

0

€21.00

€0

OK

€0

Cell in the file

Reorder plan