13. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s pay rate. Look up the employee ID listed in cell Q2. Use a structured reference to retrieve the value in the 5th column of the Staff table. Since the formula is looking for a specific staff member’s data, find an exact match.

The direct labor budget of yuvwell corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours: 1st quarter 2nd quarter 3rd quarter 4th quarterbudgeted direct labor-hours 11,200 9,800 10,100 10,900the company uses direct labor-hours as its overhead allocation base. the variable portion of its predetermined manufacturing overhead rate is $6.00 per direct labor-hour and its total fixed manufacturing overhead is $80,000 per quarter. the only noncash item included in fixed manufacturing overhead is depreciation, which is $20,000 per quarter.required: 1. prepare the company’s manufacturing overhead budget for the upcoming fiscal year.2. compute the company’s predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year.