Question
Iguana, Inc., manufactures bamboo picture frames that sell for $35 each. Each frame requires 5 linear feet of bamboo, which costs $3.00 per foot. Each
Iguana, Inc., manufactures bamboo picture frames that sell for $35 each. Each frame requires 5 linear feet of bamboo, which costs $3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $18.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 | 365 |
April | 340 |
May | 390 |
June | 490 |
July | 460 |
August | 515 |
Variable manufacturing overhead is incurred at a rate of $0.50 per unit produced. Annual fixed manufacturing overhead is estimated to be $6,000 ($600 per month) for expected production of 5,000 units for the year. Selling and administrative expenses are estimated at $740 per month plus $0.80 per unit sold. |
Iguana, Inc., had $11,700 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,900. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $240 in depreciation. During April, Iguana plans to pay $3,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 cashbudget for Iguana. Assume the company can borrow in increments of $1,000.00to maintain a $11,000.00minimum 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