You have recently been hired as an accountant by the Sweetwater Candy Company operating in Fort Collins. The Sweetwater Candy Company works with a local manufacturer to produce boxes of assorted chocolates that it sells for $24 per box. Sweetwater makes some seasonal, specialty chocolates during Colorado's peach and cherry seasons that have become favorites of locals and tourists. You have been asked to get involved with the budget preparation for next year and to use the information to make decisions. The budget process is already underway, and the accounting team has worked with the sales and marketing team to develop the following sales budget for next year: Sales Budget Selling price per unit $24.00 Units Dollar Sales January 1,350 $ 32,400 February 1,700 $ 40,800 March April 1,600 $38,400 1,550 $ 37,200 May 1,650 $39,600 June July 1,700 $ 40,800 1,750 $ 42,000 August 1,600 $38,400 September 1,300 $31,200 October November 2,100 $50,400 1,800 $43,200 December Total Annual Sales 1,900 $45,600 20,000 $480,000 Required: Work through the worksheets in this Excel workbook to complete the required calculations and analyses. Provide explanations as instructed.