accounting. Please keep file in its original Excel format.

The following information pertains to questions 1 - 5. On June 1, Year 1, ABC firm bought (50% cash, 50% 90-day note for ALL associated costs) and placed into service a machine costing $62,000. In order to install the machine, the company also had to pay $2,000 in installation fees. It is anticipated that the machine will produce 48,000 hours of production and will have salvage value of $4,000 at the end of its useful life, which is 5 years. During Year 1, the machine is used for a total of 6,000 hours and in Year 2, the machine is used for a total of 15,000 hours. 1) Calculate the depreciation for the first two calander years (June 1 - December 31 and the full second year) for all three methods (Staight-line, units of production, and DDB). Straight-line Method: A. B. C. D. E. F. June 1 - Dec.31, Year 1 $6,767 $7,000 $7,233 $7,467 $7,700 $8,000 January 1 - Dec. 31, Year 2 $11,200 $11,600 $12,000 $12,400 $12,800 $13,200 A. B. C. D. E. F. June 1 - Dec.31, Year 1 $7,000 $7,250 $7,500 $7,750 $8,000 $8,250 January 1 - Dec. 31, Year 2 $18,125 $18,750 $19,375 $20,000 $20,625 $21,250 A. B. C. D. E. F. June 1 - Dec.31, Year 1 $13,067 $13,533 $14,000 $14,467 $14,933 $15,400 January 1 - Dec. 31, Year 2 $17,173 $17,787 $18,400 $19,013 $19,627 $20,240 Select your answers here -----------> Units of Production: Select your answers here -----------> DDB Method: ` Select your answers here -----------> 2) Show the journal transaction to record the acquisition on June 1. Date Account Description 1-Jun CASH Debit Credit 3) Record the depreciation expense on December 31, Year 1 using the units of production method. Date Account Description Debit 31-Dec Credit 4) On March 13th, Year 3, the company sold the machine for $22,000 cash. The total usage inYear 3 was 2,000 hours. Record the adjusting depreciation entry in Year 3 based on units of production Date Account Description Debit 13-Mar Credit 5) Record the dispostion entry based on the assst's depreciation history using the units of production method. Date Account Description Debit 13-Mar $22,000 Credit ACCUMULATED DEPRECIATION Questions 6 - 10 are a total of 39 points. The following information pertains to questions 6 - 10. On June 30, Year 1 XYZ firm bought (100% cash) & placed into service a machine costing $40,000. Freight was $300. In order to install the machine, the company also had to pay $1,700 in installation fees. It is anticipated that the machine will produce 50,000 hours of production and will have salvage value of $2,000 at the end of its useful life, which is 4 years. During Year 1, the machine is used for a total of 6,450 hours and in Year 2, the machine is used for a total of 12,140 hours. 6) Calculate the depreciation for the first two calander years (June 30 - December 31 and the full second year) for all three methods (Staight-line, units of production, and DDB). Straight-line Method: A. B. C. D. E. F. June 30 - Dec.31, Year 1 $4,500 $4,750 $5,000 $5,038 $5,213 $5,250 January 1 - Dec. 31, Year 2 $9,000 $9,500 $10,000 $10,075 $10,425 $10,500 A. B. C. D. E. F. June 30 - Dec.31, Year 1 $5,160 $5,418 $5,547 $5,805 $5,934 $6,063 January 1 - Dec. 31, Year 2 $5,418 $5,805 $6,063 $9,712 $10,320 $10,386 A. B. C. D. E. F. June 30 - Dec.31, Year 1 $10,500 $10,800 $11,200 $21,000 $21,600 $22,400 January 1 - Dec. 31, Year 2 $12,600 $14,175 $15,750 $25,200 $28,350 $31,500 Select your answers here -----------> Units of Production: Select your answers here -----------> DDB Method: ` Select your answers here -----------> 7) Show the journal transaction to record the acquisition on June 30. Date Account Description 30-Jun Debit Credit 8) Record the depreciation expense on December 31, Year 1 using the units of production method. Date Account Description Debit 31-Dec Credit 9) On September 27th, Year 3, the company sold the machine for $23,000 cash. Total usage inYear 3 was 5,410 hours. Record the adjusting depreciation entry in Year 3 based on units of production Date Account Description Debit 27-Sep 10) Record the dispostion entry based on the assst's depreciation history using the units of production method. Date Account Description Debit 27-Sep $23,000 Credit Credit $42,000 Questions 11 - 15 are a total of 21 points. The following informations pertains to questions 11 - 15. On June 27th, Pen Image Inc. sold Marden Company 10 dozen (120) ball point pens with the Marden Company logo printed on each pen. The pens cost $27 per dozen for a total of $270. Marden was granted credits terms of 3/15, net 45. On June 30th, Marden returns 12 pens that were damaged in transit. On July 2nd, Marden calls Pen Image and requests a price reduction of $25 since the logos were not centered. Pen Image agreed to the reduction. On July 12, Marden pays half of the amount owed and pays the balance on August 11. 11) Record the journal entry for the transaction that took place on June 27. Date Account Description 27-Jun Debit Credit 12) Record the journal entry for the transaction that took place on June 30. Date Account Description 30-Jun Debit Credit 13) Record the journal entry for the transaction that took place on July 2. Date Account Description 2-Jul Debit Credit 14) Record the journal entry for the transaction that took place on July 12. Date Account Description 12-Jul CASH Debit Credit 15) Record the journal entry for the transaction that took place on August 11. Date Account Description 11-Aug Debit Credit Please make sure your name is entered in cell E2, Thank you