I need help creating an Excel for the following using the information in the picture:

1. Schedule of cost of goods manufactured

2. Schedule of Cost of goods sold

3. Traditional income statement

4000 Interest expense $35,000 Beginning balances $22,000 Ending balances $76 OD Additional raw materials Work in process (Beginning) $18,000 Work an Process (Endling $9000 $147,000 Adminstrative expense $57,205 Selling cost $81.000 Direct labor $42,000 Overhead costs $5,000 Indrect materials $45,000 manufacturing overhead $46,000 Beginning good inventory $38,000 Ending good inventory Sales $ 500,000 Tax rode - 21%