Managerial Accounting

I need A 7 part excel spread sheet for managerial accounting done.

Instructions

Southern New Hampshire University College of Continuing Education (COCE) ACC2

0

2 – 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

&

Fi

x

ed

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

for start-up costs – monthly payment of $420; in effect immediately; limited cash and loan funding – used angel investors

Grooming:

.

Day Care:

Boarding:

General:

– $650 per month; Allocate based on square footage

.

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

/Cost

Fixed
Variable

x

x

x

x

x

x

x

Rent

x

x

x

x

x

x

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

Item

Item
Fixed Costs

High-tensile strength nylon webbing

Polyester/nylon ribbons

Depreciation on sewing machines

Buckles made of cast hardware

Rent

Price tags

Utilities and insurance

Scissors, thread, and cording

Loan payment

Salary to self

Item
Variable Cost/Item

Item
Fixed Costs

High-tensile strength nylon webbing

Polyester/nylon ribbons

Depreciation on sewing machines

Buckles made of cast hardware

Rent

Price tags

Utilities and insurance

Scissors, thread, and cording

Loan payment

Salary to self

Total Fixed Costs

Item
Variable Cost/Item

Item
Fixed Costs

High-tensile strength nylon webbing

Polyester/nylon ribbons

Depreciation on sewing machines

Buckles made of cast hardware

Rent

Price tags

Utilities and insurance

Scissors, thread, and cording

Loan

Salary to self

Total 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

Southern New Hampshire University

College of Continuing Education (COCE)

ACC202 – Managerial Accounting

IMPORTANT NOTE:

Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7)

GENERAL

Fixed & Variable cost designation is provided

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

per Unit

Contribution Margin

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

COLLARS

LEASHES

HARNESSES

Sales Price

$ – 0

$ – 0

Fixed Costs
$ – 0

$ – 0

$ – 0

Contribution Margin
$ – 0

$ – 0

$ – 0

– 0

– 0

– 0

Break-Even Units (round up)
– 0

– 0

– 0

Target Profit
$ 500.00

Break-Even Units (round up)
– 0

– 0

– 0

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

Southern New Hampshire University

College of Continuing Education (COCE)

ACC202 – Managerial Accounting

IMPORTANT NOTE:

Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7)

GENERAL

Use the data at the top of the schedule to complete the report

Variance

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

$ – 0

0

Direct Labor
Overhead

0

Cost of Goods Sold

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

Collars
$ – 0
Leashes
– 0
Harnesses
– 0

$ – 0

– 0

$ – 0

$ – 0

Office supplies
– 0
Other business equipment
– 0

$ – 0

$ – 0

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

Labor
Materials

Variance

$ – 0

Direct Labor Rate Variance

$ – 0

$ – 0

Direct Materials Price Variance

$ – 0

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