Question

                                    Sales Information of Asha Traders

	A	B	C	D	E	F
1.	Particulars	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
2.	Unit sold (in kg)	3500	4300	3100	4700
3.
4.
5.
6.	Electricity Expenses	18000	16000		22000	76000
7.	Advertisement Expenses	22000	26000		18000	28000
8.	Total Cost
9.	Net Profit
10.	Selling price per unit	50	50	50	50
11.	Cost price per unit	35	35	35	35

Based on the information given in the spread sheet above, write the formula for calculating each of the following:

(a) Sales Revenue for Quarter 1 in cell B3. 
(b) Cost of Goods Sold for Quarter 2 in cell C4.
(c) Total Advertisement Expenses incurred in cell F7.
(d) Gross Profit for Quarter 4 in cell E5.
(e) Electricity Expenses for Quarter 3 cell D6.

Answer 1

(a) = B2*B10 
(b) = C2*C11 
(c) = Sum (B7 : E7) or = B7 + C7 + D7 + E7 
(d) = (E2*E10) – (E2*E11) or = E2*(E10 – E11) or = (E3 – E4) 
(e) = F6 – (B6 + C6 + E6) or = F6 – B6 – C6 – E6 or F6 – (SUM (B6 : C6) + E6)