How do you set the formulas up in excel? I need to work this problem out using excel without hardcoding the numbers.

a) Prepare purchase budget as follows: DB Department store Monthly purchase budget Quarterly ending June 30,2017 April $42,000 $48,000 May June $60,000 Total $60,000 S.no Particulars 1 Ending inventories [50% pof next month cost of goods sold] 2 Cost of goods sold 3 Beginning inventory [120%$35,000] [120%$40,000] [120%*$50,000] $30,000 $35,000 $40,000 $36,000 S42,000 $48,000 [120%$30,000] $36,000 $41,000 $52,000 $105,000 $36,000 4 Purchases (1+2-3] $129,000