CASE 5A-12 Analysis of Mixed Costs in a Pricing Decision LO5-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.
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:
Food and beverages.................................................$15.00
Labor (0.5 hrs. @ $10.00/hr.)…………………………………………………………………………………………………5.00
Overhead(0.5 hrs. @ $13.98/hr.)………………………………………………………………………………….……… 6.99
Total cost per guest………………………………………………………………………………………………………………$26.99
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 beverages and labor but is not as comfortable with the estimate of overhead cost. The $13.98 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 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 confident that these potential customers would be favorably impressed by her company’s services at the charity event.
Required:
- Prepare a scatter graph plot that puts labor-hours on the X-axis and overhead expenses on the Y-axis. What insights are revealed by your scattergraph?
- 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.
- 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?
- How low could Chavez bid for the charity event in terms of a price per guest and still break even on the event itself?
- The individual who is organizing the charity’s fundraising event has indicated that he has already received a bid under $30 from another catering company. Do you think Chavez should bid below her normal $31 per guest price for the charity event? Why or why not?
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
MANAGERIAL ACCOUNTING
- Cost Behavior, High-Low Method, Pricing Decision Fonseca, Ruiz, and Dunn is a large, local accounting firm located in a southwestern city. Carlos Ruiz, one of the firms founders, appreciates the success his firm has enjoyed and wants to give something back to his community. He believes that an inexpensive accounting services clinic could provide basic accounting services for small businesses located in the barrio. He wants to price the services at cost. Since the clinic is brand new, it has no experience to go on. Carlos decided to operate the clinic for 2 months before determining how much to charge per hour on an ongoing basis. As a temporary measure, the clinic adopted an hourly charge of 25, half the amount charged by Fonseca, Ruiz, and Dunn for professional services. The accounting services clinic opened on January 1. During January, the clinic had 120 hours of professional service. During February, the activity was 150 hours. Costs for these two levels of activity usage are as follows: Required: 1. Classify each cost as fixed, variable, or mixed, using hours of professional service as the activity driver. 2. Use the high-low method to separate the mixed costs into their fixed and variable components. (Note: Round variable rates to two decimal places and fixed amounts to the nearest dollar.) 3. Luz Mondragon, the chief paraprofessional of the clinic, has estimated that the clinic will average 140 professional hours per month. If the clinic is to be operated as a nonprofit organization, how much will it need to charge per professional hour ? How much of this charge is variable? How much is fixed? (Note: Round answers to two decimal places.) 4. CONCEPTUAL CONNECTION Suppose the accounting center averages 170 professional hours per month. How much would need to be charged per hour for the center to cover its costs ? Explain why the per-hour charge decreased as the activity output increased. (Note: Round answers to two decimal places.)arrow_forwardRound Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Type I rooms do not have high-speed wireless Internet access and are not available for the Business rental class. Round Trees management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 in the Deluxe class, and 50 in the Business class. Round Tree has 100 Type I rooms and 120 Type II rooms. a. Formulate and solve a linear program to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types. b. For the solution in part (a), how many reservations can be accommodated in each rental class? Is the demand for any rental class not satisfied? c. With a little work, an unused office area could be converted to a rental room. If the conversion cost is the same for both types of rooms, would you recommend converting the office to a Type I or a Type II room? Why? d. Could the linear programming model be modified to plan for the allocation of rental demand for the next night? What information would be needed and how would the model change?arrow_forwardClaudia wants to perform a break-even analysis on her very busy casual-dining operation. She has obtained the following operating results from last month's income statement and POS system sales records: Guests served: Sales: Variable costs: Fixed costs: Total costs: Profit: 25,000 $210,000 $75,000 $110,000 $185,000 $25,000arrow_forward
- Ellis Island Tropical Tea, launched by entrepreneur Nailah Ellis-Brown as described in this chapter’s opener, makes Jamaican sweet tea from all-natural ingredients. Required 1. Identify at least two fixed costs that do not change regardless of how much tea Nailah’s company sells. 2. Ellis Island Tropical Tea is growing. How could overly optimistic sales estimates hurt Nailah’s business? 3. Explain how cost-volume-profit analysis can help Nailah manage her company.arrow_forwardAssume a Potbelly's restaurant has the following information available regarding costs at represent- tive levels of monthly sales: Monthly sales in units 5,000 8,000 10,000 Cost of food sold. $10,000 $16,000 $20,000 Wages and fringe benefits.........................4,200 4,320 4,400 Fees paid delivery help...........................1,100 1,760 2,200 Rent on building. 1,100 1,100 1,100 . 900 900 900 Utilities Depreciation on equipment... Supplies (soap, floor wax, etc.).. 1,700 1,700 Total........ .800 920 1,000 ...........1,700. ..250 340 400 Administrative costs..... $20,050 $27,040 $31,700 Required a. Identify each cost as being variable, fixed, or mixed. b. Use the high-low method to develop a schedule identifying the amount of each cost that is mixed or variable per unit. Total the amounts under each categoryarrow_forwardQuestion list Questivi 12 O Question 13 O Question 14 O Question 15 O Question 16 K Jones Ice Cream Stand is operated by Mr. Jones and experiences different sales patterns throughout the year. To plan for the future, Mr. Jones wants to determine its cost behavior patterns. He has the following information available about the ice cream stand's operating costs and the number of soft serve cones served. Month April May June 2,125 July 4,000 August 2,500 2,900 September Using the high-low method, the fixed costs for a month are (Round intermediary calculations o the nearest cent. Use the "high" data month to calculate your final answer. Do not use the "low" month, as it will result in an approximation of the cost.) Number of ice cream cones 2,000 2,100 O A. $4,800 OB. $1,000 OC. $800 O D. $2,000 Total operating costs $1,800 $1,975 $2,000 $2,800 $2.175 $2.500arrow_forward
- Question 3 Assume that HASF furniture Inc., as described, currently purchases the chair cushions for its lawn set from an outside vendor for $30 per set. Modern Furniture’s chief operations officer wants an analysis of the comparative costs of manufacturing these cushions to determine whether bringing the manufacturing in-house would save the firm money. Additional information shows that if Modern furniture’s were to manufacture the cushions, the materials cost would be $16 and the labor cost would be $10 per set and that it would have to purchase cutting and sewing equipment, which would add $25,000 to annual fixed costs. NOTE: No need to enter comma between numbers Required Computation for 10,000 units What amount should have been inccrued if company produce 10,000 units What amount should have been inccrued if company purhcase 10,000 units from outside What amount company save if company make 10,000 cushionsarrow_forward3.1 REQUIRED Study the information provided below and answer the following questions:3.1.1 If the sales manager’s proposal is rejected, calculate the total revenues at break-even by using the contribution margin ratio. (4 marks) 3.1.2 Calculate the additional expenditure that the company can afford to spend on advertising, in keeping with the sales manager’s proposal. (4 marks) 3.1.3 Calculate the break-even quantity if the sales manager’s proposal is accepted (using the proposed new selling price and the increase in the advertising outlay). (4 marks)INFORMATION Denel Enterprises manufactures a product that sells for R180 each.The company presently produces and sells 120 000 units per year. Unit variable manufacturing expenses and variable selling expenses are R90 and 10% of the sales price respectively. Fixed costs are R4 536 000 for manufacturing overheads and R1 944 000 for selling and administrative activities. The sales manager has proposed that the price be increased to R216 per…arrow_forwardIdentify Fixed and Variable Costs Intuit Inc. develops and sells software products for the personal finance market, including popular titles such as Quickbooks® and TurboTax®. Classify each of the following costs and expenses for this company as either variable or fixed to the number of units produced and sold: a. Packaging costs b. Sales commissions c. Property taxes on general offices d. Shipping expenses e. Straight-line depreciation of computer equipment f. President’s salary g. Salaries of software developers h. Salaries of human resources personnel i. Wages of telephone order assistants j. Users' guidesarrow_forward
- QUESTION 32 Jerry Seavolt is requesting your assistance in determining a cost equation for foreasting his expenses for his Maple Valley Restaurant. He provides costs at two extremes as follows: 1. Identify each cost as fixed, variable or mixed 2. What are the estimated monthly fixed costs (including the fixed portion of mixed costs)? 3. What are the estimated variable costs per cover sold? Monthly Covers Monthly Covers 4,000 8,000 Cost of food sold $12,000 $24,000 Salaries $10,000 $10,000 Wages $10,000 $20,000 Employee Benefits $6,000 $8,000 Supplies $3,000 $6,000 Utilities $2,000 $3,000 Rent $2,000 $4,000 Other operating costs $4,000 $5,000 Insurance $1,000 $1,000 Depreciation $1,200 $1,200 Property taxes $1,500 $1,500arrow_forward14 Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 36,000 hours of services in Year 3. Required Required Required A B с $ b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $80 per hour, the firm can achieve 45,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…arrow_forwardQ. 8 Which following costs need to be considered for both make or buy options? O. Fixed overhead O. Variable overhead O. Rental revenue Q. 9 What is the per unit cost to purchase from the vendor? Round to the nearest penny. Q. 10 Based on your analysis, the CreativeStationary Co. should make the product in-house or buy them from the vender? O. Make O. Buy Do (Q8,9,10 plz)arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning