Show your work on the excel file below, update the names and upload.

You are given the following information for the MRP table. Assume the lead time is $1$ week. The setup cost is $$100$ per setup and the holding cost is $$0\mathrm{.}50$ per unit per week.

Given the Excel File below, use the Fixed period method to determine the MRP

EIN$4333$ FINAL MRP$-$XXXX LASTNAME FIRSTNAME.XISX $+-$

What is Lambda? $/$ week

$($round up to next integer, use this rounded up number in your EOQ calculation. For example, if Lambda is $31\mathrm{.}23,$ use $32)$

What is the EOQ? $$ units $($round up to next integer$)$

What is the Fixed Time Period?

$$ weeks $($round up to next integer$)$

What is the total cost $($Setup $+$ Holding$)?$ $