micronutrientsupport / micronutrient-support-tool

Web front-end for the MAPS Micronutrient Support Tool
MIT License
2 stars 0 forks source link

Calculation issue #1369

Open kpitten opened 9 months ago

kpitten commented 9 months ago

It seems like there might be in issue in the premix cost calculations (not in the calculator but the recurring cost screen). In the screenshot below, premix cost per MT is $3.66, and then we need to account for 18% shipping and 5% local transport and storage, so Total premix cost per MT of domestically fortified wheat flour at standard or target addition rate ($/MT) should be $3.66*(1+.18+.05)= $4.40, but the calculation shown is $6.098 (and it's not highlighted as a calculation but should be).

Also, there seems to be a missing row after "Total premix cost per MT of domestically fortified wheat flour at standard or target addition rate ($/MT)" and before "Availability of wheat flour in food supply (g/capita/day)" (missing row is "Total premix cost per MT of imported fortified wheat flour scaled by average addition rate as a percent of the standard or target"). I assume this is the same as the cost per MT of domestically fortified food vehicle, but the user may want to change that assumption.

Also also, the "Fortifiable/industrially processed wheat flour in the food system (%)" value is pulled in from an earlier screens so should not be editable here.

"Annual quantity of fortifiable wheat flour in the food system (MT)" is a calculation based on the values above so should not be editable here. I'm wondering if the missing row is causing these other issues.

Screenshot 2024-03-05 164205