Assume the following data for Pet Luggage Company: (Click the icon to view the assumptions.) (Click the icon to view budget information.) Requirements 1. Prepare a cash budget for April for Pet Luggage. 2. Why do Pet Luggage'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 Pet Luggage. 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 "0" 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 Deduct disbursements Direct materials Direct manufacturing labor Manufacturing overhead Nonmanufacturing salaries Sales commissions Other nonmanufacturing fixed costs Machinery purchase Income taxes Total disbursements Cash excess (deficiency) Financing Repayment of loan Interest on loan Total effects of financing Ending cash balance, April 30 Revenue Budget For the Month of April Units Selling price Total Revenues 500 $ 215 $ 107,500 215 320 68,800 $ 176,300 Cat-allac Dog-eriffic Total Manufacturing Overhead Budget For the Month of April Machine setup costs $ 8,900 Processing costs 42,000 448 Inspection costs $ 51,348 Total Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced Hours Wage Rate Total 520 3 1,560 $ 10 $ 15,600 200 5 1,000 10 10,000 $ 25,600 per unit Cat-allac Dog-eriffic Total Nonmanufacturing Costs Budget For the Month of April Salaries $ 18,300 Other fixed costs 19,000 1,763 Sales commissions $ 39,063 Total nonmanufacturing costs Assume the following data for Pet Luggage Company: (Click the icon to view the assumptions.) (Click the icon to view budget information.) Requirements 1. Prepare a cash budget for April for Pet Luggage. 2. Why do Pet Luggage'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 Pet Luggage. 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 "0" 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 Deduct disbursements Direct materials Direct manufacturing labor Manufacturing overhead Nonmanufacturing salaries Sales commissions Other nonmanufacturing fixed costs Machinery purchase Income taxes Total disbursements Cash excess (deficiency) Financing Repayment of loan Interest on loan Total effects of financing Ending cash balance, April 30 Revenue Budget For the Month of April Units Selling price Total Revenues 500 $ 215 $ 107,500 215 320 68,800 $ 176,300 Cat-allac Dog-eriffic Total Manufacturing Overhead Budget For the Month of April Machine setup costs $ 8,900 Processing costs 42,000 448 Inspection costs $ 51,348 Total Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced Hours Wage Rate Total 520 3 1,560 $ 10 $ 15,600 200 5 1,000 10 10,000 $ 25,600 per unit Cat-allac Dog-eriffic Total Nonmanufacturing Costs Budget For the Month of April Salaries $ 18,300 Other fixed costs 19,000 1,763 Sales commissions $ 39,063 Total nonmanufacturing costs
