Question

In: Accounting

So I did the Milestone 1 already and it seems to be correct. But now i...

So I did the Milestone 1 already and it seems to be correct. But now i need to do the Milestone 2

Please help.


Street Sweep
MILESTONE 1 - Variable & Fixed Cost Exercise


INSTRUCTIONS:
Determine the per unit cost for each dog.
Fill in the blanks to get the per unit cost and fixed cost of each service.

Based on 5 grooms per day
GROOMING

Item	Variable Costs	Item	Fixed Costs

Shampoo	$ 1.04	Groomer	$ 2,080.01
Clipper(s)	1.37	Rent	30.95
Bowls	0.72	Loan	20.00
Towels	5.83	Utilities and Insurance	28.57
Scissors	1.01	Depreciation on heating system	3.95
		Cleaning Products: Odoban	2.08
		Cleaning Products: Simple Green	2.36
		Draw	200.00

Total Variable Costs	$ 9.97	Total Fixed Costs	$ 2,367.92


Based on 22 dogs per day for six days a week. Assume 25 operating days for kennel and 22 eight-hour work days for kennel attendant.
DAY CARE

Item	Variable Costs	Item	Fixed Costs

Day care attendant	$ 2.88	Rent	$ 232.14
Toys	0.27	Loan	150.00
Bowls	0.10	Utilities and Insurance	214.29
Towels	1.40	Depreciation on heating system	29.64
		Cleaning Products: Odoban	15.59
		Cleaning Products: Simple Green	16.78
		Draw	200.00

Total Variable Costs	$ 4.74	Total Fixed Costs	$ 858.44


Based on 12 dogs per day. Assume 22 eight-hour work days for kennel attendant.
BOARDING

Item	Variable Costs	Item	Fixed Costs

Kennel attendant	$ 5.63	Depreciation on kennels	$ 80.00
Bowls	0.86	Rent	386.90
Towels	0.87	Loan	250.00
		Utilities and Insurance	357.16
		Depreciation on heating system	49.40
		Cleaning Products: Odoban	25.98
		Cleaning Products: Simple Green	29.55
		Draw	200.00

Total Variable Costs	$ 7.36	Total Fixed Costs	$ 1,378.99

Street Sweep

MILESTONE 2 - Contribution Margin per Unit & Contribution Margin Ratio

INSTRUCTIONS:

Select a price from the scenarios below and compute the contribution for each service based on your selected price.

Variable cost per unit comes from your Variable_Fixed tab completed in Milestone 1.

SCENARIO (choose one from each category):

Dog Day Care

1. With pricing at $18 per dog per day, you can expect to have 22 dogs per day.

2. With pricing at $20 per dog per day, you can expect to have 15 dogs per day.

3. With pricing at $25 per dog per day, you can expect to have 10 dogs per day.

Overnight Boarding

1. With pricing at $25 per dog per day, you can expect to have 12 dogs per day.

2. With pricing at $28 per dog per day, you can expect to have 10 dogs per day.

3. With pricing at $30 per dog per day, you can expect to have 7 dogs per day.

Basic Groom

1. With pricing at $25 per dog per day, you can expect to have 5 dogs per day.

2. With pricing at $30 per dog per day, you can expect to have 4 dogs per day.

3. With pricing at $35 per dog per day, you can expect to have 3 dogs per day.

DAY CARE

BOARDING

GROOMING

Sales Price

$ -

Variable Cost per Unit

-

Contribution Margin

$ -


Street Sweep
MILESTONE 2 - Break-Even Analysis


INSTRUCTIONS:
Show all steps and calculations to determine the break-even.
Determine the break-even for the target profit levels as outlined in the instructions.


Break-even = Fixed Costs / Contribution Margin


	DAY CARE	BOARDING	GROOMING

Sales Price	$ -	$ -	$ -

Fixed Costs	$ -	$ -	$ -

Contribution Margin	$ -	$ -	$ -

Break-even Units (round up)	-	-	-



Target Profit	$ 417.00	$ 583.00	$ 1,000.00

Break-even Units (round up)	-	-	-



Target Profit	$ 667.00	$ 909.00	$ 1,500.00

Break-even Units (round up)	-	-	-

Expert Solution

MILESTONE 2

	Day Care (22 dogs per day)	Boarding (12 dong per day)	Grooming (5 grooms per day)
Sales Price	$ 18.00	$ 25.00	$ 25.00
Variable Cost Per Unit	$ 4.74	$ 7.36	$ 9.97
Contribution Margin	$ 13.26	$ 17.64	$ 15.03

	Day Care (22 dogs per day)	Boarding (12 dong per day)	Grooming (5 grooms per day)
Sales Price	$ 18.00	$ 25.00	$ 25.00
Variable Cost Per Unit	$ 4.74	$ 7.36	$ 9.97
Contribution Margin	$ 13.26	$ 17.64	$ 15.03
Fixed Cost	$ 858.44	$ 1,378.99	$ 2,367.92
Break-even Units	65	79	158

