Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Home Office Inc is a large stationery retail store specializing in office supplies. Anthony Vella, the assistant manager, is in the process of budgeting monthly

Home Office Inc is a large stationery retail store specializing in office supplies. Anthony Vella, the assistant manager, is in the process of budgeting monthly supplies expense for 2022. He assumes that in some way supplies expense is related to sales, either in units or in dollars. He has collected these data for sales and supplies expenses for January 2020 through to December 2021, and has estimated sales for 2022. As Shown Below

Question : Develop the regression that Anthony should use based on the data, and evaluate the reliability and precision of the regression you have chosen.

image text in transcribed
B C D E G Supplies Date Expense Sales (Units) Sales (Dollars) January-20 2,310 212 $ 19,990 February-20 2,573 284 21,900 March-20 2,487 246 18,940 April-20 2,484 278 21,340 May-20 3,384 498 32, 100 June-20 2,945 424 28,500 July-20 2,758 312 22,650 August-20 3,394 485 24,350 10 September-20 2, 199 188 18,930 October-20 2,763 276 22,320 12 November-20 3.245 489 30,040 13 December-20 4,576 692 32,090 14 January-21 2, 103 104 21,950 15 February-21 2,056 167 20,450 16 March-21 3,874 298 23,010 April-21 2,784 398 23,450 May-21 2,345 187 18, 150 19 June-21 2,912 334 20,940 20 July-21 2,093 264 19,340 August-21 2,873 333 20,540 22 September-21 2,254 143 19,770 23 October-21 2,384 245 18,570 24 November-21 2,476 232 21,890 25 December-21 3,364 560 30,303 26 January-22 180 18,500 27 February-22 230 20,000 28 March-22 190 19,000 29 April-22 450 24,000 30 May-22 350 21,250 31 June-22 350 23,000 32 July-22 450 25,000 33 August-22 560 30,000 34 September-22 300 24.500 35 October-22 300 $ 25,000 36 November-22 450 32,000 37 December-22 600 33,500 38 39 Question One Question Two Question Three

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

Cambridge IGCSE And O Level Accounting Coursebook

Authors: Catherine Coucom

2nd Edition

1316502775, 978-1316502778

More Books

Students also viewed these Accounting questions

Question

Did the researcher do a confirmability audit?

Answered: 1 week ago