Part #4: E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July, and $160,000 for August. To prepare a cash budget, the company must determine the budgeted cash collections from sales. Generally the trend has been 55 percent collected in the month of sale, 25 percent collected in the month following sale, 18 percent collected in the second month following sale, and 2 percent uncollectible. Also, E Company grants a 2 percent cash discount to customers who pay in the month of sale (so they only collect 98 percent of the total amount for those sales instead of the usual 100 percent). Prepare a schedule of cash collections for the month of July only.

Part #5: At the beginning of September, L Company had 1,600 finished goods units. Budgeted sales for October, November, December, and January are 8,400 units and 10,200 units and 13,600 units and 7,400 units respectively. L Company wants to have sufficient units on hand at the end of each month to meet 20 percent of the following months budgeted sales. Prepare a Production Budget with columns for October, November, December and Total 4th Quarter.

Part #6: H Companys Direct Labor Budget indicates the number of direct labor hours to be used in July, August, and September are 21,000 and 18,900 and 23,000 respectively. Variable overhead is expected to be $0.90per direct labor hour. Fixed overhead per month is expected to be $8,200. Prepare an Overhead Budget with columns for July, August, September, and Total 3rd Quarter.