Suggested Ordering amounts for Coater are low

Store 01173

• Restaurant is having issues when ordering Coater with suggested ordering
• Suggestions are way lower than the amount needed
• Saying we only need 1 case per $10,000 in sales

Steps to Reproduce:

• On hand number is correct when placing orders
• Inventory is counted weekly
• Restaurant is not editing daily sales forecast - using system generates sales forecast numbers
• Calculated expected forecast based on forecasted sales and CFA Coater UPT
• Calculated number is higher than number reflected in truck order

Expected Outcome:

• Suggested Ordering numbers will be correct when ordering Coater

forecasted sales:
8/26 (after 4pm): $3456
8/27: $11246
8/28: $11036
8/29: $11895
8/31: $9078
9/1: $8757
Total: $55468
UPT for regular coater: 0.1722 - Auto calc is on
Safety stock set to 2 inventory units - auto calc is on
55468/1000 = 55.468
55.468 * 0.1722 = 9.5516 - expected forecasted usage
Forecasted usage per truck order: 7.42
Amount suggested after on hand and on order subtracted: 0
Amount ordered: 6
Previous truck order (3728269): 0 suggested, 4 ordered

select version, ManagerTransactionCount, ManagerSales,* from Forecasting.forecast with(nolock)
where EntityId = 673
and BusinessDay = '2020-08-28'

// ForecastId = 6524650,6555706

// RawTransactionCount = 67.6621737221593
// SystemTransactionCount = 62.1573874891889
// InventoryItemId = 62.1573874891889

declare @forecastid INT='6555706'
declare @itemid INT='545'

select sum(RawTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(SystemTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(ManagerTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid

// RawTransactionCount = 67.6621737221593
// SystemTransactionCount = 62.1573874891889
// InventoryItemId = 62.1573874891889

declare @forecastid INT='6555706'
declare @itemid INT='545'

select sum(RawTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(SystemTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid
select sum(ManagerTransactionCount) from Forecasting.InventoryItemMetricDetail with(nolock)
where forecastid = @forecastid
and InventoryItemId = @itemid

// RawTransactionCount = 67.6621737221593
// SystemTransactionCount = 62.1573874891889
// InventoryItemId = 62.1573874891889