Question

In: Statistics and Probability

August, 2018 $250.84 September, 2018    $236.61 October, 2018 $220.70 November, 18 $230.20 December, 2018 $180.32...

August, 2018

$250.84

September, 2018   

$236.61

October, 2018

$220.70

November, 18

$230.20

December, 2018

$180.32

January 2019

$140.36

February, 2019

$160.22

March, 2019

$128.66

April 2019

$130.12

May 2019

$106.24

June 2019

$176.46

July 2019

$191.45

  1. Pick three bills from the last 12 months and change the values into z-scores. What does the z-score tell you about that particular month?
  2. Between what two values would be considered a normal bill? Remember, being within 2 Standard Deviations is considered normal.

Solutions

Expert Solution

We are given the bill charges for the last 12 months. We will first calculate the mean and standard deviation of the last 12 months bill.

Mean of the last 12 months bill, x̄ = $(250.84 + 236.61+----------------------------------------------+ 176.46 + 191.45)/12

= $179.35

Standard deviation of the last 12 months bill, σ = $√{(250.84 - 179.35)2 + (236.61 - 179.35)2 +----------------------+ (176.46 - 179.35)2 + (191.45 - 179.35)2/11

σ = $47.74

I will pick October, 2018, January, 2019 and May, 2019 to calculate the z-scores for these months.

Z- score for October 2018:

Z- score = (x̄ - µ)/σ

= (179.35 - 220.70)/47.74

= -41.35/47.74

= -0.87

Therefore, Z- score for October 2018 is -0.87.

Z- score for January 2019:

Z- score = (x̄ - µ)/σ

= (179.35 - 140.36)/47.74

= 38.99/47.74

= 0.82

Therefore, Z- score for January 2019 is 0.82.

Z- score for May 2019:

Z- score = (x̄ - µ)/σ

= (179.35 - 106.24)/47.74

= 73.11/47.74

= 1.53

Therefore, Z- score for May 2019 is 1.53.

The value of the z-score tells you how many standard deviations you are away from the mean.

The Z- score for October 2018 is -0.87 which tells us that it is 1 standard deviation below the mean. This means that the Z- score for October 2018 is less than the average bill score.

The Z- score for January 2019 is 0.82 which tells us that it is 1 standard deviation above the mean. This means that the Z- score for October 2018 is more than the average bill score.

The  Z- score for May 2019 is 1.53 which tells us that it is approximately 1.5 standard deviation above the mean. This means that the Z- score for October 2018 is much more than the average bill score.

A bill is considered normal if it is within two Standard Deviations of the average bill.

Let us find the bill under two Standard Deviations.

Two Standard Deviations below the mean bill:

Bill = x̄ - 2*σ

= $(179.35 - 2*47.74)

= $(179.35 - 95.47)

= $83.88

Thus, a bill below the two Standard Deviations of the mean bill is $83.88.

Two Standard Deviations above the mean bill:

Bill = x̄ - 2*σ

= $(179.35 + 2*47.74)

= $(179.35 + 95.47)

= $274.82

Thus, a bill above the two Standard Deviations of the mean bill is $274.82.

In conclusion, a bill would be considered normal if it is between $83.88 and $274.82.


Related Solutions

Month May June July August September October November December January Sales 350 350 250 250 350...
Month May June July August September October November December January Sales 350 350 250 250 350 550 650 750 650 Collections month 0: 80%*95% month -1: 15% month -2: 5% Payments Purchase - 70% of next month sales Purchase payment - 50% of current month purchase Purchase payment - 50% of last month purchase Lease payment 10 10 10 10 10 10 construction 0 0 0 60 0 0 wages 30 30 40 50 70 80 other 5 5 5...
The budgeted sales for Milton Machine, Inc. are shown below: August............................$12,000 September......................$10,000 October..........................$20,000 November...................... $15,000 December.........................
The budgeted sales for Milton Machine, Inc. are shown below: August............................$12,000 September......................$10,000 October..........................$20,000 November...................... $15,000 December.........................$9,000 From past experience, the company has collected 20% of the cash in the month of the sale, 50% in the month after the sale, and 30% two months after the sale occurred. Prepare a schedule of expected cash collections from sales, by month and in total for the fourth quarter of the year.
At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December.
At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . ....
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020...
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020 Tonnes Supply, total 52,295 56,466 57,389 56,675 57,238 Beginning stocks 39,478 41,949 44,234 42,674 42,274 Production 12,407 13,808 12,474 13,388 14,738 Imports 410 709 680 613 226 Ending stocks 41,949 44,234 42,674 42,274 42,660 Disappearance, total 10,346 12,232 14,714 14,401 14,578 Exports 121 256 367 191 487 Domestic disappearance 10,226 11,976 14,347 14,209 14,091 Cheddar cheese, total Supply and disposition2 September 2019 October 2019...
Budgeted Sales: September October November December January 280,000 300,000 320,000 360,000 200,000 Planning Assumptions: 25% of...
Budgeted Sales: September October November December January 280,000 300,000 320,000 360,000 200,000 Planning Assumptions: 25% of all Sales are cash. Accounts receivable are collected 60% in the month of sale, 30% in the next month, and with the final 10% in the third month. Cost of Goods sold is 40% of sales. Inventory is purchased in the month prior to the sale, 70% is paid in the month of acquisition and 30% is paid the next month. Operating Expenses: Salaries...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour...
September october November December January sales (units) 8000 12000 13000 16000 15000 Direct manufacturing labours hour per unit 1.79 1.75 1.70 1.65 1.60 Direct manufacturing labour rate per unit $15.75 $16.00 $16.50 $17.50 $17.50 Ending inventory required is the next month sales , plus one half the following months sales The ending inventory in august was 15000 units Each employee is required to contributed to canada pension plan in the order of 4.9% of wages, this is matched by the...
The following selected transactions apply to Topeca Supply for November and December 2018. November was the...
The following selected transactions apply to Topeca Supply for November and December 2018. November was the first month of operations. Sales tax is collected at the time of sale but is not paid to the state sales tax agency until the following month. Cash sales for November 2018 were $65,000 plus sales tax of 7 percent. Topeca Supply paid the November sales tax to the state agency on December 10, 2018. Cash sales for December 2018 were $83,000 plus sales...
Graham Potato Company has projected sales of $13,200 in September, $16,000 in October, $23,200 in November,...
Graham Potato Company has projected sales of $13,200 in September, $16,000 in October, $23,200 in November, and $19,200 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
Graham Potato Company has projected sales of $20,400 in September, $22,000 in October, $30,400 in November,...
Graham Potato Company has projected sales of $20,400 in September, $22,000 in October, $30,400 in November, and $26,400 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
Graham Potato Company has projected sales of $14,400 in September, $17,000 in October, $24,400 in November,...
Graham Potato Company has projected sales of $14,400 in September, $17,000 in October, $24,400 in November, and $20,400 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT