Assuming 30 days/month
Grooming $30= 3 grooms/day
Daycare $20= 12 dogs/Day
Boarding $25= 12 dogs/Day
I assume the formula for revenue would be for example ($30*3)*30 days.
I just want to be sure that i have filled this out correctly and if you could help with the spaces i have not filled out.
My Drive - Google Drive X + ACC 202 Final Project V X @ Managerial Accounting, X MindTap - Cengage Lea X @ ACC 202 Milestone Thre X * ACC 202 Final Project V X + X C A docs.google.com/spreadsheets/d/1VOTuahvy63cwH1laPnAJBn1q2RpPUUGz/edit#gid=1003849520 C EE ACC 202 Final Project Workbook (2) .XLSX 6 Share File Edit View Insert Format Data Tools Help Last edit was seconds ago C 100% - $ % .0 .00 123- Calibri Y A fx 0 A B C D E F G H J K L M N P Q IN HOME Bark 'N Park MILESTONE 3 - Income Statement INSTRUCTIONS: Complete the Statement in proper form 9 Revenue will be provided in an Announcement at the end of Module 4 10 (based on actual number of services for your pricing levels) 11 12 Additional Information necessary to complete the Income Statement: 13 General & Administrative Salaries paid = $1,200 14 Advertising = $10 15 Cleaning Products = $120 16 Depreciation = $83 17 Rent = $650 18 Loan = $420 19 Utilities & Insurance = $600 20 21 22 Bark 'N Park 23 Income Statement 24 For the Month Ended January 31, xxxx 25 + Break-Even Analysis Instructions - Milestone 3 . COS Schedule Income Statement * Variances 1 + Type here to search O a 6:50 PM 99 7/29/2020My Drive - Google Drive X + ACC 202 Final Project V X @ Managerial Accounting, X MindTap - Cengage Lea X @ ACC 202 Milestone Thre X * ACC 202 Final Project V X + X C A docs.google.com/spreadsheets/d/1VOTuahvy63cwH1laPnAJBn1q2RpPUUGz/edit#gid=1003849520 C EE ACC 202 Final Project Workbook (2) .XLSX 6 Share File Edit View Insert Format Data Tools Help Last edit was seconds ago C 100% - $ % .0 .00 123- Calibri Y 10 . B I S A Q. B E3 - E L . H . V G + Y . E. A fx 0 A B C D E F G H I J K L M N P Q 28 Revenue : 29 Grooming S 2,700 30 Day Care 7,200 31 Boarding 9,000 33 Tota Revenue S 18,900 34 Cost of Services * 35 Gross Profit $ 18,900 36 37 Expenses: 38 G&A Salaries S 1,200 39 Advertising 100 40 Cleaning Products 120 41 Depreciation 83 42 Rent 650 43 Loan 420 44 Utilities and Insurance 600 46 Total Expenses $ 3,173 47 48 Net Income / Loss $ 49 50 *Cost of Goods Sold = Cost of Services 51 There is no finished goods inventory to maintain. 52 54 55 + Break-Even Analysis Instructions - Milestone 3 . COS Schedule Income Statement Variances 1 + Type here to search O a 6:50 PM 99 7/29/2020
