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

  Uses the perpetual method

BeCo, which uses the perpetual method, records merchandise purchases at gross. On October 3, BeCo buys $42,000 of merchandise on account. Terms are 2/10,n/40. On October 11, BeCo pays $31,360. What journal entry does BeCo record on October 11?

  Clearing house for business students

If it costs about the same amount per minute for processing witheither of the two methods, when should each be used?

  Decision-making case study

Should directly connect with the customer and should talk about the two important events - Contents must give a clear idea about the best deals and new product range which will help in attracting the customer.

  The first-in-first-out method of inventory costing is used

Department G had 3,842 units, one-third completed at the beginning of the period, 12,391 units were completed during the period, 1,623 units were one-fifth completed at the end of the period, and the following manufacturing costs were debited to the ..

  Assuming that the company uses variable costing

McIntyre Manufacturing produces a single product. Last year, the company produced 20,000 units, out of which 18,000 were sold. There were no units in beginning inventory. Calculate McIntyre's product cost per unit, assuming that the company uses vari..

  Advantages and disadvantages of the fifo method

Explain in your own words the FIFO (First In First Out) method. How is this inventory method calculated? What are some of the advantages and disadvantages of the FIFO method? Thoroughly describe why the Direct Write-Off Method of Uncollectible Accoun..

  List out five pieces of information you want to obtain

List out five pieces of information you want to obtain to aid you in your forecast, explaining why this will aid you in your forecast.

  Brief report advising management on the relative merits

Each project requires an investment of $480,000. A rate of 15% has been selected for the net present value analysis and prepare a brief report advising management on the relative merits of each project.

  Fill in the missing amounts in each of eight case situation

Assume that only one product is being sold in each of the four following case situations: (Input all amounts as positive values except losses which should be indicated by a minus sign. Omit the "$" sign in your response.)

  Nutritional interventions and acupuncture intervention

Give information about the Nutritional interventions and Acupuncture intervention for ADHD.

  Prepare the schedules for each month in the first quarter

Prepare the schedules for each month in the first quarter of 2010 and for the quarter in total expected collections from clients.

  Prepare journal entries for the transactions that occurred

Enter the adjusting entry for bad debt expense at the end of 20-6. Prepare journal entries for the transactions that occurred in 20-7.

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