The following date from the just completed year are taken from the accounting records of Nouf Company (in 2 Number of units sold (units) 3 Selling Price (Sunit) Variable selling expense per unit (S/unit) dollar): 1,000 925 46 Total fixed selling expense ($) Variable administrative expense per unit (Sun) Total fixed administrative expense ($) 8 Direct labor cost (5). Manufacturing overhead applied to work in process (3) Actual manufacturing overhead cost(5) 11 Indirect materials ($) Purchases of materials during period ($) 100,000 34 250,000 120,000 Calculate in siteet "Overhead appled 290,000 3,000 80,000 14 Account Balances of Inventory accounts: Beginning balance (5) Ending Balance ($) Raw Materials 5,000 9,000 Work in process 15,000 4,000 Finished goods 9,000 2,000 20 Instructions. Please prepare the following reports in the assigned tabs of the excel file: 21 Sheet 1. Calculate POHR, overhead applied and under- or overapplied overhead PPP 8 8 8 22 23 Sheet 2. Prepare a schedule of cost of goods manufactured. Sheet ..... Prepare a schedule of cost of goods sold; Sheet 4. Prepare a traditional format income statement; Sheet 5..... Prepare a contribution format income statement.