13. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s pay rate. Look up the employee ID listed in cell Q2. Use a structured reference to retrieve the value in the 5th column of the Staff table. Since the formula is looking for a specific staff member’s data, find an exact match.

When consumers discard their gasoline-powered automobiles for electric-powered ones, this partially reflects the of gasoline?

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?

Afreelance​ singer-songwriter is planning the restoration of a recently purchased civil​ war-era farmhouse. while he professes an enjoyment​ of, and talent in the construction​ trades, the theory of comparative advantage implies that a. the value of what he imports​ (in this​ case, professional contractor​ services) must equal the value of what he exports​ (songs). b. he should concentrate on the restoration work since his​ out-of-pocket costs will be much lower than if he hires professionals. c. ​self-sufficiency is​ advantageous, hence he should split his time between music and construction. d. the income lost while away from music will likely exceed the savings realized by doing the work​ himself, thus, he should hire professionals to do the restoration work. e. he ought to do as much of the work himself as possible since imports​ (in this​ case, professional contractor​ services) should always be restricted to those things that cannot be done internall