{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Dallan Delgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID","002-46-2565"," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-22T20:13:46.400"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-21T23:08:53.180","Dallan Delgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (32-bit) NT :.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Dallan Delgado","002-46-2565","2021-04-21T23:08:52.900","Dallan Delgado"]
["Starter Sheet","None",0,"2020-01-01"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.48 build 411 running on Macintosh (Intel) Version 11.0.1 (Build 20B29)!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals ",null,null,null,"income ","expenses","profit","percentage"]
[null,"Time period",null,null,"Fixed Costs",null,null,null,"Donut",3.5,0.5,{"$f":"J6-K6","v":3},{"$f":"L6/J6","v":0.8571428571428571}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs"]
["Revenue: Donut"," ",3.5,null,"Coffee"]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut"]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":27,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","centered moving average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",2475,null,null,null,null,null,1,null,"SUMMARY OUTPUT"]
["2018-02-01",2665.5,null,null,null,null,null,2]
["2018-03-01",3597.5,null,null,null,null,null,3,null,"Regression Statistics"]
["2018-04-01",3104,null,null,null,null,null,4,null,"Multiple R",0.9999977883667549]
["2018-05-01",2410,null,null,null,null,null,5,null,"R Square",0.99999557673840112]
["2018-06-01",3592,null,null,null,null,null,6,null,"Adjusted R Square",0.99999544664247164]
["2018-07-01",2740,null,{"$f":"AVERAGE(AVERAGE(B2:B13),AVERAGE(B3:B14))","v":3044.333333333333},{"$f":"B8/D8","v":0.9000328479141575},{"$f":"AVERAGEIF(A$8:A$31,A8,E$8:E$31)","v":0.9000328479141575},{"$f":"B8/F8","v":3044.333333333333},7,null,"Standard Error",0.68457659593646991]
["2018-08-01",2683.5,null,{"$f":"AVERAGE(AVERAGE(B3:B14),AVERAGE(B4:B15))","v":3042.895833333333},{"$f":"B9/D9","v":0.88189019505816146},{"$f":"AVERAGEIF(A$8:A$31,A9,E$8:E$31)","v":0.88189019505816146},{"$f":"B9/F9","v":3042.895833333333},8,null,"Observations",36]
["2018-09-01",2697.5,null,3022.854166666667,0.8923685534504503,0.8923685534504503,3022.854166666667,9]
["2018-10-01",3090,null,2991.75,1.0328403108548507,1.0328403108548507,2991.7500000000005,10,null,"ANOVA"]
["2018-11-01",3342.5,"Put yearly average in below cell ",3037.3541666666665,1.1004643569993073,1.1004643569993073,3037.3541666666665,11,null,null,"df","SS","MS","F","Significance F"]
["2018-12-01",4304.5,{"$f":"AVERAGE(B2:B13)","v":3058.5},3082.020833333333,1.3966485733792089,1.3966485733792089,3082.020833333333,12,null,"Regression",1,3602288.2882882878,3602288.2882882878,7686601.5831130361,1.2901293445688044E-92]
["2019-01-01",2135,null,3084,0.69228274967574577,0.69228274967574577,3084,13,null,"Residual",34,15.933933933934803,0.46864511570396478]
["2019-02-01",2971,null,3101.645833333333,0.95787854566460018,0.95787854566460018,3101.645833333333,14,null,"Total",35,3602304.2222222215]
["2019-03-01",2811,null,3133.3125,0.89713362455867396,0.89713362455867396,3133.3125,15]
["2019-04-01",3144,null,3175.8333333333335,0.98997638415114142,0.98997638415114142,3175.8333333333335,16,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2019-05-01",3464.5,null,3241.041666666667,1.0689464549720382,1.0689464549720382,3241.041666666667,17,null,"Intercept",43069.444444444445,0.23303073387597797,184823.02195969812,1.2544201694138548E-154,43068.970869015022,43069.918019873869,43068.970869015022,43069.918019873869]
["2019-06-01",3609.5,null,3307.375,1.0913488793983144,1.0913488793983144,3307.375,18,null,"X Variable 1",30.45045045045044,1.0983140416637401E-2,2772.4721068232643,1.2901293445688044E-92,30.428130023643664,30.472770877257215,30.428130023643664,30.472770877257215]
["2019-07-01",2770,null,3354.458333333333,0.82576670351646453,0.82576670351646453,3354.458333333333,19]
["2019-08-01",3077,null,3375.75,0.9115011478930608,0.9115011478930608,3375.75,20]
["2019-09-01",3064,null,3383.375,0.90560461078065546,0.90560461078065546,3383.375,21]
["2019-10-01",3744,null,3405.375,1.0994383878427485,1.0994383878427485,3405.3750000000005,22]
["2019-11-01",4253.5,"Put yearly average in below cell ",3443.416666666667,1.2352556811306599,1.2352556811306599,3443.416666666667,23]
["2019-12-01",4985.5,{"$f":"AVERAGE(B14:B25)","v":3335.75},3476.125,1.4342119457729512,1.4342119457729512,3476.125,24]
["2020-01-01",2584,null,3498.375,0.73862864901561442,0.73862864901561442,3498.375,25]
["2020-02-01",3033,null,3523.729166666667,0.86073584448293994,0.86073584448293994,3523.729166666667,26]
["2020-03-01",2932,null,3536.1458333333335,0.82915132412289738,0.82915132412289738,3536.1458333333335,27]
["2020-04-01",3551,null,3549.625,1.0003873648624855,1.0003873648624855,3549.625,28]
["2020-05-01",3970.5,null,3585.8125,1.1072804280759243,1.1072804280759243,3585.8124999999995,29]
["2020-06-01",3888.5,null,3596.5625,1.0811712572769137,1.0811712572769137,3596.5625,30]
["2020-07-01",3025,null,null,null,null,null,31]
["2020-08-01",3430.5,null,null,null,null,null,32]
["2020-09-01",3008.5,null,null,null,null,null,33]
["2020-10-01",4123,null,null,null,null,null,34]
["2020-11-01",4743,"Put yearly average in below cell ",null,null,null,null,35,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",4754,{"$f":"AVERAGE(B26:B37)","v":3586.9166666666665},null,null,null,null,36,"Seasonalized forecast"]
[null,null,null,null,null,null,null,null,null,null,"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[]
[null,"Intercept"]
[null,"slope",{"$f":"SLOPE(demand,periods)","v":33.74684684684685}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2"]
["AVERAGE DEMAND"]
["Month "]
["Demand",null,null,null,null,null,null,null,null,null,null,null," "]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand"]
["satisfied demand"]
["Extra donuts(over) "]
["Unsatisfied customers (short)"]
["Revenue"]
["coffee "]
["donut"]
["Revenue from day old sales "]
["Total Revenue"]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Total Variable Expenses"]
["Expenses: due to lost sales"]
["Total  Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee"]

{"sheet":"Expected Values Pt3","index":6,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[]
[]
[null,null,null,null,null,null,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}