Show work, please!

The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2017. 1. Sales for May are expected to be $817,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at 10% of the following month's cost of goods sold. 4. Operating expenses are estimated to be as follows: Sales salaries Advertising Delivery expense Sales commissions Rent expense Depreciation Utilities Insurance $31,500 6% 2 % 5% $5,210 $810 $650 $520 per month of monthly sales of monthly sales of monthly sales per month per month per month per month 5. Interest expense is $2,000 per month. Income taxes are estimated to be 30% of income before income taxes. Prepare the merchandise purchases budget for each month in columnar form. (Round answers to 0 decimal places, e.g. 5,270.) SUPPAR COMPANY San Miguel Store Merchandise Purchases Budget For the Months of May and June, 2017 May June Budgeted Cost of Goods Sold Add : Desired Ending Merchandise Inventory Total Less : Beginning Merchandise Inventory Required Merchandise Purchases A Click if you would like to Show Work for this question: Open Show Work