I have to find the fixed costs for GROOMER

Also I have to write the answer with the Excel formula

E FO Number 5 Formatting Table Styles Clipboard Font Alignment Styles Q12 . E F G H I J K L M For simplicity, base all calculations using 30 days in each month OPERATIONAL DATA Grooming: The Groomer can groom 5 dogs a day, 5 days a week Each grooming takes 1.5 labor hours Day Care: The Day Care can house 10 large dogs and 12 small dogs daily. Day Care is offered 6 days a week Boarding: There are 12 kennels (single dog only). Boarding (kennel services) is offered every day Facilities: The Grooming facility is 200 square feet The Boarding facility is 2,500 square feet The Day Care facility is 1,500 square feet General: Loan for start-up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel investors Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, boarding) SALARY & HIRING DATA Groomer (Allison) - $12.00 an hour, 40 hours a week Day Care Attendant (Beverly) - $9.00 per hour, based on need Receptionist (Cathie) - $8.50 per hour, 30 hours a week Kennel Attendant (Ben) - $11.50 per hour, based on need 1 OTHER COST DATA . Instructions - Milestone 1 Company Profile Cost Classification Variable Fixed Instructions - Milestone 2 Contribution Margin An Start a search 70 000 Formatting Styles For Table Styles Number K L M N O P Clipboard Font Alignment Q12 A B C D E F G H I J OTHER COST DATA Grooming: Dog Grooming Arm - $300 Grooming Table - $900 Grooming Tub - $2,800 Clippers - $136.99; can be used for 100 grooms Shampoo - $103.96 per 5-gallon pail; can be used for 100 grooms Salon Tuff Capri Mobile Carry Cart - $90 Scissors (7 inch straight) - $194.99, used for 200 grooms Scissors (ear and nose) - $7.49; used for 200 grooms Day Care: Fencing for Day Care area - $1,249 Fencing Installation - $1,000 Toys - $3.29 per 6 pack; one toy will last for two dogs in day care per day Rubberized Flooring for Day Care - $3,800 Boarding: 12 Kennels; Depreciation is $80 per month General: Food & Water bowls - $3.59 per unit Day Care -two bowls last for every 75 dogs that attend daycare Boarding - two bowls last for every 100 dogs boarded; two bowls per kennel Grooming - each bowl lasts for 20 grooms and you need 4 bowls at all times Towels - $34.99 per 12 pack Day Care - 12 towels for every 25 dogs Boarding - 12 towels for every 40 dogs Grooming - 2 towels for every groom per day Heating System - $10,000; Depreciation is $83 per month; Allocate based on square footage Rent - $650 per month; Allocate based on square footage Instructions - Milestone 1 Company Profile Cost Classification Variable Fixed Instructions - Milestone 2 Contribution Margin Ann Start a search Paste BIU = Merge & Center $ % Formatting Clipboard Font Alignment Number P109 A N . XV B C D E F G H I J K L M Boarding: 12 Kennels; Depreciation is $80 per month General: Food & Water bowls - $3.59 per unit Day Care - two bowls last for every 75 dogs that attend daycare Boarding two bowls last for every 100 dogs boarded; two bowls per kennel Grooming - each bowl lasts for 20 grooms and you need 4 bowls at all times Towels - $34.99 per 12 pack Day Care - 12 towels for every 25 dogs Boarding - 12 towels for every 40 dogs Grooming - 2 towels for every groom per day Heating System - $10,000; Depreciation is $83 per month; Allocate based on square footage Rent - $650 per month; Allocate based on square footage Utilities / Insurance - $600 per month; Allocate based on square footage Cage Bank - $2,200 per set of 5 Dryer - $1,250 Cleaning Products Odoban - $14.55 per gallon; Each area wil dilute 1 oz to 1 gallon of water; Allocate based on square footage Simple Green - $15.66 per gallon; Each area will dilute 1 oz to 1 gallon of water; Allocate based on square footage 101 102 103 104 105 106 107 108 109 110 111 112 113 114 1.16 Company Profile Instructions - Milestone 1 Cost Classification Variable Fixed Instructions - Milestone D49 2 fir 50D+51D-58D=49D 5.62 DE AB INSTRUCTIONS: Determine the per unit cost for each dog. Fill in the blanks to get the per unit cost and fixed cost of each service. Based on 5 grooms per day GROOMING Item Fixed Costs 16 30.95 Shampoo Clipper(s) Bowls Towels Scissors 20.00 Variable Costs Item 17D+18D+19D+20D=16D 1.04 Groomer 1.37 Rent 0.72 Loan 5.83 Utilities and Insurance Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green Draw $ 9.97 Total Fixed Costs 1.01 21 28.57 3.95 2.08 2.36 200.00 2,367.91 $ Total Variable Costs Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 eight-hour work days for kennel attendant. DAY CARE Item Variable Costs Item Fixed Costs Day care attendant Rent 232.14 150.00 Loan Toys Bowls 0.10 Utilities and Insurance 336+34G+36G+376+38G+396 416-350 Towels 1.40 Depreciation on heating system 29.64 Instructions - Milestone 1 Company Profile Cost Classification Variable Fixed con Instructions Milestone 2.88 0.27 O Start a search BIUB A EEE3Merge & Center Clipboard $ Font % ) 88-98 Conditional Format as Formatting Table 22 Delete- Alignment Cell Styles D49 - X Number 50D+51D-58D=49D 5.62 Styles Cells Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 eight-hour work days for kennel attendant. DAY CARE Item Variable Costs Item Day care attendant Fixed Costs 2.88 Toys Rent 0.27 232.14 Bowls Loan 150.00 0.10 Towels Utilities and Insurance 336+346+36G+376+38G+39G-416-356 214.29 1.40 Depreciation on heating system 29.64 Cleaning Products: Odoban 15.59 Cleaning Products: Simple Green 16.78 Draw 200.00 Total Variable Costs 33D+34D+35D+36D=41D 4.65 Total Fixed Costs 858.44 0.86 Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant. BOARDING Item Variable Costs Item Kennel attendant 50D+51D-58D=490 5.62 Depreciation on kennels Bowls Rent Towels Loan Utilities and Insurance Depreciation on heating system Cleaning Products: Odoban Cleaning Products: Simple Green Draw Total Variable Costs Total Fixed Costs 0.87 UwN- Fixed Costs 80.00 386.90 250.00 49G+50G+516+53G+54G+55G+566-586-526 357.14 49.40 25.98 29.55 200.00 $ 1,378.97 S 7.35 Instructions - Milestone 1 Company Profile Cost Classification Variable Fixed Instructions - Milestone 2 Contribution Margin An Start a search