Sales mixPet Palace provides two types of services to dog owners: grooming and training. All company personnel can perform each service equally well. To expand sales and market share, Pet Palacmanager, Jim Jones, relies heavily on radio and billboard advertising, but next year's advertising budget is expected to be very limited. Information on projected operations for next yearfollows.Revenue per billable hourVariable cost of laborMaterial cost per billable hourGrooming Training$50$70$20$41$6$7$450,000 $468,000Allocated fixed cost per yearProjected billable hours for the year54,000 36,000a. What is Pet Palace's projected pre-tax profit (or loss) for next year? $ 0b. If $1 spent on advertising could increase grooming revenue by $20 or training revenue by $20, on which service should the advertising dollar be spent?c. If $1 spent on advertising could increase either grooming billable time or training billable time by one hour, on which service should the advertising dollar be spent?

ParticularsGroomingTrainingRevenue per billable hour $50$70Material cost per billable…

a. What is Pet Palace's projected pre-tax profit (or loss) for next year? $0 b. If $1 spent on advertising could increase grooming revenue by $20 or training revenue by $20, on which service should the advertising dollar be spent? c. If $1 spent on advertising could increase either grooming billable time or training billable time by one hour, on which service should the advertising dollar be spent?

a. What is Pet Palace's projected pre-tax profit (or loss) for next year? $0 b. If $1 spent on advertising could increase grooming revenue by $20 or training revenue by $20, on which service should the advertising dollar be spent? c. If $1 spent on advertising could increase either grooming billable time or training billable time by one hour, on which service should the advertising dollar be spent?

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter13: Nonlinear Optimization Models

Section: Chapter Questions

Problem 1P: GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special...

See similar textbooks

Similar questions

