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
-
Do you agree with the statement that ''debits mean increase and credits mean decrease''? If not, what do debit and credit mean?
-
A helicopter has a rotor diameter of 30 ft and it is being operated in a hover at 286.5 rpm. Find the tip speed Vt of the rotor.
-
A sociologist surveys a sample of college students to determine whether there are differences in the attitudes and behaviors of male and female students. The survey contains 20 questions. For one...
-
The following pension-related data pertain to Metro Recreation's noncontributory, defined benefit pension plan for 2011: Required: Prepare a pension spreadsheet that shows the relationships among the...
-
Assignment The width of a carriage way approaching an intersection is given as 15 m. The entry and exit width at the rotary is 8 m. The traffic approaching the intersection from the four sides is...
-
Required - Please submit the following two documents: 1. Using Excel, submit the following: i. ii. Calculate Rashmika's minimum net income for tax purposes in accordance with the ordering provisions...
-
6. The equation, In y + y = 1-2 ln x -0.2(lnx) defines y as a function of x for x > 0, y > 0. Compute y' and show that y' = 0 for x = e-5.
-
Y was involved with a gang and was being observed by the FBI. Gang was plotting to make explosives to kill the governor. Rival gang informant who has been reliable in the past told the FBI about the...
-
Police officers noticed two capsules on top of Mr. Rochin's dresser table. They asked Mr. Rochin whose "stuff" is this. Mr. Rochin grabbed the capsules and put them in his mouth and swallowed the...
-
Sheridan Corporation manufactures wireless soundbar speakers. It is a division of Vany TV, which manufactures televisions. Sheridan sells the speakers to Vany as well as to retail stores. The...
-
Each student shall include a "reflection" piece in the portfolio. This reflection shall be a minimum of seven fifty words. The student will reflect on their experiences and courses at DTCC in the...
-
Should Gillham try to improve pay levels? Why or why not and in what ways (e.g., indirect/non-financial components)
-
To what extent does the digital revolution augment or diminish the traditional mechanisms of social capital formation and maintenance, particularly in the context of virtual communities and online...
-
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...
-
How does the presence of a whistle-blowing process improve quality control and independence at a public accounting firm?
-
Trish Mulcahy, a new junior in your office, says that she does not understand why she cannot work on the audit of a company that is a client of your firm and that is owned by her uncle. Trish says...
-
How do these standards differ for (1) errors, (2) frauds, (3) direct-effect illegal acts, and (4) far-removed-effect illegal acts?
Study smarter with the SolutionInn App