Plz help me 1. Read the following data regarding payroll deductions, and answer the questions that follow: Lydia: $9.50/hour, worked 20 hours this pay period
Thomas: $12.50/hour, worked 40 hours this pay period
Bruce: $8.50/hour, worked 30 hours this pay period
a) Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings. (3 points)

b) Add a "Tax (%)" column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who make $9.00 or less an hour, the rate is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the rate is 7%. (4 points)

Exercise 6-2 variable costing income statement; explanation of difference in net operating income [lo6-2] ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $970. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 200 units sold 180 units in ending inventory 20 variable costs per unit: direct materials $ 130 direct labor $ 300 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 63,000 fixed selling and administrative $ 25,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 174,600 cost of goods sold 139,500 gross margin 35,100 selling and administrative expense 27,700 net operating income $ 7,400 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing.