In cell d12, enter a formula to calculate the difference between the actual and budget. copy the formula to the range d13: d19. delete the formula in cell d15. if the actual expense is more than the budget expense, the result is positive. if the actual expense is less than the budget expenses, the result is negative, indicating under budget.

The company financial officer was interested in the average cost of pcs that had been purchased in the past six months. she took a random sample of the price of 10 computers, with the following results. $3,250, $1,127, $2,995, $3,250, $3,445, $3,449, $1,482, $6,120, $3,009, $4,000 what is the iqr?

Acompany that makes shopping carts for supermarkets and other stores recently purchased some new equipment that reduces the labor content of the jobs needed to produce the shopping carts. prior to buying the new equipment, the company used 6 workers, who produced an average of 79 carts per hour. workers receive $16 per hour, and machine coast was $49 per hour. with the new equipment, it was possible to transfer one of the workers to another department, and equipment cost increased by $11 per hour while output increased by four carts per hour. a) compute the multifactor productivity (mfp) (labor plus equipment) under the prior to buying the new equipment. the mfp (carts/$) = (round to 4 decimal places). b) compute the productivity changes between the prior to and after buying the new equipment. the productivity growth = % (round to 2 decimal places)

Laval produces lamps and home lighting fixtures. its most popular product is a brushed aluminum desk lamp. this lamp is made from components shaped in the fabricating department and assembled in the assembly department. information related to the 22,000 desk lamps produced annually follows.direct materials $280,000direct labor fabricating department (8,000 dlh × $24 per dlh) $192,000assembly department (16,600 dlh × $26 per dlh) $431,600machine hours fabricating department $15,200mhassembly department $20,850mhexpected overhead cost and related data for the two production departments follow.fabricating assemblydirect labor hours 150,000dlh 295,000dlhmachine hours 161,000mh 128,000mhoverhead cost $400,000 430,000required1. determine the plantwide overhead rate for laval using direct labor hours as a base.2. determine the total manufacturing cost per unit for the aluminum desk lamp using the plantwide overhead rate.3. compute departmental overhead rates based on machine hours in the fabricating department and direct labor hours in the assembly department.4. use departmental overhead rates from requirement 3 to determine the total manufacturing cost per unit for the aluminum desk lamps.