2. Please answer in excel

On January 1, 2023, the Pharoah Company budget committee reached agreement on the following data for the six months ending June 30, 2023: 1. Sales units: First quarter 5,100: second quarter 6,100;third quarter 7,100 2. Ending raw materials inventory: 40% of the next quarter's production requirements 3. Ending finished goods inventory: 25% of the next quarter's expected sales units Third-quarter production: 7.400 units The ending raw materials and finished goods inventories at December 31, 2022, had the same percentages for production and sales that are budgeted for 2022.3 kilograms of raw materials are needed to make each unit of finished goods. Raw materials purchased are expected to cost $4 per kilogram. PHAROAH COMPANY Production Budget For the Six Months Ending June 30, 2023 Quarter 1 2 PHAROAH COMPANY Production Budget For the Six Months Ending June 30, 2023 Quarter 1 2 Total