Calculate the customer-level operating income

Assignment Help Accounting Basics
Reference no: EM131640424

Question - 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 Carl's 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:

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

b) Mark would like to earn a return of 50% on costs. What price should he have charged per child for each customer to earn a 50% return on costs? How does this compare the original fee he charged per child? What are the main reasons for this variance? Do you have any suggestions on how Mark could adjust his fee schedule?

Reference no: EM131640424

Questions Cloud

Find the mean length of all great white sharks : Give a 90% confidence interval for the mean length of all great white sharks. (The interval may be too wide due to the influence of the outliers on s.)
Production possibilities frontier to shift from fg to fh : What could cause the production possibilities frontier to shift from FG to FH?
Define relationship between complaints and leaving the hmo : The chi-square statistic for this table is ?2 = 31.765. What null and alternative hypotheses does this statistic test? What are its degrees of freedom?
How might your communication behavior change : How might your communication behavior change if you were to talk to members of each of groups? Why do you think we classify people into the kinds of categories?
Calculate the customer-level operating income : Calculate the customer-level operating income for each customer by preparing a customer profitability analysis
What contributes to the progression from normal adolescent : If taking part in delinquent activities is part of maturing, what contributes to the progression from normal adolescent behavior to chronic offending?
Define percentage of nebraska eighth-graders are white : Explain carefully why this makes sense, using the fact that a much higher percentage of Nebraska eighth-graders are white.
Calculate the npv of the order : Assume that the discount rate is 10% per year, there is no chance of a repeat order, and Q will pay either in full or not at all.
Wacc and corporate investment decisions : Students should understand corporate risk and be able to use the financial models learned in the class to evaluate and calculate a company's weighted average.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd