Peres, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April May June and July : opted out of good old 167,000 $17.000 1,000,000 Perer had a beginning inventory balance of $4200 on April and a beginning balance in accounts payable of $4.500 The company desires to maintain an ending inventory balance equal to 10 percent of the next periods.cost of goods sold. Perez mokes all purchases on account. The company Days 70 percent of accounts payable in the month of purchase and the remaining 30 percent in the month following purchase Required a. Prepare an inventary purchases budget for April May, and June b. Determine the amount of ending inventory Perez report on the end of quarter to forma balance sheet c. Prepare a schedule of cash payments for inventory for Apr May, and June d. Determine the balance in accounts payable Perez will report on the end of quarter pro forma balance sheet Complete this question by entering your answers in the tabs below. Required Red Required Recured Prepare a inventory purchases budget for Apr May, and une Inventory Puree Budget Art May Budgeted of goods 5 000 1000 1000 veronded Respurgon Complete this question by entering your answers in the tabs below. e de Duterme amount of ending nentory Pera wit report on the end of enter proferrin balance sheet EN Required A Required Required Recured Prepare a schedule of can payments for inventory for Apr May, and one. Round your finansowers to the nearest whole dollar) Sedule of Cash Payments April Pement of our accounts payable Payment of previous accounts payable Total budgeted payments for inventory Complete this question by entering your answers in the tab blow RA