Question
Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each
Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $11.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 | 295 |
April | 270 |
May | 320 |
June | 420 |
July | 395 |
August | 445 |
Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $8,400 ($700 per month) for expected production of 6,000 units for the year. Selling and administrative expenses are estimated at $670 per month plus $0.70 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% 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 $2,200. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $170 in depreciation. During April, Iguana plans to pay $3,200 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 $10,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