{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Product Mix Example 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":317,"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":"Product Mix Example 1","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,1,15,4],[15,6,15,7],[11,1,11,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Production Decisions"]
[null,null,"LCD TV","Stereo","Speakers"]
[null,"Number to Build:   ",0,0,0]
[]
[null,"Part Requirements by Product",null,null,null,null,"Part Inventory Levels"]
[null,"Part Name","LCD TV","Stereo","Speakers",null,"Used","Available"]
[null,"Chassis",1,1,0,null,{"$f":"SUMPRODUCT(C18:E18,$C$14:$E$14)","v":0},450]
[null,"LCD Screen",1,0,0,null,{"$f":"SUMPRODUCT(C19:E19,$C$14:$E$14)","v":0},250]
[null,"Speaker",2,2,1,null,{"$f":"SUMPRODUCT(C20:E20,$C$14:$E$14)","v":0},800]
[null,"Power Supply",1,1,0,null,{"$f":"SUMPRODUCT(C21:E21,$C$14:$E$14)","v":0},450]
[null,"Electronics",2,1,1,null,{"$f":"SUMPRODUCT(C22:E22,$C$14:$E$14)","v":0},600]
[]
[null,"Profit per unit",75,50,35,null,{"$f":"SUMPRODUCT(C24:E24,$C$14:$E$14)","v":0}]