In cell K6, enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K7:K32.

The required formula to get the value of the cell K6 i.e., total cost of the rental based on the daily rate, cost of gas, amount of discount, and number of days rented can be given as follows:

K6 =E6*G6*(1-H6)-J6

Explanation:

In the above formula, the value of the cell E6 (#Days rented) is being multiplied with the cell G6 (Daily rate), amount of discount (H6) subtracted from 1 and subtract the cell value J6 (Cost of gas) from the resulted value of the expression E6*G6*(1-H6).

Copy the above formula to the range K7:K32 to fill all the values. The resulted excel sheet will be shown as follows:

answer; i believe the above is false;

the benefits of raising bc’s minimum wage to $15 through a

series of pre-announced staged increases far outweigh the likely

costs. claims that such an increase will lead to massive job losses

in low-wage sectors of the economy are not credible.

• an increase to $15 would result in some job losses. however,

the likely impact is less than a 1 per cent reduction in the overall

provincial employment rate, and a 7.6 per cent reduction in the

employment rate for those currently making between $10.25

and $15 per hour.

• the large job loss impacts predicted by some opponents of

minimum wages misrepresent the existing economic research. in

reading and using that research, it is important to recognize that

estimates showing job loss effects of minimum wage increases

apply only to teenagers. estimated effects for young adult and

adult workers range from insignificant to non-existent.

• focusing on teenage workers plays up an inaccurate stereotype

about who earns very low wages in bc and leads to exaggerated

claims about job losses. only 26 per cent of those currently making

between $10.25 and $12 are teenagers, and only 5 per cent

of those making between $12 and $15 are teenagers.