Question
Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 3 linear feet of bamboo, which costs $2.00 per foot. Each
Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 3 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 months sales. |
Ending raw materials inventory should be 30 percent of next months production. |
Expected unit sales (frames) for the upcoming months follow: |
March | 465 |
April | 440 |
May | 490 |
June | 590 |
July | 540 |
August | 615 |
Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $9,100 ($650 per month) for expected production of 7,000 units for the year. Selling and administrative expenses are estimated at $840 per month plus $0.70 per unit sold. |
Iguana, Inc., had $17,000 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,900. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $340 in depreciation. During April, Iguana plans to pay $4,900 for a piece of equipment. |
Required: | |
1. | Compute the budgeted cash receipts for Iguana. (Do not round your intermediate calculations. Round final answers to 2 decimal places.) |
2. | Compute the budgeted cash payments for Iguana. (Do not round your intermediate calculations. Round final answers to 2 decimal places.) |
3. | Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000.00 to maintain a $14,000.00 minimum cash balance. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started