Please show step by step in excel

E.J. Korvair Department Store has $1,000 in available cash. At the beginning of each of the next six months, E.J. will receive revenues and pay bills as shown in below table. It is clear that E.J. will have a short-term cash flow problem until the store receives revenues from the Christmas shopping season. To solve this problem, E.J. must borrow money. At the beginning of July, E.J. may take out a six-month loan. Any money borrowed for a six-month period must be paid back at the end of December along with 9% interest (early payback does not reduce the interest cost of the loan). E.J. may also meet cash needs through month-to-month borrowing. Any money borrowed for a one-month period incurs an interest cost of 4% per month. Use linear programming to determine how E.J. can minimize the cost of paying its bills on time.

please answer the question in LP model

Show transcribed data

Bills (S) 5,000 5,000 6.000 2.000 2.000 1,000 Month July Revennes (S) 1.000 August2,000 Septeber 2,000 October November 7.000 December 9,000 4,000