solutions in excel format pls

The following data are obtained from Gianna Manufacturing Company: . . Cost of goods manufactured is P187,500 Inventory variations are as follows: raw materials ending inventory is 1/3 based on raw materials beginning; no initial inventory of work in process, but at the end of period P 12,500 was on hand; finished goods inventory was four times as large at the end of the period as at the start. Net income after taxes amounted to P 26,000, the income tax rate is 35% Purchases of raw materials amounted to net income before taxes Breakdown of costs incurred in manufacturing cost was as follows: o Raw materials consumed - 50% - Direct labor -30% - Manufacturing overhead - 20% . . The total amount of raw materials beginning inventory was OP90,000 OP40,000 OP38,571 OP60,000