I'm unsure if these are correct any help would be appreciated!
Rosave ACC 202 Final Project Workbook. Excel Home Insert Draw Page Layout Formulas Data Review View Help X cut Format Painter Calibri 410A B TUBE -A- General 24 23 Wrap Tort E Merge & Center - $ - %) *888 Conditio Formattir Clipboard Font Alignment Number D H INSTRUCTIONS Putting an X in the appropriate spot, classify the costs highlighted in yellow as: Direct Material, Direct Labor, Overhead, or Period Costs. Other costs have been provided for you The fixed and variable cost classifications have been provided for you. For more information see Objective in Chapter 5 Direct Material Direct Labor Overhead Period Costs Fixed Variable X X X x X X X XXX X Item/Cost Groomer Day care attendant Receptionist Kennel attendant Food and water bowis Depreciation on kennels Rent Utilties and insurance Grooming tub 48 Depreciation on heating system Clippers Shampoo Crystal clear five non po Towels Scissors 17-inch straight, ear & nose) Toys used in day care only Cleaning products used throughout Dryer X X X X X X X X X X 1 66 5 O Type here to search hp Calibri 10 29 Wrap Text General X Cut 1 Copy 3 Format Painter - A A a-A- BIU Merge & Center - $ - % Clipboard Font Alignment Num X A B C D 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 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 gaion of water: Allocate based on square footage Simple Green - $15.66 per gallon; Each area will dilute 1 oz to 2 gallon of water: Allocate based on square footage PA 199 Type here to search ACC 202 Final Project Workbook - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Calibri X Cut Copy Paste Format Painter 10-A A General BIU - a A- Wrap Text + Mergea Center - EE S- Clipboard Font Alignment Nu 178 f 4 A G H 42 For simplicity, base all calculations using 30 days in each month OPERATIONAL DATA 43 44 45 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 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 in Modest monthly draw of $600 a month for first year, should be divided evenly amoung the services (prooming day care 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 OTHER COST DATA 66 67 68 69 70 71 73 74 75 76 77 78 79 RO Grooming Dog Grooming Arm $300 Grooming Table - $900 Grooming Tub - $2,800 Clippers - $136.99, can be used for 100 grooms Shampoo - 5103.96 per 5-gallon pail; can be used for 100 grooms Salon Tuff Capri Mobile Carry Cart - $90 Scicons 17 inch stralehti. 104 40 carline 200 orang Type here to search O
