The Cache Corporation has forecasted the following sales for the first seven months of the year

January 120,000

February 160,000

March 180,000

April 240,000

May 120,000

June 200,000

July 220,000

Cost of goods sold ratio to sales is 60%. Inventory ending per month are set equal to 20% of forecasted sales needs for the next month. Of the total inventory purchases cost, 40% are paid in the month of purchase and 60% in the following month. Labor costs will run P60,000 per month and fixed overhead is P30,000 per month. Conversion costs are paid as incurred. Interest payments on the debt will be P45,000 for both March and June. Atlantas sales force will receive a 3% commission on sales, payable at the end of each month.

Sales terms are as follows: 50% cash sales; 50% credit sales. Credit sales are collected as follows: 30% in the month of sale, 50% in the month after the sales, 20% two months after the sale.

A. How much will be paid in the month of June for the purchase of inventory?

B. How much does Cache plan to disburse in the month of June?

C. How much is the accounts payable balance at the end of June?

D. How much is the total estimated cash receipts for June?

E. How much is the total cash provided (used) by operating activities for the month of June alone?