VOID NUMBERS IN THE Parentheses (those are a different problem, just the same questions)
Assume the following data for Animal Gear Company: (Click the icon to view the assumptions.) Click the icon to view budget information) Requirements 1. Prepare a cash budget for April for Animal Gear, 2. Why do Animal Gear's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Requirement 1. Prepare a cash budget for April for Animal Gear. Begin the cash budget by calculating the cash available, then total disbursements, and finally the effects of financing and the ending cash balance. (Round your answers to the nearest whole dollar Enter "O" for repayment of loan if excess cash does not exceed $10,000 at the end of April) Cash Budget April 30 Cash balance, beginning Add receipts Total cash available for needs Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 530 $ 205 $ 108,650 69,750 Dog-eriffic 225 310 Total $ 178,400 Manufacturing Overhead Budget For the Month of April Machine setup costs $ 7,875 Processing costs 101,540 Inspection costs 417 $ Total 109,832 Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced ner unit Hours Wage Rate Total Print Done Torg out TOTO $ Inspection costs 417 Total 109,832 Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced Hours Wage Rate Total 550 3 1,650 $ 10 $ 16,500 210 1,080 10 10,800 $ 27,300 per unit Cat-allac 3 Dog-eriffic 5 Total Operating (nonmanufacturing) Costs Budget For the Month of April Salaries 16,800 Other fixed costs 16,000 Sales commissions 1,784 34,584 Total operating (nonmanufacturing) costs Print Done Cash sales (10%*166100) Credit card sales (166100*9*96%) Total cash available Deduct disbursements Payment to suppliers 8600+(13190*.5) Purchase of machinery Payment of Direct labor Payment of manufacturing oerhead cost (68580-20500) Payment of non manufacturing cost (40161-11500) Payment of income tax Total disbursements Cash excess Repayment of loan Interest on loan (2500*1%) Total effect of financing Ending cash balance Assume the following data for Animal Gear Company: (Click the icon to view the assumptions.) Click the icon to view budget information) Requirements 1. Prepare a cash budget for April for Animal Gear, 2. Why do Animal Gear's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Requirement 1. Prepare a cash budget for April for Animal Gear. Begin the cash budget by calculating the cash available, then total disbursements, and finally the effects of financing and the ending cash balance. (Round your answers to the nearest whole dollar Enter "O" for repayment of loan if excess cash does not exceed $10,000 at the end of April) Cash Budget April 30 Cash balance, beginning Add receipts Total cash available for needs Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 530 $ 205 $ 108,650 69,750 Dog-eriffic 225 310 Total $ 178,400 Manufacturing Overhead Budget For the Month of April Machine setup costs $ 7,875 Processing costs 101,540 Inspection costs 417 $ Total 109,832 Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced ner unit Hours Wage Rate Total Print Done Torg out TOTO $ Inspection costs 417 Total 109,832 Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced Hours Wage Rate Total 550 3 1,650 $ 10 $ 16,500 210 1,080 10 10,800 $ 27,300 per unit Cat-allac 3 Dog-eriffic 5 Total Operating (nonmanufacturing) Costs Budget For the Month of April Salaries 16,800 Other fixed costs 16,000 Sales commissions 1,784 34,584 Total operating (nonmanufacturing) costs Print Done Cash sales (10%*166100) Credit card sales (166100*9*96%) Total cash available Deduct disbursements Payment to suppliers 8600+(13190*.5) Purchase of machinery Payment of Direct labor Payment of manufacturing oerhead cost (68580-20500) Payment of non manufacturing cost (40161-11500) Payment of income tax Total disbursements Cash excess Repayment of loan Interest on loan (2500*1%) Total effect of financing Ending cash balance
