Please show it in excel form or in the chart shown above

Requirement 1. What is the opportunity cost of interest forgone from purchasing all 228,000 units at the start of the year instead of in 12 monthly purchases of 19,000 units per order? Let's begin the calculation for the opportunity cost of interest forgone by first determining the formula, then calculate the opportunity cost. Requirement 2. Would this opportunity cost be recorded in the accounting system? Why? The opportunity cost be recorded in the accounting system, due to transaction being recorded in the accounting system. Requirement 3. Should Global Lawn purchase 228,000 units at the start of the year or 19,000 units each month? Show your calculations. Begin by calculating the relevant costs for each alternative, then calculate the difference between the two alternatives