PLEASE ANSWER IN EXCEL FORMAT ONLY WITH FORMULAS

. = Average stock $ = (BOMs$ + EOM$) / (#of BOMs and EOM) Turn = Net Sales $ / Average Stock $ BOM $ = Stock-sales ratio x Planned monthly sales $ - . 1. A store has the following BOM figures for the Hat Department: January $2,600.00, February $4,200.00, March $3,300.00, and April $2,800.00. What is the average stock figure for the first quarter of the year? (2 pt) Jan Feb Mar April BOM EOM (Hint: Remember that the BOM of a period is the same as the previous EOM) . = Average stock $ = (BOMs$ + EOM$) / (#of BOMs and EOM) Turn = Net Sales $ / Average Stock $ BOM $ = Stock-sales ratio x Planned monthly sales $ - . 1. A store has the following BOM figures for the Hat Department: January $2,600.00, February $4,200.00, March $3,300.00, and April $2,800.00. What is the average stock figure for the first quarter of the year? (2 pt) Jan Feb Mar April BOM EOM (Hint: Remember that the BOM of a period is the same as the previous EOM)