Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

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

Technical Guide On Internal Auditing Including Internal Audit Survey 2014

Authors: Taxmann

2015th Edition

9350716615, 978-9350716618

More Books

Students also viewed these Accounting questions