Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Kaitlyn Rafferty owner of Flower Poww.eperates a local chain of the shops Each shop has its own delivery van Intead of charging a flat delivery

image text in transcribed
image text in transcribed
image text in transcribed
Kaitlyn Rafferty owner of Flower Poww.eperates a local chain of the shops Each shop has its own delivery van Intead of charging a flat delivery fee, Rafferty wants to set the delivery focused on the distance diven to deliver the flower Rafferty wants to separate the bed and variabile portion of her van operating costs so that she has a better idea how delivery distance alfeds the chose towing data from the past seven month mick the icon to view the data) Read the Requirement Demand the company's cou emotion (use the output on the ceremony towde mo dodalice) Requirementatie the Power the prom here to This What does Power Power Rand indicate? The Red indicates that the cost equation plains of the variability in the data in other words, it Flower Power escondensing this quote predictol contest the volumes within the relevant and Requirement Predivan perating costs at a vu 15.500 ml suming the company would be the cost from the Excel og gardens of its Red Shoulde company to the cost estimate? The operating 15500 Should company rely on this coutume why why not? - X Data Table Month Miles Driven Van Operating Costs $5,400 ... January February... March 15,500 17,500 $5,350 = 14.400 $4.980 16.400 $5.280 April May $5.580 16.900 15.300 June $5.010 July 13,500 $4,590 Print Done Ratferty owner of Flower Power operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a fat delivery for, Rafferty wants to the delivery fee based on the distance diven to deliver wers Rafferty wants to separate the food and variatie 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 more Click the icon to view the data) the quierents mativament 1. Determine the company's cost equations the output from the Excel regression Hound the amounts to un decimal place) uirumem 2. Detainine the Round (use the output from the Excel regeerakon) Rsquared is at dous Flower Power's squared indicato? Roard indicates that the cost equation explains of the variability in the data in other words, Flower Power identing the content predicto sts at the volumes within the same relevant range equirement Predict van operating costs at a volume of 15 500 ml suming the company would use the costquation from the Easton regardless of quared Sraude company ty on this? w or why? Round your aww to the nearen seperti conto 15 500 hould the company on this contestate? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions