Maria Chavez owns a catering company that serves food and be

Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez’s business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez’s customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows:

Labor (0.5 hour @ $9.80

/hr.)

The standard cocktail party lasts three hours and Chavez hires one worker for every six guests, so that works out to one-half hour of labor per guest. These workers are hired only as needed and are paid only for the hours they actually work.

When bidding on cocktail parties, Chavez adds a 13% markup to yield a price of about $35 per guest. She is confident about her estimates of the costs of food and beverages and labor but is not as comfortable with the estimate of overhead cost. The $18.58 overhead cost per labor-hour was determined by dividing total overhead expenses for the last 12 months by total labor-hours for the same period. Monthly data concerning overhead costs and labor-hours follow:

Chavez has received a request to bid on a 175-guest fundraising cocktail party to be given next month by an important local charity. (The party would last the usual three hours.) She would like to win this contract because the guest list for this charity event includes many prominent individuals that she would like to secure as future clients. Maria is confident that these potential customers would be favorably impressed by her company’s services at the charity event.

A. Use the least-squares regression method to estimate the fixed and variable components of overhead expenses. (Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount.)

B. Express these estimates in the form Y = a + bX. (Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount.)

C. If Chavez charges her usual price of $35 per guest for the 175-guest cocktail party, how much contribution margin will she earn by serving this event? (Round your intermediate calculations and final answers to 2 decimal places.)

D. How low could Chavez bid for the charity event in terms of a price per guest and still break even on the event itself?

E. The individual who is organizing the charity’s fundraising event has indicated that he has already received a bid under $34 from another catering company. Do you think Chavez should bid below her normal $35 per guest price for the charity event?

Food and beverages $ 17.00

Labor (0.5 hour @ $9.80

/hr.)

4.90
Overhead (0.5 hour @ $18.58/hr.) 9.29
Total cost per guest $ 31.19

Solution

B.

A.
Fixed cost per month $38,503
Variable cost per hour $4.05
Working:
Month Labor Overhead
Hours Expenses
x y x^2 x*y
January 2500 45000 6250000 112500000
February 2500 49000 6250000 122500000
March 2700 50000 7290000 135000000
April 3900 54000 15210000 210600000
May 4200 57000 17640000 239400000
June 5200 61000 27040000 317200000
July 6200 64000 38440000 396800000
August 7200 67000 51840000 482400000
September 6700 65000 44890000 435500000
October 4200 58000 17640000 243600000
November 3800 54000 14440000 205200000
December 6200 62000 38440000 384400000
55300 686000 285370000 3285100000
x y x2 xy
Formulas
Unit Variable Cost=b=(nxy-x.y) / ((nx^2-(x)^2)
Total Fixed Cost=a=(y-bx) / n
     Where,
n is number of pairs of units—total-cost used in the calculation;
y is the sum of total costs of all data pairs;
x is the sum of units of all data pairs;
xy is the sum of the products of cost and units of all data pairs; and
x2 is the sum of squares of units of all data pairs.
Unit variable cost = b = (12*3285100000-55300*686000) / (12*285370000 - (55300)^2)
= (39421200000 - 37935800000) / (3424440000 - 3058090000)
= 1485400000 / 366350000
= $4.05
Total fixed costs = a    = (686000 - 4.05*55300) / 12
= 462035 / 12
= $38,503
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez’s business is seasonal, with a heavy schedule duri
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez’s business is seasonal, with a heavy schedule duri

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site