What would be the excel formula to this: IF Year 1 Income Tax (cell B18): if Year 1 Operating Income is less than 0, then Year 1 Income tax equals 0; otherwise Year 1 Income Tax equals 33%* Year 1 Operating Income. Copy cell B18 to C18:I18.

According to maslow's hierarchy of needs theory, which of the following would be an issue that requires the fulfillment of a lower order need? a)the need for a challenging project at work. b)the need for a promotion at work.c) the need to locate your business in an area with a low crime rate. d)the need for a mentor to you ascend within the company. none of the above

Stocks a, b, and c are similar in some respects: each has an expected return of 10% and a standard deviation of 25%. stocks a and b have returns that are independent of one another; i.e., their correlation coefficient, r, equals zero. stocks a and c have returns that are negatively correlated with one another; i.e., r is less than 0. portfolio ab is a portfolio with half of its money invested in stock a and half in stock b. portfolio ac is a portfolio with half of its money invested in stock a and half invested in stock c. which of the following statements is correct? a. portfolio ab has a standard deviation that is greater than 25%.b. portfolio ac has an expected return that is less than 10%.c. portfolio ac has a standard deviation that is less than 25%.d. portfolio ab has a standard deviation that is equal to 25%.e. portfolio ac has an expected return that is greater than 25%.

Thomas kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. thomas's fastest-moving inventory item has a demand of 6,000 units per year. the cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. the average ordering cost is $30 per order. it takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (this is a corporate operation, and the are 250 working days per year.)a) what is the eoq? b) what is the average inventory if the eoq is used? c) what is the optimal number of orders per year? d) what is the optimal number of days in between any two orders? e) what is the annual cost of ordering and holding inventory? f) what is the total annual inventory cost, including cost of the 6,000 units?