Question
Part #4: E Company has budgeted sales revenues of $160,000 for May, $210,000 for June, $235,000 for July, and $172,000 for August. To prepare a
Part #4: E Company has budgeted sales revenues of $160,000 for May, $210,000 for June, $235,000 for July, and $172,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,000 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 20,000 and 19,100 and 22,900 respectively. Variable overhead is expected to be $0.80 per direct labor hour. Fixed overhead per month is expected to be $6,200. Prepare an Overhead Budget with columns for July, August, September, and Total 3rd Quarter.
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,000 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 20,000 and 19,100 and 22,900 respectively. Variable overhead is expected to be $0.80 per direct labor hour. Fixed overhead per month is expected to be $6,200. Prepare an Overhead Budget with columns for July, August, September, and Total 3rd Quarter.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started