if you could please answer this in excel (showing formulas), that would be great. I posted a photo of the excel format as well that would be helpful to have it in. **** some of the have the answers posted on chegg were in excel format but different letters and cell numbers. For learning purposes, I would like to make it as simple as possible. Thank you!

Complete the following MPS record and find out what is the available-to-promise. There are 20 units in beginning inventory and the lot size is 50. Answer in Excel and submit your answer in the drop box Period 20 Forecast Customers order (committed) 123 2025 213331 202 1 23 20 20 8 POH (Projected on hand) MPS (Master production schedule) ATP (Available-to-promise) Home Insert Draw Page Layout Formulas Data Review View ou LO BI U 12 a AA === A E Calibri (Body) Paste BI U 1 Ax & fx B C D E