This past week, your friend Joe who lives in your neighborhood asks you for a favor. He heard that you recently completed a graduate level course in Managerial Economics, and he figured that you would be the perfect person to help his daughter Nicole, who is in Girl Scouts, better manage her cookie sales. Each girl scout is trying to sell as many boxes of cookies as possible, but she has no control over prices. The cookies are identical across US markets and it's relatively very easy for new members to get started. Last year, the market price for the cookies was $3 per box; however, with all the supply chain limitations and logistical bottlenecks taking place at shipping ports across the US and internationally, the price of the cookies has skyrocketed to $10 per box. For each girl scout, the main costs associated with selling the cookies are the logistical and set-up costs including transportation to the different sales sites every weekend. Although there is some inflation with the prices, Joe suspects that rising costs may cause Nicole's bottom line to take a hit. You have the following production and cost data for Nicole's Girl Scout cookie stand. Quantity of Total Cost Total Marginal Marginal Average Profit / Cookies (Q) (TC) Revenue Cost (MC) Revenue Total Cost Loss (TR) (MR) (ATC) 0 20 32 37 47 4 61 75 92 113 8 136 a) Calculate the respective measures missing in the spreadsheet based on the data provided in the case and your knowledge of these concepts. ALL WORKING MUST BE SHOWN TO OBTAIN FULL CREDIT. (6pts) b) Use the data in your now completed spreadsheet to create a scatter plot with the following curves: Demand (i.e. price), MR, MC and ATC. Use the graphing sheet provided. Label each curve or line clearly on your graph. (6pts) c) Using the relevant rule in Economics, determine the profit-maximizing or loss- minimizing level of output for Nicole. (8pts) . Highlight the area representing Nicole's profit (or loss) on your graph. . Does this area align with the profit / loss data in your spreadsheet? What is the amount of the profit or loss