need help with this 3 part question. all info is there and red pictures divied each question. please help asap. im lost!

Data Table $ 213,000 40,750 37,300 Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing overhead costs: Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses: 1,075 900 6.750 Salaries expense 8,000 Rent expense 2,000 1 600 Insurance expense Data Table 37,300 1,075 900 Budgeted direct labor cost Budgeted manufacturing overhead costs: Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses: Salaries expense 6,750 8.000 2,000 1,600 Rent expense Insurance expense Depreciation expense Supplies expense 550 6,390 P 99% BI 99+ More Info x a. Capital expenditures include $36,000 for new manufacturing equipment to be purchased and paid in the first quarter. b. Cash receipts are 85% of sales in the quarter of the sale and 15% in the quarter following the sale. c. Direct materials purchases are paid 50% in the quarter purchased and 50% in the next quarter. d. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred. e. Income tax expense for the first quarter is projected at $45,000 and is paid in the quarter incurred. f. Langley Company expects to have adequate cash funds and does not anticipate borrowing in the first quarter. g. The December 31, 2023, balance in Cash is $45,000, in Accounts Receivable is $26,200, and in Accounts Payable is $11,600. Read the requirements. Requirements 1. Prepare Langley Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2024. 2. Prepare Langley Company's cash budget for the first quarter of 2024. Print Done hers Langley Company has provided the following budget information for the first quarter of 2024 Click the icon to view the budget information.) Additional data related to the first quarter of 2024 for Langley Company (Click the icon to view the data) Read the fequitomon Requirement 1. Prepare Langley Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2024 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2024. Cash Receipts from Customers CO First Quarter ico 2024 icon Total sales Cash Receipts from Customers Accounts Recovable balance, December 31, 2023 1st Or Sales icore Total cash receipts from customers score Next Langley Company has provided the following budget information for the first quarter of 2024 (Click the icon to view the budget information.) Additional data (Click the i Read the feauir ..... Accounts Receivable balance, March 31, 2024: 1st Qtr.-Sales, collected in 2nd Qtr. Prepare the schedule of cash payments for the first quarter of 2024. Cash Payments First Quarter 2024 Total direct materials purchases Cash Payments Direct Materials: Accounts Payable balance, December 31, 2023 Accounts Payable balance, December 31, 2023 1st Qtr.-Direct material purchases Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: Total payments for manufacturing overhead Total payments for manufacturing overhead Selling and Administrative Expenses: Total payments for Selling and Admin. expenses Income Taxes: Total payments for income taxes Read the C ork Total payments for income taxes /Test Capital Expenditures: Total payments for capital expenditures Total cash payments Accounts Payable balance, March 31, 2024 1st Qtr.- Direct materials purchases, paid in 2nd Qtr. Requirement 2. Prepare Langley Company's cash budget for the first quarter of 2024. Review the schedule of cash receipts from customers you prepared in Requirement 1. Daim then maha KARARI Danmark Requirement 2. Prepare Langley Company's cash budget for the first quarter of 2024. Review the schedule of cash receipts from customers you prepared in Requirement 1. Review the schedule of cash payments you prepared in Requirement 1. Langley Company Cash Budget For the Quarter Ended March 31, 2024 Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor os Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes Capital expenditures Total cash payments Ending cash balance TT:59pm ere to search O 99+ O Professional Printing Supply Balance Sheet March 31, 2024 Assets Current Assets: Cash $ Accounts Receivable 51,000 14,400 11,600 Merchandise Inventory Total Current Assets Property, Plant, and Equipment: $ 77,000 > Data Table $ 77,000 Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures 80,900 (12,700) 68,200 Less: Accumulated Depreciation $ 145,200 Total Assets Liabilities Current Liabilities: Accounts Payable $ $ 8,400 Stockholders' Equity Common Stock, no par $ 40,000 ata Table Less: Accumulated Depreciation (12,700) 68,200 Total Assets $ 145,200 R Liabilities Current Liabilities: Accounts Payable $ 8,400 Stockholders' Equity Common Stock, no par $ 40,000 96,800 Retained Earnings Total Stockholders' Equity 136,800 $ Total Liabilities and Stockholders' Equity 145,200 X More Info ai a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,600 budgeted for cash purchase of equipment. C. April depreciation expense, $700. d. Cost of goods sold, 60% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $29,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 5% of sales, all paid in April. h. April budgeted sales, $85,000, 70% collected in April and 30% in May. i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,400. j. April purchases of inventory, $24,400 for cash and $37,800 on account. Half the credit purchases will be paid in April and half in May. . FO w Requirements 1. Prepare the sales budget for April. 2. Prepare the inventory, purchases, and cost of goods sold budget for April. 3. Prepare the selling and administrative expense budget for April. 4. Prepare the schedule of cash receipts from customers for April. 5. Prepare the schedule of cash payments for selling and administrative expenses for April. 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance. 7. Prepare the budgeted income statement for April. 8. Prepare the budgeted balance sheet at April 30, 2024. score score est Professional Printing Supply of Baltimore has applied for a loan. Its bank has As Professional Printing Supplys controller, you have assembled the following requested a budgeted income statement for April 2024 and budgeted balance additional information sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the information) Click the icon to view the balance sheet) Read the recitations Requirement 1. Prepare the sales budget for April Professional Printing Supply Sales Budget For the Month Ended April 30, 2024 Total budgeted sales Requirement 2. Prepare the inventory, purchases, and cost of goods sold budget for April Professional Printing Supply Inventory. Purchmes, and cost of Goods Sold Budget For the Month Ended April 30, 2024 score tore icore Toore As add Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) Rea Plus: Total merchandise inventory required Less: Budgeted Purchases Requirement 3. Prepare the selling and administrative expense budget for April. Professional Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2024 Variable expenses: allback(_Page: 234761732' scoreCallBack scoreCallBackPreCallo.scoreCallBackError true) ere to search 99+ O Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) As adc 0 Rea .... Fixed expenses: Total fixed expenses Total selling and administrative expenses Requirement 4. Prepare the budgeted cash receipts from customers for April. Professional Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2024 Current month sales, 70% (Click the icon to view the balance sheet.) H. Current month sales, 70% Prior month sales, 30% Total cash receipts Requirement 5. Prepare the budgeted cash payments for selling and administrative ex Professional Printing Supply Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expenses Fixed expenses: Callback('_Page: 'Q 234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search BI 99+ O X Professional Printing Supply of Baltimore has applied for a loan. Its bank has As Professional Printing Supply's controller, you have assem requested a budgeted income statement for April 2024 and budgeted balance additional information: sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the information.) Click the icon to view the balance sheet.) Read the requirements Fixed expenses: 30% of current month's salaries expense Total payments for selling and administrative expenses Requirement 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance Review the budgeted cash receipts from customers you prepared above. Review the budgeted cash payments for selling and administrative expenses you prepared above. Professional Printing Supply Cash Budget For the Month Ended April 30, 2024 Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the balance sheet.) . Cash available Cash payments: Total cash payments Ending cash balance Requirement 7. Prepare the budgeted income statement for April. TEON Callback('_Page Q_234761732"scoreCallBack scoreCallBackPreCallo.scoreCallBackError true) here to search O 8 99+ requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the balance sheet.) Requirement 7. Prepare the budgeted income statement for April. Review the sales budget you prepared above. Review the selling and administrative expense budget you prepared above. Review the inventory, purchases, and cost of goods sold budget you prepared above. Professional Printing Supply Budgeted Income Statement For the Month Ended April 30, 2024 Gross Profit Selling and Administrative Expenses: TENT Callback(_Page: Q 234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search O 81 99+) Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) .... Selling and Administrative Expenses: Total Selling and Administrative Expenses Net income (loss) Requirement 8. Prepare the budgeted balance sheet at April 30, 2024. Review the cash budget you prepared above. Professional Printing Supply Budgeted Balance Sheet allback(_Page Q_234761732' scoreCallBack,scoreCallBackPreCall(.scoreCallBackError true) ere to search O 99+ Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) April 30, 2024 Assets Current Assets: Total Current Assets Property, Plant, and Equipment: Total Assets TEET Callback('_Page Q_234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search BRE 99+ O . Quiz: Chapter M:... Question 2 Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) Total Assets Liabilities Current Liabilities: Total Liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Stockholders' Equity Callback(_Page:'Q_234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search O 99+ The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and young teens, and an adult bat, designed for high school and college-aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth bat sells for $50, the adult bat sells for $75. Mata's highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Mata's balance sheet for December 31, 2024, and other data for the first quarter of 2025 follow Click the foon to view the balance sheet.) Click the icon to view the other data.) Re Data Table ements core icore score Requirement 1. Prepare Mata's sales budget for the first quarter of 2025 Mata Batting Company Sales Budget For the Quarter Ended March 31, 2025 Youth core Adult Score Bats Bats Total Budgeted bats to be sold Sales price per unit score Total sales kore Data Table Mata Batting Company Balance Sheet December 31, 2024 Assets Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets $ 40,000 22,500 4,050 15,130 $ 81,680 EcoreCallBackPreCallo,scoreCallBackError,true) O DE 96% 99+ A Click the icon to view the other data ata Table $ 81,680 Total Current Assets Property, Plant, and Equipment: Equipment 115,000 (30,000) 85,000 Less: Accumulated Depreciation $ 166,680 Total Assets Liabilities Current Liabilities: Accounts Payable $ 16,500 Stockholders' Equity $ Common Stock, no par $ 150,000 180 CoreCallBackPreCallo.scoreCallBackError,true) BI 99+ w O 96% ata Table (30,000) 85,000 Less: Accumulated Depreciation $ $ 166,680 $ 16,500 Total Assets Liabilities Current Liabilities: Accounts Payable Stockholders Equity Common Stock, no par $ Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 150,000 180 150,180 $ 166,680 oreCallBackPreCallO.scoreCallBackError true) 96% O E 99+ tures wood baseball bats. Mata's two primary products are a youth bat, designed for children a aged players. Mata sells the bats to sporting goods stores and all sales are on account. The yo lume is in the first three months of the year as retailers prepare for the spring baseball season. for the first quarter of 2025 follow: ce sheet A Click the icon to view the other data More Info a. Budgeted sales are 1,500 youth bats and 3,600 adult bats. b. Finished Goods Inventory on December 31, 2024, consists of 450 youth bats at $17 each and 440 adult bats at $17 each. c. Desired ending Finished Goods Inventory is 200 youth bats and 400 adult bats, FIFO inventory costing method is used. d. Direct materials requirements are 52 ounces of wood per youth bat and 64 ounces of wood per adult bat. The cost of wood is $0.15 per ounce. e. Raw Materials Inventory on December 31, 2024, consists of 27,000 ounces of wood at $0.15 per ounce. f. Desired ending Raw Materials Inventory is 27,000 ounces (indirect materials are insignificant and not considered for budgeting purposes) g. Each bat requires 0.3 hours of direct labor, direct labor costs average $12 per hour. h. Variable manufacturing overhead is $0.80 per bat. sack scoreCallBackPreCallo.scoreCallBackErrortrue) O BI 99+ 96% nanufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and yo college-aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth b sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Mata er data for the first quarter of 2025 follow: na balance shoot A/Click the icon to view the other data More Info 1 10 la Qul ounces of wood per adult bat. The cost of wood is $0.15 per ounce. e. Raw Materials Inventory on December 31, 2024, consists of 27,000 ounces of wood at $0.15 per ounce f. Desired ending Raw Materials Inventory is 27.000 ounces (indirect materials are insignificant and not considered for budgeting purposes). g. Each bat requires 0.3 hours of direct labor, direct labor costs average $12 per hour h. Variable manufacturing overhead is $0.80 per bat. i. Fixed manufacturing overhead includes $900 per quarter in depreciation and $2,467 per quarter for other costs, such as insurance and property taxes. 1. Fixed selling and administrative expenses include $10,000 per quarter for salaries; $1,500 per quarter for rent, S1,500 per quarter for insurance, and $400 per quarter for depreciation. k. Variable selling and administrative expenses include supplies at 5% of sales, ScoreCallback,scoreCallBack Precall.scoreCallbackError, true) ORI 99+ 96% + X Fr FS FB FY EN FB DI FIO FO F11 FU U % 5 & 7 # 00 4 6 8 9 O ures wood baseball bats. Mata's two primary products are a youth bat, designed for children and your -aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth ba Tume is in the first three months of the year as retailers prepare for the spring baseball season. Mata's For the first quarter of 2025 follow: 2 shoot A Click the icon to aim the other data Requirements 1 1. Prepare Mata's sales budget for the first quarter of 2025, 2. Prepare Mata's production budget for the first quarter of 2025. 3. Prepare Mata's direct materials budget, direct labor budget, and manufacturing overhead budget for the first quarter of 2025. Round the predetermined overhead allocation rate to two decimal places. The overhead allocation base is direct labor hours. 4. Prepare Mata's cost of goods sold budget for the first quarter of 2025. 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025 Print Done IBack scoreCallBackPreCallo.scoreCallBackError true) 96% O BE 99 + P x cm -- F11 F9 F10 FA N Requirement 1. Prepare Mata's sales budget for the first quarter of 2025. w Mata Batting Company Sales Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Budgeted bats to be sold Sales price per unit Total sales Requirement 2. Prepare Mata's production budget for the first quarter of 2025. Mata Batting Company Production Budget For the Quarter Ended March 31, 2025 EUR Callback('_Page 234761732 scoreCallBack scoreCallBackPreCallO.scoreCallBackError true) ere to search O BI 99+ 19- + my lees, a For the Quarter Ended March 31, 2025 Adult Youth Bats Bats Total Plus Total bats needed Less Budgeted bats to be produced Requirement 3. Prepare Mata's direct materials budget, direct labor budget, and manufacturing overhead budget for the first quarter of 2025. Round the predetermined overhead allocation rate to two decimal places. The overhead allocation base is direct labor hours. Begin by preparing the direct materials budget. Mata Batting Company Direct Materials Budget Enthan 2006 H. Mata Batting Company Direct Materials Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Direct materials per bat (ounces) Direct materials needed for production Plus: Total direct materials needed Less: Budgeted purchases of direct materials Direct materials cost per ounce Budgeted cost of direct materials The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, design Budgeted cost of direct materials Prepare the direct labor budget. (Enter any hours per unit amounts to two decimal places, X.XX.) Review the production budget you prepared above. Mata Batting Company Direct Labor Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Direct labor hours needed for production Budgeted direct labor cost The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and young teens, and an aduit Prepare the manufacturing overhead budget (Enter any per unit amounts to two decimal places, XXX Abbreviations used: VOH = variable manufacturing overhead: FOH = food manufacturing overhead.) Review the production budget you prepared above. Review the direct labor budget you prepared above. Mata Batting Company Manufacturing Overhead Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Total Bats VOH Cost per bat Budgeted VOH Budgeted FOH Depreciation Insurance and property taxes Udi Usiyou for Children and young teens, and an ad SEE Insurance and property taxes Total budgeted FOH Budgeted manufacturing overhead costs Direct labor hours Budgeted manufacturing overhead costs Predetermined overhead allocation rate Requirement 4. Prepare Mata's cost of goods sold budget for the first quarter of 2025. Before preparing the cost of goods sold budget, calculate the projected manufacturing cost per bat for 2025. (Round all amounts to the nearest cent.) Youth Bats Adult Bats Youth Bats Adult Bats D rk Test Total projected manufacturing cost per bat for 2025 Now prepare the cost of goods sold budget. Review the sales budget you prepared above. Review the production budget you prepared above. Mata Batting Company Cost of Goods Sold Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total ER -rm DoCallback Page 2224761222 The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a yo For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Tots Bats produced and sold in 1st quarter of 2025 Total budgeted cost of goods sold Requirement 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025 Review the sales budget you prepared above. Mata Batting Company Selling and Administrative Expense Budget For the Quarter Ended March 31, 2025 TER back(_Page: Q234761732' scoreCallBack scoreCallBackPreCallo scoreCallbackError true) e to search O 99+) FE F2 3 + D The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed fo Bats produced and sold in 1st quarter of 2025 Total budgeted cost of goods sold Requirement 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025. Review the sales budget you prepared above. Mata Batting Company Selling and Administrative Expense Budget For the Quarter Ended March 31, 2025 Total budgeted selling and administrative expense Data Table $ 213,000 40,750 37,300 Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing overhead costs: Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses: 1,075 900 6.750 Salaries expense 8,000 Rent expense 2,000 1 600 Insurance expense Data Table 37,300 1,075 900 Budgeted direct labor cost Budgeted manufacturing overhead costs: Variable manufacturing overhead Depreciation Insurance and property taxes Budgeted selling and administrative expenses: Salaries expense 6,750 8.000 2,000 1,600 Rent expense Insurance expense Depreciation expense Supplies expense 550 6,390 P 99% BI 99+ More Info x a. Capital expenditures include $36,000 for new manufacturing equipment to be purchased and paid in the first quarter. b. Cash receipts are 85% of sales in the quarter of the sale and 15% in the quarter following the sale. c. Direct materials purchases are paid 50% in the quarter purchased and 50% in the next quarter. d. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred. e. Income tax expense for the first quarter is projected at $45,000 and is paid in the quarter incurred. f. Langley Company expects to have adequate cash funds and does not anticipate borrowing in the first quarter. g. The December 31, 2023, balance in Cash is $45,000, in Accounts Receivable is $26,200, and in Accounts Payable is $11,600. Read the requirements. Requirements 1. Prepare Langley Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2024. 2. Prepare Langley Company's cash budget for the first quarter of 2024. Print Done hers Langley Company has provided the following budget information for the first quarter of 2024 Click the icon to view the budget information.) Additional data related to the first quarter of 2024 for Langley Company (Click the icon to view the data) Read the fequitomon Requirement 1. Prepare Langley Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2024 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2024. Cash Receipts from Customers CO First Quarter ico 2024 icon Total sales Cash Receipts from Customers Accounts Recovable balance, December 31, 2023 1st Or Sales icore Total cash receipts from customers score Next Langley Company has provided the following budget information for the first quarter of 2024 (Click the icon to view the budget information.) Additional data (Click the i Read the feauir ..... Accounts Receivable balance, March 31, 2024: 1st Qtr.-Sales, collected in 2nd Qtr. Prepare the schedule of cash payments for the first quarter of 2024. Cash Payments First Quarter 2024 Total direct materials purchases Cash Payments Direct Materials: Accounts Payable balance, December 31, 2023 Accounts Payable balance, December 31, 2023 1st Qtr.-Direct material purchases Total payments for direct materials Direct Labor: Total payments for direct labor Manufacturing Overhead: Total payments for manufacturing overhead Total payments for manufacturing overhead Selling and Administrative Expenses: Total payments for Selling and Admin. expenses Income Taxes: Total payments for income taxes Read the C ork Total payments for income taxes /Test Capital Expenditures: Total payments for capital expenditures Total cash payments Accounts Payable balance, March 31, 2024 1st Qtr.- Direct materials purchases, paid in 2nd Qtr. Requirement 2. Prepare Langley Company's cash budget for the first quarter of 2024. Review the schedule of cash receipts from customers you prepared in Requirement 1. Daim then maha KARARI Danmark Requirement 2. Prepare Langley Company's cash budget for the first quarter of 2024. Review the schedule of cash receipts from customers you prepared in Requirement 1. Review the schedule of cash payments you prepared in Requirement 1. Langley Company Cash Budget For the Quarter Ended March 31, 2024 Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor os Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes Capital expenditures Total cash payments Ending cash balance TT:59pm ere to search O 99+ O Professional Printing Supply Balance Sheet March 31, 2024 Assets Current Assets: Cash $ Accounts Receivable 51,000 14,400 11,600 Merchandise Inventory Total Current Assets Property, Plant, and Equipment: $ 77,000 > Data Table $ 77,000 Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures 80,900 (12,700) 68,200 Less: Accumulated Depreciation $ 145,200 Total Assets Liabilities Current Liabilities: Accounts Payable $ $ 8,400 Stockholders' Equity Common Stock, no par $ 40,000 ata Table Less: Accumulated Depreciation (12,700) 68,200 Total Assets $ 145,200 R Liabilities Current Liabilities: Accounts Payable $ 8,400 Stockholders' Equity Common Stock, no par $ 40,000 96,800 Retained Earnings Total Stockholders' Equity 136,800 $ Total Liabilities and Stockholders' Equity 145,200 X More Info ai a. April dividends of $6,000 were declared and paid. b. April capital expenditures of $16,600 budgeted for cash purchase of equipment. C. April depreciation expense, $700. d. Cost of goods sold, 60% of sales. e. Desired ending inventory for April is $22,800. f. April selling and administrative expenses include salaries of $29,000, 30% of which will be paid in cash and the remainder paid next month. g. Additional April selling and administrative expenses also include miscellaneous expenses of 5% of sales, all paid in April. h. April budgeted sales, $85,000, 70% collected in April and 30% in May. i. April cash payments of March 31 liabilities incurred for March purchases of inventory, $8,400. j. April purchases of inventory, $24,400 for cash and $37,800 on account. Half the credit purchases will be paid in April and half in May. . FO w Requirements 1. Prepare the sales budget for April. 2. Prepare the inventory, purchases, and cost of goods sold budget for April. 3. Prepare the selling and administrative expense budget for April. 4. Prepare the schedule of cash receipts from customers for April. 5. Prepare the schedule of cash payments for selling and administrative expenses for April. 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance. 7. Prepare the budgeted income statement for April. 8. Prepare the budgeted balance sheet at April 30, 2024. score score est Professional Printing Supply of Baltimore has applied for a loan. Its bank has As Professional Printing Supplys controller, you have assembled the following requested a budgeted income statement for April 2024 and budgeted balance additional information sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the information) Click the icon to view the balance sheet) Read the recitations Requirement 1. Prepare the sales budget for April Professional Printing Supply Sales Budget For the Month Ended April 30, 2024 Total budgeted sales Requirement 2. Prepare the inventory, purchases, and cost of goods sold budget for April Professional Printing Supply Inventory. Purchmes, and cost of Goods Sold Budget For the Month Ended April 30, 2024 score tore icore Toore As add Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) Rea Plus: Total merchandise inventory required Less: Budgeted Purchases Requirement 3. Prepare the selling and administrative expense budget for April. Professional Printing Supply Selling and Administrative Expense Budget For the Month Ended April 30, 2024 Variable expenses: allback(_Page: 234761732' scoreCallBack scoreCallBackPreCallo.scoreCallBackError true) ere to search 99+ O Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) As adc 0 Rea .... Fixed expenses: Total fixed expenses Total selling and administrative expenses Requirement 4. Prepare the budgeted cash receipts from customers for April. Professional Printing Supply Budgeted Cash Receipts from Customers For the Month Ended April 30, 2024 Current month sales, 70% (Click the icon to view the balance sheet.) H. Current month sales, 70% Prior month sales, 30% Total cash receipts Requirement 5. Prepare the budgeted cash payments for selling and administrative ex Professional Printing Supply Budgeted Cash Payments for Selling and Administrative Expenses For the Month Ended April 30, 2024 Variable expenses: Miscellaneous expenses Fixed expenses: Callback('_Page: 'Q 234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search BI 99+ O X Professional Printing Supply of Baltimore has applied for a loan. Its bank has As Professional Printing Supply's controller, you have assem requested a budgeted income statement for April 2024 and budgeted balance additional information: sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the information.) Click the icon to view the balance sheet.) Read the requirements Fixed expenses: 30% of current month's salaries expense Total payments for selling and administrative expenses Requirement 6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance Review the budgeted cash receipts from customers you prepared above. Review the budgeted cash payments for selling and administrative expenses you prepared above. Professional Printing Supply Cash Budget For the Month Ended April 30, 2024 Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the balance sheet.) . Cash available Cash payments: Total cash payments Ending cash balance Requirement 7. Prepare the budgeted income statement for April. TEON Callback('_Page Q_234761732"scoreCallBack scoreCallBackPreCallo.scoreCallBackError true) here to search O 8 99+ requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: Click the icon to view the balance sheet.) Requirement 7. Prepare the budgeted income statement for April. Review the sales budget you prepared above. Review the selling and administrative expense budget you prepared above. Review the inventory, purchases, and cost of goods sold budget you prepared above. Professional Printing Supply Budgeted Income Statement For the Month Ended April 30, 2024 Gross Profit Selling and Administrative Expenses: TENT Callback(_Page: Q 234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search O 81 99+) Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) .... Selling and Administrative Expenses: Total Selling and Administrative Expenses Net income (loss) Requirement 8. Prepare the budgeted balance sheet at April 30, 2024. Review the cash budget you prepared above. Professional Printing Supply Budgeted Balance Sheet allback(_Page Q_234761732' scoreCallBack,scoreCallBackPreCall(.scoreCallBackError true) ere to search O 99+ Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) April 30, 2024 Assets Current Assets: Total Current Assets Property, Plant, and Equipment: Total Assets TEET Callback('_Page Q_234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search BRE 99+ O . Quiz: Chapter M:... Question 2 Professional Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2024 and budgeted balance sheet at April 30, 2024. The March 31, 2024, balance sheet follows: (Click the icon to view the balance sheet.) Total Assets Liabilities Current Liabilities: Total Liabilities Stockholders' Equity Total Stockholders' Equity Total Liabilities and Stockholders' Equity Callback(_Page:'Q_234761732' scoreCallBack scoreCallBackPreCallo,scoreCallBackError true) here to search O 99+ The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and young teens, and an adult bat, designed for high school and college-aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth bat sells for $50, the adult bat sells for $75. Mata's highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Mata's balance sheet for December 31, 2024, and other data for the first quarter of 2025 follow Click the foon to view the balance sheet.) Click the icon to view the other data.) Re Data Table ements core icore score Requirement 1. Prepare Mata's sales budget for the first quarter of 2025 Mata Batting Company Sales Budget For the Quarter Ended March 31, 2025 Youth core Adult Score Bats Bats Total Budgeted bats to be sold Sales price per unit score Total sales kore Data Table Mata Batting Company Balance Sheet December 31, 2024 Assets Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Total Current Assets $ 40,000 22,500 4,050 15,130 $ 81,680 EcoreCallBackPreCallo,scoreCallBackError,true) O DE 96% 99+ A Click the icon to view the other data ata Table $ 81,680 Total Current Assets Property, Plant, and Equipment: Equipment 115,000 (30,000) 85,000 Less: Accumulated Depreciation $ 166,680 Total Assets Liabilities Current Liabilities: Accounts Payable $ 16,500 Stockholders' Equity $ Common Stock, no par $ 150,000 180 CoreCallBackPreCallo.scoreCallBackError,true) BI 99+ w O 96% ata Table (30,000) 85,000 Less: Accumulated Depreciation $ $ 166,680 $ 16,500 Total Assets Liabilities Current Liabilities: Accounts Payable Stockholders Equity Common Stock, no par $ Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 150,000 180 150,180 $ 166,680 oreCallBackPreCallO.scoreCallBackError true) 96% O E 99+ tures wood baseball bats. Mata's two primary products are a youth bat, designed for children a aged players. Mata sells the bats to sporting goods stores and all sales are on account. The yo lume is in the first three months of the year as retailers prepare for the spring baseball season. for the first quarter of 2025 follow: ce sheet A Click the icon to view the other data More Info a. Budgeted sales are 1,500 youth bats and 3,600 adult bats. b. Finished Goods Inventory on December 31, 2024, consists of 450 youth bats at $17 each and 440 adult bats at $17 each. c. Desired ending Finished Goods Inventory is 200 youth bats and 400 adult bats, FIFO inventory costing method is used. d. Direct materials requirements are 52 ounces of wood per youth bat and 64 ounces of wood per adult bat. The cost of wood is $0.15 per ounce. e. Raw Materials Inventory on December 31, 2024, consists of 27,000 ounces of wood at $0.15 per ounce. f. Desired ending Raw Materials Inventory is 27,000 ounces (indirect materials are insignificant and not considered for budgeting purposes) g. Each bat requires 0.3 hours of direct labor, direct labor costs average $12 per hour. h. Variable manufacturing overhead is $0.80 per bat. sack scoreCallBackPreCallo.scoreCallBackErrortrue) O BI 99+ 96% nanufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and yo college-aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth b sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Mata er data for the first quarter of 2025 follow: na balance shoot A/Click the icon to view the other data More Info 1 10 la Qul ounces of wood per adult bat. The cost of wood is $0.15 per ounce. e. Raw Materials Inventory on December 31, 2024, consists of 27,000 ounces of wood at $0.15 per ounce f. Desired ending Raw Materials Inventory is 27.000 ounces (indirect materials are insignificant and not considered for budgeting purposes). g. Each bat requires 0.3 hours of direct labor, direct labor costs average $12 per hour h. Variable manufacturing overhead is $0.80 per bat. i. Fixed manufacturing overhead includes $900 per quarter in depreciation and $2,467 per quarter for other costs, such as insurance and property taxes. 1. Fixed selling and administrative expenses include $10,000 per quarter for salaries; $1,500 per quarter for rent, S1,500 per quarter for insurance, and $400 per quarter for depreciation. k. Variable selling and administrative expenses include supplies at 5% of sales, ScoreCallback,scoreCallBack Precall.scoreCallbackError, true) ORI 99+ 96% + X Fr FS FB FY EN FB DI FIO FO F11 FU U % 5 & 7 # 00 4 6 8 9 O ures wood baseball bats. Mata's two primary products are a youth bat, designed for children and your -aged players. Mata sells the bats to sporting goods stores and all sales are on account. The youth ba Tume is in the first three months of the year as retailers prepare for the spring baseball season. Mata's For the first quarter of 2025 follow: 2 shoot A Click the icon to aim the other data Requirements 1 1. Prepare Mata's sales budget for the first quarter of 2025, 2. Prepare Mata's production budget for the first quarter of 2025. 3. Prepare Mata's direct materials budget, direct labor budget, and manufacturing overhead budget for the first quarter of 2025. Round the predetermined overhead allocation rate to two decimal places. The overhead allocation base is direct labor hours. 4. Prepare Mata's cost of goods sold budget for the first quarter of 2025. 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025 Print Done IBack scoreCallBackPreCallo.scoreCallBackError true) 96% O BE 99 + P x cm -- F11 F9 F10 FA N Requirement 1. Prepare Mata's sales budget for the first quarter of 2025. w Mata Batting Company Sales Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Budgeted bats to be sold Sales price per unit Total sales Requirement 2. Prepare Mata's production budget for the first quarter of 2025. Mata Batting Company Production Budget For the Quarter Ended March 31, 2025 EUR Callback('_Page 234761732 scoreCallBack scoreCallBackPreCallO.scoreCallBackError true) ere to search O BI 99+ 19- + my lees, a For the Quarter Ended March 31, 2025 Adult Youth Bats Bats Total Plus Total bats needed Less Budgeted bats to be produced Requirement 3. Prepare Mata's direct materials budget, direct labor budget, and manufacturing overhead budget for the first quarter of 2025. Round the predetermined overhead allocation rate to two decimal places. The overhead allocation base is direct labor hours. Begin by preparing the direct materials budget. Mata Batting Company Direct Materials Budget Enthan 2006 H. Mata Batting Company Direct Materials Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Direct materials per bat (ounces) Direct materials needed for production Plus: Total direct materials needed Less: Budgeted purchases of direct materials Direct materials cost per ounce Budgeted cost of direct materials The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, design Budgeted cost of direct materials Prepare the direct labor budget. (Enter any hours per unit amounts to two decimal places, X.XX.) Review the production budget you prepared above. Mata Batting Company Direct Labor Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total Direct labor hours needed for production Budgeted direct labor cost The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed for children and young teens, and an aduit Prepare the manufacturing overhead budget (Enter any per unit amounts to two decimal places, XXX Abbreviations used: VOH = variable manufacturing overhead: FOH = food manufacturing overhead.) Review the production budget you prepared above. Review the direct labor budget you prepared above. Mata Batting Company Manufacturing Overhead Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Total Bats VOH Cost per bat Budgeted VOH Budgeted FOH Depreciation Insurance and property taxes Udi Usiyou for Children and young teens, and an ad SEE Insurance and property taxes Total budgeted FOH Budgeted manufacturing overhead costs Direct labor hours Budgeted manufacturing overhead costs Predetermined overhead allocation rate Requirement 4. Prepare Mata's cost of goods sold budget for the first quarter of 2025. Before preparing the cost of goods sold budget, calculate the projected manufacturing cost per bat for 2025. (Round all amounts to the nearest cent.) Youth Bats Adult Bats Youth Bats Adult Bats D rk Test Total projected manufacturing cost per bat for 2025 Now prepare the cost of goods sold budget. Review the sales budget you prepared above. Review the production budget you prepared above. Mata Batting Company Cost of Goods Sold Budget For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Total ER -rm DoCallback Page 2224761222 The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a yo For the Quarter Ended March 31, 2025 Youth Adult Bats Bats Tots Bats produced and sold in 1st quarter of 2025 Total budgeted cost of goods sold Requirement 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025 Review the sales budget you prepared above. Mata Batting Company Selling and Administrative Expense Budget For the Quarter Ended March 31, 2025 TER back(_Page: Q234761732' scoreCallBack scoreCallBackPreCallo scoreCallbackError true) e to search O 99+) FE F2 3 + D The Mata Batting Company manufactures wood baseball bats. Mata's two primary products are a youth bat, designed fo Bats produced and sold in 1st quarter of 2025 Total budgeted cost of goods sold Requirement 5. Prepare Mata's selling and administrative expense budget for the first quarter of 2025. Review the sales budget you prepared above. Mata Batting Company Selling and Administrative Expense Budget For the Quarter Ended March 31, 2025 Total budgeted selling and administrative expense