I would like a quote.
ACC 202 Project Workbook Instructions Southern New Hampshire University College of Continuing Education (COCE) ACC202 - Managerial Accounting MILESTONE 1 (Due in Module 2)MILESTONE 2 (Due in Module 4)MILESTONE 3 (Due in Module 5) 1.1.1. NameChoose a price range and calculate:Create a Cost of Goods Manufactured Schedule LocationGrooming VisionDay Care MissionBoarding 2.2.2. Identify the following:Calculate the break-even unitsCreate an Income Statement Direct MaterialsGroomingRevenue will be provided end of week 4 Diret LaborDay Care Manufacturing OverheadBoarding Period CostsCalculate the break-even for target profits 3.Grooming3. Day Care Calculate the Variable & Fixed Costs for:BoardingCalculate for the Grooming line: GroomingDirect Labor Time Variance Day CareDirect Labor Rate Variance BoardingDirect Materials Efficiency Variance Direct Materials Price Variance ACC202 - MANAGERIAL ACCOUNTING Company Profile /xl/drawings/drawing1.xml#CompanyProfileVariable & Fixed Costs /xl/drawings/drawing1.xml#VariableFixedCostsCost Classification /xl/drawings/drawing1.xml#CostClassificationContribution Margin /xl/drawings/drawing1.xml#ContributionMarginBreak-Even Analysis /xl/drawings/drawing1.xml#BreakevenAnalysisCOGM Schedule /xl/drawings/drawing1.xml#COGMScheduleIncome Statement /xl/drawings/drawing1.xml#COGMScheduleVariances /xl/drawings/drawing1.xml#VariancesInstructions Milestone 1 /xl/drawings/drawing1.xml#InstructionsMilestone1Instructions Milestone 2 /xl/drawings/drawing1.xml#'Instructions%20-%20Milestone%202'!InstructionsMilestone2Instructions Milestone 3 /xl/drawings/drawing1.xml#'Instructions%20-%20Milestone%203'!InstructionsMilestone3 Instructions - Milestone 1 Southern New Hampshire University College of Continuing Education (COCE) ACC202 - Managerial Accounting INSTRUCTIONS FOR MILESTONE 1 (Due Week 2) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 1 Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7) ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs): GENERAL You plan to open a pet services business that will offer dog grooming, day care and boarding COST CLASSIFICATION Accurately classify all of your costs (direct material, direct labor, manufacturing overhead, period costs) Fixed & Variable cost designation is provided VARIABLE & FIXED COSTS Determine your per unit cost per dog for grooming, day care and boarding OPERATIONAL & COST INFORMATION: 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 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 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 . ACC202 - MANAGERIAL ACCOUNTING HOME /xl/drawings/drawing2.xml#Home Cost Classification Milestone One - Cost Classification INSTRUCTIONS: Putting an X in the appropriate spot, classify the costs as: Direct Material, Direct Labor, Overhead, or Period Costs. The Fixed and Variable cost classifications have been provided for you. Item/CostDirect MaterialDirect Labor OverheadPeriod Costs FixedVariable Salary - Collar makerx x Salary - Leash makerxx Salary - Harness makerxx Salary - Receptionistx High-tensile strength nylon webbing xx Polyester/nylon ribbons x x Buckles made of cast hardware x x Depreciation on sewing machinesxx Rentxx Utilities and insurancexx Scissors, thread, and cordingxx Price tagsx x Office suppliesx Other business equipmentx Loan payment xx Salary to selfxx &8ACC202 - MANAGERIAL ACCOUNTING HOME /xl/drawings/drawing3.xml#Home Variable and Fixed Costs Milestone One - Variable and Fixed Costs Collars ItemVariable Cost/ItemItemFixed Costs High-tensile strength nylon webbing $ 4.00Collar maker's salary (monthly)$ 2,773.33 Polyester/nylon ribbons $ 3.00Depreciation on sewing machines$ 55.00 Buckles made of cast hardware $ 2.00Rent$ 250.00 Price tags$ 0.10Utilities and insurance$ 200.00 Scissors, thread, and cording$ 400.00 Loan payment$ 183.33 Salary to self$ 166.67 Total Variable Costs per Collar$ 9.10Total Fixed Costs$ 4,028.33 Leashes ItemVariable Cost/ItemItemFixed Costs High-tensile strength nylon webbing $ 6.00Leash maker's salary (monthly)$ 2,773.33 Polyester/nylon ribbons $ 4.50Depreciation on sewing machines$ 55.00 Buckles made of cast hardware $ 1.50Rent$ 250.00 Price tags$ 0.10Utilities and insurance$ 200.00 Scissors, thread, and cording$ 400.00 Loan payment$ 183.33 Salary to self$ 166.67 Total Variable Costs per Leash$ 12.10Total Fixed Costs$ 4,028.33$ 4,028.33 Harnesses ItemVariable Cost/ItemItemFixed Costs High-tensile strength nylon webbing $ 6.00Harness maker's salary$ 2,946.67 Polyester/nylon ribbons $ 4.50Depreciation on sewing machines$ 55.00 Buckles made of cast hardware $ 4.00Rent$ 250.00 Price tags$ 0.10Utilities and insurance$ 200.00 Scissors, thread, and cording$ 400.00 Loan$ 183.33 Salary to self$ 166.67 Total Variable Costs per Harness$ 14.60Total Fixed Costs$ 4,201.67 &8ACC202 - MANAGERIAL ACCOUNTING HOME /xl/drawings/drawing4.xml#Home Instructions - Milestone 2 Southern New Hampshire University College of Continuing Education (COCE) ACC202 - Managerial Accounting INSTRUCTIONS FOR MILESTONE 2 (Due Week 4) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 2 Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7) ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): GENERAL Use data from Milestone 1 in your analysis CONTRIBUTION MARGIN ANALYSIS Select a price for each service (grooming, day care, boarding) Determine the variable cost from the Variable_Fixed tab for each service Calculate the contribution margin for each service based on your sales price and the variable cost for that service BREAK-EVEN ANALYSIS Determine the fixed cost from the Variable_Fixed tab for each service Fixed & Variable cost designation is provided Calculate the break-even units (round up) for each service Calculate the break-even units (round up) for suggested target profit levels for each service ACC202 - MANAGERIAL ACCOUNTING HOME /xl/drawings/drawing5.xml#Home Contribution Margin Analysis Milestone Two - Contribution Margin AnalysisScenario 1 - (When Sales Price is $20 , $22 & $25 per unit) COLLARSLEASHESHARNESSES Sales Price per Unit$ 20.00$ 22.00$ 25.00 Variable Cost per Unit9.1012.1014.60 Contribution Margin$ 10.90$ 9.90$ 10.40Contribution Margin = (Sales price per unit ) - (Variable cost per unit) Milestone Two - Contribution Margin AnalysisScenario 2 - (When Sales Price is $24 , $26 & $30 per unit) COLLARSLEASHESHARNESSES Sales Price per Unit$ 24.00$ 26.00$ 30.00 Variable Cost per Unit9.1012.1014.60 Contribution Margin$ 14.90$ 13.90$ 15.40Contribution Margin = (Sales price per unit ) - (Variable cost per unit) Milestone Two - Contribution Margin AnalysisScenario 3 - (When Sales Price is $28 , $30 & $35 per unit) COLLARSLEASHESHARNESSES Sales Price per Unit$ 28.00$ 30.00$ 35.00 Variable Cost per Unit9.1012.1014.60 Contribution Margin$ 18.90$ 17.90$ 20.40Contribution Margin = (Sales price per unit ) - (Variable cost per unit) &8ACC202 - MANAGERIAL ACCOUNTING HOME /xl/drawings/drawing6.xml#Home Break-Even Analysis Milestone Two - Break-Even AnalysisScenario 1 - (When Sales Price is $20 , $22 & $25 per unit) COLLARSLEASHESHARNESSES Sales Price$ 20.00$ 22.00$ 25.00 Fixed Costs$ 4,028$ 4,028$ 4,202 Contribution Margin$ 10.90$ 9.90$ 10.40 Break-Even Units (round up)370407405BEP = (Fixed Cost $ ) / (Contribution$ per unit) Target Profit$ 300$ 400$ 500 Break-Even Units (round up)398448453BEP = (Fixed Cost $ + Desired Profit ) / (Contribution$ per unit) Target Profit$ 500$ 600$ 650 Break-Even Units (round up)416468467BEP = (Fixed Cost $ + Desired Profit ) / (Contribution$ per unit) Milestone Two - Break-Even AnalysisScenario 2 - (When Sales Price is $24 , $26 & $30 per unit) COLLARSLEASHESHARNESSES Sales Price$ 24.00$ 26.00$ 30.00 Fixed Costs$ 4,028$ 4,028$ 4,202 Contribution Margin$ 14.90$ 13.90$ 15.40 Break-Even Units (round up)271290273BEP = (Fixed Cost $ ) / (Contribution$ per unit) Target Profit$ 300$ 400$ 500 Break-Even Units (round up)291319306BEP = (Fixed Cost $ + Desired Profit ) / (Contribution$ per unit) Target Profit$ 500$ 600$ 650 Break-Even Units (round up)304333316BEP = (Fixed Cost $ + Desired Profit ) / (Contribution$ per unit) Milestone Two - Break-Even AnalysisScenario 3 - (When Sales Price is $28 , $30 & $35 per unit) COLLARSLEASHESHARNESSES Sales Price$ 28.00$ 30.00$ 35.00 Fixed Costs$ 4,028$ 4,028$ 4,202 Contribution Margin$ 18.90$