4. Nehemiah Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding sales for the first 6 months of the coming year are as follows: Type of monthly sales Cash sales 20% Credit sales 80% Estimated monthly sales January P600,000 February 650,000 March 700,000 April May June 800,000 Collection pattern for credit sales Month of sale 30% One month following sale 40% Second month following sale 25% 625,000 720,000 Nehemiah's cost of goods sold averages 40% of the sales value. Company's objective is to maintain a target inventory equal to 30% of the next month's sales in units. Purchases of merchandise for resale are paid for in the month following sale. The variable operating expenses (other than cost of goods sold) for Nehemiah are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for insurance and property taxes. Insurance is paid quarterly in January, April, July and October. Property taxes are paid twice a year in April and October Advertising Depreciation Insurance Property taxes Salaries 1,080,000 P720,000 420,000 180,000 240,000 Required: a. How much is the amount of cash collected in March from the sales made during March? b. How much is the total cash receipts for the month of April? C. How much is the purchase of merchandise the company will need to make during February? d. How much is the cost of goods sold projected for the month of February? e. How much is the total cash disbursement for operating expenses (excluding cost of goods sold) during April