{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Assignment (V2)","Financial Information - data ","Prod not = demand","5.ID","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":"Assignment (V2)","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[" Demand not equal supply and Simulation",null,"Name ______________________________"]
[]
["1.       Randbetween Function? What does it do and what are the variables it uses? Enter response in A4"]
[]
[]
["     Start with the template of Prod not = demand.  "]
["    Assume Demand is Randomly distributed between 1000 and 6000. "]
["   Now assume Production doesn’t equal Demand.  Set production to 3500 units (coffee and Donuts) each month."]
[]
["2.       Which line now must change to be based off the production number? Enter response in A11"]
[]
[]
["3.        What function can you use in Excel to calculate satisfied demand? ? Enter  just function name in cell A14"]
[]
["4.       Which line must be changed to be based off the Satisfied demand number? Enter the Heading for the row in below yellow box"]
[]
["5.       What formula will you use to calculate Unsatisfied customers/Lost sales expense? Enter  in below yellow box"]
[]
["6.        What formula will you use to calculate Revenue from Leftover donuts? Enter in below yellow box"]
[]
[" Unsatisfied customers/Lost sales(coffee and Donuts)  are set at $1.50.  Leftover donuts can be sold at a day old donut store for $1.00, the coffee is thrown out.  Add lines for both of these on your spread sheet. "]
["   7.  What sections will you add Left Overs to?  Enter in below yellow box."]
[]
["   8.  What section will you add unhappy customer to?  Enter in below yellow box  "]
[]
[]
["9.   Using the Financial Information sheet for Muffin, create a copy of donut sheet (production not = Demand) fill in  the Spread sheet  for muffin (Using a Production level of 4000 )"]
[]
[]
["10.   What is the average yearly average profit for Donuts to Go and Mufffins to go?  Enter amount in line C31, round to 2 decimal points"]
[]
["LOAD YOUR completed excel files to  icollege folder,  (to get to: Assessment,  Assignments).  Name your file as:  Your last name crossover and Your last name "]

{"sheet":"Financial Information - data ","index":1,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["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,"Andrice"]
["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,"Spring 2020"]
["Assume that each customer will buy one donut and one cup of coffee"]
["Sales estimate range from 200-5000 per week "]
[]
[]
[null,"Time period"]
["Revenue: Cup of Coffee",null,4]
["Revenue: Donut"," ",3.5]
["Donut ingredients per donunt)","per donut",0.6,null,{"$f":"C12+C14+C15+C18+C19+C20+C21+C22+C23+C24+C26+C27","v":5550}]
["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]
["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," "]
["Muffins to Go "]
["Assume that each customer will buy one muffin and one cup of coffee"]
["Sales estimate range from 200-5000 per week "]
[" "]
[]
["Muffin Financial Information "]
[null,"Time period"]
["Revenue: Cup of Coffee",null,4]
["Revenue: Muffin"," ",5.5]
["Muffin ingredients (per muffin)","per donut",1.2]
["paper products: napkins, plates etc"]
["Insurance","month",500]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",250]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000]
["Muffin and Coffee equipment rent ","month",2500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",2000]
["Previous research expense for Muffin advancements",null,2000]
["Supplies: Office","month",25]
["Utilities","month",500]
[" ",null," "]

{"sheet":"Prod not = demand","index":2,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["DTG","lines added or changed ",null,"Demand greater than","Demand less than ",null,"Production","Left over revenue","unhappy customers"]
[]
["Demand"]
["Production"]
["Month ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Quantity Sold/Satisfied Demand"]
["Left Over Sales"]
["Lost Sales/Shortage"]
["Revenue"]
["coffee "]
["donut"]
["left over rev"]
["Total Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Fixed Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Fixed Expense"]
[]
["Variable Expenses"]
["Coffee Variable expense"]
["Donut Variable expense"]
["Unhappy Cust Exp"]
["Total Variable Expenses"]
["Total  Expenses"]
["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,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,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,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"5.ID","index":3,"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","Andrice",9999999,"2020-08-29T13:18:26.310","Microsoft Office User"]
["Starter Sheet","None",0,"2020-01-01"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.16 build 810 running on Macintosh (Intel) Version 10.13.6 (Build 17G14019)!"]

{"sheet":"Sheet9","index":4,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[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,"Andrice"]
[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 2020"]