P9.5 Prepare purchases and income statement budgets for a merchandiser The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2022. 1. Sales for May are expected to be $800,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 $35,000 per month Advertising 6% of monthly sales Delivery expense 2% of monthly sales Sales commissions 5% of monthly sales Rent expense $5,000 per month Depreciation $800 per month Utilities $600 per month Insurance $500 per month 5. Interest expense is $2,000 per month. Income taxes are estimated to be 20% of income before income taxes. Instructions a. Prepare the merchandise purchases budget for each month in columnar form. b. Prepare budgeted income statements for each month in columnar form. Show in the statements the details of cost of goods sold. NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), into the yellow shaded input cells. SUPPAR COMPANY San Miguel Store Merchandise Purchases Budget For the Months of May and June, 2022 May June Budgeted sales Budgeted cost of goods sold Add: Desired ending merchandise inventory Total Less: Beginning merchandise inventory Required merchandise purchases June SUPPAR COMPANY San Miguel Store Budgeted Income Statement For the Months of May and June, 2022 May Sales revenue Cost of goods sold Beginning inventory Add: Purchases Cost of goods available for sale Less: Ending inventory Cost of goods sold Gross profit Operating expenses Sales salaries Advertising* Delivery** Sales commissions*** Rent Depreciation Utilities Insurance Total Income from operations Interest expense Income before income taxes Income tax expense Net income