Question Details

[answered] ABC Furniture Company Year 1 January February March April M


Hello,

Could someone help provide an analysis on this? I've attached the information.


ABC Furniture Company

 

Year 1

 

January

 

February

 

March

 

April

 

May

 

June

 

July

 

August

 

September

 

October

 

November

 

December Customers Sales ($000)

 

185

 

241

 

374

 

421

 

425

 

259

 

298

 

321

 

215

 

282

 

235

 

300 230

 

301

 

310

 

389

 

421

 

300

 

318

 

298

 

202

 

265

 

312

 

298 Number

 

Month

 

1

 

January

 

2

 

February

 

3

 

March

 

4

 

April

 

5

 

May

 

6

 

June

 

7

 

July

 

8

 

August

 

9

 

September

 

10

 

October

 

11

 

November

 

12

 

December

 

Totals

 

Mean b1 0.6480 b0 111.65 Y= b0+ b1x

 

Y=111.650+0.6480x Customers

 

(x)

 

185

 

241

 

374

 

421

 

425

 

259

 

298

 

321

 

215

 

282

 

235

 

300

 

3556

 

296

 

X-bar Insert chart here Sales (y)

 

230

 

301

 

310

 

389

 

421

 

300

 

318

 

298

 

202

 

265

 

312

 

298

 

3644

 

303.67

 

Y-bar XY

 

42,550.0

 

72,541.0

 

115,940.0

 

163,769.0

 

178,925.0

 

77,700.0

 

94,764.0

 

95,658.0

 

43,430.0

 

74,730.0

 

73,320.0

 

89,400.0

 

1,122,727.0 X2

 

34,225

 

58,081

 

139,876

 

177,241

 

180,625

 

67,081

 

88,804

 

103,041

 

46,225

 

79,524

 

55,225

 

90,000

 

1,119,948 Y2

 

52,900.00

 

90,601.00

 

96,100.00

 

151,321.00

 

177,241.00

 

90,000.00

 

101,124.00

 

88,804.00

 

40,804.00

 

70,225.00

 

97,344.00

 

88,804.00

 

1,145,268.00 450

 

400

 

350

 

300

 

250

 

Axis Title 200

 

150

 

100

 

50

 

0

 

150 200 250 300 Axis Title 200 250 300

 

Axis Title 350 400 450 ABC Furniture Company

 

b1 0.6480 Year 2 b0 111.65 January

 

February

 

March

 

April

 

May

 

June

 

July

 

August

 

September

 

October

 

November

 

December

 

Totals Y= b0+ b1x

 

Y=111.650+0.6480x Customers (x)

 

215

 

259

 

325

 

354

 

258

 

199

 

254

 

299

 

264

 

198

 

223

 

261

 

259.08 Sales

 

Actual Y(t)

 

Forecast F(t)

 

230

 

260

 

331

 

384

 

278

 

210

 

265

 

299

 

293

 

215

 

257

 

250

 

272.67 251

 

279

 

322

 

341

 

279

 

241

 

276

 

305

 

283

 

240

 

256

 

281

 

279.54 Variance

 

-21.0

 

-19.5

 

8.8

 

43.0

 

-0.8

 

-30.6

 

-11.2

 

-6.4

 

10.3

 

-25.0

 

0.8

 

-30.8

 

-6.87 Forcast ve

 

400

 

350

 

300

 

250 Axis Title 200

 

150

 

100

 

50

 

0

 

200 220 240 260 Forcast versus Actual Sales

 

400

 

350

 

300

 

250 is Title 200

 

150

 

100

 

50

 

0

 

200 220 240 260 280 300 Axis Title 320 340 360 380 400

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001003893.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now