Section # $2$: Creating an Excel Spreadsheet to Calculate Economic Order Quantity $($EOQ$)$

Problem # $1$: Creating an Excel Spreadsheet to calculate the Annual demand in units, annual demand in dollars, the $($EOQ$)$ Economic Order Quantity in units and the number of orders per year required for each item below. Requirements for this Problem:

Create a Spreadsheet like the table below.

Calculate the annual demand in units for each item $($Assumption $-$ use $360$ days per year to calculate annual demand$).$

Calculate the annual demand in dollars for each item $($Assumption $-$ use $360$ days per year to calculate annual demand$).$