You are recently appointed as a centralized “Cost Control Analyst” for one of the bank in...

You are recently appointed as a centralized “Cost Control Analyst” for one of the bank in Toronto. Head of Banking operations in Toronto Mr. Horton has asked you to analyse the cost of basic stationary as Stationary in different regions of the bank seems to be one of the highest cost. He wants you to come up with your statistical analysis with two pager report. Use Central tendencies, Standard deviation and Regression analysis techniques along with graphical representation. (30 Marks

OrderDate	Region	Rep	Item	Units	UnitCost	Total
1/6/2019	East	Jones	Papers	95	1.99	189.05
1/23/2019	Central	Kivell	Files	50	19.99	999.50
2/9/2019	Central	Jardine	Papers	36	4.99	179.64
2/26/2019	Central	Gill	Pen	27	19.99	539.73
3/15/2019	West	Sorvino	Papers	56	2.99	167.44
4/1/2019	East	Jones	Files	60	4.99	299.40
4/18/2019	Central	Andrews	Papers	75	1.99	149.25
5/5/2019	Central	Jardine	Files	90	4.99	449.10
5/22/2019	West	Thompson	Papers	32	1.99	63.68
6/8/2019	East	Jones	Files	60	8.99	539.40
6/25/2019	Central	Morgan	Pen	90	4.99	449.10
7/12/2019	East	Howard	Files	29	1.99	57.71
7/29/2019	East	Parent	Files	81	19.99	1,619.19
8/15/2019	East	Jones	Papers	35	4.99	174.65
9/1/2019	Central	Smith	Files	2	19.99	138
9/18/2019	East	Jones	Pen Set	16	15.99	255.84
10/5/2019	Central	Morgan	Files	28	8.99	251.72
10/22/2019	East	Jones	Pen	64	8.99	575.36
11/8/2019	East	Parent	Pen	15	19.99	299.85
11/25/2019	Central	Kivell	Pen Set	96	4.99	479.04
12/12/2019	Central	Smith	Papers	67	1.29	86.43
12/29/2019	East	Parent	Pen Set	74	15.99	1,183.26
1/15/2020	Central	Gill	Binder	46	8.99	413.54

Expert Solution

The various statistical measures for the report

Sorted Data
Region	Rep	Item	Units	Unit Cost	Total
Central	Andrews	Papers	75.00	1.99	149.25
Central	Andrews	Papers	75.00	1.99	149.25
Central	Gill	Pen	27.00	19.99	539.73
Central	Gill	Pen	27.00	19.99	539.73
Central	Jardine	Files	90.00	4.99	449.10
Central	Jardine	Files	90.00	4.99	449.10
Central	Jardine	Papers	36.00	4.99	179.64
Central	Jardine	Papers	36.00	4.99	179.64
Central	Kivell	Files	50.00	19.99	999.50
Central	Kivelll	Files	50.00	19.99	999.50
Central	Morgan	Pen	90.00	4.99	449.10
Central	Morgan	Pen	90.00	4.99	449.10
Central	Smith	Files	2.00	19.99	39.98
East	Howard	Files	29.00	1.99	57.71
East	Jones	Fies	60.00	8.99	539.40
East	Jones	Files	60.00	4.99	299.40
East	Jones	Files	60.00	8.99	539.40
East	Jones	Files	60.00	4.99	299.40
East	Jones	Papers	95.00	1.99	189.05
East	Jones	Papers	95.00	1.99	189.05
East	Jones	Papers	35.00	4.99	174.65
East	Jones	Pen Set	16.00	15.99	255.84
East	Parent	Files	81.00	19.99	1619.19
West	Sorvino	Papers	56.00	2.99	167.44
West	Sorvino	Papers	56.00	2.99	167.44
West	Thompson	Papers	32.00	1.99	63.68
West	Thompson	Papers	32.00	1.99	63.68

Region	# of Transactions	Total Spent	Average Spent	Standard Deviation
Central	13.00	5572.62	428.66	292.11
East	10.00	4163.09	416.31	426.68
West	4.00	462.24	115.56	51.88
Total	27.00	10197.95	377.70	347.70

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.001869628
R Square	3.49551E-06
Adjusted R Square	-0.039996365
Standard Error	361.3411975
Observations	27

	Coefficients	Standard Error
Intercept	376.5333903	143.036
Sl	0.083461538	8.928131

The regression equation is y(Date number) = 376.533 + 0.083 x (Spent)

RESIDUAL OUTPUT

Observation	Predicted Total	Residuals
1	376.6168519	-187.567
2	376.7003134	622.7997
3	376.7837749	-197.144
4	376.8672365	162.8628
5	376.950698	-209.511
6	377.0341595	-77.6342
7	377.1176211	-227.868
8	377.2010826	71.89892
9	377.2845442	-313.605
10	377.3680057	162.032
11	377.4514672	71.64853
12	377.5349288	-188.485
13	377.6183903	621.8816
14	377.7018519	-198.062
15	377.7853134	161.9447
16	377.8687749	-210.429
17	377.9522365	-78.5522
18	378.035698	-228.786
19	378.1191595	70.98084
20	378.2026211	-314.523
21	378.2860826	161.1139
22	378.3695442	70.73046
23	378.4530057	-320.743
24	378.5364672	1240.654
25	378.6199288	-203.97
26	378.7033903	-338.723
27	378.7868519	-122.947

orchestra answered 3 years ago

Accounting Theory You have been recently appointed as a lending officer in a large bank. The...

Accounting Theory You have been recently appointed as a lending officer in a large bank. The bank is concerned about lending in the current economic environment, where there has been an economic downturn. Prepare a report outlining what agency problems the bank should be concerned with and how debt covenants in debt agreements can be used to reduce those problems. Also explain how accounting numbers can be used to assist in the process? Required: Using the reference materials available on...

You have been recently hired by Bank of Wealth Investment Brokers as a Portfolio Analyst. On...

You have been recently hired by Bank of Wealth Investment Brokers as a Portfolio Analyst. On your first day in the position, the Portfolio Manager requested that you design a short in-service training session for the new research interns in your department on the mechanics of the primary and secondary markets, including the various types of security regulators and a brief history of the stock market. You will need to develop an Information Sheet that explains the similarities and differences...

anielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies Inc. One of...

anielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies Inc. One of Danielle's first assignments was to perform a net present value analysis for a new warehouse. Danielle performed the analysis and calculated a present value index of 0.75. The plant manager, Jerrod Moore, is very intent on purchasing the warehouse because he believes that more storage space is needed. Jerrod asks Danielle into his office and the following conversation takes place: Jerrod: Danielle, you're new...

Mary Smith, a CFA candidate, was recently hired for an analyst position at the Bank of...

Mary Smith, a CFA candidate, was recently hired for an analyst position at the Bank of Ireland. Her first assignment is to examine the competitive strategies employed by various French wineries. Smith’s report identifies four wineries that are the major players in the French wine industry. Key characteristics of each are cited in the table below. In the body of Smith’s report, she includes a discussion of the competitive structure of the French wine industry. She notes that over the...

You are appointed as a credit manager in the local branch of ZAA Bank that is...

You are appointed as a credit manager in the local branch of ZAA Bank that is situated in an industrial area. Most customers are businesses. Provide a brief summary of important credit risk factors relating to the following forms of business that you as a banker should keep in mind: a. Sole proprietor b. Partnership c. Private company

you have recently been appointed as a board member to the Hospital System. You are a...

you have recently been appointed as a board member to the Hospital System. You are a labor law attorney who has worked for the hospital for nearly 10 years. Now, you must help to determine whether the hospital should consider a bond to finance a major hospital renovation bond. Identify the factors you believe to be most critical to consider during this renovation bond decision. summarize your decoision

2). a). You have been recently appointed as a CEO of a distressed Bankand you are...

