{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Tutorial Question","Solution","Feedback","Feedback to others"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Tutorial Question","index":0,"n_rows":19,"n_cols":2,"rows_kept":19}
["Create your tutorial question in this sheet"]
[]
[]
[]
[]
[]
[]
["Big N Production Budget"]
[]
["Incitec Pivot creates the Big N nitrogen fertiliser. The unit sales required for delivery each month is below"]
[]
["October",330000]
["November",270000]
["December",250000]
["Janaury",380000]
[]
["Incitec Pivot policy is that ending inventories for each month is 15 per cent of next month's sales. September opening balance was 45 000 units"]
[]
["Prepare a production budget for Q4. Show the number of units that should be produced and a quarter total"]

{"sheet":"Solution","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[]
[]
[null,null,"October","November","December","Q4 Total"]
["Sales Units BIG N",null,{"$f":"'Tutorial Question'!B12","v":330000},{"$f":"'Tutorial Question'!B13","v":270000},{"$f":"'Tutorial Question'!B14","v":250000},{"$f":"SUM(C4:E4)","v":850000}]
[]
["Desired ending inventory",null,{"$f":"SUM('Tutorial Question'!B13*15%)","v":40500},{"$f":"'Tutorial Question'!B14*15%","v":37500},{"$f":"'Tutorial Question'!B15*15%","v":57000},{"$f":"SUM(C6:E6)","v":135000}]
["Total needed",null,{"$f":"SUM(C4:C6)","v":370500},{"$f":"SUM(D4:D6)","v":307500},307000,985000]
["Less Beginning Inventory",null,45000,{"$f":"C6","v":40500},{"$f":"D6","v":37500},{"$f":"SUM(C8:E8)","v":123000}]
["Units to be produced",null,{"$f":"C7-C8","v":325500},{"$f":"D7-D8","v":267000},269500,{"$f":"F7-F8","v":862000}]

{"sheet":"Feedback","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[2,0,3,0],[2,1,2,2],[2,3,3,3]]}
["Include the feedback from your peers in this sheet"]
[]
["Peer reviewer's name","Feedback about the quality of your question",null,"Feedback about the correctness of your solution"]
[null,"Rating out of 5","Comments on the quality"]

{"sheet":"Feedback to others","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[2,0,3,0],[2,1,2,2],[2,3,3,3]]}
["Include the feedback that YOU gave TO your peers in this sheet"]
[]
["The name of the person that YOU gave feedback to","Feedback about the quality of their question",null,"Feedback about the correctness of your solution"]
[null,"Rating out of 5","Comments on the quality"]