Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600...

Jan	523.9
Feb	510.23
March	545.65
April	514.23
May	550.71
June	505.34
July	525.34
August	600
Sept.	569.42
October	500.2
Novem.	533.12
December	507.11

What percentage of your bills are within two standard deviations of the mean?

Expert Solution

The answer is:

First, we calculate the mean, standard deviation. Then we calculate the upper and lower limits of the 2 SD of the mean as shown below:

Mean	532.1041667
SD	29.85258675
Mean - 2*SD	472.40
Mean + 2*SD	591.81

Then test whether individual values are within this interval or not:

Month	Amount	Is between Mean - 2SD and Mean + 2SD
Jan	523.9	TRUE
Feb	510.23	TRUE
Mar	545.65	TRUE
Apr	514.23	TRUE
May	550.71	TRUE
Jun	505.34	TRUE
Jul	525.34	TRUE
Aug	600	FALSE
Sep	569.42	TRUE
Oct	500.2	TRUE
Nov	533.12	TRUE
Dec	507.11	TRUE

Then ratio is simply 11/12

Using excel to answer the same:

Calulations:

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!

orchestra answered 1 year ago

Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...

Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC SALES 200,000 230,000 150000 210,000.00 220,000.00 170,000.00 160,000.00 150,000.00 180,000.00 210,000.00 220,000.00 210,000.00 COLLECTIONS: No cash Sales 30 days 50% 60 days 50% TOTAL CASH RECEIPTS CASH DISBURSEMENTS SUPPLIES 70% PAYABLES/SUPPLIES paid next month(in 30 days) SALARIES/OVER monthly 40000 INTEREST monthly 1000 DIVIDENDS monthly 1000 TAXES quarterly 1200 TOTAL DISBURSEMENT 42000 0 1200 0 0 0 0 0 0 0 0...

Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54,...

Using basic Python 2. Given the following dictionary: speed ={'jan':47, 'feb':52, 'march':47, 'April':44, 'May':52, 'June':53, 'july':54, 'Aug':44, 'Sept':54} Get all values from the dictionary and add it to a new list called speedList, but don’t add duplicates values to the new list. Your code should print out: speedList [47, 52, 44, 53, 54] 3. Given the following list of numbers: numberList = [10, 20, 33, 46, 55, 61, 70, 88, 95] First iterate the list and print only those numbers,...

Titan manufactures and sells a product. It projects unit sales for Jan, Feb, March and April...

Titan manufactures and sells a product. It projects unit sales for Jan, Feb, March and April of 2500, 2250, 3000, and 3750, respectively. At the end of a month, Titan plans to have finished goods inventory equal to 20% of the following month's sales. *Make a Monthly production schedule for Jan-March (Titan had 800 units of finished goods on hand at the end of December.) 2.) Cubs sales for Jan, Feb, and March are budgeted to be $5000, $4500, and...

Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...

Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...

Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July...

Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July 543 August 550 September 546 October 540 November 535 December 529 Predict naïve forecast of patient days for February and June. Predict the patient days for January, using a four-period moving average. Predict the patient days for January, using the six-period moving average. Plot the actual data and the results of the four period and the six-period moving averages. Which is a better predictor?

Machine-Hours Maintenance Cost March 4,440 $50,950 April 4,431 $50,877 May 4,412 $50,696 June 4,460 $51,113 July...

Machine-Hours Maintenance Cost March 4,440 $50,950 April 4,431 $50,877 May 4,412 $50,696 June 4,460 $51,113 July 4,414 $50,711 August 4,433 $50,900 September 4,443 $50,976 October 4,415 $50,730 November 4,391 $50,530 Management believes that maintenance cost is a mixed cost that depends on machine-hours. Using the high-low method, calculate Variable cost per machine-hour? Fixed cost per month? What would total costs be for a month with 4,000 machine-hours?

Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...

Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July 61 August 86 September 81 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) c. Using simple linear regression, calculate the trend line for the historical data....

Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000;...

Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000; respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75%of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78%in the following month. What are the cash collections...

Cost Behavior Assume a local pizzeria reported the following results for June and July April May...

Cost Behavior Assume a local pizzeria reported the following results for June and July April May Unit Sales 2,000 3,000 Cost of Food Sold $ 8,000 $ 12,000 Wages and Salaries 3,700 4,000 Rent 2,000 2,000 Depreciation 500 500 Utilities 1,400 1,500 Supplies 200 300 Total $ 15,800 $ 20,300 a. Identify each cost as being fixed, variable or mixed. b. Determine the equation for total operating costs...

Ruiz Co. provides the following sales forecast for the next four months: April May June July...

Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...

Question