Use the following problem statement to answer questions $23-25.$

A partially completed MPS record for an end item is shown in the table below. The current on$-$hand inventory $($in units$),$ the order quantity $($in units$),$ and the lead time $($LT$,$ in weeks$)$ are iven in the table. Develop MPS for the end item. Round to the nearest whole number.

Jote: Projected on$-$hand inventory at the end of this week $=$ On$-$hand inventory at the end last week $+$ MPS quantity due at start of this week $-$ Projected requirements this week. P for the first week $=$ Projected on$-$hand inventory at the end of last week $+$ MPS quantity the first week $-$ The cumulative total number of customer orders booked up to $($but not uding$)$ the week in which the next MPS quantity arrives.

for the $2$ nd$,3rd,...$ weeks $=$ MPS quantity $-$ The cumulative total number of customer ers booked up to $($but not including$)$ the week in which the next MPS quantity arrives.$]$

Question $23$

$7$ pts

Wiat is the available$-$to "romise imentory $($ATP$)$ for weok $3)$ Round to the noarose whote number.

Question $24$

$7$ Pts

$30$

$15$

$2$

$29$

$3$

$29$

$40$

Question $25$

$7$ pts

What is the available$-$to$-$promise inventory $($ATP$)$ for week $1?$ Round to the nearest whole number.

Current on$-$hand inventory:

$\backslash$table$[[,1,2,3,4],[$Forecast$,$Order quantity: $45,,,],[$Customer orders $($booked$),17,14,10,8],[$Projected on$-$hand inventory,,$13,23,10],[$MPS quantity,,,,$],[$MPS start,,,,$],[$ATP inventory,,,,$]]$