{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Special-Order Pricing"],"not_rendered":{"charts":0,"images":0,"macros":0,"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","formulas":"cached_only"}

{"sheet":"Special-Order Pricing","index":0,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Special-Order Pricing"]
["[Date]"]
[]
["Gray cells are calculated for you. You do not need to enter anything in them.","[Company Name] CONFIDENTIAL"]
["Product name","Widget"]
["Customer name","Northwind Traders"]
["Salesperson name","Robert O'Hara"]
["Order number",1500]
["Time frame of order (< 1 year considered special order)","6 months"]
[]
[]
["Order information and financial analysis"]
[]
["Incremental revenue"]
["Customer bid price per unit",25]
["Volume (units) requested",100000]
[]
["Incremental costs"]
["Direct material cost per unit",10]
["Direct labor cost per unit",15]
["Variable overhead cost per unit",1.5]
[]
["Total incremental revenue",2500000]
["Less total incremental costs",2650000]
["Net benefit (cost) of order",-150000]
[]
[]
["Strategic considerations"]
["If we accept this bid, could our regular customers start to demand a lower price?","Yes"]
["If line 30 is Yes, what is the probability of regular customers demanding a lower price?",0.1]
["If line 30 is Yes, can we quantify the impact?","Yes"]
["If line 32 is Yes, what is the potential long-term impact on revenue (not probability weighted)?",250000]
["Expected long-term impact (probability weighted)",25000]
[]
["Subjective considerations"]
["If we accept this bid, will there be dilution of brand equity?","Yes",1]
["[Add other subjective consideration.]","No"]
["[Add other subjective consideration.]","No"]
[]
["Recommendation (based on quantifiable inputs)"]
["Net impact on operating margin",-175000]
["Initial recommendation","Reject or Renegotiate"]
["If line 43 is Reject or Renegotiate, what price would be acceptable?",26.75]
["Is additional management discussion warranted regarding subjective considerations?","Yes"]