all the info should be there. These are the tables and the tabs are the options i can choose from. there are a couple more options ive added in the original question
Required information SB Self-Study Problem (Algo) [The following information applies to the questions displayed below] Hansell Company's management wants to prepare budgets for one of its products, Duraflex, for July 2022. The firm sells the product for $99 per unit and has the following expected sales (in units) for these months in 2022 : The production process requires 4 pounds of Dura-1000 and 2 pounds of Flexplas. The firm's policy is to maintain an ending inventory each month equal to 10% of the following month's budgeted sales, but in no case less than 500 units. All materials inventories are to be maintained at 5% of the production needs for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end of June to be within the guidelines. The purchases department expects the materials to cost $1.25 per pound and $5.00 per pound for Dura-1000 and Flexplas, respectively. The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50 per hour and $20 per hour for the K175 level. The K102 level can process one batch of duraflex per hour; each batch consists of 100 units. The manufacturing of Duraflex also requires one-tenth of an hour of K175 workers' time for each unit manufactured. Self-Study Problem 10-2 (Algo) Cash Budget and Budgeted Income Statement Hansell Company expects its trial balance on June 30 to be as follows: Typically, cash sales for Hansell represent 20% of sales while credit sales represent 80%. Credit sales terms by the company are 2/10,n/30. Hansell bills customers on the first day of the month following the month of sale. Experience has shown that 60% of the company's billings will be collected within the discount period, 25% by the end of the month after sales, 10% by the end of the second month after the sale, and 5% will ultimately be uncollectible. The company writes off uncollectible accounts after 12 months. The purchase terms for materials are 2/15, N60. Hansell makes all payments within the discount period. Experience has shown that 80% of the purchases are paid in the month of the purchase and the remainder are paid in the month immediately following. In June 2022, the firm budgeted purchases of $23,900 for Dura-1000 and $20,900 for Flexplas. Typically, cash sales for Hansell represent 20% of sales while credit sales represent 80%. Credit sales terms by the company are 2/10,n/30. Hansell bills customers on the first day of the month following the month of sale. Experience has shown that 60% of the company's billings will be collected within the discount period, 25% by the end of the month after sales, 10% by the end of the second month after the sale, and 5% will ultimately be uncollectible. The company writes off uncollectible accounts after 12 months. The purchase terms for materials are 2/15,n/60. Hansell makes all payments within the discount period. Experience has shown that 80% of the purchases are paid in the month of the purchase and the remainder are paid in the month immediately following. In June 2022, the firm budgeted purchases of $23,900 for Dura-1000 and $20,900 for Flexplas. Variable manufacturing overhead is budgeted at $1,100 per batch (of 100 units) plus $80 per direct labor hour. In addition to variable overhead, the firm has a monthly fixed factory overhead of $47,800, of which $17,800 is depreciation expense. The firm pays all manufacturing labor and factory overhead when incurred. Total budgeted marketing, distribution, customer service, and administrative costs for 2022 are $2,774,000. Of this amount, $1,110,000 is considered fixed and includes depreciation expense of $111,000. The remainder varies with sales. The budgeted total sales for 2022 are $4 million. All marketing and administrative costs are paid in the month incurred. Management desires to maintain an end-of-month minimum cash balance of $38,000. The firm has an agreement with a local bank to borrow its short-term needs in multiples of $1,000 up to $100,000 at an annual interest rate of 12%. Borrowings are assumed to occur at the end of the month. Bank borrowing at July 1 is $0. Required: Using the information presented above: 1. Prepare the cash budget for July 2022. 2. Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) Prenare the cash budaet for lulv 2022 . (Round vour answers to the nearest whole dollar amount.) HANSELL COMPANY Cash Budget For July 2022 Cash balance, beginning (given) Cash flow from operations: \begin{tabular}{|l|l|l|} \hline Collections of receivables from credit sales in June - After the discount period \\ Collections of receivables from credit sales in June - Within the discount period \\ Collections of receivables from credit sales in May & & \\ \hline Direct manufacturing labor & & \\ \hline & Cash balance, July 31,2019 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Required 2> Required 1 Required 2 Prepare the cash budget for July 2022. (Round your answers to the nearest whole dollar amount.) HANSELL COMPANY Cash Budget For July 2022 Cash balance, beginning (given) Cash flow from operations: Collections of receivables from credit sales Fixed factory overhead Fixed marketing, customer services, and administrative expenses Interest payments, end of month July cash saies Materials purchases - July Total cash flow from operations Investing activities: Financing activities: Required 2> Required 1 Required 2 Prepare the cash budget for July 2022. (Round your answers to the nearest whole dollar amount.) Required 2> Required 1 Required 2 Prepare the cash budget for July 2022. (Round your answers to the nearest whole dollar amount.) Required 2> Required 1 Required 2 Prepare the cash budget for July 2022. (Round your answers to the nearest whole dollar amount.) Required 2> Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Rouns "per unit" to 2 decimal places and other answers to the nearest whole dollar amount.) Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Rount.) Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Rour "per unit" to 2 decimal places and other answers to the nearest whole dollar amount.) Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Rour "Der unit" to 2 decimal places and other answers to the nearest whole dollar amount.) Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Rou Required information SB Self-Study Problem (Algo) [The following information applies to the questions displayed below.] Hansell Company's management wants to prepare budgets for one of its products, Duraflex, for July 2022. The firm sells the product for $99 per unit and has the following expected sales (in units) for these months in 2022: The production process requires 4 pounds of Dura-1000 and 2 pounds of Flexplas. The firm's policy is to maintain an ending inventory each month equal to 10% of the following month's budgeted sales, but in no case less than 500 units. All materials inventories are to be maintained at 5% of the production needs for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end of June to be within the guidelines. The purchases department expects the materials to cost $1.25 per pound and $5.00 per pound for Dura-1000 and Flexplas, respectively. The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50 per hour and $20 per hour for the K175 level. The K102 level can process one batch of duraflex per hour; each batch consists of 100 units. The manufacturing of Duraflex also requires one-tenth of an hour of K175 workers' time for each unit manufactured. Self-Study Problem 10-2 (Algo) Cash Budget and Budgeted Income Statement Hansell Company expects its trial balance on June 30 to be as follows: Typically, cash sales for Hansell represent 20% of sales while credit sales represent 80%. Credit sales terms by the company are 2/10, n/30. Hansell bitls customers on the first day of the month following the month of sale. Experience has shown that 60% of the company's billings will be collected within the discount period, 25% by the end of the month after sales, 10% by the end of the second month after the sale, and 5% will ultimately be uncollectible. The company writes off uncollectible accounts after 12 months. The purchase terms for materials are 2/15,n/60. Hansell makes all payments within the discount period. Experience has shown that 80% of the purchases are paid in the month of the purchase and the remainder are paid in the month immediately following. In June 2022 , the firm budgeted purchases of $23,900 for Dura-1000 and $20,900 for Flexplas. Variable manufacturing overhead is budgeted at $1,100 per batch (of 100 units) plus $80 per direct labor hour. In addition to variable overhead, the firm has a monthly fixed factory overhead of $47,800, of which $17,800 is depreciotion expense. The firm pays all manufacturing labor and factory overhead when incurred. Total budgeted marketing, distribution, customer service, and administrative costs for 2022 are $2,774,000,01 this amount, $1,110,000 is considered fixed and includes depreciation expense of $11,000. The remainder varies with sales. The budgeted total sales for 2022 are $4 million. All marketing and administrative costs are paid in the month incurred. Management desires to maintain an end-of-month minimum cash balance of $38,000. The firm has an agreement with a local bank to borrow its short-term needs in multiples of $1,000 up to $100,000 at an annual interest rate of 12%. Borrowings are assumed to occur at the end of the month. Bank borrowing at July 1 is $0. Required: Using the information presented above: 1. Prepare the cash budget for July 2022 . 2. Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-fiow assumption.) Complete this question by entering your answers in the tabs below. Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) (Round "per unit" to 2 decimal places and other answers to the nearest whole dollar amount.) Prepare the cash budget for July 2022. 2. Prepare the budgeted income statement for July 2022. (Assume that the company uses a LIFO cost-flow assumption.) Complete this question by entering your answers in the tabs below. Prenare the cash hudoet for lulv 2022 . (Round vnur anewere to the nearest whole dollar amount.) HANSELL COMPANY Cash Budget For July 2022 Cash balance, beginning (given) Cash flow from operations: Collections of receivables from credit sales
