Compute the budgeted cash payments for iguana iguana inc

Reference no: EM13579665

Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 5 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13.00 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	425
April	400
May	450
June	550
July	450
August	580

Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead is estimated to be $5,400 ($900 per month) for expected production of 3,000 units for the year. Selling and administrative expenses are estimated at $800 per month plus $0.60 per unit sold.

Iguana, Inc., had $16,100 cash on hand on April 1... Of its sales, 80 percent is in cash. Of the credit sales, 50% is collected during the month of the sale, and 50% 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,500. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $300 in depreciation. During April, Iguana plans to pay $4,500 for a piece of equipment.

1.	Compute the budgeted cash receipts for Iguana. (Do not round your intermediate calculations. Round final answers to 2 decimal places.)

	April	May	June	2nd Quarter Total
Budgeted Cash Receipts

Compute the budgeted cash payments for Iguana. (Do not round your intermediate calculations. Round final answers to 2 decimal places.)

	April	May	June	2nd Quarter Total
Budgeted Cash Payments

3.	Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000.00 to maintain a $15,000.00 minimum cash balance.

	April	May	June	2nd Quater total
Beginning Cash Balance
Plus: Budgeted Cash Receipts
Less: Budgeted Cash Payments
Preliminary Cash Balance
Cash Borrowed/Repaid
Ending Cash Balance

Reference no: EM13579665

Questions Cloud

Edison corporation paid a dividend of 10 per share on its : 1. on may 1 2014 stanton company purchased 60000 of harris companys 12 bonds at 100 plus accrued interest of 2400. on

The standard deviation of a distribution is 20 if a sample : the standard deviation of a distribution is 20. if a sample of 225 is selected what is the standard error of the

Consider the following budget information materials to be : consider the following budget information materials to be used totals 65854 direct labor totals 201900 factory overhead

A random sample of 30 students was selected and the : a researcher knows that the population mean among college students taking social conformity test is neutral100. scores

Compute the budgeted cash payments for iguana iguana inc : iguana inc. manufactures bamboo picture frames that sell for 25 each. each frame requires 5 linear feet of bamboo which

Next years sales forecast shows that 20000 units of product : next years sales forecast shows that 20000 units of product a and 22000 units of product b are going to be sold for

Eplain the statistical analysis hint define a : i just need someone to answer all the question with a paragraph each. just needs to be a page 1-2 pages max. i am a

A firm expects to sell 27000 units of its product at 12 : a firm expects to sell 27000 units of its product at 12 per unit. pretax income is predicted to be 70000. if the

Bradford company budgeted 4200 pounds of material costing : bradford company budgeted 4200 pounds of material costing 5.4 per pound to produce 2100 units. the company actually

User Account

All Pages