just question 20. I attached the cut off column. will rate and like thank!

is it to be done in a spread sheet similar to the excel sheet i attached. Thank you.

*** What information is needed. I thought I provided everything. The second photo is the cut off information. The numbers are used to solve the questions.

What specifically is missing?

Which photo is not visible. the first 4 look sharp to me. is it the last one?

ok i added a clearer picture

Accounting Transactions 49 19 3-1 Employee Costs and Deductions Employee ($) Total gyer's Costs 600.00 37.20 350.00 21.70 Security 1,850.00 114.70 26.83 care 400.00 24.80 5.80 12.00 3.20 8.00 8.70 55.50 ON 500.00 31.00 7.25 15.00 4.00 10.00 15.00 40.00 33.20 655.45 14.80 37.00 18.00 4.80 12.00 54.00 40.00 38.92 813.62 Insurance Comp. Insurance 36.00 136.50 40.00 29.79 160.00 129.42 2,524.75 27.51 496.09 559.59 appee Deductions Security re Withholdings Withholdings Insurance 37.20 8.70 59.85 24.80 5.80 29.85 24.00 60.00 144.45 21.70 5.08 22.35 21.00 31.00 7.25 44.85 30.00 60.00 173.10 114.70 26.83 156.90 111.00 240.00 649.43 36.00 60.00 201.75 Employer's Costs Wages Social Security Medicare SUTA FUTA Liability Insurance Workers' Comp. Health Insurance Vacation Total Employee Deductions Social Security Medicare Federal Withholdings State Withholdings Health Insuranee TOHU 20. ABC Framing has been hired to frame a light commer- cial building. The project began on July 2 and was com- pleted on August 9. The following is a list of accounting transactions associated with the project. For each trans- action, determine the changes that occur on the balance sheet, income statement, and job cost ledger as a result of that transaction and the year-to-date totals by general ledger account and job cost code. The company uses the chart of accounts in Figure 2-1. The general contractor doesn't withhold retention. All costs are billed to job cost code 1005.06110. The appropriate cost type (M, L, or E) needs to be added to the job cost code. The company rents its equipment and the equipment is billed directly to the job cost ledger; therefore, they do not keep an equipment ledger. After you have entered all of the transactions, plot the daily balance of the 110 cash account and profit for the project. a. On July 11 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $4,299.52; social security, $602.88; Medicare, $142.08; SUTA, $268.16; FUTA, $5.76; workers' compensation, $425.92; general liability, $38.08; and employer-paid health insurance, $288.00. b. On July 13 the employees were paid for the time entered into the accounting system on July 11. c. On July 18 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, CHAPTER THREE $335.20; FUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. d. On July 20 the employees were paid for the time entered into the accounting system on July 18. e. On July 25 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. f. On July 27 the employees were paid for the time entered into the accounting system on July 25. g. On July 31, the social security, Medicare, SUTA, FUTA, workers' compensation, general liability, and employer-paid health insurance premiums recorded during July were paid. h. On August 1 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. 1. On August 2 a bill for materials (eg, nails, hardware, and small tools) in the amount of $3,846 was entered into the accounting system. A bill for the forklift rental in the amount of $6,720 was also entered. 1. On August 3 the employees were paid for the time entered into the accounting system on August 1. k. On August 5 the general contractor was billed $15.000 for July's work. 1. On August 8 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60, Medicare, $17760; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. m. On August 10 the employees were paid for the time entered into the accounting system on August 8. n. On August 15 the time cards were entered into the accounting system: The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; FUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. o. On August 15 the materials and equipment bills entered into the accounting system on August 2 were paid. p. On August 17 the employees were paid for the time entered into the accounting system on August 15. q. On August 17 a bill for the forklift rental in the amount of $2,240 was entered into the accounting system. r. On August 25 payment was received from the gen- eral contractor for July's work. 5. On August 31, the social security, Medicare, SUTA, FUTA, workers' compensation, general liability, and employer-paid health insurance premiums recorded during August were paid.. t. On August 31 the forklift rental bill recorded on August 17 was paid. u. On September 3 the bill for materials (e.g. nails. hardware, and small tools) in the amount of $1,705 was entered into the accounting system. v. On September 5 the general contractor was billed for $20,800 for July's work. w. On September 15 the materials bill recorded on September 3 was paid. x. On September 25 payment is received from the gen- eral contractor for July's work. 120 M 3 10 Accounts Accrued 342 Accrued 43 Accrued income 500 Revenue 610 Meter 620 met 1005.0611M 100506111 100506111 Fe Balance Sheet Date 110 Cash 120 Accounts 310 Accounts Receivable Payable 340 Accrued Payroll 342 Accrued Taxes 343 Accrued Insurance 430 Current Period Net Income/Profit 5 Ideas Sensitivity Cell Styles ditional Format as matting Table Styles Format Sort & Find & Filter Select Editing Cells Ideas Sensitivity NO Job Cost Income Statement 640 Equipment1005.0611M 1005.0611L 1005.0611E 620 Labor 500 Revenue 610 Materials Accounting Transactions 49 19 3-1 Employee Costs and Deductions Employee ($) Total gyer's Costs 600.00 37.20 350.00 21.70 Security 1,850.00 114.70 26.83 care 400.00 24.80 5.80 12.00 3.20 8.00 8.70 55.50 ON 500.00 31.00 7.25 15.00 4.00 10.00 15.00 40.00 33.20 655.45 14.80 37.00 18.00 4.80 12.00 54.00 40.00 38.92 813.62 Insurance Comp. Insurance 36.00 136.50 40.00 29.79 160.00 129.42 2,524.75 27.51 496.09 559.59 appee Deductions Security re Withholdings Withholdings Insurance 37.20 8.70 59.85 24.80 5.80 29.85 24.00 60.00 144.45 21.70 5.08 22.35 21.00 31.00 7.25 44.85 30.00 60.00 173.10 114.70 26.83 156.90 111.00 240.00 649.43 36.00 60.00 201.75 Employer's Costs Wages Social Security Medicare SUTA FUTA Liability Insurance Workers' Comp. Health Insurance Vacation Total Employee Deductions Social Security Medicare Federal Withholdings State Withholdings Health Insuranee TOHU 20. ABC Framing has been hired to frame a light commer- cial building. The project began on July 2 and was com- pleted on August 9. The following is a list of accounting transactions associated with the project. For each trans- action, determine the changes that occur on the balance sheet, income statement, and job cost ledger as a result of that transaction and the year-to-date totals by general ledger account and job cost code. The company uses the chart of accounts in Figure 2-1. The general contractor doesn't withhold retention. All costs are billed to job cost code 1005.06110. The appropriate cost type (M, L, or E) needs to be added to the job cost code. The company rents its equipment and the equipment is billed directly to the job cost ledger; therefore, they do not keep an equipment ledger. After you have entered all of the transactions, plot the daily balance of the 110 cash account and profit for the project. a. On July 11 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $4,299.52; social security, $602.88; Medicare, $142.08; SUTA, $268.16; FUTA, $5.76; workers' compensation, $425.92; general liability, $38.08; and employer-paid health insurance, $288.00. b. On July 13 the employees were paid for the time entered into the accounting system on July 11. c. On July 18 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, CHAPTER THREE $335.20; FUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. d. On July 20 the employees were paid for the time entered into the accounting system on July 18. e. On July 25 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. f. On July 27 the employees were paid for the time entered into the accounting system on July 25. g. On July 31, the social security, Medicare, SUTA, FUTA, workers' compensation, general liability, and employer-paid health insurance premiums recorded during July were paid. h. On August 1 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. 1. On August 2 a bill for materials (eg, nails, hardware, and small tools) in the amount of $3,846 was entered into the accounting system. A bill for the forklift rental in the amount of $6,720 was also entered. 1. On August 3 the employees were paid for the time entered into the accounting system on August 1. k. On August 5 the general contractor was billed $15.000 for July's work. 1. On August 8 the time cards were entered into the accounting system. The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60, Medicare, $17760; SUTA, $335.20; PUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. m. On August 10 the employees were paid for the time entered into the accounting system on August 8. n. On August 15 the time cards were entered into the accounting system: The following costs were recorded: wages due to employees, $5,374.40; social security, $753.60; Medicare, $177.60; SUTA, $335.20; FUTA, $7.20; workers' compensation, $532.40; general liability, $47.60; and employer-paid health insurance, $360.00. o. On August 15 the materials and equipment bills entered into the accounting system on August 2 were paid. p. On August 17 the employees were paid for the time entered into the accounting system on August 15. q. On August 17 a bill for the forklift rental in the amount of $2,240 was entered into the accounting system. r. On August 25 payment was received from the gen- eral contractor for July's work. 5. On August 31, the social security, Medicare, SUTA, FUTA, workers' compensation, general liability, and employer-paid health insurance premiums recorded during August were paid.. t. On August 31 the forklift rental bill recorded on August 17 was paid. u. On September 3 the bill for materials (e.g. nails. hardware, and small tools) in the amount of $1,705 was entered into the accounting system. v. On September 5 the general contractor was billed for $20,800 for July's work. w. On September 15 the materials bill recorded on September 3 was paid. x. On September 25 payment is received from the gen- eral contractor for July's work. 120 M 3 10 Accounts Accrued 342 Accrued 43 Accrued income 500 Revenue 610 Meter 620 met 1005.0611M 100506111 100506111 Fe Balance Sheet Date 110 Cash 120 Accounts 310 Accounts Receivable Payable 340 Accrued Payroll 342 Accrued Taxes 343 Accrued Insurance 430 Current Period Net Income/Profit 5 Ideas Sensitivity Cell Styles ditional Format as matting Table Styles Format Sort & Find & Filter Select Editing Cells Ideas Sensitivity NO Job Cost Income Statement 640 Equipment1005.0611M 1005.0611L 1005.0611E 620 Labor 500 Revenue 610 Materials