BMGT $301$ Excel Project $2$Winter $2024$

Due by $11$:$59$ PM$,$ January $15$th$,2024$

$(10$ Points$)$

THIS IS AN INDIVIDUAL ASSIGNMENT

To improve quality and reduce the number of defective ErgoBeds produced, Karake, Inc. management has hired $5$ new quality control personnel. Remember from the previous narrative $($Project $1)$ that the company has recently been experiencing increased demand for its ErgoBeds Line and was forced to increase the number of shifts in its factories which led to a problem in quality and increase in the number of defectives and returns.

Due to increased demand, the company opened new production facilities and hired new production managers as well as more employees for customer support. Given the negative goodwill caused by the problem with production quality, Karake Inc. has decided to offer customers quantity discount on the ErgoBeds Line. Discounts are based on the quantity ordered as per the $$Discount$\_$Table$$ in range R$1$:S$7$ on the Transaction Sheet of the Excel data associated with this project $($Project$2\_$Data$\_2024).$

What the $$Discount$\_$Table$$ indicates is that if the order is less than $33$ beds $($X$<33),$ then the customer will not get a quantity discount; if the order is equal to or more than $33$ but less than $83(33<=$X$<83),$ then the customer will get a $2\mathrm{.}5\%$ discount, etc.