Hello Can anyone help me solve with the Job-Order Costing Case Assignment

Case 2 Assignment: Job-Order Costing \"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 $12,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: Department Cutting Direct labour $318,000 Manufacturing overhead $572,400 Machining Assembly Total Plant 424,00 $212,000 $ $ 954,000 0 106,00 $848,000 $ $1,526,400 0 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: Department Direct material Direct labour Manufacturing overhead Cutting $21,600 $12,500 ? Machining $2,100 $4,100 ? Assembly Total Plant $ 8,000 $31,700 $20,200 $36,800 ? ? 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 POHR for the current year. b. Determine the amount of manufacturing overhead cost that would have been applied to the Hastings job. 2. Suppose that instead of using a plantwide overhead rate, the company had used a separate predetermined overhead rate in each department, then: a. Compute the rate for each department for the current year. Determine the amount of manufacturing overhead cost that would have been applied to b. the Hastings job with the departmental overhead rates. 3. 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 with plantwide overhead rate? b. What would the bid price have been if departmental overhead rates had been used to apply overhead cost? 4. At the end of the year, the company assembled the following actual cost data relating to all jobs worked on during the year: Department Cutting Direct material $814,000 Direct labour $344,000 Manufacturing overhead $602,000 Machining Assembly Total Plant 434,00 1,344,00 $ 96,000 $ $ 0 0 359,20 $228,000 $ $ 931,200 0 1,600,30 $901,100 $ 97,200 $ 0 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. (Enter all overapplied values as negative numbers.) Please note the following requirements for your case submission: The case must be submitted by a spreadsheet or Word file. Besides figures provided by the case, all calculated figures should contain formula in the cell or supported by notes/explanations. Any calculated figures that do not supported by cell formula or side notes will not receive marks. Students can discuss the case with each other. However, each student must submit your own file. The file cannot be the same with another student. If any two or more students have identical files, all students involved will receive zero mark with no exceptions