Problem #$1$ has $2$ parts. PART A: $($complete PART B: as well$)$

Typically, employees in a local company are required to work no more than $39$ hours a week. Their regular hourly rate is $$29\mathrm{.}00.$ If an employee works overtime $($more than $39$ hours a week$),$ the hourly rate is $$44\mathrm{.}00$ for each extra hour. The table shows the working hours of employees of this company.

Calculate the total wage using the IF function. Do NOT hard code values; instead use cell references to refer to fixed values such as $$29\mathrm{.}00.$ Use absolute and relative referencing appropriately.

PART B:

Go to a new $($separate$)$ sheet. Call it $$Payroll Summary$.$ In this worksheet, calculate the Total hours and Total pay using relevant data from Problem #$1$: Hourly Rate table. Do NOT copy RAW data. Problem #$2-$ A particular company offers two types of discounts based on the quantity $($q$)$ bought; regular discount and deep discount $($see the table to the left$).$

For each of its customers, calculate sales using the nested IF function. Do NOT hard code values; instead use cell references to refer to fixed values such as $$16\mathrm{.}00.$ Use absolute and relative referencing appropriately.

NOTE: Discount is applied directly, NOT progressively. For example, Avila Enterprises bought $220$ units; so$,$ sales will be $220*$ $$22.$