Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents (column B) by the deduction per dependent (A24) and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40.

Vulcan company is a monthly depositor whose tax liability for march 2019 is $2,510. 1. what is the due date for the deposit of these taxes? march 17 2. assume that no deposit was made until april 29. compute the following penalties. assume a 365-day year in your computations. round your answers to the nearest cent. a. penalty for failure to make timely deposits. $ b. penalty for failure to fully pay employment taxes $ c. interest on late payment (assume a 5% interest rate). $ d. total penalty imposed $

Which of the following is an effective strategy when interest rates are falling? a. use long-term loans to take advantage of current low rates. b. use short-term loans to take advantage of lower rates when you refinance a loan. c. deposit to a short-term savings instrumentals to take advantage of higher interest rates when they mature. d. select short-term savings instruments to lock in earnings at a current high rates.

Companies in the u. s. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. in 2011 hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. the following data show the number of cars in service (1000s) and the annual revenue ($ millions) for six smaller car rental companies (auto rental news website, august 7, 2012). excel file: data14-09.xls if required, enter negative values as negative numbers. a. select a scatter diagram with the number of cars in service as the independent variable. b. what does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. use the least squares method to develop the estimated regression equation (to 3 decimals). ŷ = + x d. for every additional car placed in service, estimate how much annual revenue will change. by $ e. fox rent a car has 11,000 cars in service. use the estimated regression equation developed in part (c) to predict annual revenue for fox rent a car. round your answer to nearest whole value. $ million hide feedback partially correct