5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function.

Electronics assembly inc. is a contract manufacturer that assembles consumer electronics for a number of companies. currently, the operations manager is assessing the capacity requirements as input into a bid for a job to assemble cell phones for a major global company. the company would assemble three models of cell phones in the same assembly cell. setup time between the phones is negligible. electronics assembly inc. operates two 8-hour shifts for 275 days per year. cell phone demand forecast (phones/year) processing time (minutes/phone) mars 47,000 19.8 saturn 35,000 20.7 neptune 7,500 16.2 a. calculate total capacity required by line. b. determine the total operating time available. c. calculate the total number of assembly cells. (round up your answer to the next whole number.)

Beck company had the following accounts and balances at the end of the year. what is net income or net loss for the year? cash $ 74 comma 000 accounts payable $12,000 common stock $21,000 dividends $12,000 operating expenses $ 13 comma 000 accounts receivable $ 49 comma 000 inventory $ 47 comma 000 longminusterm notes payable $33,000 revenues $ 91 comma 000 salaries payable $ 30 comma 000

Emery pharmaceutical uses an unstable chemical compound that must be kept in an environment where both temperature and humidity can be controlled. emery uses 825 pounds per month of the chemical, estimates the holding cost to be 50% of the purchase price (because of spoilage), and estimates order costs to be $48 per order. the cost schedules of two suppliers are as follows: vendor 1 vendor 2 quantity price/lb quantity price/lb 1-499 $17 1-399 $17.10 500-999 $16.75 400-799 $16.85 1000+ $16.50 800-1199 $16.60 1200+ $16.25 (a) what is the economic order quantity for each supplier? (b) what quantity should be ordered and which supplier should be used? (c) the total cost for the most economic order sire is $