Question

In: Accounting

Month: Radiology Tests:   Total Costs: January 2,800    $133,500 February 2,600 $135,060 March 3,100 $175,000 April...

Month: Radiology Tests:   Total Costs:

January 2,800    $133,500

February 2,600 $135,060

March 3,100 $175,000

April 3,500 $170,600

May 3,400 $176,900

June 3,700 $186,600

July 3,840 $174,450

August 4,100 $195,510

September 3,450 $15,300

1. Compute the cost formula for radiology services using the method of least square

2. Using the formula computed in requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar)

3. What does the coefficient of determination tell you about the cost formula computed in requirement 1? What are the t statistics for the number of tests and the intercept term? What do these statistics tell you about the choice of number of tests as the independent variable and the probability that there are fixed costs?  

Solutions

Expert Solution

Please give positive rating your feedback is valuable to me.

In case, any problem please leave a comment.

Answer-


Related Solutions

MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000...
MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000 $400,000 May 14,000 $434,000 June 9,000 $360,000 July 20,000 $550,000 August 21,000 $525,000 September 24,000 $605,000 October 23,000 $589,000 November 28,000 $702,000 December 18,000 $496,000 1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS) Fixed Costs = Variable Cost per Unit = 2) If I manufacture 35,000 units this month, what...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14 10 -Compute the RSFE, MAD and tracking signals for months January to April?
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 Cash disbursement Cash receipts January 100,000 100,000 February 110,000 90,000 March 110,000 80,000 April 150,000...
Month Cash disbursement Cash receipts January 100,000 100,000 February 110,000 90,000 March 110,000 80,000 April 150,000 100,000 May 180,000 120,000 June 180,000 160,000 July 180,000 200,000 August 180,00 250,000 September 150,000 250,000 October 110,000 200,000 November 100,000 140,000 December 100,000 100,000 Below table shows the monthly estimates of cash disbursement and receipts from January to December 2019 for preparing the cash budgets for Bintang Sdn Bhd. Bintang Sdn Bhd has beginning cash on hand of RM10,000 and the company wishes...
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?
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT