Answer both question and show all work fo ra quick thumbs up

3.15. Given the following data, calculate the projected available balance and the planned MPS receipts. The lot size is 100. The demand time fence is 2 weeks.

Week	1	2	3	4
Forecast	50	50	50	50
Customer Orders	60	30	65	25
Projected Available Balance	60
MPS

3.18. Given the following master schedule, fill in the projected available and available to promise rows:

a.

On Hand: 35	Planning time fence: 10	Lot Size: 200
	Demand time fence: 2

b. A customer wants an order of 100 in period 4. What can you tell him?

c. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now?

d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?

e. What action (if any) should be taken in period 11? Why is it okay to take the action?

\begin{tabular}{|l|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Period & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 \\ \hline Forecast & 30 & 40 & 40 & 50 & 40 & 40 & 30 & 40 & 40 & 50 & 40 & 40 \\ \hline Customer Orders & 31 & 35 & 29 & 21 & 17 & 14 & 33 & 11 & 5 & 2 & 0 & 1 \\ \hline Projected Available & & & & & & & & & & & & \\ \hline Available to Promise & & & & & & & & & & & & \\ \hline MPS & & 200 & & & & 200 & & & & & & \\ \hline \end{tabular}