QRB week #3 T.A

profiledhoskins69
qrb501_team_assignment.xlsx

Question 1

Case 8.1 Chapter 8 Page 305 of your text
Text: Business Math, Eleventh Edition
Case 8.1 Image Manufacturing's Rebate Offer
Part 3
New order quantity pieces per month
Unit Price each
Total Cost for the order =New Order Quantity*Unit Price
Rebate (trade discount) ($)
Total rebate for the order =Rebate($)*New order quantity
Net amount before cash discount =Total cost - Total rebate for the order
Cash discount (%)
Cash discount ($) =Cash Discount (%)*Net amount before cash discount
Total concession (rebate + cash discount) $
Net Price ($) Total cost - Total concession

Question 2

Case 8.3 Chapter 8 Page 306/307 of your text
Text: Business Math, Eleventh Edition
Part 3
Supplier 1 Supplier 2
List Price
First Trade Discount %
Second Trade Discount %
Third Trade Discount %
Net Decimal Equivalent =(1 - 1st Trade Discount%)*(1 - 2nd Trade Discount%) * (1 - 3rd Trade Discount%)
Single Trade Discount =1-Net Decimal Equivalent
Trade Discount ($)