Just use your Excel regression results and type up a Word document with your answers...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Just use your Excel regression results and type up a Word document with your answers to these questions
Susan lewis owner of a florist shop is interested in predicting the cost of delivering floral arrangements . she collected monthly data on the number of deliveries and the total monthly delivery cost for the past year.
month number of deliveries delivery cost
january 100 1,200
febuary 550 1,800
march 85 1,100
april 115 1,050
may 160 1,190
june 590 1,980
july 500 1,800
august 520 1,700
september 100 1,100
october 200 1,275
november 260 1,400
december 450 2,200
#1 How much is the fixed cost of labor per month?
#2 How much is the variable rate per delivery?
#3 What would the cost formula be to use to predict future delivery cost?
#4 Using that cost formula, calculate the budgeted cost for next month, assuming that 305 deliveries are expected.
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.