Kallie Jungemann, owner of Flowers 4 You, operates a local chain of fioral shops. Each shop...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kallie Jungemann, owner of Flowers 4 You, operates a local chain of fioral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers. Jungemann wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. Flowers 4 You does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows: E (Click the icon to view the regression analysis.) Requirements 1. Determine the firm's cost equation (use the output from the Excel regression). 2. Determine the R-square (use the output from the Excel regression). What does Flowers 4 You's R-square indicate? 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should the company rely on this cost estimate? Why or why not? SUMMARY OUTPUT Regression Statistics Multiple R 0.95 R Square 0.90 Adjusted R Square 0.87 Standard Error 124.99 Observations ANOVA df MS F Significance F Regression 1 668,089.58 668,089.58 42.77 0.0013 78,110.42 15,622.08 Residual 746,200.00 Total Standard Lower Upper Coefficients Error t Stat P-value 95% 95% Intercept 931.23 678.87 1.37 0.23 -813.87 2,676.33 X Variable 1 0.04 6.54 0.00 0.17 0.39 0.28 5 Kallie Jungemann, owner of Flowers 4 You, operates a local chain of fioral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers. Jungemann wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. Flowers 4 You does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows: E (Click the icon to view the regression analysis.) Requirements 1. Determine the firm's cost equation (use the output from the Excel regression). 2. Determine the R-square (use the output from the Excel regression). What does Flowers 4 You's R-square indicate? 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should the company rely on this cost estimate? Why or why not? SUMMARY OUTPUT Regression Statistics Multiple R 0.95 R Square 0.90 Adjusted R Square 0.87 Standard Error 124.99 Observations ANOVA df MS F Significance F Regression 1 668,089.58 668,089.58 42.77 0.0013 78,110.42 15,622.08 Residual 746,200.00 Total Standard Lower Upper Coefficients Error t Stat P-value 95% 95% Intercept 931.23 678.87 1.37 0.23 -813.87 2,676.33 X Variable 1 0.04 6.54 0.00 0.17 0.39 0.28 5
Expert Answer:
Related Book For
Posted Date:
Students also viewed these organizational behavior questions
-
Kara Woo, owner of Flower Power, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Woo wants to set the delivery fee based on the...
-
Martha LaChance, owner of Posies Unlimited, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, LaChance wants to set the delivery fee...
-
Alice Jungemann, owner of Flower Power, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Jungemann wants to set the delivery fee...
-
Factor each trinomial. 4(m 5)2 4(m 5) 15
-
Assume that each sample is obtained by randomly selecting values from a population with a normal distribution. The listed values are waiting times (in minutes) of customers at the Humber Valley...
-
In the context of emergency response planning, how does Process Safety Management ensure readiness and effective coordination during a process safety incident? Analyze the role of drills, training,...
-
A survey consists of asking people for their blood types (O, A, B, and AB), including whether they are Rh-positive or Rh-negative. Determine the number of outcomes and identify the sample space.
-
Tabares Corporation had these transactions during 2017. (a) Issued $50,000 par value common stock for cash. (b) Purchased a machine for $30,000, giving a long-term note in exchange. (c) Issued...
-
Let r(t) = (3t2, sin(t) - tcos(t), cos(t) + tsin(t)), t > 0. (a) Find the vectors unit tangent vector T and unit normal vector N. (b) Find the curvature. (c) Find the binormal vector B. (b) Find the...
-
The Harvard Co-op orders sweatshirts with the Harvard University emblem on them and sells them for $50 each. During a typical month, 900 sweatshirts are sold (this includes all styles and sizes...
-
Graph the theoretical combined water supply if you put a 750 gpm at 50 psi centrifugal fire pump on the water supply from Question 10. Assume 5 psi of friction loss between the effective point of the...
-
Provide an underpinning rationale in support of the development and practice of strategically integrated recruitment and selection;
-
What obstacles do you think may stand in the way of an attempt by organisations to adopt a new style of management in which the new style manager is supportive, a team leader, a coach and facilitator?
-
It is common practice for companies to make two allowances for doubtful accounts: 1. The specific allowance is based on accounts the company has reason to suspect may not be paid. 2. The general...
-
For each of the above In Practice Cases answer the following question and justify your answer with reference to case evidence: Which of the six strands of strategic integration are evident in the...
-
Critically evaluate the extent to which strategic human resource planning represents the vital connecting link between organisational strategy and SHRM practice;
-
Calculate the following, and report your answers in scientific notation. a) 235.15 cm + 9.2 cm + 35.111 cm b) (6.555e-3 cm) /(0.010 cm) Questior To a beaker weighing 0.2996 kg. you add 8710. cg of...
-
Planning: Creating an Audience Profile; Collaboration: Team Projects. Compare the Facebook pages of three companies in the same industry. Analyze the content on all available tabs. What can you...
-
Paulson Auto Components has an inventory of 490 obsolete remote entry keys that are carried in inventory at a manufacturing cost of $79,870. Production Supervisor Ricky Lewis must decide to do one of...
-
One subunit of Charles Sports Company had the following financial results last month: Requirements 1. Complete the performance evaluation report for the subunit (round to three decimal places). 2....
-
Bentfi eld Dry Cleaners has determined the following about its costs: Total variable expenses are $32,000, total fixed expenses are $25,200, and the sales revenue needed to break even is $42,000....
-
What is meant by the statistical significance of differences? How does this notion underpin marketing research?
-
Do association analysis and the correlation coefficient explicitly assume a cause-and-effect relationship? State the reasons for your answer.
-
What must be determined before using correlation? Why is it essential?
Study smarter with the SolutionInn App