adame_Titman_Problem_13-11_Start Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View 4+ Share X Cut Times New... 14 5. AutoSum" A- A A Wrap Text General 1.17 Fill- Copy Format 3 Pasta B B I U. Merge & Center - $ - %) Delete Insert Format CU Conditional Format Cell Formatting as Table Styles Clear Sort & Filter Find Select A1 H . M a a A S S T U V W X a Niece Equipment Rentals ar Del Valle, Texas, the recently heen prached about the propect of purchasing large construction crane. Omer Al Niece estimates that the crone will rent for $5011 an hour, but operator, fuel, ingrance, und miscellaneous expenses run S210 an hour when the crone is in use. The company owner estimates that it will cost $1,000 2 month to store and maintain the crane, and the annual depreciation expense is $50,100. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy paste a formule across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Eveel function is to be used, the directions will specify the use of that function. Do not type in numerkal data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the green cells highlighted below. In all cases, unless other te directed, use the earliest appearance of the data in your formulas, usually the Gtven Det section. 5 7 Given Data: Price per an hour Variable com per hour Fixed costs per month Depreciation expenses per year Months in a yeur S500.000 szio.0001 $1,000.00 550,000.00 12 10 13 2. Calculate the accounting break-en number of annual rental hours needed to produce nera operating earnings from the crane (before taxes 12 13 14 15 15 Fixed costs other thin depreciativa per your Accounting break-even point 13 b. Calculate the cash break-pven point. If weignuru nuncash expenses such as depreciation in the break-swea calculation, for huw many bours must the crane berated in order to break even on a cash basis? 19 Cash rank.com 21 22 21 34 Requirements 1 Star Excel 2 In cell D14, by using all references, calculate the lixed casts that the depreciation pa year. (1 pan.) 3 In cell D15, by using cell references, calculate the counting forcak-creat number of annual rental hours (1 pr.) 4 In cell 019, by using cell references, calculate the cash reak-cu paint af annual rental hours (1 p.) S Save the workhook. Close the workbook and then exit Excel. Submit the workloak as directed 36 21 13-11 + Ready 90% adame_Titman_Problem_13-11_Start Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View 4+ Share X Cut Times New... 14 5. AutoSum" A- A A Wrap Text General 1.17 Fill- Copy Format 3 Pasta B B I U. Merge & Center - $ - %) Delete Insert Format CU Conditional Format Cell Formatting as Table Styles Clear Sort & Filter Find Select A1 H . M a a A S S T U V W X a Niece Equipment Rentals ar Del Valle, Texas, the recently heen prached about the propect of purchasing large construction crane. Omer Al Niece estimates that the crone will rent for $5011 an hour, but operator, fuel, ingrance, und miscellaneous expenses run S210 an hour when the crone is in use. The company owner estimates that it will cost $1,000 2 month to store and maintain the crane, and the annual depreciation expense is $50,100. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy paste a formule across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Eveel function is to be used, the directions will specify the use of that function. Do not type in numerkal data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the green cells highlighted below. In all cases, unless other te directed, use the earliest appearance of the data in your formulas, usually the Gtven Det section. 5 7 Given Data: Price per an hour Variable com per hour Fixed costs per month Depreciation expenses per year Months in a yeur S500.000 szio.0001 $1,000.00 550,000.00 12 10 13 2. Calculate the accounting break-en number of annual rental hours needed to produce nera operating earnings from the crane (before taxes 12 13 14 15 15 Fixed costs other thin depreciativa per your Accounting break-even point 13 b. Calculate the cash break-pven point. If weignuru nuncash expenses such as depreciation in the break-swea calculation, for huw many bours must the crane berated in order to break even on a cash basis? 19 Cash rank.com 21 22 21 34 Requirements 1 Star Excel 2 In cell D14, by using all references, calculate the lixed casts that the depreciation pa year. (1 pan.) 3 In cell D15, by using cell references, calculate the counting forcak-creat number of annual rental hours (1 pr.) 4 In cell 019, by using cell references, calculate the cash reak-cu paint af annual rental hours (1 p.) S Save the workhook. Close the workbook and then exit Excel. Submit the workloak as directed 36 21 13-11 + Ready 90%