Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Budget information Assume the following data for Pet Transport Company: i (Click the icon to view the assumptions.) Requirement (Click the icon to view
Budget information Assume the following data for Pet Transport Company: i (Click the icon to view the assumptions.) Requirement (Click the icon to view b Prepare a cash budget for April for Pet Transport. (Round your answers to the nearest v Revenue Budget For the Month of April Units Selling price Total Revenues Manufacturing Overhead Budget For the Month of April Machine setup costs $ 7,700 Cat-allac 490 $ 200 $ 98,000 Processing costs 78,000 51,900 700 Begin the cash budget by calculating the total cash available, then total disbursements, Dog-eriffic 300 260 Inspection costs $ 176,000 $ 60,300 Cash Budget April 30 Total Total Direct Manufacturing Labour Costs Budget Cash balance, April 1 Add receipts Cash sales Credit card sales Total cash available for needs Deduct cash disbursements Direct materials Direct manufacturing labour Manufacturing overhead Nonmanufacturing salaries Sales commissions Other nonmanufacturing fixed costs Machinery purchase Income taxes Total disbursements Financing Repayment of loan Interest on loan Total effects of financing Ending cash balance, April 30 6400 For the Month of April Nonmanufacturing Costs Budget Output units DMLH Total Hourly For the Month of April 52800 produced per unit Hours Wage Rate Total Salaries $ 18,700 118272 Cat-allac 510 3 1,530 $ 171072 Dog-eriffic 285 5 1,425 14 $ 21,420 19,950 14 $ 41,370 Other fixed costs 18,000 Total Sales commissions Total nonmanufacturing costs 1,760 $ 38,460 Assumptions Print Done Pet Transport (PT) does not make any sales on credit. PT sells only to the public and accepts cash and credit cards. Of its sales, 70% are to customers using credit cards, for which PT gets the cash right away, less a 4% transaction fee. Purchases of materials are on account. PT pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March, PT owes suppliers $8,300. PT plans to replace a machine in April at a net cash cost of $13,400. Labour, other production costs, and nonproduction costs are paid in cash in the month incurred except of course, depreciation, which is not a cash flow. For April, $22,000 of the production cost and $13,500 of the nonproduction cost is depreciation. PT currently has a $3,200 loan at an annual interest rate of 6%. The interest is paid at the end of each month. If PT has more than $10,000 cash at the end of April, it will pay back the loan. PT owes $4,800 in income taxes that need to be remitted in April. PT has cash of $6,400 on hand at the end of March.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started