AutoSave 2 hw1 202 copy Home Insert Draw Page Layout Formulas Data Review View Tell me H6 fx The following data from the just completed year are taken from the accounting records of Nouf Company (in dollars): 2 Number of units sold (units) 3 Selling Price (S/unit) Variable selling expense per unit (S/unit) 4 5 Total fixed selling expense (S) Variable administrative expense per unit (S/unit) 1,000 925 46 100,000 Total fixed administrative expense (S) 8 Direct labor cost (S) Manufacturing overhead applied to work in process (S) 34 250,000 120,000 Calculate in sheet "Overhead applied 290,000 0 Actual manufacturing overhead cost(S) 1 Indirect materials (S) Purchases of materials during period (S) 2 3,000 80,000 Balances of Inventory accounts: Beginning Account Ending Balance ($) balance ($) Raw Materials 5,000 9,000! Work in process 15,000 4,000! Finished goods 9,000 2,000! Instructions. Please prepare the following reports in the assigned tabs of the excel file: Sheet 1. Calculate POHR, overhead applied and under- or overapplied overhead Sheet 2. Prepare a schedule of cost of goods manufactured. Sheet 3. Prepare a schedule of cost of goods sold; Sheet 4. Prepare a traditional format income statement; Sheet 5. Prepare a contribution format income statement. HW Assignment 1. Overhead applied 2. Schedule of COGM 3. Schedule of COG!