T Sql Project By Shashkora1 on Sep 5 Max Bid: Open to fair suggestions

Initially they want to check how many EOH units (Ending On Hand i.e how many units remained at the end of the month which is the last day which will generally be in the last week of the month).
So they want preliminary data to know how many units are in Work in process (WIP) [Output table) how many are intransit that means are on the way (1 OUTPUT table) and finally how many units are finished goods (Outputtable:)
Then they want to know from the bucket of rules that are listed in the excel sheet like how many units Where?  based on the excel sheet rules for each of the 1 unit and other unit from the view and dumping into the one table
Calculate the cost for each of the buckets and also calculating how many units are  the able ones i.e working and not wrking/ or not ready and then applying the LAC last available cost.
And then comparing the data with the source table to know the delta values and how much threshold it is. Is it within the range or not.

Requirements Interview Answers:

To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.