UMU 39 X M N G D B A 1 2 Danica's Donuts Projected Statement For the Year Ended, December 31, 2017 4 Mar May Jun yu Sep Aug od NOW eb Dec Summary 5 3 Sales $ 6,000 Costs of Good Sold 0 Food 1 Paper 2 Other COGS 3 Total Cost of Goods Sold 5 Gross Profit 6 7 Operating Expenses 8 Utilities 9 Payroll O Insurance 1 Repairs 2 Miscellaneous 3 Total Operating Expenses 4 5 Projected income 6 7 8 9 0 1 2 3 Before + Danica Donuts(3) ayout References Mailings Review View Tell me ' ' Aav 1 A E E AL EESE TE AaBbCcDdE AaBbCcDc A AaBbCcDdE Normal A DV v No Spacing Heading 1 . Hints: As a check figure, ending cash (second sheet) should be the same as cash at the end of the year (end of year cash is the same as end of December cash). You should not be forcing the 2 figures to equal, though. It should occur naturally if there are no formula errors or you have incorporated everything necessary into the formulas. Beginning cash for the year (in the summary column) is the same as beginning cash in January (use a formula in the summary column). Prepare the following projection of revenues and expenses for Danica's Donuts, 2017. 1. The spreadsheet should cover the period January-December. I set up a column for each month. You can abbreviate the name of each month if it looks better on the chart. 2. Sales projections for January indicate that January sales will be $6,000. 3. Sales for February and March will increase 15% over the previous month. Sales for April through December will increase 6% over the previous month. Use "Precision as Displayed" (newer excel versions - File, Options, Advanced - scroll down and check "precision as displayed") after you have completed your worksheets. 4. Set your projection up using a traditional format (as opposed to contribution margin format) a. Food 5. Monthly expenses (Food, paper and other cogs are all part of "Cost of Goods Sold. For informational purposes only, expenses shown as percentages are variable, others are fixed): 25% of prior months sales (December 2016 sales were $7,200). b. Paper 15% of current sales c. Utilities $750/month January - June), 5800/month (July-December) d. Payroll 20% of current sales e. Insurance $750 per month + 5% of current sales f. Repairs $400/month S500/month h. Other COGS $4% of current sales & Misc English (United States) Focus 80 000 1 F5 90 F7 F8 79 or