Score: 0 of 1 pt of completely HW Score: 35014 P6-41 (similar to) Assume the following data for Animal Toport Company (Cicon to view the antion Click the con todet normation Requirements 1 Depecah budget for for Animal transport 2 Wide Armater managers are a canh ludpet in ad the opened in income Requirement Proare a cash budget for ori for Ano Bogn the cathtudying the cath will be there and and your own color is catholce 1000 the end Cash B A 30 Cashbac bogine Andre i More Info . pa il fod ava een Animal Transport (AT) does not make any sales on credit. AT sells only to the public and accepts cash and credit cards: 90% of its sales are to customers using credit cards, for which AT gets the cash right away, less a 2% transaction fee. Purchases of materials are on account. AT pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March AT owes suppliers $8.700. During April they plan to purchase direct materials worth $21,230. AT plans to replace a machine in April at a net cash cost of $13,700 Labor, other manufacturing costs, and nonmanufacturing costs are paid in cash in the month incurred except of course depreciation which is not a cash flow. Depreciation is $23,000 of the manufacturing cost and $13,500 of the nonmanufacturing (fixed) cost for April AT currently has a $2,900 loan at an annual interest rate of 12%. The interest is paid at the end of each month. If AT has more than $10,000 cash at the end of April it will pay back the loan AT owes 55,800 in income taxes that need to be remitted in April. AT has cash of $5,400 on hand at the end of March er in the Print Done "CreaTTA Revenue Budget For the Month of April Units Selling price Total Revenues 530 $ 205 $ 108,650 82. 150 265 310 $ 190.800 Cat-allac Dog-eriffic Total Manufacturing Overhead Budget For the Month of April Machine setup costs $ 8.715 Processing costs 105,500 465 Inspection costs Reference $ 114,680 Total 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 250 12.500 5 10 1.250 $ 29,000 per unit Cal-allac Dog-erific Total Nonmanufacturing Costs Budget For the Month of April SA $ 120 Punt Done e PI DOLL FE F7 FB F9 F10 F11 F12 Priser reference DMLH Output units produced 550 per unit Cat-allac 3 Total Hourly Hours Wage Rate Total 1,650 $ 10 $ 16,500 12,500 1.250 10 - $ 29,000 Dog-eriffic 250 5 Total Nonmanufacturing Costs Budget For the Month of April Salaries 18.200 Other foxed costs 20.000 Sales commissions 1 908 Total nonmanufacturing costs 40 108 Print Done e E PE 1 DOLL Assume the following data for Animal Transport Company (Click the icon to view the mos) Cack the con low budget information Requirements 1. Prepare a cash budget for April for Animal Transport Why do Animal Transporto managers prepare a cash usput into the expenses and operating incantat Begin the cash budget by calculating the cash available then total disbursements and finally the effects of inancing and the ending chance and you to the nearest wieder Women excess cash does not exceed $10,000 hond of Art) Cash Budget April 30 Cash salaco, beginning Addres Choose from any list or enter any number in the public and then click Check