Question

Multiple Regression Sweet Dreams Bakerý was started five years ago by Della Fontera who was known for her breads, sweet rolls, and personalized cakes. Della had kept her accounting system simple, believing that she had a good intuitive handle on costs. She had been using the following formula to describe her monthly overhead costs: Overhead cost $7,800+ $7.5 (direct labor hours) For breads and sweet rolls that were available in the bakery case each day, she applied a standard pricing system. For special orders, however, Della needed her cost formula to help her come up with an estimated cost for the personalized cake or wedding cake. To that cost, she applied a markup percentage. Lately, however, the increase in the variety of orders and the elaborateness of the wedding cakes made her wonder if a more sophísticated view of costs would help her in planning, budgeting, and pricing. After some late-night discussions with her workers, Della determined that Sweet Dreams' expansion into wedding cakes and gift baskets had made special orders a more complex operation. The various shapes of the wedding cake tiers had required Della's investing in different-sized cake pans, as well as decorating tips for ing. The different iding patterns and elaborate designs took much more time for icing, as well. In addition, while a five-year-oid s birthday cake just requires that the child's name and (possibly) the superhero's name are spelled correctly, a wedding cake is a once-in-a-lifetime item that must achieve perfection. (Della hated to ase the term "bridezilla but..) Gift baskets required Della to stock baskets, cellophane, and bows. Then when an order a worker had to stop baking to arrange the muffins and breads artfully in the basket, wrap it, and tie the bow. While it seemed simple enough, this direct labor hours was stil, an important variable, but so were the number of wedding cakes and gift baskets took time and thought. Thus, the number of Della rummaged through her college textbooks and found informationion regr ession. Then, with help from one of her computer savvy workers, she ran ata for Sweet Dreams for three independent variablès: pumber of direct labor hours, the number of multiple regression tables for the past 24 months ofd wedding cakes, and the number of gift baskets. The following printout was obtained multiple regr wedding cakes, and the number of gift baskets. The following printout was obtained: tables for the past 24 months of data for S Dreams for three independent variables: number of direct labor hours, the of t for He Standard Error Estimate Parameter- P,>t of Parameter $1,980 $2.54 $67.40 93.00 3.60 5.58 $2.20,2.96 264.00 0.89 3.19 0.75 Intercept Number of direct labor hours (X) Number of wedding cakes (Xa) Number of gift baskets (%) R2-0.92 s.- 65 Observations: 24 Required: 0.0001 0.0050 0.0050 0.0250 1. Write out the cost equation for Sweet Dreams' monthly overhead cost. x2 + X3 2. Suppose that next month Sweet Dreams expects to have 550 direct labor hours, 33 wedding cakes, and 24 gift baskets. What is the expected overhead? (Round your answer to the nearest dollar amount.) 3. What is your evaluation of the cost equation that was developed for the cost of overhead based on the R' in this equation? 958 PM 2019 eBook Number of wedding cakes (Xa) Number of gift baskets (%) R 0.92 S-65 Observations: 24 Required: $67.40 0.0050 3.19 $2.20 2.96 0.0250 0.75 1. Write out the cost equation for Sweet Dreams monthly overhead cost. xr t 2. Suppose that next month Sweet Dreams expects to have 550 direct labor hours, 33 wedding cakes, and 24 gift baskets. What is the expected overhead? (Round your answer to the nearest dollar amount,) is your evaluation of the cost equation that was developed for the cost of 3. What Suppose that Sweet Dreams charges an extra $2.50 to prepare a gift basket. This charge is in addition to the price charged for the items (e.g., muffins) that the customer chooses to put into the basket. Can Della compare the additional cost of a gift basket ($2.20) to the arice charged of $2.50 59 PM &2019

Answer 1

1. From the output, it is clear that the regression coefficients, P, is 1,980, A is 2.56, B, is 67.40 and B, is 2.20. Hence, the cost equation for Sweet Dreams' monthly overhead cost is Y-1,980+2.56X, +67.40X, +2.20X, 2. The predicted value for 550 direct labor hours, 35 wedding cakes, and 20 gift baskets is calculated as follows: Y-1,980+(2.56x550) (67.40x35)+(2.20x20) -1,980+1,408+2,359+44 5, 791 Hence, the predicted value is 5,791 3. obtain the 95% confidence interval. The value fo r confidence interval is derived as follows: Y±t,r.xs, 5.791 ± (2.4055 x 65) 5,791 +156.36 (5,634.64,5,947.36) Hence, the 95% confidence interval for the predicted value is l 5.63464 Y-5.94736

4) From the output, it is clear that R-square value is 0.92 or 92% which implies that the coefficient of determination for predictors. That is, the independent variables given at 92% information to the multiple regression model.