Instructions: JTL Corporation Term Project ACC 3020 Spring Summer 2016 1. This is a problem for a fictional company, JTL Corporation. It applies principles from various chapters in the textbook. 2. Completing this exercise will fulfill the requirements of the Term Paper/Project for ACC 3020. It is worth 200 points. 3. The project is due no later than 6:00 pm on July 27. Late submission will receive a 10% scoring reduction. Submissions after 6:00 pm on July 29 will NOT be graded. 4. Your particular assignment will be based on the first letter of your last name with the following ranges: A-H, J-P, R-S and T-Z. 5. Your work must be completed and submitted on Excel. 6. You may work with other students but you must submit your own work individually. Consider visiting the Accounting Tutorial Lab for additional help. 7. Your submission must be made by uploading your work through Blackboard. Any other type of submission, including direct email to me or hand delivery of a hardcopy will receive a 20% scoring reduction. It is your responsibility to learn how to perform this task in BB. I suggest you do that before the last moments. 8. One final comment.This is a progressive problem some of the chapters may have already been covered in class, others will be covered soon. I strongly suggest you start working on it NOW and work on it piece by piece. Dont try to finish it all in one weekend. Good luck and I look forward to seeing your work! Numbers and info Assignment Last Name A-H JTL MANUFACTURING Problem JTL MANUFACTURING Corporation is a private corporation formed for the purpose of providing the products and the services needed to irrigate farms, parks, commercial projects, and private homes. It has a centrally located factory in a U.S. city that manufactures the products it markets to retail outlets across the nation. It also maintains a division that provides installation and warranty servicing in six metropolitan areas. The mission of JTL MANUFACTURING is to manufacture quality parts that can be used for effective irrigation projects that also conserve water. By that effort, the company hopes to satisfy its customers, provide rapid and responsible service, and serve the community and the employees who represent them in each community. The company has been growing rapidly, so management is considering new ideas to help the company continue its growth and maintain the high quality of its products. JTL MANUFACTURING was founded by Thomas Watkins who is the company president and chief executive officer (CEO). Working with him from the companys inception was Wills brother, Thomas, whose sprinkler designs and ideas about the installation of proper systems have been a major basis of the companys success. Thomas is the vice president who oversees all aspects of design and production in the company. The factory itself is managed by Jenna Parsons who hires his line managers to supervise the factory employees. The factory makes all of the parts for the irrigation systems. The purchasing department is managed by Hector Hines. The installation and training division is overseen by vice president Mason Spolski, who supervises the managers of the six local installation operations. Each of these local managers hires his or her own local service people. These service employees are trained by the home office under Mason Spolskis direction because of the uniqueness of the companys products. There is a small Human Resources department under the direction of Sergey Singh, a vice president who handles the employee paperwork, though hiring is actually performed by the separate departments. Gene Totter is the vice president who heads the sales and marketing area; he oversees 10 well-trained salespeople. The accounting and finance division of the company is headed by Keilly OToole, who is the chief financial officer (CFO) and a company vice president; he is a member of the Institute of Management Accountants and holds a certificate in management accounting. He has a small staff of Certified Public Accountants, including a controller and a treasurer, and a staff of accounting input operators who maintain the financial records. A partial list of JTL MANUFACTURING accounts and their balances for the month of November 2012 follows. Accounts Receivable $ 275,000 Advertising Expenses 54,000 Cash 260,000 DepreciationFactory Equipment 16,800 DepreciationOffice Equipment 2,400 Direct Labor 42,000 Factory Supplies Used 16,800 Factory Utilities 10,200 Finished Goods Inventory, November 30 68,800 Finished Goods Inventory, October 31 72,550 Indirect Labor 48,000 Office Supplies Expense 1,600 Other Administrative Expenses 72,000 Prepaid Expenses 41,250 Raw Materials Inventory, November 30 52,700 Raw Materials Inventory, October 31 38,000 Raw Materials Purchases 184,500 RentFactory Equipment 47,000 RepairsFactory Equipment 4,500 Salaries 325,000 Sales 1,350,000 Sales Commissions 40,500 Work In Process Inventory October 31 52,700 Work In Process Inventory, November 30 42,000 Instructions (a)A list of accounts and their values are given above. From this information, prepare a cost of goods manufactured schedule, an income statement, and the current assets section of the balance sheet for JTL MANUFACTURING Corporation for the month of November 2012. JTL MANUFACTURING JTL MANUFACTURING Corporation is continuing its budget preparations. JTL MANUFACTURING had the following static budget and overhead costs for March 2014. JTL MANUFACTURING CORPORATION JTL MANUFACTURING CORPORATION Manufacturing Overhead Budget Manufacturing Overhead Costs (Actual) (Static) For the Month of March 2014For the Month of March 2014 Budgeted production in units 117,500 Production in units 118,500 Budgeted costs Costs Indirect materials $ 5,875 Indirect materials $ 5,910 Indirect labor 14,100 Indirect labor 14,195 Utilities 11,750 Utilities 11,880 Maintenance 8,225 Maintenance 8,275 Salaries 42,000 Salaries 42,000 Depreciation 16,800 Depreciation 16,800 Property taxes 3,000 Property taxes 3,000 Insurance 1,200 Insurance 1,200 Janitorial 1,500 Janitorial 1,500 Total budgeted costs $104,450 Total costs $104,760 JTL MANUFACTURING produced 118,500 units in March rather than the budgeted number of units. Instructions (a)Prepare a flexible overhead budget based on the following amounts produced. (1)115,500 units (2)116,500 units (3)117,500 units (b)Prepare a flexible budget report showing the differences (favorable and unfavorable) in manufacturing overhead costs for the month of March. JTL MANUFACTURING JTL MANUFACTURING Corporation uses very stringent standard costs in evaluating its manufacturing efficiency. These standards are not ideal at this point, but the management is working toward that as a goal. At present, the company uses the following standards. Materials Item Per unit Cost Metal Plastic Rubber 1 lb. 12 oz. 4 oz. 63 per lb. $1.00 per lb. 88 per lb. Direct Labor Item Per unit Cost Labor 15 min. $8.00 per hr. Predetermined overhead rate based on direct labor hours = $4.28 The January figures for purchasing, production, and labor are: The company purchased 229,000 pounds of raw materials in January at a cost of 78 a pound. Production used 229,000 pounds of raw materials to make 115,500 units in January. Direct labor spent 18 minutes on each product at a cost of $7.80 per hour. Overhead costs for January totaled $54,673 variable and $73,800 fixed. Instructions Answer the following questions about standard costs. (a)What is the materials price variance? (b)What is the materials quantity variance? (c)What is the total materials variance? (d)What is the labor price variance? (e)What is the labor quantity variance? (f)What is the total labor variance? (g)Evaluate the variances for this company for January. What do these variances suggest to management? JTL MANUFACTURING JTL MANUFACTURING puts much emphasis on cash flow when it plans for capital investments. The company chose its discount rate of 8% based on the rate of return it must pay its owners and creditors. Using that rate, JTL MANUFACTURING then uses different methods to determine the best decisions for making capital outlays. In 2014 JTL MANUFACTURING is considering buying five new backhoes to replace the backhoes it now has. The new backhoes are faster, cost less to run, provide for more accurate trench digging, have comfort features for the operators, and have 1-year maintenance agreements to go with them. The old backhoes are working just fine, but they do require considerable maintenance. The backhoe operators are very familiar with the old backhoes and would need to learn some new skills to use the new backhoes. The following information is available to use in deciding whether to purchase the new backhoes. Old Backhoes New Backhoes Purchase cost when new $90,000 $200,000 Salvage value now $42,000 Investment in major overhaul needed in next year $55,000 Salvage value in 8 years $15,000 $90,000 Remaining life 8 years 8 years Net cash flow generated each year $30,425 $43,900 Instructions (a)Evaluate in the following ways whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For the new machine, subtract the salvage value of the old machine to determine the initial cost of the investment.) (1)Using the net present value method for buying new or keeping the old. (2)Using the payback method for each choice. (Hint: For the old machine, evaluate the payback of an overhaul.) (3)Comparing the profitability index for each choice. (4)Comparing the internal rate of return for each choice to the required 8% discount rate. (b)Are there any intangible benefits or negatives that would influence this decision? (c)What decision would you make and why? 3