"Bennett Co. has a potential new project that is expected to generate annual revenues of $247,700, with variable costs of $137,6
00, and fixed costs of $56,500. To finance the new project, the company will need to issue new debt that will have an annual interest expense of $16,500. The annual depreciation is $22,000 and the tax rate is 40 percent. What is the annual operating cash flow?"
The computation of the total budgeted direct labor cost is shown below:
= Number of units to be produced × number of hours per unit × labor cost per hour
= 34,400 units × 3 hours × $15
= $1,548,000
We simply multiplied the number of units to be produced with the number of hours per unit and the labor cost per hour so that the accurate amount can come
Click the Math & Trig button on the formula page, in the library category function.
Click SUMIF
In the range argument box, type category
In the criteria box, type "office expense"
In the sum range argument box, type cost
Click ok
The SUIMIF function is a workbook function which based on one criterion, adds all the numbers in a set of cells (e.g., 2000). The SUMIF function is an optimized Excel function which is labeled as a Math / Trig function.
This method can be used in Excel as a WS function.