Supply Chain Solutions [for clients]
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
OOS Upside Calculator for FS.OSA
2
3
OSA (a product to monitor OOS rate and improve business processes by helping workers do the right data-driven decisions and spend their time more effectively)NowFutureEffectChange cells colored in yellow
4
OOS rate8.3%7.0%-1.3%
5
Number of stores 100--
6
Number of SKUs per store50,000--
7
Profit margin2.0%--
8
Average transaction size per store visit$30--
9
Wage for a store worker with amortization for office, benefits, etc.$18--
10
Weekly revenue per store (sales volume)$516,727$520,490$3,763
11
12
Firm's OOS-related annual loss (lost sales + labor cost)-$9,211,849-$7,769,030$1,442,820
13
Annual lost revenue due to OOS-$111,509,687-$94,044,314$17,465,373
14
Annual labor cost due to OOS (store workers handling unplanned OOS questions)-$6,712,958-$5,661,531$1,051,427
15
Annual lost revenue due to OOS customer churn to other chains-$13,434,902-$11,330,640$2,104,262
16
17
OSA total cost (evaluation + training + license) based on a 12 months subscription
$0-$171,300-$171,300
18
OSA evaluation cost (given that a firm already monitores OSA and has historical data)
$0-$11,700-$11,700
19
OSA training cost (2h per person using the product)$0-$60,000.00-$60,000.00
20
OSA license fee (SaaS monthly subscription)$0-$99,600.00-$99,600.00
21
BOTTOM LINE (total profit for OSA project per chain)$1,271,520
22
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
Loading...
 
 
 
Firm's View OSA
Firm's View REPLENISHMENT
Support Plans