Question: Given Data: Price per an hour Variable cost per hour Fixed costs per month Depreciation expenses per year Months in a vea S500.00 S200.00 S1,000.00

Given Data: Price per an hour Variable cost per hour Fixed costs per month Depreciation expenses per year Months in a vea S500.00 S200.00 S1,000.00 $50,000.00 12 a. Calculate the accounting break-even number of annual rental hours needed to produce zero operating earnings from the crane (before taxes) Fixed costs other than depreciation per year Accounting break-even point b. Calculate the cash break-even point. If we ignore noncash expenses such as depreciation in the break-even calculation, for how many hours must the crane be rented in order to break even on a cash basis? Cash break-even point Requirements 1 Start Excel 2 In cell D14, by using cell references, calculate the fixed costs other than depreciation per year. (1 pt.) 3 In cell D15, by using cell references, calculate the accounting break-even number of annual rental hours. (1 pt.) 4 In cell D19, by using cell references, calculate the cash break-even point of annual rental hours. (1 pt.) 5 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
