To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training. In cell K2 enter a formula using the IF and OR functions as follows to determine if Kay Colbert can join the leadership training program:The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if the student's finance certified status is "Yes", returning the text Yes if a student meets one or both of those criteria or the text No if a student meets neither of those criteria.

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.