******Please Use the numbers given from first 2 photos to complete the charts given on photos 3 and 4. Any explanations on the Memo questions also greatly appreciated!!********

-1A. Calculating Manufacturing Overhead Rates Glassman Company accumulated the following data for the current year. 2A. Calculating Activity-Based Costing Overhead Rates Assume that manufacturing overhead for Glassman Company in the previous exercise consisted of the following activities and costs: The following additional data were provided for Job 845: Required a. Calculate the cost per unit of activity driver for each activity cost category. b. Calculate the cost of Job 845 using ABC to assign the overhead costs. c. Calculate the cost of Job 845 using the company-wide overhead rate based on machine hours calculated in P5-1A(a). d. Calculate the cost of Job 845 using a machine hour departmental overhead rate for the Milling Department and a direct labor hour overhead rate for the Finishing Department (see P5-1A (c)). 4. Worksheet: Follow this format. Be sure to link variables to the worksheet. Formulas should be included in the links. A link begins in the destination cell with "=" and then you pick up the variable from the variables page. If necessary, build a formula and add more variables. When complete, hit enter. Here is how to set up your Worksheet (there are three tables). j0; Total set-up costs tor JoD 4, \$1,44U. Directions for Your Excel Memo 1. Direct your memo to President Window of the Glassman Company. 2. Your first sentence summarizes the subject matter of the memo. 3. Insert Production Cost Comparison Table 4. Explain why there are differences in the three calculations. What is your recommendation