i need help solving "schedule e: cash payments for purchases" table.

***answers must be entered as formulas

My Drive-Google Drive ACTG 252 F18 Financial XACTG 252 project-Google https://docsgoogle.com/spreadsheets/d/1 6f82 fp4T6d-miwboARmzqGOEGNs ACTG 252 F18 Financial Model HSC Template File Edit View Insert Format Data Tools Add-ons Help Last edit was made 100, $ % 0.00123- 405000 75,500 92,700106,100 40 500 52,200 274,300 119,700 154,600 Less beginning inventory Total purchases 44,000 Schedule d: Purchases budget in dollars Ma June Total $405,000 $477,000 $531,000 $1,413,000 Desired ending inventory Plus cost of goods sold Total needed Less beginning inventory 350,000 450,000 530,000 1,330,000 755,000 315,000 $405.0a 927,000 1,061,000 $2,743,000 77,000 Total purchases Schedule e: cash payments for purchases June Total From accounts payable (3/31) 9 April o May 1 June $85,750 +Data Input Schedules Statements Write-Up 2 4 5 6 Q W E R T Y