Giggles Comedy Emporium provides entertainment for birthday parties Over the last year, Giggles has entertained at over 150 birthday parties Giggles business is booming The company has parties booked solid for the next six months Customers generally must book 6 8 months in advance to secure a spot Mark Spear, the owner of Giggles Comedy Emporium, however, is worried His business is busy, his customers are extremely happy, his employees are happy, but he is barely breaking even He cannot understand, with his business being so successful, why he is barely able to pay himself a wage Mark has asked you to help him figure out what he is doing wrong The services provided at each party vary Some customers only want a clown to perform and they handle the other party details themselves Other customers want a full package food, cake, entertainment, cleanup, party favours, decorations, and costumes for the kids Mark has identified the following services that can be provided at a party Clown most, if not all, parties include a clown who performs for one hour at the party Mark pays the clown $40 for each party Food (excluding cake) when customers order food for their party through Giggles, Mark outsources this service to Carls Catering Carl charges an average of $12 per child for food Cake Mark orders birthday cakes through his sister, Sarah, who has a small bakery and makes custom cakes for Giggles Her smallest cake is 8 (which will serve up to 10 kids) and costs $40 She also makes a 10 cake for $60 (which serves 20 kids) Cleanup Giggles also provides cleanup service Cleaning staff are paid $15 per hour Cleanup averages 2 hours per 20 kids Party favours Party favours can also be ordered through Giggles These cost $5 per bag to assemble Decorations Giggles will also fully decorate a party Decorating staff are paid $15 per hour and take one hour to decorate a party for 20 kids Decorations cost an average of $50 for party of 20 kids Costumes Giggles also provides costumes for parties so the kids can dress up in a theme On average, costumes cost $40 each and can be worn 25 times before needed to be replaced Costumes are cleaned after every party at a cost of $5 each Mark has set up a fee schedule for each service as follows Service Fee charged to customer Clown $60 per party Food $15 per child Cake $2 per child Cleanup $2 per child Party favours $6 per child Decorations $2 per child Costumes $6 per child During the two weeks, Mark catered 6 parties Some details of the parties are shown below Customer 1 2 3 4 5 6 of kids attended 20 25 45 15 5 12 Clown Y Y Y Y N Y Food services Y Y N N Y N Cake Y N N Y Y N Clean up Y Y N N Y N Party favours Y Y N N y N Decorations Y Y Y N Y N Costumes N N Y N Y N REQUIRED Calculate the customer level operating income for each customer by preparing a customer profitability analysis Rank the customers according to profitability (15 marks)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 28, 2024

Giggles Comedy Emporium provides entertainment for birthday parties. Over the last year, Giggles has entertained at over 150 birthday parties. Giggles business is booming! The

Giggles Comedy Emporium provides entertainment for birthday parties. Over the last year, Giggles has entertained at over 150 birthday parties. Giggles business is booming! The company has parties booked solid for the next six months. Customers generally must book 6-8 months in advance to secure a spot. Mark Spear, the owner of Giggles Comedy Emporium, however, is worried. His business is busy, his customers are extremely happy, his employees are happy, but he is barely breaking even. He cannot understand, with his business being so successful, why he is barely able to pay himself a wage. Mark has asked you to help him figure out what he is doing wrong.

The services provided at each party vary. Some customers only want a clown to perform and they handle the other party details themselves. Other customers want a full package food, cake, entertainment, cleanup, party favours, decorations, and costumes for the kids. Mark has identified the following services that can be provided at a party.

Clown: most, if not all, parties include a clown who performs for one hour at the party. Mark pays the clown $40 for each party.
Food (excluding cake): when customers order food for their party through Giggles, Mark outsources this service to Carls Catering. Carl charges an average of $12 per child for food.
Cake: Mark orders birthday cakes through his sister, Sarah, who has a small bakery and makes custom cakes for Giggles. Her smallest cake is 8 (which will serve up to 10 kids) and costs $40. She also makes a 10 cake for $60 (which serves 20 kids).
Cleanup: Giggles also provides cleanup service. Cleaning staff are paid $15 per hour. Cleanup averages 2 hours per 20 kids.
Party favours: Party favours can also be ordered through Giggles. These cost $5 per bag to assemble.
Decorations: Giggles will also fully decorate a party. Decorating staff are paid $15 per hour and take one hour to decorate a party for 20 kids. Decorations cost an average of $50 for party of 20 kids.
Costumes: Giggles also provides costumes for parties so the kids can dress up in a theme. On average, costumes cost $40 each and can be worn 25 times before needed to be replaced. Costumes are cleaned after every party at a cost of $5 each.

Mark has set up a fee schedule for each service as follows:

Service	Fee charged to customer
Clown	$60 per party
Food	$15 per child
Cake	$2 per child
Cleanup	$2 per child
Party favours	$6 per child
Decorations	$2 per child
Costumes	$6 per child

During the two weeks, Mark catered 6 parties. Some details of the parties are shown below:

Customer	1	2	3	4	5	6
# of kids attended	20	25	45	15	5	12
Clown	Y	Y	Y	Y	N	Y
Food services	Y	Y	N	N	Y	N
Cake	Y	N	N	Y	Y	N
Clean up	Y	Y	N	N	Y	N
Party favours	Y	Y	N	N	y	N
Decorations	Y	Y	Y	N	Y	N
Costumes	N	N	Y	N	Y	N

REQUIRED:

Calculate the customer-level operating income for each customer by preparing a customer profitability analysis. Rank the customers according to profitability. (15 marks)