Question: User: what is the formula?
1. **State the problem:**
You asked for the formula to calculate the key metrics: gross sales, gross promotions, refunds, fees, and net sales for 5 items.
2. **Formula for Gross Sales:**
$$\text{Gross Sales} = \text{Units Sold} \times \text{MSRP}$$
where MSRP is $1500$ per unit.
3. **Formula for Gross Promotions:**
$$\text{Gross Promotions} = (\text{MSRP} + \text{Delivery Fee} - \text{Actual Price per Unit}) \times \text{Units Sold}$$
Given delivery fee is $250$ and total price to customers is $2500$, so promotions reflect discounts from MSRP plus delivery fee.
4. **Refunds and Fees:**
These are given or calculated separately.
5. **Formula for Net Sales:**
$$\text{Net Sales} = \text{Gross Sales} - \text{Gross Promotions} - \text{Refunds} - \text{Fees}$$
6. **Per Unit Basis:**
For any dollar amount $D$ and units sold $U$:
$$\text{Per Unit Value} = \frac{D}{U}$$
7. **Excel formula examples:**
- Gross Sales in cell C2 if units in B2: `=B2*1500`
- Gross Promotions in D2 if actual price per unit in E2: `=(1500+250-E2)*B2`
- Net Sales in F2: `=C2-D2-E2-F2` (assuming refunds and fees in E2 and F2 respectively)
These formulas avoid using SUM and use direct arithmetic operations.
This completes the formula explanation.