Note: Please provide in excel format (horizontal)

Perry Corporation makes three products, X, Y, and Z. Expected overhead costs for the coming year include: Perry uses direct labor hours as the cost driver to allocate overhead costs. Budgeted direct labor hours for each product are: Product X, 20,000 direct labor hours Product Y, 30,000 direct labor hours Product Z, 10,000 direct labor hours Required: 1) Determine the amount of manufacturing overhead that should be allocated to each of the three products. 2) Assume that each unit of Product X requires $25 in direct materials and 3 direct labor hours at a rate of $12 per hour. Calculate the budgeted or expected cost of each unit of X.