I need help figuring out for revenue for grooming, day care, boarding for the income statement? how do I get those revenues?
INSTRUCTIONS: Complete the Statement in proper form Revenue will be provided in an Announcement at the end of Module 4 10 (based on actual number of services for your pricing levels) Additional Information necessary to complete the Income Statement: General & Administrative Salaries paid = $1,200 Advertising = $100 Cleaning Products = $120 16 Depreciation = $83 Rent = $650 Loan = $420 Utilities & Insurance = $600 A dogs bestfriend Corporation Income Statement For the Month Ended January 31, xxxx 28 Revenue: Grooming 30 Day Care 31 Boarding 33 Tota Revenue S 34 Cost of Goods Sold * 11,040 Gross Profit S 37 Expenses: G&A Salaries S 1,200 Advertising 100 40 Cleaning Products 120 Depreciation 83 Rent 650 Loan 420 44 Utilities and Insurance 600 LO Total Expenses 3,173 47 48 Net Income / Loss S 49 8 * Cost of Goods Sold = Cost of Goods Manufactured (COGM). There is no finished goods inventory to maintain. 52 54 COGM Schedule Income Statement Variances +A dogs bestfriend Corporation MILESTONE 2 - Break - Even Analysis INSTRUCTIONS Show all steps and calculations to determine the break -even Determine the break- even for the target profit levels as outlined in the instructions Break- even = Fixed Costs / Contribution Margin DAY CARE BOARDING GROOMING ales Price 20.00 28.00 30. 00 Fixed Costs 1, 379 2, 368 Contribution Margin 15 . 35 20. 64 20.03 Break- even Units ( round up ) 55. 92 66 , 81 118.22 Target Profit 417.00 583. 00 1, 010.00 Break- even Units ( round up ) 64.52 70.81 112 . 93 Target Profit 657.00 909.00 1, 500.00 Break- even Units ( round up ) 77: 02 129.60A dogs bestfriend Corporation MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio INSTRUCTIONS: Select a price from the scenarios below and compute the contribution for each service based on your selected price. Variable cost per unit comes from your Variable_Fixed tab completed in Milestone 1. SCENARIO (choose one from each category) : Dog Day Care 1. With pricing at $18 per dog per day, you can expect to have 22 dogs per day. 2. With pricing at $20 per dog per day, you can expect to have 15 dogs per day. 3. With pricing at $25 per dog per day, you can expect to have 10 dogs per day. Overnight Boarding 1. With pricing at $25 per dog per day, you can expect to have 12 dogs per day. 2. With pricing at $28 per dog per day, you can expect to have 10 dogs per day. 3. With pricing at $30 per dog per day, you can expect to have 7 dogs per day. Basic Groom 1. With pricing at $25 per dog per day, you can expect to have 5 dogs per day. 2. With pricing at $30 per dog per day, you can expect to have 4 dogs per day. 3. With pricing at $35 per dog per day, you can expect to have 3 dogs per day. DAY CARE BOARDING GROOMING Sales Price $ 20.00 S 28.00 30.00 Variable Cost per Unit 4.65 7.36 9.97 Contribution Margin S 15.35 S 20.64 S 20.03