Assume the following data for Pet Luggage Company: 1 (Click the icon to view the assumptions.)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume the following data for Pet Luggage Company: 1 (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 Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 580 S 190 S 110,200 55,900 Dog-eriffic 215 260 166,100 Total Manufacturing Overhead Budget For the Month of April Machine setup costs 9,100 Processing costs 60,000 480 Inspection costs $ 69,580 Total Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced per unit Hours Wage Rate Total Cat-allac 600 3 1,800 $ 14 $ 25,200 For the Month of April Output units DMLH Total Hourly produced per unit Hours Wage Rate Total Cat-allac 600 3 1,800 $ 14 $ 25,200 Dog-eriffic 200 1,000 14 14,000 $ 39,200 Total Nonmanufacturing Costs Budget For the Month of April Salaries $ 18,800 Other fixed costs 18,000 1,661 Sales commissions $ 38,461 Total nonmanufacturing costs Pet Luggage (PL) does not make any sales on credit. PL sells only to the public and accepts cash and credit cards; 90% of its sales are to customers using credit cards, for which PL gets the cash right away, less a 2% transaction fee. • Purchases of materials are on account. PL pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March, PL owes suppliers $8,200. During April they plan to purchase direct materials worth $13,310. • PL plans to replace a machine in April at a net cash cost of $13,400. • 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 $21,000 of the manufacturing cost and $10,500 of the nonmanufacturing (fixed) cost for April. • PL currently has a $2,900 loan at an annual interest rate of 24%. The interest is paid at the end of each month. If PL has more than $10,000 cash at the end of April it will pay back the loan. PL owes $5,800 in income taxes that need to be remitted in April. PL has cash of $5,200 on hand at the end of March. Assume the following data for Pet Luggage Company: 1 (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 Revenue Budget For the Month of April Units Selling price Total Revenues Cat-allac 580 S 190 S 110,200 55,900 Dog-eriffic 215 260 166,100 Total Manufacturing Overhead Budget For the Month of April Machine setup costs 9,100 Processing costs 60,000 480 Inspection costs $ 69,580 Total Direct Manufacturing Labor Costs Budget For the Month of April Output units DMLH Total Hourly produced per unit Hours Wage Rate Total Cat-allac 600 3 1,800 $ 14 $ 25,200 For the Month of April Output units DMLH Total Hourly produced per unit Hours Wage Rate Total Cat-allac 600 3 1,800 $ 14 $ 25,200 Dog-eriffic 200 1,000 14 14,000 $ 39,200 Total Nonmanufacturing Costs Budget For the Month of April Salaries $ 18,800 Other fixed costs 18,000 1,661 Sales commissions $ 38,461 Total nonmanufacturing costs Pet Luggage (PL) does not make any sales on credit. PL sells only to the public and accepts cash and credit cards; 90% of its sales are to customers using credit cards, for which PL gets the cash right away, less a 2% transaction fee. • Purchases of materials are on account. PL pays for half the purchases in the period of the purchase and the other half in the following period. At the end of March, PL owes suppliers $8,200. During April they plan to purchase direct materials worth $13,310. • PL plans to replace a machine in April at a net cash cost of $13,400. • 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 $21,000 of the manufacturing cost and $10,500 of the nonmanufacturing (fixed) cost for April. • PL currently has a $2,900 loan at an annual interest rate of 24%. The interest is paid at the end of each month. If PL has more than $10,000 cash at the end of April it will pay back the loan. PL owes $5,800 in income taxes that need to be remitted in April. PL has cash of $5,200 on hand at the end of March.
Expert Answer:
Answer rating: 100% (QA)
Pet Luggage Collection Budget April Total sale 16610000 A Cash sale at 10 1661000 BA10 Credit ... View the full answer
Related Book For
Accounting
ISBN: 978-1337899451
27th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
Assume the following data for Lusk Inc. before its year-end adjustments: Journalize the adjusting entries for the following: a. Estimated customer allowances b. Estimated customer returns? Unadjusted...
-
Assume the following data for Interactive Technology and Silicon Software. a. Compute return on shareholders' equity for both firms. Which firm has the higher return? b. Compute the following ratios...
-
The budget committee of Litwin Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2014. 1. Sales for May are expected to be...
-
Develop a media plan that supports the planned marketing campaign. Include: a media budget, recommendations and rationale for the selected and integrated multi-media activities within the set budget...
-
The time t required to empty a tank varies inversely as the rate r of pumping. If a pump can empty a tank in 35 min at the rate of 800 kL/min, how long will it take the pump to empty the same tank at...
-
The beginning balance in the Machinery control account and Accumulated Depreciation account, and dates in the accounts for various machinery acquisitions and disposals during the year by Liu Ltd are...
-
Use Table 1, or software, to find (a) \(B(7 ; 18,0.45)\); (b) \(b(7 ; 18,0.45)\); (c) \(B(8 ; 11,0.95)\); (d) \(b(8 ; 11,0.95)\); (e) \(\sum_{k=4}^{11} b(k ; 11,0.35)\); (f) \(\sum_{k=2}^{4} b(k ;...
-
What is the time value of money? Why should accountants have an understanding of compound interest, annuities, and present value concepts?
-
Rubber and Steel Company is planning to manufacture a new product. The variable manufacturing costs will be $57 per unit and the fixed costs are estimated to be $6819 The selling price of the product...
-
The Sally Coffee Shop is considering closing one hour earlier in the evening through the week. Sally obtained the following data from a study taken last week of the number of customers between the...
-
2. (30 points) Complete the gradient descent optimizers (gradient descent and stochastic gradi- ent descent). Use the code to conduct the following experiments: (a) (15 points) Implement ridge...
-
After studying the fundamental trends from COX Company's annual report, you have decided to purchase one round lot of the firm's stock on the open market. On Monday morning you call a stockbroker and...
-
Included in Arco Companys December 31, 2015, trial balance are the following accounts: Accounts Payable 220,000, Pension Liability 375,000, Advances from Customers 41,000, Bonds Payable 371,000,...
-
What are the benefits and drawbacks of using tracking Gantt charts as a monitoring tool?
-
If there are 20 multiple choice questions in an exam, and each question has two possible answers, how many different answers are possible?
-
How many different outcomes are possible if a fair die is rolled 6 times and how many if a fair coin is tossed 8 times? Explain the difference between the results of the two.
-
What is the exception principle of control? Give some examples of exception principle of control. How it works.
-
Using the information presented in Problem 13.4B, prepare a partial statement of cash flows for the current year, showing the computation of net cash flows from operating activities using the...
-
Daryl Kirby opened Squid Realty Co. on January 1, 2018. At the end of the first year, the business needed additional capital. On behalf of Squid Realty Co., Daryl applied to Ocean National Bank for a...
-
Product AA is normally sold for $120 per unit. A special price of $112 is offered for the export market. The variable production cost is $80 per unit. An additional export tariff of 30% of revenue...
-
Hahn Flooring Company's perpetual inventory records indicate that $1,333,150 of merchandise should be on hand on December 31, 2019. The physical inventory indicates that $1,309,900 of merchandise is...
-
Which is an advantage to an employee who participates in a profit-sharing plan? A. Employee does not have to make investment decisions. B. Graded vesting schedule. C. Older employees receive the...
-
Which of the following is not a characteristic of a defined benefit plan? A. A guaranteed retirement benefit. B. Risk of preretirement inflation assumed by employer. C. Benefits based upon the...
-
Which of the following is true about cash balance plans? I. Past service credit is available. II. Employer guarantees a minimum rate of return. III. Participants direct investments in hypothetical...
Study smarter with the SolutionInn App