Brahma Industries sells vinyl replacement windows to home improvement retailers nationwide. The national sales manager believes that if they invest an additional $25,000 in advertising, they would increase sales volume by 10,000 units. Prepare a forecasted contribution margin income statement for Brahma if they incur the additional advertising costs, using this information:
Basu Company produces two types of sleds for playing in the snow: basic sled and aerosled. The projected income for the coming year, segmented by product line, follows: The selling prices are 30 for the basic sled and 60 for the aerosled. (Round break-even packages and break-even units to the nearest whole unit.) Required: 1. Compute the number of units of each product that must be sold for Basu to break even. 2. Assume that the marketing manager changes the sales mix of the two products so that the ratio is five basic sleds to three aerosleds. Repeat Requirement 1. 3. CONCEPTUAL CONNECTION Refer to the original data. Suppose that Basu can increase the sales of aerosleds with increased advertising. The extra advertising would cost an additional 195,000, and some of the potential purchasers of basic sleds would switch to aerosleds. In total, sales of aerosleds would increase by 12,000 units, and sales of basic sleds would decrease by 5,000 units. Would Basu be better off with this strategy?
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of 3,000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S=2R210M28RM+18R+34M, where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. a. What is the value of sales if 2,000 is spent on radio advertising and 1,000 is spent on direct-mail advertising? b. Formulate an optimization problem that can be solved to maximize sales subject to the media budget of spending no more than 3,000 on total advertising. c. Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated?
Ethical Behavior Consider the following scenario between Dave, a printer, and Steve, an assistant in the local universitys athletic department. Steve: Dave, our department needs to have 10,000 posters printed for the basketball team for next year. Heres the mock-up, and well need them in a month. How much will you charge? Dave: Well, given the costs I have for ink and paper, 1 can come in at around 5,000. Steve: Great, heres what I want you to do. Print me up an invoice for 7,500. Huts our budget. Then, when they pay you, you give me a check for 2,500. Ill make sure that you get the job. Required: CONCEPTUAL CONNECTION Is Steves proposal ethical? What should Dave do?
Product costing and decision analysis for a service company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation: Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Instructions Determine the fuel, crew, and depreciation cost per mile flown. Determine the cost per arrival or departure by terminal city. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.
Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)
Jean and Tom Perritz own and manage Happy Home Helpers, Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Required: 1. Calculate the prime cost per cleaning. 2. Calculate the conversion cost per cleaning. 3. Calculate the total variable cost per cleaning. 4. Calculate the total service cost per cleaning. 5. What if rent on the office that Jean and Tom use to run HHH increased by 1,500? Explain the impact on the following: a. Prime cost per cleaning b. Conversion cost per cleaning c. Total variable cost per cleaning d. Total service cost per cleaning
Katayama Company produces a variety of products. One division makes neoprene wetsuits. The divisions projected income statement for the coming year is as follows: Required: 1. Compute the contribution margin per unit, and calculate the break-even point in units. Repeat, using the contribution margin ratio. 2. The divisional manager has decided to increase the advertising budget by 140,000 and cut the average selling price to 200. These actions will increase sales revenues by 1 million. Will this improve the divisions financial situation? Prepare a new income statement to support your answer. 3. Suppose sales revenues exceed the estimated amount on the income statement by 612,000. Without preparing a new income statement, determine by how much profits are underestimated. 4. How many units must be sold to earn an after-tax profit of 1.254 million? Assume a tax rate of 34 percent. (Round your answer up to the next whole unit.) 5. Compute the margin of safety in dollars based on the given income statement. 6. Compute the operating leverage based on the given income statement. (Round to three significant digits.) If sales revenues are 20 percent greater than expected, what is the percentage increase in profits?
Bigdog Company distributes pet products. Its ABC system has five activities: Activity Area Cost Driver Rate in 2020 1. Order processing $50 per order 2. Line-item ordering $5 per line item 3. Store deliveries $40 per store delivery 4. Carton deliveries $6 per carton 5. Shelf-stocking $19 per stocking hour Rufus McBrain, the controller of Bigdog Company, wants to use this ABC system to examine customer profitability. He focuses on two of his customers to find out the insights he can gain from using this system. Data for these two customers in April 2020 are as follows: Pet Store Annerley RSPCA store Springwood Total orders 13 7 Average line items per order 11 19 Total store deliveries 5 7 Average cartons shipped per store delivery 21 18 Average hours of shelf stocking per store delivery 0.5 0.75 Average revenue per delivery $2,600 $1,900 Average cost of goods sold per delivery…
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is Increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Selling Next year Price (units) per Unit $ 26.00 $ 7.50 $ 41.50 $ 11.00 $ 8.80 Demand Direct Direct Product Materials Labor $ 2.10 $ 8.78 $ 3.90 $ 2.70 $ 8.48 Debbie 58,000 5e, 000 43,000 $5.10 Trish $1.90 Sarah $7.64 Mike 48, 000 $2.80 Sewing kit 333,000 $4.00 The following additional Informatlon is avallable: a. The company's plant has a capacity of 92,190 direct labor-hours per year on a single-shift basis. The company's present employees and equipment can produce all five products. b. The direct labor rate of $6 per hour is expected to remaln unchanged during the coming year. C. FIxed manufacturing costs total $600,000 per year. Varlable overhead costs are $3 per direct labor-hour. d. All of the…
Bigdog Company distributes pet products. Its ABC system has five activities: Activity Area Cost Driver Rate in 2020 1. Order processing $50 per order 2. Line-item ordering $5 per line item 3. Store deliveries $40 per store delivery 4. Carton deliveries $6 per carton 5. Shelf-stocking $19 per stocking hour Rufus McBrain, the controller of Bigdog Company, wants to use this ABC system to examine customer profitability. He focuses on two of his customers to find out the insights he can gain from using this system. Data for these two customers in April 2020 are as follows: Pet Store Annerley RSPCA store Springwood Total orders 13 7 Average line items per order 11 19 Total store deliveries 5 7 Average cartons shipped per store delivery 21 18 Average hours of shelf stocking per store delivery 0.5 0.75 Average revenue per delivery $2,600 $1,900 Average cost of goods sold per delivery…
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Next year (units) 63,000 55,000 48,000 Selling Price per Unit $ 21.00 $7.50 $36.50 $ 16.00 $ 9.30 48,000 338,000 The following additional information is available: Direct Materials $ 5.60 $ 2.40 $ 8.39 $ 3.30 $4.50 Direct Labor $ 4.20 $1.44 $ 7.80 $ 5.40 $ 0.84 a. The company's plant has a capacity of 94,310 direct labor-hours per year on a single-shift basis. The company's present employees and equipment can produce all five products. b. The direct labor rate of $12 per hour is expected to remain unchanged during the coming year. c. Fixed manufacturing costs total $650,000 per year. Variable overhead costs are $4 per direct labor-hour. d. All of the…