Complete each sentence to describe how to add range names to existing formulas. Select the cells containing formulas with cell references that should be changed to names. Click the tab. In the group, click the Define Names drop-down arrow. Click . Use the dialog box to select the names.

True or false: on january 1, year one, the epstein corporation buys a plot of land with a four-story office building. the company believes the building is worth $1.9 million and has an estimated life of twenty years (with no anticipated residual value). the straight-line method is used. the land has an assessed value of $100,000. because the seller was interested in a quick sale, epstein was able to buy this land and building for $1.7 million. depreciation expense to be recognized in year one is $80,750.

The production manager of rordan corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st quarter 2nd quarter 3rd quarter 4th quarter units to be produced 10,800 8,500 7,100 11,200 each unit requires 0.25 direct labor-hours, and direct laborers are paid $20.00 per hour. required: 1. prepare the company’s direct labor budget for the upcoming fiscal year. assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2. prepare the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. instead, assume that the company’s direct labor workforce consists of permanent employees who are guaranteed to be paid for at least 2,500 hours of work each quarter. if the number of required direct labor-hours is less than this number, the workers are paid for 2,500 hours anyway. any hours worked in excess of 2,500 hours in a quarter are paid at the rate of 1.5 times the normal hourly rate for direct labor.

Lambert manufacturing has $100,000 to invest in either project a or project b. the following data are available on these projects (ignore income taxes.): project a project b cost of equipment needed now $100,000 $60,000 working capital investment needed now - $40,000 annual cash operating inflows $40,000 $35,000 salvage value of equipment in 6 years $10,000 - both projects will have a useful life of 6 years and the total cost approach to net present value analysis. at the end of 6 years, the working capital investment will be released for use elsewhere. lambert's required rate of return is 14%. the net present value of project b is: