Q1. Northwest Calculators, Inc. purchases plates used in the manufacture of calculators directly from the supplier. Northwest's calculator production operation, which is operated at a constant rate,...

Can someone help me with the following problems (the last 3) on excel Thank you

Extracted text: Q1. Northwest Calculators, Inc. purchases plates used in the manufacture of calculators directly from the supplier. Northwest's calculator production operation, which is operated at a constant rate, will require 9,000 plates_per month throughout the year (HINT: Calculate the annual demand). Assume that the ordering costs are $60 per order, the unit cost is $3 per component, and annual holding costs are 20% of the value of the inventory. Northwest has 300 working days per year and a lead time of 5 days. Fill in the following Optimal inventory policy related blanks (round to two decimal places): Optimal Inventory Policy Answer Economic Order Quantity Q* Annual Inventory Holding Cost H Annual Ordering Cost O Total Annual Cost TC Maximum Inventory Level Q Average Inventory Level Q/2 Reorder Point r Number of Orders Per Year (D/Q*) Cycle Time (Days) T