Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process

"Plantcity is a large nursery and retail store specializing in house and garden

plants and supplies. Jean Raouth, the assistant manager, is in the process of

budgeting monthly supplies expense for 2019. She assumes that in some way

supplies expense is related to sales, either in units or in dollars. She has

collected these data for sales and supplies expenses for June 2016 through

December 2018, and has estimated sales for 2019. "

Data

Date "Supplies

Expense" Sales (Units) Sales (Dollars)

June-16 $2,745 354 $20,090

July-16 $3,200 436 $21,900

Aug-16 $3,232 525 $28,780

Sep-16 $2,199 145 $18,560

Oct-16 $2,321 199 $21,680

Nov-16 $3,432 543 $21,520

Dec-16 $4,278 1,189 $24,630

Jan-17 $2,310 212 $19,990

Feb-17 $2,573 284 $21,900

Mar-17 $2,487 246 $18,940

April-17 $2,484 278 $21,340

May-17 $3,384 498 $32,100

June-17 $2,945 424 $28,500

July-17 $2,758 312 $22,650

Aug-17 $3,394 485 $24,350

Sept-17 $2,254 188 $18,930

Oct-17 $2,763 276 $22,320

Nov-17 $3,245 489 $30,040

Dec-17 $4,576 1,045 $33,090

Jan-18 $2,103 104 $21,950

Feb-18 $2,056 167 $20,450

Mar-18 $3,874 298 $23,010

April-18 $2,784 398 $23,450

May-18 $2,345 187 $18,150

June-18 $2,912 334 $20,940

July-18 $2,093 264 $19,340

Aug-18 $2,873 333 $20,540

Sept-18 $2,563 143 $19,770

Oct-18 $2,384 245 $18,570

Nov-18 $2,476 232 $21,890

Dec-18 $3,364 1,122 $34,330

Jan-19 180 $16,000

February-19 ` 230 $20,000

March-19 190 $19,000

April-19 450 $24,000

May-19 350 $23,000

June-19 350 $23,000

July-19 450 $25,000

August-19 550 $30,000

September-19 300 $25,000

October-19 300 $25,000

November-19 450 $32,000

December-19 950 $39,000

Required

"1. Develop the regression that Jean should use based on the data and

evaluate the reliability and precision of the regression you have chosen. "

2. What are the predicted monthly figures for supplies expense for 2019?

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

Intermediate Accounting Volume 1

Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod Dick

7th Edition

1260306747, 978-1260306743

More Books

Students also viewed these Accounting questions

Question

Why does HTTP use TCP and DNS use UDP?

Answered: 1 week ago

Question

1. What factors lead to criminal behaviour?

Answered: 1 week ago

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago