Case - Coffee Beans Pricing

Contribution:
u11321-Paarki Malhotra, paarkhimerotra11@gmail.com
u113099-Prachi Agarwal, prachi.agarwal09@gmail.com

Coffee beans can be purchased according to this price schedule:

For the first 500 Quintal, Rs.5000 per quintal

For the next 1000 quintal, Rs 4000 per quintal

For anything beyond 1000, Rs 3000 per quintal

Create a spreadsheet model that will calculate the total price of buying x quintals of coffee, where x is a number to be entered into a cell on the spreadsheet. (x = 800, x= 1200, x = 300).

STEP 1

Create a table array indicating the rates of coffee beans at different levels of quantity purchased, or simply, the rate list.

STEP 2

Create the output table, where quantity purchased is a variable input and the output is the total cost of the purchase, subject to the rate list created above.

STEP 3

Use ‘IF’ function, as shown below, to model the total cost of coffee.