show work please only need questions 2-5 thanks!
CASE 5A-12 Analysis of Mixed Costs in a Pricing Decision LON L-11 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.x. 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: 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 15% markup to yield a price of about $31 per guest. She is confident about her estimates of the costs of food and bererages and labor but is not as comfortable with the estimate of orerhead cost. The $13.98 overhead cost per labor-hour was determined by diriding total orerhead 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 180-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 confldent that these potential customers would be favorably impressed by her company's services at the charity event. Required: 1. Prepare a scattergraph plot that puts labor-hours on the X axis and overhead expenses on the Y-axis. What insights are revealed by your scattergraph? 2. Use the least-squares regression method to estimate the fixed and variable components of overhead expenses. Express these estimates in the form Y=a+bX 3. If Chavez charges her usual price of $31 per guest for the 180-guest cocktail party, how much contribution margin will she earn by serving this event? 4. How low could Chavez bid for the charity event in terms of a price per guest and still break even on the eveat itself?? 5. The individual who is organizing the charity's flundraising event has indicated that he has already received a bid under $30 from another catering company. Do you think Chavez should bid below her nomal 331 per guest price for the charity event? Why or why not? (CMA, adapted) CASE 5A-12 Analysis of Mixed Costs in a Pricing Decision LON L-11 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.x. 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: 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 15% markup to yield a price of about $31 per guest. She is confident about her estimates of the costs of food and bererages and labor but is not as comfortable with the estimate of orerhead cost. The $13.98 overhead cost per labor-hour was determined by diriding total orerhead 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 180-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 confldent that these potential customers would be favorably impressed by her company's services at the charity event. Required: 1. Prepare a scattergraph plot that puts labor-hours on the X axis and overhead expenses on the Y-axis. What insights are revealed by your scattergraph? 2. Use the least-squares regression method to estimate the fixed and variable components of overhead expenses. Express these estimates in the form Y=a+bX 3. If Chavez charges her usual price of $31 per guest for the 180-guest cocktail party, how much contribution margin will she earn by serving this event? 4. How low could Chavez bid for the charity event in terms of a price per guest and still break even on the eveat itself?? 5. The individual who is organizing the charity's flundraising event has indicated that he has already received a bid under $30 from another catering company. Do you think Chavez should bid below her nomal 331 per guest price for the charity event? Why or why not? (CMA, adapted)
