This sheet has two problems: Hourly Rate and Disounts.

Remember to do both problems.

Problem #$1$: Hourly Rate

Problem #$2$: Discounts

New Salem Enterprises

Timson and Brothers

French Brothers, Inc.

Zaragosa, Inc.

Orleans and Sons

Xenix Company

Oswego Trading Company

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.

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.$