subject
Business, 08.05.2020 00:57 JASMINEM8347

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.

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 21.06.2019 21:00, mrgutierrez1
Barbara jones opened barb’s book business on february 1, 2010. the company specilizes in editing accounting textbooks. you have been hired as manager. your duties include maintaining the company’s financial records. the following transactions occurred in february , the first month of operations. a. received shareholders' cash contributions on february 1 totaling $16,000 to form the corporation; issued 1,000 shares of common stock. b. paid $2,400 cash on february 2 for three months' rent for office space. tip: for convenience, simply record the full amount of the payment as an asset (prepaid rent). at the end of the month, this account will be adjusted to its proper balance. c. purchased and received supplies on february 3 for $300 cash. d. signed a promissory note on february 4, payable in two years; deposited $10,000 in the company's bank account. e. on february 5, paid cash to buy equipment for $2,500 and land for $7,500. f. placed an advertisement in the local paper on february 6 for $425 cash. g. recorded sales on february 7 totaling $1,800; $1,525 was in cash and the rest on accounts receivable. h. collected accounts receivable of $50 from customers on february 8. i. on february 9, repaired one of the computers for $120 cash. tip: most repairs involve costs that do not provide additional future economic benefits. j. incurred and paid employee wages on february 28 of $420.required: set up appropriate t-accounts for cash, accounts receivable, supplies, prepaid rent, equipment, furniture and fixtures, notes payable, contributed capital, service revenue, advertising expense, wages expense, and repair expense. all accounts begin with zero balances. tip: when preparing the t-accounts, you might find it useful to group them by type: assets, liabilities, stockholders’ equity, revenues, and expenses.2. record in t-accounts the effects of each transaction in february, referencing each transaction in the accounts with the transaction letter. show the unadjusted ending balances in the t-accounts. 3. prepare an unadjusted trial balance at the end of february.4. refer to the revenues and expenses shown on the unadjusted trial balance. based on this information, write a short memo offering your opinion on the results of operations during the first month of business.
Answers: 1
image
Business, 22.06.2019 08:00, maddison788
Shrieves casting company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by sidney johnson, a recently graduated mba. the production line would be set up in unused space in the main plant. the machinery’s invoice price would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000 to install the equipment. the machinery has an economic life of 4 years, and shrieves has obtained a special tax ruling that places the equipment in the macrs 3-year class. the machinery is expected to have a salvage value of $25,000 after 4 years of use. the new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first year, excluding depreciation. each unit can be sold for $200 in the first year. the sales price and cost are both expected to increase by 3% per year due to inflation. further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues. the firm’s tax rate is 40%, and its overall weighted average cost of capital, which is the risk-adjusted cost of capital for an average project (r), is 10%. define “incremental cash flow.” (1) should you subtract interest expense or dividends when calculating project cash flow?
Answers: 1
image
Business, 22.06.2019 20:30, maguilarz2005
Contrast two economies that transitioned to capitalism and explain what factors affected the ease kf their transition as welas the “face” of capitalism that each has adopted
Answers: 2
image
Business, 22.06.2019 20:50, fathimasaynas2975
Lead time for one of your fastest-moving products is 20 days. demand during this period averages 90 units per day. a) what would be an appropriate reorder point? ) how does your answer change if demand during lead time doubles? ) how does your answer change if demand during lead time drops in half?
Answers: 1
You know the right answer?
Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek i...

Questions in other subjects:

Konu
Mathematics, 02.07.2019 08:30