Assume the following data for Pet Gear Company: (Click the icon to view the assumptions.) Requirement...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume the following data for Pet Gear Company: (Click the icon to view the assumptions.) Requirement (Click the icon to view budget information.) Prepare a cash budget for April for Pet Gear. (Round your answers to the nearest whole dollar.) Begin the cash budget by calculating the total cash available, then total disbursements, and finally the effects of financing and the ending cash balance. (Round amounts to the nearest whole dollar.) Cash balance, April 1 Add receipts Cash Budget April 30 Total cash available for needs Budget information Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 550 $ Dog-eriffic 320 Total Manufacturing Overhead Budget For the Month of April Machine setup costs $ 7,400 180 $ 99,000 Processing costs 51,400 275 88,000 200 Inspection costs $ 187,000 $ 59,000 Total Direct Manufacturing Labour Costs Budget For the Month of April Nonmanufacturing Costs Budget Output units DMLH Total Hourly For the Month of April produced per unit Hours Wage Rate Total Salaries $ 18,300 Cat-allac 570 3 1,710 $ 14 $ 23,940 Other fixed costs 17,500 Dog-eriffic 305 21,350 5 1,525 14 Sales commissions 1,870 $ 45,290 Total Total nonmanufacturing costs $ 37,670 Print Done or Assumptions Pet Gear (PG) does not make any sales on credit. PG sells only to the public and accepts cash and credit cards. Of its sales, 80% are to customers using credit cards, for which PG gets the cash right away, less a 3% transaction fee. Purchases of materials are on account. PG pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March, PG owes suppliers $7,800. PG plans to replace a machine in April at a net cash cost of $13,500. 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,000 of the nonproduction cost is depreciation. PG currently has a $1,800 loan at an annual interest rate of 18%. The interest is paid at the end of each month. If PG has more than $10,000 cash at the end of April, it will pay back the loan. PG owes $5,100 in income taxes that need to be remitted in April. PG has cash of $6,600 on hand at the end of March. or Print Done - X Requirement Prepare a cash budget for April for Pet Gear. (Round your answers to the nearest whole dollar.) Assume the following data for Pet Gear Company: (Click the icon to view the assumptions.) Requirement (Click the icon to view budget information.) Prepare a cash budget for April for Pet Gear. (Round your answers to the nearest whole dollar.) Begin the cash budget by calculating the total cash available, then total disbursements, and finally the effects of financing and the ending cash balance. (Round amounts to the nearest whole dollar.) Cash balance, April 1 Add receipts Cash Budget April 30 Total cash available for needs Budget information Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 550 $ Dog-eriffic 320 Total Manufacturing Overhead Budget For the Month of April Machine setup costs $ 7,400 180 $ 99,000 Processing costs 51,400 275 88,000 200 Inspection costs $ 187,000 $ 59,000 Total Direct Manufacturing Labour Costs Budget For the Month of April Nonmanufacturing Costs Budget Output units DMLH Total Hourly For the Month of April produced per unit Hours Wage Rate Total Salaries $ 18,300 Cat-allac 570 3 1,710 $ 14 $ 23,940 Other fixed costs 17,500 Dog-eriffic 305 21,350 5 1,525 14 Sales commissions 1,870 $ 45,290 Total Total nonmanufacturing costs $ 37,670 Print Done or Assumptions Pet Gear (PG) does not make any sales on credit. PG sells only to the public and accepts cash and credit cards. Of its sales, 80% are to customers using credit cards, for which PG gets the cash right away, less a 3% transaction fee. Purchases of materials are on account. PG pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March, PG owes suppliers $7,800. PG plans to replace a machine in April at a net cash cost of $13,500. 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,000 of the nonproduction cost is depreciation. PG currently has a $1,800 loan at an annual interest rate of 18%. The interest is paid at the end of each month. If PG has more than $10,000 cash at the end of April, it will pay back the loan. PG owes $5,100 in income taxes that need to be remitted in April. PG has cash of $6,600 on hand at the end of March. or Print Done - X Requirement Prepare a cash budget for April for Pet Gear. (Round your answers to the nearest whole dollar.)
Expert Answer:
Related Book For
Accounting
ISBN: 978-0324662962
23rd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these accounting questions
-
The US Womens Swimming Team won the 1500 m relay at the 2016 Olympic Games. Here are the completion times, in seconds, for all eight teams that competed in the finals: a. Calculate the sample...
-
Can two different entities have the same defining attributes? Explain.
-
Enumclaw Brick, Inc., manufactures bricks using clay deposits on the companys property. Raw clays are blended and then extruded into molds to form unfired bricks. The unfired bricks are then stacked...
-
In what two ways can the breakeven point be stated?
-
Emma Doyle, age 55, is employed as a corporate attorney. For calendar year 2014, she had AGI of $100,000 and paid the following medical expenses: Medical insurance premiums .................. $3,700...
-
Dani Corporation has 8 million shares of common stock outstanding. The current share price is $82, and the book value per share is $6. The company also has two bond issues outstanding. The first bond...
-
What steps are involved when monitoring performance? Give three (3) good key performance indicators in relation to your role in the organisation. 9. What are the different ways an organisation can...
-
Mah, Seng Company Berhad had total earnings last year of $5 million but expects total earnings to drop to $4,750,000 this year because of a slowdown in the consumer sector. There are currently 1...
-
Mackenzie Mining has two operating divisions, Northern and Southern, that share the common costs of the company's human resources (HR) department. The annual costs of the HR department total...
-
Can you explain how a company undertaking a share buyback and using either its existing reserves or borrowing money could result in an increase in its share price. How is value being created for...
-
8 . You are applying for a mortgage loan at 5 . 7 5 % over 3 0 years with monthly payments. The home you are considering is at a price of $ 2 2 9 , 0 0 0 . Lenders are offering 8 0 % loan to value...
-
Explain whether the process of vertical technology transfer and technology commercialization are identical or distinct process.
-
Clarissa McWhirter, vice-president of Cyprus Company, was pleased to see a small variance on the income statement after the trouble the company had been having in controlling manufacturing costs. She...
-
After graduating from college and working a few years at a small technology firm. Preet scored a high-level job in the logistics department at Amex Corporation. Amex sells high-quality electronic...
-
Do you think it is ethically appropriate for a plaintiff to be able to bring a lawsuit against an auditor for RICO violations? Do you think an auditor should be held legally liable under the RICO...
-
Statement on Auditing Standards (SAS) No. 90, Audit Committee Communications, requires the auditor to discuss with the audit committee the quality, not just the acceptability, of the accounting...
-
In a speech titled "A QT Report Card for High Quality Financial Reporting." at the Critical Issues in Accounting Forum program sponsored by Wake Forest University, Lynn Turner, former chief...
Study smarter with the SolutionInn App