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 2 years ago

Okay so I already completed steps A - C listapi is now a library for project...

Okay so I already completed steps A - C listapi is now a library for project 4 the trouble I am having is how to do part D. Use ListAPI as a library. a) Create a Intellij project and name it “p4_2_your-id”. b) Create a JAR file of “ListAPI”. Download “ListAPI.zip” from Moodle and extract the NetBeans project folder “ListAPI” from the archive file. In NetBeans, open “ListAPI”. Under the Project tab, right click on ListAPI and select Clean. Under...

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...

Hey guys, So it seems like I made a slight error in my program. So one...

Hey guys, So it seems like I made a slight error in my program. So one of the requirement for this program is not to show any negatives shown as a output, however my program showed some negative numbers. I was wondering if someone could look over my program and find the error and maybe give it a tweak. I don't want to change my program because I worked so hard for it. Anyway here the assignment at the bottom...

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'm having trouble understanding this concept. I already completed the first part now I need to...

I'm having trouble understanding this concept. I already completed the first part now I need to convert the Second Part into a Control Structure. Please help answering the Problem. The first part will be below. (Second Part) Continuing with Control Structures Control Structures are called such because they control the execution flow during the running of a program. There are 3 basic control structures: Sequence, Selection and Loop. This week let's work with the structures we already know - Sequence...

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?