Which function in excel tells how many numeric entries are there​

White company has two departments, cutting and finishing. the company uses a job-order costing system and computes a predetermined overhead rate in each department. the cutting department bases its rate on machine-hours, and the finishing department bases its rate on direct labor-hours. at the beginning of the year, the company made the following estimates: department cutting finishing direct labor-hours 6,000 30,000 machine-hours 48,000 5,000 total fixed manufacturing overhead cost $ 264,000 $ 366,000 variable manufacturing overhead per machine-hour $ 2.00 " variable manufacturing overhead per direct labor-hour " $ 4.00 required: 1. compute the predetermined overhead rate for each department. 2. the job cost sheet for job 203, which was started and completed during the year, showed the following: department cutting finishing direct labor-hours 6 20 machine-hours 80 4 direct materials $ 500 $ 310 direct labor cost $ 108 $ 360 using the predetermined overhead rates that you computed in requirement (1), compute the total manufacturing cost assigned to job 203. 3. would you expect substantially different amounts of overhead cost to be assigned to some jobs if the company used a plantwide predetermined overhead rate based on direct labor-hours, rather than using departmental rates?

Mystic bottling company bottles popular beverages in the bottling department. the beverages are produced by blending concentrate with water and sugar. the concentrate is purchased from a concentrate producer. the concentrate producer sets higher prices for the more popular concentrate flavors. a simplified bottling department cost of production report separating the cost of bottling the four flavors follows:

The monthly demand equation for an electric utility company is estimated to be p equals 60 minus left parenthesis 10 superscript negative 5 baseline right parenthesis x, where p is measured in dollars and x is measured in thousands of killowatt-hours. the utility has fixed costs of $3 comma 000 comma 000 per month and variable costs of $32 per 1000 kilowatt-hours of electricity generated, so the cost function is upper c left parenthesis x right parenthesis equals 3 times 10 superscript 6 baseline plus 32 x. (a) find the value of x and the corresponding price for 1000 kilowatt-hours that maximize the utility's profit. (b) suppose that the rising fuel costs increase the utility's variable costs from $32 to $38, so its new cost function is upper c 1 left parenthesis x right parenthesis equals 3 times 10 superscript 6 baseline plus 38 x. should the utility pass all this increase of $6 per thousand kilowatt-hours on to the consumers?