10 18 points Problem 5-31 Plantwide versus Departmental Overhead Rates; Underapplied or Overapplied Overhead [LO3, LO5, LO7] "Don't tell me we've lost another bid!" exclaimed Janice Hudson, president of Prime Products Inc. "I'm afraid so," replied Doug Martin, the operations vice president. "One of our competitors underbid us by about $13,000 on the Hastings job." "I just can't figure it out," said Hudson. "It seems we're either too high to get the job or too low to make any money on half the jobs we bid. What's happened?" Prime Products manufactures specialized goods to customers' specifications and operates a job-order costing system. Manufacturing overhead cost is applied to jobs on the basis of direct labour cost. The following estimates were made at the beginning of the year: Direct labour Manufacturing overhead. Cutting Department Machining Assembly $ 322,500 $ 215,000 $ 430,000 $ 580,500 $ 860,000 $ 107,500 Total Plant $ 967,500 $1,548,000 Jobs require varying amounts of work in the three departments. The Hastings job, for example, would have required manufacturing costs in the three departments as follows: Direct material Direct labour Manufacturing overhead Department Cutting $24,000 Machining $ 2,400 Assembly Total Plant $ 8,600 $35,000 $14,000 $ 4,700 ? ? $22,000 ? $40,700 ? The company uses a plantwide overhead rate to apply manufacturing overhead cost to jobs. Required: 1. Assuming the use of a plantwide overhead rate: a. Compute the rate for the current year. Predetermined overhead rate % b. Determine the amount of manufacturing overhead cost that would have been applied to the Hastings job. Manufacturing overhead cost 18 2. Suppose that instead of using a plantwide overhead rate, the company had used a separate predetermined overhead rate in each department. Under these conditions: a. Compute the rate for each department for the current year. 10 Predetermined Overhead Rate points Cutting department Machining department % Assembly department % % b. Determine the amount of manufacturing overhead cost that would have been applied to the Hastings job. Manufacturing overhead cost 3. This part of the question is not part of your Connect assignment. 4. Assume that it is customary in the industry to bid jobs at 140% of total manufacturing cost (direct materials, direct labour, and applied overhead). a. What was the company's bid price on the Hastings job? Company's bid price b. What would the bid price have been if departmental overhead rates had been used to apply overhead cost? Company's bid price 18 5. At the end of the year, the company assembled the following actual cost data relating to all jobs worked on during the year: 10 points Direct material Direct labour Manufacturing overhead Cutting $827,500 $350,000 $612,500 Machining $ 97,500 $232,500 $918,900 Department Assembly $440,000 $364,000 $ 98,500 Total Plant $1,365,000 $ 946,500 $1,629,900 a. Compute the underapplied or overapplied overhead for the year, assuming that a plantwide overhead rate is used. b. Compute the underapplied or overapplied overhead for the year, assuming that departmental overhead rates are used. Cutting Machining Assembly Total plant