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:

$1.$ Create a Spreadsheet like the table below.

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

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

$4.$ Calculate the $($EOQ$)$ Economic Order Quantity for each item.

$5.$ Calculate the number of orders the company would need to place annually based on the EOQ that you calculated and the item$$s annual unit demand.

$6.$ HINT: Formula: Average Daily Demand X # of days in a year $=$ Annual Demand in units

$7.$ HINT: Refer to the EOQ Formula in the textbook page # $138$