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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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