{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RS","Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RS","index":0,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[18,8,25,18],[2,0,4,7],[5,0,8,7],[9,0,12,7],[13,0,13,1],[14,0,14,1],[15,0,15,1]]}
[]
[]
["Demand is  random with an average of 200 and uniformly distributed between 100 and 300."]
[]
[]
["If the Realized Demand  is more than your Order Quantity, then you have to incur the costs of unsold items ($1 per unsold item)."]
[]
[]
[]
["If the Realized Demand is less than your Order Quantity then you lose the opportunity to make a sale ($4 per item short)."]
[]
[]
[]
[" Selling Price (p) =",null,20]
["Buying Price (w) =",null,{"$f":"1/4*4","v":1}]
[" Shared Revenue (r) =",null,{"$f":"(1-1/4)*C14","v":15}]
["Sl.No","Order Quantity (Q)","Realized Demand (D)","You Ordered","Profit($)","Total Profit($)","Cost of Unsold Items($)","Lost Profit($)"]
[1,null,{"$f":"IF(B18=0,0,Sheet1!B3)","v":0},{"$f":"IF(B18=0,\"---\",IF(B18>C18,\"More\",IF(B18<C18,\"Less\", \"Equal\")))","v":"---"},{"$f":"IF(B18=0,\"ENTER Q\",IF(C18>=B18,($C$14-$C$15-$C$16)*B18,IF(C18<B18,$C$14*C18-$C$15*B18-$C$16*C18)))","v":"ENTER Q"},{"$f":"IF(B18=0,0,E18)","v":0},{"$f":"IF(B18>C18,(B18-C18)*$C$15,0)","v":0},{"$f":"IF(C18>B18,(C18-B18)*($C$14-$C$16-$C$15),0)","v":0}]
[2,null,{"$f":"IF(B19=0,0,[1]Sheet1!B4)","v":0},{"$f":"IF(B19=0,\"---\",IF(B19>C19,\"More\",IF(B19<C19,\"Less\", \"Equal\")))","v":"---"},{"$f":"IF(B19=0,\"ENTER Q\",IF(C19>=B19,($C$14-$C$15-$C$16)*B19,IF(C19<B19,$C$14*C19-$C$15*B19-$C$16*C19)))","v":"ENTER Q"},{"$f":"IF(B19=0,0,F18+E19)","v":0},0,0,"REVENUE SHARING CONTRACT"]
[3,null,{"$f":"IF(B20=0,0,[1]Sheet1!B5)","v":0},{"$f":"IF(B20=0,\"---\",IF(B20>C20,\"More\",IF(B20<C20,\"Less\", \"Equal\")))","v":"---"},"ENTER Q",0,0,0]
[4,null,{"$f":"IF(B21=0,0,[1]Sheet1!B6)","v":0},"---","ENTER Q",0,0,0]
[5,null,{"$f":"IF(B22=0,0,[1]Sheet1!B7)","v":0},"---","ENTER Q",0,0,0]
[6,null,{"$f":"IF(B23=0,0,[1]Sheet1!B8)","v":0},"---","ENTER Q",0,0,0]
[7,null,{"$f":"IF(B24=0,0,[1]Sheet1!B9)","v":0},"---","ENTER Q",0,0,0]
[8,null,{"$f":"IF(B25=0,0,[1]Sheet1!B10)","v":0},"---","ENTER Q",0,0,0]
[9,null,{"$f":"IF(B26=0,0,[1]Sheet1!B11)","v":0},"---","ENTER Q",0,0,0]
[10,null,{"$f":"IF(B27=0,0,[1]Sheet1!B12)","v":0},"---","ENTER Q",0,0,0]
[11,null,{"$f":"IF(B28=0,0,[1]Sheet1!B13)","v":0},"---","ENTER Q",0,0,0]
[12,null,{"$f":"IF(B29=0,0,[1]Sheet1!B14)","v":0},"---","ENTER Q",0,0,0]
[13,null,{"$f":"IF(B30=0,0,[1]Sheet1!B15)","v":0},"---","ENTER Q",0,0,0]
[14,null,{"$f":"IF(B31=0,0,[1]Sheet1!B16)","v":0},"---","ENTER Q",0,0,0]
[15,null,{"$f":"IF(B32=0,0,[1]Sheet1!B17)","v":0},"---","ENTER Q",0,0,0]
[16,null,{"$f":"IF(B33=0,0,[1]Sheet1!B18)","v":0},"---","ENTER Q",0,0,0]
[17,null,{"$f":"IF(B34=0,0,[1]Sheet1!B19)","v":0},"---","ENTER Q",0,0,0]
[18,null,{"$f":"IF(B35=0,0,[1]Sheet1!B20)","v":0},"---","ENTER Q",0,0,0]
[19,null,{"$f":"IF(B36=0,0,[1]Sheet1!B21)","v":0},"---","ENTER Q",0,0,0]
[20,null,{"$f":"IF(B37=0,0,[1]Sheet1!B22)","v":0},"---","ENTER Q",0,0,0]
[21,null,{"$f":"IF(B38=0,0,[1]Sheet1!B23)","v":0},"---","ENTER Q",0,0,0]
[22,null,{"$f":"IF(B39=0,0,[1]Sheet1!B24)","v":0},"---","ENTER Q",0,0,0]
[23,null,{"$f":"IF(B40=0,0,[1]Sheet1!B25)","v":0},"---","ENTER Q",0,0,0]
[24,null,{"$f":"IF(B41=0,0,[1]Sheet1!B26)","v":0},"---","ENTER Q",0,0,0]
[25,null,{"$f":"IF(B42=0,0,[1]Sheet1!B27)","v":0},"---","ENTER Q",0,0,0]
[26,null,{"$f":"IF(B43=0,0,[1]Sheet1!B28)","v":0},"---","ENTER Q",0,0,0]
[27,null,{"$f":"IF(B44=0,0,[1]Sheet1!B29)","v":0},"---","ENTER Q",0,0,0]
[28,null,{"$f":"IF(B45=0,0,[1]Sheet1!B30)","v":0},"---","ENTER Q",0,0,0]
[29,null,{"$f":"IF(B46=0,0,[1]Sheet1!B31)","v":0},"---","ENTER Q",0,0,0]
[30,null,{"$f":"IF(B47=0,0,[1]Sheet1!B32)","v":0},"---","ENTER Q",0,0,0]
[31,null,{"$f":"IF(B48=0,0,[1]Sheet1!B33)","v":0},"---","ENTER Q",0,0,0]
[32,null,{"$f":"IF(B49=0,0,[1]Sheet1!B34)","v":0},"---","ENTER Q",0,0,0]
[33,null,{"$f":"IF(B50=0,0,[1]Sheet1!B35)","v":0},"---","ENTER Q",0,0,0]
[34,null,{"$f":"IF(B51=0,0,[1]Sheet1!B36)","v":0},"---","ENTER Q",0,0,0]
[35,null,{"$f":"IF(B52=0,0,[1]Sheet1!B37)","v":0},"---","ENTER Q",0,0,0]
[36,null,{"$f":"IF(B53=0,0,[1]Sheet1!B38)","v":0},"---","ENTER Q",0,0,0]
[37,null,{"$f":"IF(B54=0,0,[1]Sheet1!B39)","v":0},"---","ENTER Q",0,0,0]
[38,null,{"$f":"IF(B55=0,0,[1]Sheet1!B40)","v":0},"---","ENTER Q",0,0,0]
[39,null,{"$f":"IF(B56=0,0,[1]Sheet1!B41)","v":0},"---","ENTER Q",0,0,0]
[40,null,{"$f":"IF(B57=0,0,[1]Sheet1!B42)","v":0},"---","ENTER Q",0,0,0]
[41,null,{"$f":"IF(B58=0,0,[1]Sheet1!B43)","v":0},"---","ENTER Q",0,0,0]
[42,null,{"$f":"IF(B59=0,0,[1]Sheet1!B44)","v":0},"---","ENTER Q",0,0,0]
[43,null,{"$f":"IF(B60=0,0,[1]Sheet1!B45)","v":0},"---","ENTER Q",0,0,0]
[44,null,{"$f":"IF(B61=0,0,[1]Sheet1!B46)","v":0},"---","ENTER Q",0,0,0]
[45,null,{"$f":"IF(B62=0,0,[1]Sheet1!B47)","v":0},"---","ENTER Q",0,0,0]
[46,null,{"$f":"IF(B63=0,0,[1]Sheet1!B48)","v":0},"---","ENTER Q",0,0,0]
[47,null,{"$f":"IF(B64=0,0,[1]Sheet1!B49)","v":0},"---","ENTER Q",0,0,0]
[48,null,{"$f":"IF(B65=0,0,[1]Sheet1!B50)","v":0},"---","ENTER Q",0,0,0]
[49,null,{"$f":"IF(B66=0,0,[1]Sheet1!B51)","v":0},"---","ENTER Q",0,0,0]
[50,null,{"$f":"IF(B67=0,0,[1]Sheet1!B52)","v":0},"---","ENTER Q",0,0,0]

{"sheet":"Sheet1","index":1,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,153]
[null,290]
[null,175]
[null,295]
[null,151]
[null,217]
[null,192]
[null,210]
[null,266]
[null,113]
[null,286]
[null,206]
[null,191]
[null,297]
[null,203]
[null,120]
[null,184]
[null,125]
[null,223]
[null,165]
[null,237]
[null,111]
[null,290]
[null,190]
[null,236]
[null,243]
[null,294]
[null,226]
[null,124]
[null,265]
[null,135]
[null,165]
[null,238]
[null,230]
[null,149]
[null,240]
[null,226]
[null,297]
[null,257]
[null,141]
[null,162]
[null,261]
[null,235]
[null,113]
[null,275]
[null,130]
[null,272]
[null,131]
[null,163]
[null,226]