I need A 7 part excel spread sheet for managerial accounting done.
Instructions
2 – Managerial Accounting
1.
1.
2.
2.
Create an
Income Statement
Grooming
Day Care
Boarding
Grooming
3.
Day Care
Calculate the
&
ed
Costs
for:
Boarding
Grooming
Time
Day Care
Boarding
ACC202 – MANAGERIAL ACCOUNTING
Company Profile
/xl/drawings/drawing1.xml#CompanyProfile
Variable &
/xl/drawings/drawing1.xml#VariableFixedCosts
Cost Classification
/xl/drawings/drawing1.xml#CostClassification
/xl/drawings/drawing1.xml#ContributionMargin
Break-Even Analysis
/xl/drawings/drawing1.xml#BreakevenAnalysis
COGM Schedule
/xl/drawings/drawing1.xml#COGMSchedule
Income Statement
/xl/drawings/drawing1.xml#COGMSchedule
Variances
/xl/drawings/drawing1.xml#Variances
Instructions Milestone 1
/xl/drawings/drawing1.xml#InstructionsMilestone1
Instructions Milestone 2
/xl/drawings/drawing1.xml#’Instructions%20-%20Milestone%202′!InstructionsMilestone2
Instructions Milestone 3
/xl/drawings/drawing1.xml#’Instructions%20-%20Milestone%203′!InstructionsMilestone3
Instructions – Milestone 1
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 12 Kennels; Depreciation is $80 per month | ||||
| 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 | ||||
| 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 | Direct Material |
Direct Labor |
Overhead | Period Costs | ||||||
| Salary – Collar maker | ||||||||||
| Salary – Leash maker | ||||||||||
| Salary – Harness maker | ||||||||||
| Salary – Receptionist | ||||||||||
| High-tensile strength nylon webbing | ||||||||||
| Polyester/nylon ribbons | ||||||||||
| Buckles made of cast hardware | ||||||||||
| Depreciation on sewing machines | ||||||||||
| Utilities and insurance | ||||||||||
| Scissors, thread, and cording | ||||||||||
| Price tags | ||||||||||
| Office supplies | ||||||||||
| Other business equipment | ||||||||||
| Loan payment | ||||||||||
| Salary to self | ||||||||||
&8ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing3.xml#Home
Variable and Fixed Costs
| Milestone One – Variable and Fixed Costs | ||||||||||||||||||||||||
| Collars | ||||||||||||||||||||||||
| Variable Cost/Item | ||||||||||||||||||||||||
| $ 4.00 | Collar maker’s salary (monthly) | $ 2,773.33 | ||||||||||||||||||||||
| $ 183.33 | ||||||||||||||||||||||||
| $ 166.67 | ||||||||||||||||||||||||
| Total Variable Costs per Collar | Total Fixed Costs | |||||||||||||||||||||||
| Leashes | ||||||||||||||||||||||||
| Leash maker’s salary (monthly) | ||||||||||||||||||||||||
| Total Variable Costs per Leash | $ | – 0 | ||||||||||||||||||||||
| Harnesses | ||||||||||||||||||||||||
| Harness maker’s salary | ||||||||||||||||||||||||
| Total Variable Costs per Harness |
&8ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing4.xml#Home
Instructions – Milestone 2
| INSTRUCTIONS FOR MILESTONE 2 (Due Week 4) |
| Make sure to completely review the Rubric for Milestone 2 |
| ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): |
| 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 |
| 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 Analysis | |||||
| COLLARS | LEASHES | HARNESSES | |||
| Sales Price | |||||
| Variable Cost per Unit | |||||
&8ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing6.xml#Home
Break-Even Analysis
| Milestone Two – Break-Even Analysis | ||||||||||
| $ – 0 | ||||||||||
| Break-Even Units (round up) | ||||||||||
| Target Profit | $ 300.00 | $ 400.00 | $ 500.00 | |||||||
| $ 600.00 | $ 650.00 |
&8ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing7.xml#Home
Instructions – Milestone 3
| INSTRUCTIONS FOR MILESTONE 3 (Due Week 5) | |
| Make sure to completely review the Rubric for Milestone 3 | |
| ITEMS TO COMPLETE FOR THIS MILESTONE (Purple Tabs): | |
| Use data from Milestone 1 and Milestone 2 in your analysis | |
| Revenue data needed for the Income Statement will be provided at the end of Module 4 | |
| COST OF SERVICES PROVIDED SCHEDULE | |
| Use the data at the top of the schedule to complete the report | |
| INCOME STATEMENT | |
| Use the data from your Cost of Services Provided Schedule | |
| VARIANCES | |
| Use the data at the top of the schedule to calculate the following: | |
| Favorable / Unfavorable |
ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing8.xml#Home
COGS
| Milestone Three – Statement of | Cost of Goods Sold |
| Beginning Work in Process Inventory | |
| Direct Materials: | |
| Materials: Beginning | |
| Add: Purchases for month of January | |
| Materials available for use | |
| Deduct: Ending materials | |
| Materials Used | |
| Total Costs | |
| Deduct: Ending Work in Process Inventory | |
&8ACC202 – MANAGERIAL ACCOUNTING
HOME
/xl/drawings/drawing9.xml#Home
Income Statement
| Milestone Three – Income Statement |
| Revenue: |
| Total Revenue: |
| Cost of goods sold |
| Gross profit |
| Expenses: |
| General and administrative salaries |
| Total Expenses |
| Net Income/Loss |
&8ACC202 – MANAGERIAL ACCOUNTING
Variances
| Milestone Three – Variance Analysis | |||
| Data for Variance Analysis: | |||
| Budgeted (Standard) Hours/Qty |
Budgeted (Standard) Rate |
Actual Hours/Qty |
Actual Rate |
| Variances for Collar Sales | |||
| Favorable/ Unfavorable |
Direct Labor Time Variance | ||
| (Actual Hours – Standard Hours) x Standard Rate | |||
| (Actual Rate – Standard Rate) x Actual Hours | |||
| Direct Materials Quantity/Efficiency Variance | |||
| (Actual Quantity – Standard Quantity) x Standard Price | |||
| (Actual Price – Standard Price) x Actual Quantity |
&8ACC202 – MANAGERIAL ACCOUNTING
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
