Reference no: EM131050156
Neosho Concrete is attempting to estimate their financial needs for the first 6 months of 2010. Sales forecasts for 2010 are as follows:
January $50,000 May $ 80,000
February 60,000 June 120,000
March 60,000 July 125,000
April 70,000
Actual sales in 2009 were:
October $100,000
November 150,000
December 200,000
The credit department estimates the collections as follows: collections within the month of sale, 20 percent; collections the month following the sale, 40 percent; collections the second month following the sale, 40 percent.
The cost of raw materials is 40 percent of sales. Raw materials are delivered and paid for in the month prior to sale. Labor costs are 24 percent of sales and are paid for in the month of the sale. Selling, administrative, and other expenses are 16 percent of sales and are paid for in the month of the sale. All goods sold are manufactured in the month of the sale.
A new mixer with a 12-year life and no salvage value will be delivered and paid for in May. The cost of the mixer is $144,000, on which depreciation of $20,160 will be charged on June 30 (assuming the mixer falls in the MACRS 7-year class life).
Semiannual interest charges on $345,833 of long-term bonds (12 percent coupon) are due in March. Quarterly common stock cash dividends of $10,000 are paid in March and June. Income tax prepayments of $18,000 are made in March.
Cash on hand December 31, 2009, is $60,000, and a minimum cash balance of $50,000 should be maintained. All short-term borrowing is repaid as soon as cash is available. The interest rate on short-term borrowing is 12 percent per annum. All borrowing and repayments take place on the first day of the month. Interest payments are due the first day of the month following the borrowing.
Prepare a cash budget for Neosho Concrete for the first 6 months of 2010. Indicate the amount of excess cash or the amount of financing required to maintain the $50,000 minimum cash balance.
If Neosho Concrete changed all sales to a cash basis, no credit, would their outside financing needs for the cash budget period studied increase or decrease? Do not rework the problem but simply explain why it would increase or decrease.
|
Test the claim that the average sat score
: Test the claim that the average SAT score for graduating high school students is equal to 1100. A random sample of 70 students was selected, and the average SAT score was 1035. Assume σ " 310 and use α= 0.10. What is the p-value for this sample?
|
|
Compare the two projects in terms of general progress
: Both projects have a planned daily cost of 100 and a planned daily earned value of 100. The first six days for each team have progressed as follows:
|
|
Investment fund that has an annual yield
: A retired woman has $130,000 to invest. She has chosen one relatively safe investment fund that has an annual yield of 9% and another, riskier one that has an annual yield of 13%.
|
|
Assume population standard deviations
: Test the hypothesis that the average number of days that a home is on the market in City A is different from City B using the following sample data:
|
|
Cash budget for neosho concrete
: Prepare a cash budget for Neosho Concrete for the first 6 months of 2010. Indicate the amount of excess cash or the amount of financing required to maintain the $50,000 minimum cash balance.
|
|
Test the hypothesis that the average hourly wage
: Test the hypothesis that the average hourly wage for City A is more than $0.50 per hour above the average hourly wage in City B using the following sample data:
|
|
What can you conclude about this project
: In fact, progress for the first 20 days has been: 2, 3, 4, 6, 7, 9, 12, 14, 15, 17, 20, 21, 21, 22, 24, 26, 27, 29, 31, 33. What can you conclude about this project?
|
|
Proportion of home ownership in the state of florida
: Test the hypothesis that the proportion of home ownership in the state of Florida exceeds the national proportion at the α = 0.01 level using the following data.
|
|
Recruit for production line workers
: Select at least five (5) places you would recruit for a customer service assistant and at least five (5) places you would recruit for production line workers. Explain why each place you selected would be a viable option for recruiting employees.
|