Prepare the cash budget for iguana

Assignment Help Financial Accounting
Reference no: EM131148638

Iguana, Inc., manufactures bamboo picture frames that sell for $30 each.

Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot.

Each frame takes approximately 30 minutes to build, and the labor rate averages $15 per hour. Iguana has the following inventory policies:

Ending finished goods inventory should be 40 percent of next month's sales.

Ending raw materials inventory should be 30 percent of next month's production.

Expected unit sales (frames) for the upcoming months follow: March 335 April 370 May 420 June 520 July 495 August 545 Variable manufacturing overhead is incurred at a rate of $0.50 per unit produced.

Annual fixed manufacturing overhead is estimated to be $9,000 ($750 per month) for expected production of 4,500 units for the year.

Selling and administrative expenses are estimated at $850 per month plus $0.50 per unit sold.

Iguana, Inc., had $11,000 cash on hand on April

1. Of its sales, 80 percent is in cash. Of the credit sales, 50 percent is collected during the month of the sale, and 50 percent is collected during the month following the sale. Of raw materials purchases, 80 percent is paid for during the month purchased and 20 percent is paid in the following month.

Raw materials purchases for March 1 totaled $3,700. All other operating costs are paid during the month incurred.

Monthly fixed manufacturing overhead includes $270 in depreciation.

During April, Iguana plans to pay $4,200 for a piece of equipment.

2. Compute the budgeted cash payments for Iguana.

(Do not round your intermediate calculations. Round final answers to 2 decimal places.)

Budgeted cash payments April_______ May_______ June__________ 2nd quarter total_______

3. Prepare the cash budget for Iguana.

Assume the company can borrow in increments of $1,000 to maintain a $10,000 minimum cash balance. (Round your answers to 2 decimal places.)

April May June 2nd Quarter Total Beginning Cash Balance $11,000.00 Plus: Budgeted Cash Receipts 10,995.00 12,450.00 15,300.00 38,745.00 Less: Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed / Repaid Ending Cash Balance

Reference no: EM131148638

Questions Cloud

Describe the differences between temperature and heat : Describe the differences and similarities between temperature and heat. Analyze how heat transfer occurs during the processes of conduction and convection. Provide an example of where each occurs in natural physical systems.
Prepare a corporate tax return for 2015 : ACC 404 Corporate Tax Return Project. Using the following information, prepare a corporate tax return for 2015. It is due on Monday, August 1, 2016. You may work on it in a group with up to two other students (maximum of 3 students per group)
How viruses - adware and spyware would impact organization : Provide a review of the potential security issues related to the internal and external communications. Discuss how company communications policies can play an important role in the reduction of communication security risks. Include specifi..
Indicate whether each statement is true or false : One reason managers use the full cost of products as the cost base in their pricing decisions is to promote price stability.- When there is price discrimination, pricing is not linked closely to the cost of the product.
Prepare the cash budget for iguana : Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. - Compute the budgeted cash payments for Iguana.- Prepare the cash budget for Iguana.
Conduct external research from reputable and quality sources : Write a report on how relevant legislation, codes of practice, ethical principles, and national standards affect marketing operations - Briefly describe the following statistical methods and techniques to evaluate marketing opportunities, including..
Describe the importance of rare earth elements in science : Describe the importance of rare earth elements in science and technology. Assess the most common uses of these elements, particularly as encountered in your daily life, as well as projections for future demand of these minerals resources.
Impose a time limit on entering the correct combination : Impose a time limit on entering the correct combination in that after the user enters the first symbol of the combination, he or she has five seconds to enter the entire sequence.
What is the monthly total cost equation : razier Manufacturing Company collected the following production data for the past month:- If the high-low method is used, what is the monthly total cost equation?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Effect as positive negative or unclear

Some of these transactions have an immediately positive effect on the company’s financial condition. Some are definitely negative. Others have an effect that cannot be judged as clearly positive or negative. Evaluate each transaction’s effect as posi..

  What option does business have while financing its operation

What options does a business have while financing its operations? Which of the following expenditures would not be included in the cost of a fixed asset?

  Amount of cost of goods sold the ending inventory balance

During 2014, Welch Manufacturing Company incurred $51,600,000 of research and development (R&D) costs to create a long-life battery to use in computers. In accordance with FASB standards, the entire R&D cost was recognized as an expense in 2014. Dete..

  Management of organization-planning-directing-controlling

Listed below are the three functions of the management of an organization. Planning. Directing. Controlling. requires management to look ahead and to establish objectives. A key objective of management is to add value to the business. _____ involves ..

  How many units of each product

How many units of each product could it produce in order to maximize operating income

  Probability of audit

Probability of Audit - What judicial concept might the IRS invoke to question this transaction

  Calculating additional finance requirementsthe cfo of ipod

calculating additional finance requirements.the cfo of ipod accessories inc. has asked for your help in estimating the

  Compute the incorrect trial balance totals for debits

Compute the incorrect trial balance totals for debits and credits. Then show how to correct this error.

  Calculate the payback period of the investment

Calculate the net present value of the proposed investment in the new sewing machine - calculate the present value ratio of the investment.

  Short description computation of total cash received from

short description computation of total cash received from the selling of merchandise.first company sold merchandise on

  Determine whether you agree with lois conclusion

For each identified obligation, determine whether you agree with LOI's conclusion and discuss the basis for your determination.

  Determine the net incomefrom the given datavariable and

determine the net incomefrom the given data.variable and absorption costing unit product costs and income statement

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd