Help Need help with this with formulas please. Common parts $($Frame$,$ etc.$)$ Existing inventory $4018-$speed gear option Existing inventory $25$ Straight handlebars Existing inventory $20$ Head and tail light set Existing inventory $5$ Assignment $1.$ Fill in the master schedules listed below, taking the data from the above tables and adding row values for projected inventory and available to promise $($ATP$).$ Assume there is no demand time fence for this data. $2.$ Once you have completed the tables, examine the list of orders for this model bicycle and determine specifically what information should be given to the perspective customer. For example, if the order request was for $40$ bicycles $($with defined options$)$ in week $4$ and it appears that only $32$ could be delivered, then you should be telling the customer that they can have only $32$ in week $4$ and then the rest could be delivered at a later week $($you should be specific as to WHICH week$).$ Assume the orders listed for evaluation are NOT cumulative $-$ in other words, evaluate each requested order independently ignoring the existence of the other requested orders for the evaluation of this one order. $3.$ Suppose Macarry's Bicycle managers discover that a major competitor has had to shut down their production for the next three months due to a major fire. The Macarry's managers fully expect that many of the competitor's customers will turn to Macarry's Bicycles to fill their orders during this critical time for them. In fact, one of the competitor's customers has already asked about an order of $250$ of the models for delivery in week $5.$ What actions should Macarry's take in this case? Be as specific as possible. Common parts $($Frame$,$ etc.$).$ Existing inventory $4018-$speed gear option Existing inventory $25$ Straight handle$-$bars Existing inventory $20$ Head and tail light set Existing inventory $5$ Here are the orders to evaluate. Again you are reminded to treat these independently. For example, when you evaluate order number $2,$ ignore the other order requests $(1,3,$ and $4\backslash ()\backslash ),$ and so forth. a$.$ A customer is asking about an order of $32$ of the bicycles for week $3.$ All $32$ are to be $18$ speed, $12$ are to have straight handle$-$bars, and $14$ are to have the light set. b$.$ A customer is asking about an order of $60$ of the bicycles for week $6.$ Fifty of them are to be $18$ speed, $12$ are to have straight handlebars, and $5$ to have the light set. c$.$ A customer is asking about an order of $20$ of the bicycles for week $2.$ All are to be $18$ speed, all are to have straight handlebars, and all are to have the light set. d$.$ A customer is asking about an order of $110$ of the bicycles in week $7.$ Sixty are to be $18$ speed, $22$ are to be straight handlebars, and $15$ are to have the light set.