This question is a multi part, that includes excel, thank you!

Child$$s Play is a not$-$for$-$profit organization that works to introduce children to theater and the arts. At the end of FY $2023,$ which ended June $30,2023,$ Child$$s Play had the following account balances $($in alphabetical order$)$:

Accounts Payable: $10,000$

Cash: $381,000$

Equipment, net: $70,300$

Grants Receivable, net: $0$

Inventory: $3,000$

Net Assets: $407,600$

Notes Payable: $55,000$

Pledges Receivable, net: $26,000$

Prepaid Rent: $12,800$

Wages Payable: $20,500$

Child's Play experienced the following financial events during FY $2024$:

a$)$ On July $1,2023,$ Child's Play paid $$280,000$ cash for new sound and lighting equipment for its children's theater. The equipment is expected to last $8$ years and have a salvage value of $$50,000.$ Equipment purchased in prior fiscal years depreciated by $$14,500$ in FY $2024.$

b$)$ In early FY $2024,$ Child's Play was awarded a grant in the amount of $$23,000.$ The grant was paid to the organization during the last month of FY $2024.$

c$)$ Child's Play was awarded a second grant during FY $2024$; the organization used it to

start an after$-$school program. The total amount of the grant awarded was $$150,000.$ Half of the grant was paid to Child's Play in FY $2024,$ and the remaining amount will be paid in the first two months of FY $2025.$

d$)$ $$315,000$ in donations were pledged to Child's Play during FY $2024,85\%$ of which were collected during the fiscal year. The organization wrote off $2\%$ of all outstanding pledges $($that it thought it would collect$)$ as bad debt at the end of the fiscal year.

e$)$ Child's Play purchased $$38,000$ worth of supplies on account during FY $2024.$ The organization mailed a check to the supplier for $$28,000.$ In addition, it paid off its balance of $$6,000$ from the previous fiscal year. The organization ended the fiscal year with an ending inventory balance of $$12,000.($Hint: you must "back out" the supplies expense.$)$

f$)$ Child's Play's employees earned $$21,000$ per month during FY $2024.$ Employees are paid monthly with a one$-$month lag. In FY $2023,$ employees earned $$246,000$ in total.

g$)$ In FY $2024,$ Child's Play paid $$12,800$ per month in rent. In FY $2023,$ rent was $$10,900$ per month. The organization pays rent one month in advance, and rent will increase to $$13,200$ in FY $2025.$

h$)$ On the last day of FY $2024,$ as required, Child's Play repaid $$15,000$ of principal on its bank loan. The loan carries an annual interest rate of $3\mathrm{.}5\%$; interest must also be paid on the last day of the fiscal year. In FY $2025,$ $$20,000$ of principal is due.

$2.$ Child's Play provides snack packs to the children who participate in programming. The organization started the current fiscal year with $175$ snack packs, which had been purchased in the previous fiscal year for $$1\mathrm{.}75$ each. Three months into the current fiscal year, all $175$ snack packs had been used, so the organization purchased $250$ more snack packs at a price of $$2\mathrm{.}00$ each. Six months later, there were only $45$ snack packs left, so the organization paid $$472\mathrm{.}50$ for $225$ additional snack packs. On the last day of the current fiscal year, there were $70$ snack packs remaining. Calculate each of the following

in Excel, showing both your solutions and your formulas. $($Note: This problem does not relate back to the previous problem.$)$

a$)$ Calculate the supplies expense using LIFO

b$)$ Calculate the supplies expense using FIFO

c$)$ Calculate the inventory balance using LIFO

d$)$ Calculate the inventory balance using FIFO