Enter a logical function in cell f5 that calculates employee fica withholding. if the employee is full-time and has at least one dependent, then he or she pays 7% of the annual salary minus any deductions. all other employees pay 5% of the annual salary minus any deductions. copy the function down through column f. format the data in column f with accounting number format.

The following cost and inventory data are taken from the accounting records of mason company for the year just completed: costs incurred: direct labor cost $ 90,000 purchases of raw materials $ 134,000 manufacturing overhead $ 205,000 advertising expense $ 45,000 sales salaries $ 101,000 depreciation, office equipment $ 225,000 beginning of the year end of the year inventories: raw materials $ 8,100 $ 10,300 work in process $ 5,900 $ 21,000 finished goods $ 77,000 $ 25,800 required: 1. prepare a schedule of cost of goods manufactured. 2. prepare the cost of goods sold section of mason company’s income statement for the year.