Problem 13-11
	Niece Equipment Rentals of Del Valle, Texas, has recently been approached about the prospect of purchasing a large construction crane. The crane rents for $500 an hour but operator, fuel, insurance, and miscellaneous expenses run $200 an hour when the crane is in use. The company owner estimates that it will cost $1,000 a month to store and maintain the crane and the annual depreciation expense is $50,000.
		Given Data:
		Price per an hour	$500.00
		Variable cost per hour	$200.00
		Fixed costs	$1,000.00
		Depreciation expenses per year	$50,000.00
		Months in a year	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 non-cash 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. Use cells D6, D7, D9, and D14. (1 pt.)
	4	In cell D19, by using cell references, calculate the cash break-even point of annual rental hours. Use cells D6, D7, and D14. (1 pt.)
	5	Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
PLEASE IF YOU COULD SHOW EXCEL FORMULAS.!