2). a). You have been recently appointed as a CEO of a distressed Bankand you are to produce a 5-Year Strategic Plan to position the Bank as a market leader. Discuss the process of producing a strategic plan for the Bank for next 5 years as a sustainable Bank Leader. The following are your KPIs from your Board of Directors: Return on Equity (ROE) of more than 25% Market share of Assets & Deposits of more than 12% (Current market...

You are a recently appointed audit partner in a large independent firm of accountants. You are...

You are a recently appointed audit partner in a large independent firm of accountants. You are delighted that you are now a partner and can’t wait to sign off your first set of accounts. Your firm recently won an audit tender for a medium-sized family owned company, A Ltd, and the firm’s managing partner has allocated the client to you. The managing partner is reasonably close to the family which owns A Ltd and you believe that this is at...

Four hospitals located in one city are cooperating to establish a centralized blood-bank facility to serve...

Four hospitals located in one city are cooperating to establish a centralized blood-bank facility to serve them all. On an xy coordinate grid of the city, the hospitals are found at the following locations: Hospital 1 = (x = 5, y = 10), Hospital 2 = (7, 6), Hospital 3 = (4, 2), and Hospital 4 = (16, 3). The expected number of deliveries per month from the blood bank to each hospital is estimated at 450, 1200, 300, and...

You were recently appointed to the board of directors for Dropbox. a. What are the main...

You were recently appointed to the board of directors for Dropbox. a. What are the main responsibilities of the board of directors? b. Suppose that Microsoft just approached Dropbox about acquiring it. You and the board decide to ght this takeover attempt. What tools could you use to deter Microsoft? c. How does the Sarbanes-Oxley Act and the Dodd-Frank Act affect the board of directors at Dropbox? d. Suppose that an activist investor at Dropbox is attempting to remove the...

Question