Formula - Fixed Cost / Contribution per unit

	Day Care	Boarding	Grooming
Fixed Cost	$ 858.44	$ 1,378.99	$ 2,367.92
Target Profit	$ 417.00	$ 583.00	$ 1,000.00
Total	$ 1,275.44	$ 1,961.99	$ 3,367.92
Contribution Margin	$ 13.26	$ 17.64	$ 15.03
Break Even Units	97	112	225

Formula - (Fixed Cost + Target Profit ) / Contribution Per Unit

	Day Care	Boarding	Grooming
Fixed Cost	$ 858.44	$ 1,378.99	$ 2,367.92
Target Profit	$ 667.00	$ 909.00	$ 1,500.00
Total	$ 1,525.44	$ 2,287.99	$ 3,867.92
Contribution Margin	$ 13.26	$ 17.64	$ 15.03
Break Even Units	115	130	258

Formula - (Fixed Cost + Target Profit ) / Contribution Per Unit

ekkarill92 answered 1 year ago

Hi so I did a case on Kernicterus and now I have to explain why these...

Hi so I did a case on Kernicterus and now I have to explain why these differential diagnosis are wrong. Below are the differential diagnosis that I have to explain why it isnt kernicterus. Liver disease Hemolytic anemia (baby Acute bilirubin encephalopathy Rh incompatibility Hyperbilirubinemia Nonalcoholic fatty liver disease Biliary Atresia. Thank you for your help.

Milestone #2 – Systems Planning: Systems Request Purpose In this milestone, the project has now made...

Milestone #2 – Systems Planning: Systems Request Purpose In this milestone, the project has now made it through the pre-planning phase and you are ready to make a formal request for the new system. In order to formally kick-off the request, you will be working on completing the request for systems services document. This document is the first formal request for the new system. The request is short, but it provides a high-level overview of the need for the system...

I have to create a program that: define class cust(I already did this part) create an...

I have to create a program that: define class cust(I already did this part) create an array of cust (size 10)to hold the data of the class. (done) read the date from a file(everything from the class - already done) call a function print cust(this function will print all the data in table format)....first, last, state, sales history(0,1,2), units Read the data from a file (you may break up the strings and numeric values any way you choose (separate lines...

how to correct this java code so that i get the correct day of week? and...

how to correct this java code so that i get the correct day of week? and test the year public static void main(String[] args) { // Scanner s = new Scanner(System.in); //needed info //year month, day int year, month, dayOfMonth; // add day of week , century yr int dayOfWeek, century, yearOfCentury; //user inputs year System.out.print("Enter year: (example, 2020):"); year = s.nextInt(); //user inputs month by number System.out.print("Enter month: 1-12:"); month = s.nextInt();...

*********Please do not answer the question partially. I have already done step #1, now just needing...

*********Please do not answer the question partially. I have already done step #1, now just needing to complete all of the other steps (2-10) an explantion included would be nice as well, I would appriciate it! :) *If you can not help completely or entirely; to the furthest extent please do not leave an answer******* Question 1 Required: #1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx"....

I am not sure if the ones that I did answer were correct and wanted to...

I am not sure if the ones that I did answer were correct and wanted to make sure. Answer the following questions about the anatomy of muscle: Combination of myofilaments lead to formation of ______________________ Myosin is the make-up of the ______thick______________ filament, while actin protein is the make-up of _______thin_____________ filament Plasma membrane of muscles are known as ______sarcolemma_____________________ Sarcolemma dips down into the cell to produce tube like structures known as _____________________ Connective tissue that wraps around multiple...

*** Please provide computation. I already have the correct answer. With α = .05, what is...

*** Please provide computation. I already have the correct answer. With α = .05, what is the critical t value for a one-tailed test with n = 15?

I have solved most of question and the answers I have so far are correct, I...

I have solved most of question and the answers I have so far are correct, I just need help finding out the lower bound and upper bound (All answers were generated using 1,000 trials and native Excel functionality.) Galaxy Co. distributes wireless routers to Internet service providers. Galaxy procures each router for $75 from its supplier and sells each router for $125. Monthly demand for the router is a normal random variable with a mean of 100 units and a...

I did the previous steps and now im at 6 and 7. I can not figure...

I did the previous steps and now im at 6 and 7. I can not figure it out. It is a calculator code, and this part we need to make it password protected. The user is asked to enter in a username and password, and if the password is the backwards of the username you get into the calulator code (that i already have finished below). Use strings and arrays to hold the username and password (maybe use something like...

Choose the correct lettee of the answer 6. What developmental milestone in language is demonstrated by...

Choose the correct lettee of the answer 6. What developmental milestone in language is demonstrated by children who are 6 years old? a. Know names of familiar animals c. Tell connected stories b. Have number concepts of 4 or more d. Handle opposite analogies 7. Mr. Francisco was very much worried about the thumb sucking of his son. A friend of Piaget’s of him says that certain behavior among infants. Who presented that notion that certain behavior like thumb-sucking is...