errors)! You may verify your accuracy by utilizing a filter when complete. Any filters should then be removed. 4. (5 Pts.) Calculate the Value of Inventory. It is the number of inventory items you have times the cost for each item. 5. (5 Pts.) Calculate the Sales Prices, which are marked up 30% more than the costs. 6. (15 Pts.) Calculate the Bonus Amounts. If the Sales Price is less than $749.99, the company will give the salesperson a bonus amount that is equal to 3% of the Sales Price. If the Sales Price is between $750.00 and $999.99, the bonus is 6%; for Sales Prices between $1000.00 and $1999.99, the bonus is 9%; and for Sales Prices over $2000.00, the bonus is 15%. (Hint: Please use LOOKUP function or IF function.) errors)! You may verify your accuracy by utilizing a filter when complete. Any filters should then be removed. 4. (5 Pts.) Calculate the Value of Inventory. It is the number of inventory items you have times the cost for each item. 5. (5 Pts.) Calculate the Sales Prices, which are marked up 30% more than the costs. 6. (15 Pts.) Calculate the Bonus Amounts. If the Sales Price is less than $749.99, the company will give the salesperson a bonus amount that is equal to 3% of the Sales Price. If the Sales Price is between $750.00 and $999.99, the bonus is 6%; for Sales Prices between $1000.00 and $1999.99, the bonus is 9%; and for Sales Prices over $2000.00, the bonus is 15%. (Hint: Please use LOOKUP function or IF function.)