Description of this paper

ACC - Waterways Continuing Problem

Description

solution


Question

Question;Waterways Continuing ProblemWaterways Continuing ProblemWCP1 Waterways 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 theproducts it markets to retail outlets across the nation. It also maintains a division thatprovides installation and warranty servicing in six metropolitan areas.The mission of Waterways 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 andthe employees who represent them in each community.The company has been growing rapidly, so management is considering new ideas tohelp the company continue its growth and maintain the high quality of its products.Waterways was founded by Will Winkman who is the company president and chiefexecutive officer (CEO). Working with him from the companys inception was Wills brother,Ben, whose sprinkler designs and ideas about the installation of proper systems have beena major basis of the companys success. Ben is the vice president who oversees all aspectsof design and production in the company.The factory itself is managed by Todd Senter 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 Henry Writer, whosupervises the managers of the six local installation operations. Each of these local managershires his or her own local service people. These service employees are trained by the homeoffice under Henry Writers direction because of the uniqueness of the companys products.There is a small Human Resources department under the direction of Sally Fenton,a vice president who handles the employee paperwork, though hiring is actually performed by the separate departments. Sam Totter is the vice president who heads the salesand marketing area, he oversees 10 well-trained salespeople.The accounting and finance division of the company is headed by Abe Headman, whois the chief financial officer (CFO) and a company vice president, he is a member of theInstitute 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 Waterways accounts and their balances for the month of November2012 follows.Accounts ReceivableAdvertising ExpensesCashDepreciationFactory EquipmentDepreciationOffice EquipmentDirect LaborFactory Supplies UsedFactory UtilitiesFinished Goods Inventory, November 30Finished Goods Inventory, October 31Indirect LaborOffice Supplies ExpenseOther Administrative ExpensesPrepaid ExpensesRaw Materials Inventory, November 30Raw Materials Inventory, October 31Raw Materials PurchasesRentFactory EquipmentRepairsFactory EquipmentSalariesSalesSales CommissionsWork In Process Inventory October 31Work In Process Inventory, November 30$ 275,00054,000260,00016,8002,40042,00016,80010,20068,80072,55048,0001,60072,00041,25052,70038,000184,50047,0004,500325,0001,350,00040,50052,70042,00012Waterways Continuing ProblemInstructions(a) Based on the information given, construct an organizational chart of WaterwaysCorporation.(b) A list of accounts and their values are given above. From this information, prepare acost of goods manufactured schedule, an income statement, and the current assetssection of the balance sheet for Waterways Corporation for the month of November2012.Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapter 1)WCP2 Waterways has two major public-park projects to provide with comprehensiveirrigation in one of its service locations this month. Job J57 and Job K52 involve 15 acresof landscaped terrain which will require special-order sprinkler heads to meet the specifications of the project. Using a job cost system to produce these parts, the followingevents occurred during December 2012.Raw materials were requisitioned from the companys inventory on December 2 for$5,061, on December 8 for $1,059, and on December 14 for $3,459. In each instance, twothirds (2/3) of these materials were for J57 and the rest for K52.Six time tickets were turned in for these two projects for a total amount of 18 hoursof work. All the workers were paid $16.50 per hour. The time tickets were dated December 3,December 9, and December 15. On each of those days, 6 labor hours were spent on thesejobs, two-thirds (2/3) for J57 and the rest for K52.The predetermined overhead rate is based on machine hours. The expected machinehour use for the year is 2,112 hours, and the anticipated overhead costs are $840,576for the year. The machine were used by workers on projects K52 and J57 on December 3, 9,and 15. Six machine hours were used for project K52 (2 each day), and 8.5 machine hourswere used for project J57 (2.5 the first day and 3 each of the other days). Both of thesespecial orders were completed on December 15, producing 237 sprinkler heads for J57and 142 sprinkler heads for K52.Additional job order activities during this period of time included:Dec. 1 Purchased raw materials from Durbin Supply Company on account for $53,200.Dec. 2 Issued $40,000 of direct materials from the companys inventory to jobs otherthan K52 and J57 and $3,000 of indirect materials.Dec. 12 Paid Waterways factory salaries and wages in the amount of $65,000.Dec. 13 Paid the factorys water bill of $9,000.Dec. 18 Transferred $50,000 of costs from other completed jobs to finished goods.Dec. 21 Paid the factorys electric bill of $12,000 for Waterways factory.Dec. 31 Made adjusting entries for the factory that included accrued property taxes of$12,000, prepaid insurance of $8,800, and accumulated depreciation of $16,000.Instructions(a) Set up the job cost sheets for Job No. J57 and Job No. K52. Determine the total costfor each manufacturing special order for these jobs. (Round unit cost to nearest cent.)(b) Journalize the activities from these job cost sheets in the general journal. Also journalize the other costs that occurred during this period of time.(c) Assuming that Manufacturing Overhead has a debit balance of $3,600, determinewhether overhead has been under/over applied and make the adjusting entry.(d) Why would Waterways choose machine hours as the cost driver for the overheadrather than direct labor cost? What would Waterways be likely to choose as the costdriver for the overhead for the job of installing the irrigation system and why?34Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 and 2. The asterisk*indicates material discussed in the chapter appendix.)WCP3 Because most of the parts for its irrigation systems are standard, Waterways handles the majority of its manufacturing as a process cost system. There are multiple processdepartments. Three of these departments are the Molding, Cutting, and Welding departments. All items eventually end up in the Package department which prepares items forsale in kits or individually.The following information is available for the Molding department for January.Work in process beginning:Units in processStage of completion for materialsStage of completion for labor and overheadCosts in work in process inventory:MaterialsLaborOverhead$168,36067,56417,270Total costs in beginning work in process$253,19422,00080%30%Units started into production in JanuaryUnits completed and transferred in JanuaryCosts added to production:MaterialsLaborOverhead$264,940289,46860,578Total costs added into production in January$614,986Work in process ending:Units in processStage of completion for materialsStage of completion for labor and overhead60,00058,00024,00050%10%Instructions(a) Prepare a production cost report for Waterways using the weighted-average method.*(b) Show the equivalent units for materials and conversion costs if Waterways used FIFOinstead of weighted-average.Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 3.)WCP4 Direct labor or machine hours may not be the appropriate cost driver for overhead in all areas of manufacturing due to the complexities of many manufacturingprocesses. Many companies use activity-based costing (ABC) which uses multiple drivers(items that consume resources) rather than just one driver to apply overhead to theiractivities. With ABC, a company can use a cost driver that has a direct cause/effect relationship in its applied overhead costs.Waterways looked into ABC as a method of costing because of the variety of items itproduces and the many different activities in which it is involved. The activities listedbelow are a sample of possible cost pools for Waterways.AssemblingBillingDigging trenchesJanitorialMachine maintenanceMachine setupsMoldingPackagingPayrollPlant supervisionProduct designPurchasing materialsSellingTestingWeldingInstructions(a) For each of these cost pools, what would be the likely activity cost driver?(b) Using the following information, determine the overhead rates and the actual costassigned for each of the activity cost pools in a possible ABC system for Waterways.WATERWAYS CORPORATIONActivity Cost PoolsCost DriversIrrigation installationMachining (all machine use)Customer ordersShippingDesignSellingLabor costMachine hoursNumber of ordersnone (direct)Cost per designNumber of sales callsEstimatedOverhead$1,998,4321,670,40030,636820350,400ExpectedUse ofCost Driversper ActivityActualUse ofDrivers12,96033,408,0002,553N/A821,90012,94133,409,0002,520traced directly722,100(c) How would you classify each of the following activities by levelunit level, batchlevel, product level, or facility level?Testing of productsDesigning new productsPackagingMoldingAssemblingDepreciationMachine maintenanceAdvertisingEquipment setupsElectricity required to run equipmentRequisitioning materials(d) (1) The results of ABC can provide a more accurate picture of costs. Discuss the valueof Waterways using this system to determine overhead costs.(2) How might using ABC affect decision making at Waterways?56Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 4.)WCP5 Vice President for Sales and Marketing Sam Totter is trying to plan for the coming year in terms of production needs to meet the sales demand. He is also trying to determine ways in which the companys profits might be increased in the coming year.Instructions(a) Waterways markets a simple water control and timer that it mass-produces. During2013, the company sold 696,000 units at an average selling price of per solution $4.20 perunit. The variable expenses were $1,900,080, and the fixed expenses were $683,256.(1) What is the products contribution margin ratio? (Round to nearest wholepercentage)(2) What is the companys break-even point in units and in dollars for this product?(3) What is the margin of safety, both in dollars and as a ratio? (Round to nearestwhole percentage)(4) If management wanted to increase its income from this product by 10%, howmany additional units would have to be sold to reach this income level?(5) If sales increase by 51,000 units and the cost behaviors do not change, how muchwill income increase on this product?(b) Waterways is thinking of mass-producing one of its special-order sprinklers. To doso would increase variable costs for all sprinklers by an average of $0.70 per unit.The company also estimates that this change could increase the overall number ofsprinklers sold by 10%, and the average sales price would increase $0.20 per unit.Waterways currently sells 491,740 sprinkler units at an average selling price of$26.50. The manufacturing costs are $6,863,512 variable and $2,050,140 fixed. Sellingand administrative costs are $2,651,657 variable and $794,950 fixed.(1) If Waterways begins mass-producing its special-order sprinklers, how would thisaffect the company?(2) If the average sales price per sprinkler unit did not increase when the companybegan mass-producing the special-order sprinkler, what would be the effect onthe company?Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 5.)WCP6Part 1Waterways has a sales mix of sprinklers, valves, and controllers as follows.Annual expected sales:Sale of sprinklersSale of valvesSale of controllers460,000 units at $26.501,480,000 units at $11.2060,000 units at $42.50Variable manufacturing cost per unit:Sprinklers$13.96Valves$ 7.95Controllers$29.75Fixed manufacturing overhead cost (total)$760,000Variable selling and administrative expenses per unit:Sprinklers$1.30Valves$0.50Controllers$3.41Fixed selling and administrative expenses (total)$1,600,000Instructions(a) Determine the sales mix based on unit sales for each product.(b) Using the annual expected sales for these products, determine the weighted-averageunit contribution margin for these three products. (Round to two decimal places.)(c) Assuming the sales mix remains the same, what is the break-even point in units forthese products?Part 2Waterways packages some of its products into sets for home installations. One set (small)sells for $77 with variable costs of production for the set at $50. Another set (large) sellsfor $152 with variable costs of $100. The parts for the $77 set take 9 machine hours toproduce. The parts for the $150 set take 20 machine hours to produce.InstructionsGiven the information above, and assuming all of the package sets produced can be soldeach month, illustrate the best use of machine hours.Part 3The section of Waterways that produces controllers for the company provided the following information.Sales for month of February: 4,000Variable manufacturing cost per unit: $9.75Sales price per unit: $42.50Fixed manufacturing overhead cost (per month for controllers): $81,000Variable selling and administrative expenses per unit: $3.00Fixed selling and administrative expenses (per month for controllers): $13,122Instructions(a) Using this information for the controllers, determine the contribution margin ratio,the degree of operating leverage, the break-even point in dollars, and the margin ofsafety ratio for Waterways Corporation on this product.(b) What does this information suggest if Waterways cost structure is the same for thecompany as a whole?78Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 6.)WCP7Part 1Waterways mass-produces a special connector unit that it normally sells for $3.90. It sellsapproximately 35,000 of these units each year. The variable costs for each unit are $2.30.A company in Canada that has been unable to produce enough of a similar connector tomeet customer demand would like to buy 15,000 of these units at $2.60 per unit. The production of these units is near full capacity at Waterways, so to accept the offer from theCanadian company would require temporarily adding another shift to its production line.To do this would increase variable manufacturing costs by $0.30 per unit. However, variable selling costs would be reduced by $0.20 a unit.An irrigation company has asked for a special order of 2,000 of the connectors. Tomeet this special order, Waterways would not need an additional shift, and the irrigationcompany is willing to pay $3.10 per unit.InstructionsGiven the information above:(a) What are the consequences of Waterways agreeing to provide the 15,000 units to theCanadian company? Would this be a wise special order to accept?(b) Should Waterways accept the special order from the irrigation company?(c) What would be the consequences of accepting both special orders?Part 2Waterways has discovered that a small fitting it now manufactures at a cost of $1.00 perunit could be bought elsewhere for $0.82 per unit. Waterways has fixed costs of $0.20 perunit that cannot be eliminated by buying this unit. Waterways needs 460,000 of theseunits each year.If Waterways decides to buy rather than produce the small fitting, it can devote themachinery and labor to making a timing unit it now buys from another company.Waterways uses approximately 500 of these units each year. The cost of the unit is $12.66.To aid in the production of this unit, Waterways would need to purchase a new machineat a cost of $2,345, and the cost of producing the units would be $9.90 a unit.InstructionsGiven the information above:(a) Without considering the possibility of making the timing unit, evaluate whetherWaterways should buy or continue to make the small fitting.(b) (1) What is Waterways opportunity cost if it chooses to buy the small fitting and startmanufacturing the timing unit?(2) Would it be wise for Waterways to buy the fitting and manufacture the timingunit? Explain.Part 3Waterways is considering the replacement of an antiquated machine that has been slowingdown production because of breakdowns and added maintenance. The operationsmanager estimates that this machine still has 2 more years of possible use. The machineproduces an average of 50 units per day at a cost of $6.50 per unit, whereas other similarmachines are producing twice that much. The units sell for $8.50. Sales are equal to production on these units, and production runs for 260 days each year. The replacementmachine would cost $55,000 and have a 2-year life.InstructionsGiven the information above, what are the consequences of Waterways replacing themachine that is slowing down production because of breakdowns?Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 7.)WCP8 Waterways uses time and material pricing when it bids on irrigation projects.Budgeted data for 2013 are as follows.WATERWAYS CORPORATIONBudgeted Costs for Irrigation Projects for 2013TimeChargesLabor wages (5,750 hours)Supervisors salaryClerical and accountant wagesIrrigation supplies managerOverheadTotalMaterialLoadingCharges$240,00053,950$ 60,0004,00040,00021,000$353,950$125,00060,000Waterways has budgeted for 5,750 labor hours. It desires a $14 profit margin per hour oflabor and 16% profit on materials. It estimates the total invoice cost of materials in 2012will be $640,000.Instructions(a) Compute the rate per hour of labor. (Round to two decimal places.)(b) Compute the material loading charge. (Round to two decimal places.)(c) Waterways has received a request for a bid to do a parkway for the city. The irrigation manager estimates that it will take about a month to complete the project andrequire 480 hours of labor and $80,000 of materials. Compute the total estimated bidfor the parkway project.910Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 8.)WCP9 Waterways Corporation is preparing its budget for the coming year, 2014. Thefirst step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers.SalesUnit sales for November 2013Unit sales for December 2013Expected unit sales for January 2014Expected unit sales for February 2014Expected unit sales for March 2014Expected unit sales for April 2014Expected unit sales for May 2014Unit selling price112,500102,100113,000112,500116,000125,000137,500$12Waterways likes to keep 10% of the next months unit sales in ending inventory. Allsales are on account. 85% of the Accounts Receivable are collected in the month of sale,and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2013, totaled $183,780.Direct MaterialsItemAmount Used per UnitMetalPlasticRubberInventory, Dec. 311 lb @ 58 per lb.12 oz @ 6 per oz4 oz @ 5 per oz5,177.5 lbs3,883.125 lbs1,294.375 lbs2 lbs per unit10,355.0lbsMetal, plastic, and rubber together are 75 per pound per unit.Waterways likes to keep 5% of the materials needed for the next month in its endinginventory. Payment for materials is made within 15 days. 50% is paid in the month ofpurchase, and 50% is paid in the month after purchase. Accounts Payable on December31, 2013, totaled $120,595. Raw Materials on December 31, 2013, totaled 11,295 pounds.Direct LaborLabor requires 12 minutes per unit for completion and is paid at a rate of $8 per hour.Manufacturing OverheadIndirect materialsIndirect laborUtilitiesMaintenanceSalariesDepreciationProperty taxesInsuranceJanitorial30 per labor hour50 per labor hour45 per labor hour25 per labor hour$42,000 per month$16,800 per month$ 2,675 per month$ 1,200 per month$ 1,300 per monthSelling and AdministrativeVariable selling and administrative cost per unit is $1.60.AdvertisingInsuranceSalariesDepreciationOther fixed costs$15,000$ 1,400$72,000$ 2,500$ 3,000aaaaamonthmonthmonthmonthmonthWaterways Continuing ProblemOther InformationThe Cash balance on December 31, 2013, totaled $100,500, but management has decidedit would like to maintain a cash balance of at least $800,000 beginning on January 31,2014. Dividends are paid each month at the rate of $2.50 per share for 5,000 sharesoutstanding. The company has an open line of credit with Romneys Bank. The terms ofthe agreement requires borrowing to be in $1,000 increments at 8% interest. Waterwaysborrows on the first day of the month and repays on the last day of the month. A $500,000equipment purchase is planned for February.InstructionsFor the first quarter of 2014, do the following.(a) Prepare a sales budget.(b) Prepare a production budget.(c) Prepare a direct materials budget. (Round to nearest dollar)(d) Prepare a direct labor budget. (For calculations, round to the nearest hour.)(e) Prepare a manufacturing overhead budget. (Round amounts to the nearest dollar.)(f) Prepare a selling and administrative budget.(g) Prepare a schedule for expected cash collections from customers.(h) Prepare a schedule for expected payments for materials purchases. (Round totals tonearest dollar)(i) Prepare a cash budget.1112Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 9.)WCP10 Waterways Corporation is continuing its budget preparations. Waterways hadthe following static budget and overhead costs for March 2014.WATERWAYS CORPORATIONManufacturing Overhead Budget(Static) For the Month of March 2014WATERWAYS CORPORATIONManufacturing Overhead Costs (Actual)For the Month of March 2014117,500Production in units118,500Budgeted costsIndirect materialsIndirect laborUtilitiesMaintenanceSalariesDepreciationProperty taxesInsuranceJanitorial$ 5,87514,10011,7508,22542,00016,8003,0001,2001,500CostsIndirect materialsIndirect laborUtilitiesMaintenanceSalariesDepreciationProperty taxesInsuranceJanitorial$ 5,91014,19511,8808,27542,00016,8003,0001,2001,500Total budgeted costs$104,450Budgeted production in unitsTotal costs$104,760Waterways 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(4) 118,500 units(5) 119,500 units(b) Prepare a flexible budget report showing the differences (favorable and unfavorable)in manufacturing overhead costs for the month of March.(c) Prepare a responsibility report for the manufacturing overhead for March, assumingonly variable costs are controllable.Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 10.)WCP11 Waterways Corporation uses very stringent standard costs in evaluating its manufacturing efficiency. These standards are not ideal at this point, but the management isworking toward that as a goal. At present, the company uses the following standards.MaterialsItemMetalPlasticRubberPer unitCost1 lb.12 oz.4 oz.63 per lb.$1.00 per lb.88 per lb.Direct LaborItemPer unitCostLabor15 min.$8.00 per hr.Predetermined overhead rate based on directlabor hours $4.28The January figures for purchasing, production, and labor are:The company purchased 229,000 pounds of raw materials in January at a cost of 78a 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.InstructionsAnswer 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) What is the total overhead variance?(h) Evaluate the variances for this company for January. What do these variances suggestto management?1314Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 11.)WCP12 Waterways puts much emphasis on cash flow when it plans for capitalinvestments. The company chose its discount rate of 8% based on the rate of return itmust pay its owners and creditors. Using that rate, Waterways then uses differentmethods to determine the best decisions for making capital outlays.In 2014 Waterways is considering buying five new backhoes to replace the backhoes itnow has. The new backhoes are faster, cost less to run, provide for more accurate trenchdigging, have comfort features for the operators, and have 1-year maintenance agreementsto go with them. The old backhoes are working just fine, but they do require considerablemaintenance. The backhoe operators are very familiar with the old backhoes and wouldneed to learn some new skills to use the new backhoes.The following information is available to use in deciding whether to purchase thenew backhoes.Old BackhoesPurchase cost when newSalvage value nowInvestment in major overhaul needed in next yearSalvage value in 8 yearsRemaining lifeNet cash flow generated each yearNew Backhoes$90,000$42,000$55,000$15,0008 years$30,425$200,000$90,0008 years$43,900Instructions(a) Evaluate in the following ways whether to purchase the new equipment or overhaulthe old equipment. (Hint: For the old machine, the initial investment is the cost of theoverhaul. For the new machine, subtract the salvage value of the old machine todetermine 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, evaluatethe 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% discountrate.(b) Are there any intangible benefits or negatives that would influence this decision?(c) What decision would you make and why?Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 12.)WCP13 Waterways prepared the balance sheet and income statement for the irrigationinstallation division for 2013. Now the company also needs to prepare a cash flow statement for the same division. The comparative balance sheets for Waterways CorporationsIrrigation Installation Division for the years 2012 and 2013 and the income statement forthe year 2013 are presented below.Additional information:1. Waterways sold a company vehicle for $24,000. The vehicle had been used for 10 years.It cost $80,000 when purchased and had a 10-year life and a $6,000 salvage value.Straight-line depreciation was used.2. Waterways purchased with cash new equipment costing $209,200.3. Prepaid expenses increased by $33,960WATERWAYS CORPORATIONINSTALLATION DIVISIONBalance SheetsDecember 31AssetsCurrent assetsCashAccounts receivableWork in processInventoryPrepaid expensesTotal current assetsProperty, plant, and equipmentLandBuildingsEquipmentFurnishingsAccumulated depreciationTotal property, plant, and equipmentTotal assets20132012$ 836,797680,750702,15916,76676,550$ 746,681542,6857,50042,5902,313,0221,339,456300,000450,000929,40040,416(482,523)300,000450,000800,20040,416(485,204)1,237,2931,105,412$3,550,315$2,444,868$ 157,095101,3444,5171,18714,51515,000$ 128,36079,9891,98415,246293,658225,579Liabilities and Stockholders EquityCurrent liabilitiesAccounts payableIncome taxes payableWages payableInterest payableOther current liabilitiesRevolving bank loan payableTotal current liabilitiesLong-term liabilitiesNote payableTotal liabilitiesStockholders equityCommon stockRetained earningsTotal stockholders equityTotal liabilities and stockholders equity140,000433,658225,5791,250,0001,866,6571,250,000969,2893,116,6572,219,289$3,550,315$2,444,8681516Waterways Continuing ProblemWATERWAYS CORPORATIONINSTALLATION DIVISIONIncome StatementFor the Year Ending December 31, 2013SalesLess: Cost of goods soldGross profitOperating expensesAdvertisingInsuranceSalaries and wagesDepreciationOther operating expenses$5,536,0773,132,7772,403,300$ 50,000400,000584,64071,31921,200Total operating expenses1,127,159Income from operationsOther incomeGain on sale of equipmentOther expensesInterest expense1,276,14118,000(12,187)Net other income and expenses5,813Income before income taxIncome tax expenseNet income1,281,954384,586$ 897,368InstructionsFor the year 2013:(a) Prepare a statement of cash flows using the indirect method.*(b) Prepare a statement of cash flows using the direct method.(c) Determine free cash flow.Waterways Continuing ProblemWaterways Continuing Problem(This is a continuation of the Waterways Problem from Chapters 1 through 13.)WCP14 The comparative balance sheets of Waterways Corporations Irrigation InstallationDivision for the years 2012 and 2013 and the income statements for the year 2012 and2013 are presented below.Additional information:85% of the sales for Waterways were credit sales. There are 5,000 shares outstanding forboth years. This is a private corporation, whose shares are not available to the public.WATERWAYS CORPORATIONINSTALLATION DIVISIONBalance SheetsDecember 31AssetsCurrent assetsCashAccounts receivableWork in processInventoryPrepaid expensesTotal current assetsProperty, plant, and equipmentLandBuildingsEquipmentFurnishingsAccumulated depreciationTotal property, plant, and equipmentTotal assets20132012$ 836,797680,750702,15916,76676,550$ 746,681542,6857,50042,5902,313,0221,339,456300,000450,000929,40040,416(482,523)300,000450,000800,20040,416(485,204)1,237,2931,105,412$3,550,315$2,444,868$ 157,095101,3444,5171,18714,51515,000$ 128,36079,9891,98415,246293,658225,579Liabilities and Stockholders EquityCurrent liabilitiesAccounts payableIncome taxes payableWages payableInterest payableOther current liabilitiesRevolving bank loan payableTotal current liabilitiesLong-term liabilitiesNote payableTotal liabilitiesStockholders equityCommon stockRetained earningsTotal stockholders equityTotal liabilities and stockholders equity140,000433,658225,5791,250,0001,866,6571,250,000969,2893,116,6572,219,289$3,550,315$2,444,8681718Waterways Continuing ProblemWATERWAYS CORPORATIONINSTALLATION DIVISIONIncome StatementsFor the Year Ending December 312013SalesLess: Cost of goods soldGross profitOperating expensesAdvertisingInsuranceSalaries and wagesDepreciationOther operating expenses2012$5,536,0773,132,777$4,957,2662,807,3162,403,3002,149,95050,000400,000584,64071,31921,20048,000400,000554,64062,31918,476Total operating expenses1,127,1591,083,435Income from operationsOther incomeGain on sale of equipmentOther expensesInterest expense1,276,1411,066,51518,000(12,187)Income before income taxIncome tax expense1,281,954384,5861,066,515319,955$ 897,368$ 746,560Net incomeInstructions(a) Prepare a horizontal analysis of the income statement using 2012 as the base year.(b) Prepare a vertical analysis of the income statement for 2013.(c) Calculate the following ratios for 2013 and indicate whether the ratio is a liquidity,solvency, or profitability ratio.(1) Asset turnover ratio.(2) Receivables turnover ratio.(3) Average collection period.(4) Current ratio.(5) Debt to total assets ratio.(6) Earnings per share.(7) Profit margin rate.(9) Return on assets ratio.(10) Return on common stockholders equity ratio.(11) Times interest earned ratio.(d) Comment on your findi

 

Paper#39526 | Written in 18-Jul-2015

Price : $29
SiteLock