Kelly Battle, owner of Rose Red, operates a local chain of floral shops. Each shop has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kelly Battle, owner of Rose Red, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Battle wants to set the delivery fee based on the distance driven to deliver the flowers. Battle 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. She has the following data from the past seven months: E (Click the icon to view the data.) Data Table Read the requirements. Requirement 1. Determine the company's cost equation (use the output from the Excel regression). (Round the amounts to two decimal places.) Month Miles Driven Van Operating Costs y = $ 27 X + $ 947.20 January 16,400 $5,480 February. 17,500 $5,400 Requirement 2. Determine the R-square (use the output from the Excel regression). March 15,000 $4,950 The R-square is 0.847169 April 16,100 $5,270 What does Rose Red's R-square indicate? May 17,300 $5,740 June 15,600 $5,440 The R-square indicates that the cost equation explains 84.7% of the variability in the data. In other words, it does not fit the data at all. Rose Red should feel confident us July. 14,500 $4,680 range. Requirement 3. Predict van operating costs at a volume of 16,000 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should nearest cent.) Print Done The operating costs at a volume of 16,000 miles is $ 5267.20 Should the company rely on this cost estimate? Why or why not? Since the r-square is over .80 the company should use the cost equation with caution. Kelly Battle, owner of Rose Red, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Battle wants to set the delivery fee based on the distance driven to deliver the flowers. Battle 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. She has the following data from the past seven months: E (Click the icon to view the data.) Data Table Read the requirements. Requirement 1. Determine the company's cost equation (use the output from the Excel regression). (Round the amounts to two decimal places.) Month Miles Driven Van Operating Costs y = $ 27 X + $ 947.20 January 16,400 $5,480 February. 17,500 $5,400 Requirement 2. Determine the R-square (use the output from the Excel regression). March 15,000 $4,950 The R-square is 0.847169 April 16,100 $5,270 What does Rose Red's R-square indicate? May 17,300 $5,740 June 15,600 $5,440 The R-square indicates that the cost equation explains 84.7% of the variability in the data. In other words, it does not fit the data at all. Rose Red should feel confident us July. 14,500 $4,680 range. Requirement 3. Predict van operating costs at a volume of 16,000 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. Should nearest cent.) Print Done The operating costs at a volume of 16,000 miles is $ 5267.20 Should the company rely on this cost estimate? Why or why not? Since the r-square is over .80 the company should use the cost equation with caution.
Expert Answer:
Answer rating: 100% (QA)
1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 5 ... View the full answer
Related Book For
Modeling the Dynamics of Life Calculus and Probability for Life Scientists
ISBN: 978-0840064189
3rd edition
Authors: Frederick R. Adler
Posted Date:
Students also viewed these accounting questions
-
A cell starts at a volume of 600 m3 and loses volume at a rate of 2 m3 per second.
-
A cell starts at a volume of 400 m3 and gains volume at a rate of 3 m3 per second.
-
A cell starts at a volume of 900 m3 and loses volume at a rate of 2t m3 per second.
-
1. (a) Label Earth's layers as shown in the diagram below. (1 pt each; 4 pts total) X Y W: X: Y: Z: W (b) Explain how these layers formed (early in Earth's history). (7 pts) Z
-
Consider the CEO in the background information example who is considering creating subsistence level jobs. Do American corporations have a moral duty to pay reasonable living wages to workers outside...
-
Monochromatic light of wavelength 620 nm passes through a very narrow slit S and then strikes a screen in which are two parallel slits, S1 and S2, as in Figure P37.70. Slit S1 is directly in line...
-
How is technology being used by firms to promote their products and how does this influence sales activities?
-
Consider again the profit-maximizing decision of Beths Lawn Mowing Service from Problem. Suppose Beths greedy father decides to charge for the use of the family lawn mower. a. If the lawn mower...
-
Florida is an employment at will state, what does that mean legally in the workplace? Explain the law. How does Florida being an employment at will state effect contract negations with unions and...
-
Use the construction in the proof of Theorem 1.45 to give the state diagrams of NFAs recognizing the union of the languages described in a. Exercises 1.6a and 1.6b. b. Exercises 1.6c and 1.6f....
-
The following Course Outcome is assessed in this assignment: AC555-4: Plan to conduct a fraud examination and investigation. Final Fraud Report Assignment Access Case 5 and 6 from the Fraud...
-
Maslows hierarchy of needs a. is a theory of why people are motivated. b. uses three factors to compute the motivation of a person in a situation. c. was developed to address the Hawthorne effect. d....
-
Why are these issues sometimes difficult to talk about? What could make conversations both more comfortable and productive?
-
What are some differences among affirmative action, diversity, and inclusiveness?
-
The corporate culture is a. is a set of rules written down and distributed. b. the values and behaviors shared by managers and workers. c. defined by the country where the corporate headquarters are...
-
Jennifer Zhang was reviewing her credit card statement and noticed several charges that didnt look familiar to her. Jennifer is unsure whether she should pay the bill in full and forget about the...
-
A. Firms often pay managers a percent of profits to encourage them to work longer hours for the company. Managers are often conflicted by the desire for extra income and the reduction of leisure time...
-
Synthesize the products by drawing out reagents and intermediates along the way. `N H. OH HO HO
-
Many equations can also be solved by repeatedly applying a discrete-time dynamical system. Compare the following discrete-time dynamical systems with the Newton's method discrete-time dynamical...
-
Suppose p1 = 0.25 and p2 = 0.75. Find and graph the probability distribution for the total number inside. Find the expectation and the variance (this can be written as the sum of two binomial random...
-
The population in Section 7.8, Exercise 39, where per capita production is a random variable with p.d.f. g(x) = 5.0 for 1.0 x 1.2. Use the normal approximation to test the above hypotheses about...
-
Natural gas (methane) flows from a 3-in.-diameter gas main, through a 1-in.-diameter pipe, and into the burner of a furnace at a rate of \(100 \mathrm{ft}^{3} /\) hour. Determine the pressure in the...
-
Calculate the Reynolds numbers for the flow of water and for air through a 4-mm-diameter tube, if the mean velocity is \(3 \mathrm{~m} / \mathrm{s}\) and the temperature is \(30^{\circ} \mathrm{C}\)...
-
SAE 30 oil at \(60^{\circ} \mathrm{F}\) flows through a 2-in.-diameter pipe with a mean velocity of \(5 \mathrm{ft} / \mathrm{s}\). Determine the value of the Reynolds number (see Example 1.4)....
Study smarter with the SolutionInn App