solutions in excel format pla

The following data for the just completed year are taken from the accounting records of Eccles Company: Costs incurred: Advertising expense Direct labor cost Purchases of raw materials Rent, factory building Indirect labor Sales commissions Utilities, factory Maintenance, factory equipment Supplies, factory Depreciation, office equipment Depreciation, factory equipment P100,000 90,000 132,000 80,000 56,300 35,000 9,000 24,000 700 8,000 40,000 Inventories: End of the Year Beginning of the Year P 8,000 Raw Materials P10,000 5,000 20,000 Work-in- Process Finished Goods 70,000 25,000 Inventories: Beginning of the Year End of the Year Raw Materials P 8,000 P10,000 Work-in- Process 5,000 20,000 Finished 70,000 25,000 Goods The cost of goods sold amounts to O P430,000 O P210,000 O P415,000 O P460,000