I need A 7 part excel spread sheet for managerial accounting done.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.
Name
Choose a price range and calculate:
Create a Cost of Goods Manufactured Schedule
Location
Grooming
Vision
Day Care
Mission
Boarding
2.
2.
2.
Identify the following:
Calculate the break-even units
Create an Income Statement
Direct Materials
Grooming
Revenue will be provided end of week 4
Diret Labor
Day Care
Manufacturing Overhead
Boarding
Period Costs
Calculate the break-even for target profits
3.
Grooming
3.
Day Care
Calculate the Variable & Fixed Costs for:
Boarding
Calculate for the Grooming line:
Grooming
Direct Labor Time Variance
Day Care
Direct Labor Rate Variance
Boarding
Direct Materials Efficiency Variance
Direct Materials Price Variance
ACC202 – MANAGERIAL ACCOUNTING
Company Profile
/xl/drawings/drawing1.xml#CompanyProfile
Variable & Fixed Costs
/xl/drawings/drawing1.xml#VariableFixedCosts
Cost Classification
/xl/drawings/drawing1.xml#CostClassification
Contribution Margin
/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
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 dail
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.