Aspal cach produce (round to three decimal places utils and the weighted average contribution margin /44/up fround to four decimal places Nobody expedie Erind 20-%20Bonus%20Assignment.pdt BlueStacks App Pla Artfield Institute > Watch Deadpool .... the first 12 months of operations, utility expenses as follows: Month Utility Expense January 5472 February 3510 March 5524 April 3460 May 5440 June 3460 July 5452 $430 August September $535 October 5570 November $580 December $600 Total $6033 Requirements 1. Calculate the cost of coffee beans per ounce of coffee sold 2. Calculate the cost of cups, lids, sleeves, cream, and sogar per unit for small, medium, and large cup of coffee and in total, 3. Calculate the total labor costs for the year. 4. Prepare an income statement for The Daily Grind for the last year. You can assume that there are no inventories on hand at the end of the year (All coffee and supplies purchased during the year are consumed.) 5. Determine whether the costs incurred by The Daily Grind are fixed, variable (with respect to number of cups of coffee sold), or mixed 6. Use regression analysis and the high/low method to calculate the monthly fuced cost and the variable component of the utility expenses incurred by The Daily Grind. Use cups of coffee sold as the independent variable and utility expense as the dependent variable in your regression analysis. After calculating both numbers, round your final answers to two decimal places 7. Compare the regression results with the highlow results. Which model would you suggest? 8. Calculate the contribution margin camed for elling and Administrative Costs avid incurred $200 a month in accounting fees and spent $500 on various promotional and ad- tising materials during the year. He also paid $1,000 liability insurance ales Revenge uring the first year of operations, David set the shop's ices to be slightly lower than their competitors'. The exily Grind sells a small cup of coffee for $1.25, a me- um cup for $1.65, and a large cup for $1.95. Sales venue was as follows: Month Sales in Cups of Coffee January 9,300 cups February 9,800 March 10,850 9. Assume the sales mix given in the problem. What is Daily Grind's break-even point in terms of the number of cups of coffee sold during the year? ho Aspal cach produce (round to three decimal places utils and the weighted average contribution margin /44/up fround to four decimal places Nobody expedie Erind 20-%20Bonus%20Assignment.pdt BlueStacks App Pla Artfield Institute > Watch Deadpool .... the first 12 months of operations, utility expenses as follows: Month Utility Expense January 5472 February 3510 March 5524 April 3460 May 5440 June 3460 July 5452 $430 August September $535 October 5570 November $580 December $600 Total $6033 Requirements 1. Calculate the cost of coffee beans per ounce of coffee sold 2. Calculate the cost of cups, lids, sleeves, cream, and sogar per unit for small, medium, and large cup of coffee and in total, 3. Calculate the total labor costs for the year. 4. Prepare an income statement for The Daily Grind for the last year. You can assume that there are no inventories on hand at the end of the year (All coffee and supplies purchased during the year are consumed.) 5. Determine whether the costs incurred by The Daily Grind are fixed, variable (with respect to number of cups of coffee sold), or mixed 6. Use regression analysis and the high/low method to calculate the monthly fuced cost and the variable component of the utility expenses incurred by The Daily Grind. Use cups of coffee sold as the independent variable and utility expense as the dependent variable in your regression analysis. After calculating both numbers, round your final answers to two decimal places 7. Compare the regression results with the highlow results. Which model would you suggest? 8. Calculate the contribution margin camed for elling and Administrative Costs avid incurred $200 a month in accounting fees and spent $500 on various promotional and ad- tising materials during the year. He also paid $1,000 liability insurance ales Revenge uring the first year of operations, David set the shop's ices to be slightly lower than their competitors'. The exily Grind sells a small cup of coffee for $1.25, a me- um cup for $1.65, and a large cup for $1.95. Sales venue was as follows: Month Sales in Cups of Coffee January 9,300 cups February 9,800 March 10,850 9. Assume the sales mix given in the problem. What is Daily Grind's break-even point in terms of the number of cups of coffee sold during the year? ho