Questions: Iguana, Incorporated, manufactures bamboo picture frames that sell for 25 each. Each bamboo, which costs 3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages 12 per hour. Iguana has the following inventory policies: - Ending finished goods inventory should be 40 percent of next month's sales. - Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March: 320 April: 340 May: 390 June: 490 July: 465 August: 515 Variable manufacturing overhead is incurred at a rate of 0.20 per unit produced. Annual fixed manufacturing overhead is estimated to be 7,200 (600 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at 650 per month plus 0.50 per unit sold. Iguana, Incorporated, had 10,500 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 direct materials purchases, 80 percent is paid for during the month purchased and 20 percent is paid in the following month. Direct materials purchases for March 1 totaled 2,000. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes 240 in depreciation. During April, Iguana plans to pay 2,000 for a piece of equipment. Required: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana.

Iguana, Incorporated, manufactures bamboo picture frames that sell for 25 each. Each bamboo, which costs 3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages 12 per hour. Iguana has the following inventory policies:
- Ending finished goods inventory should be 40 percent of next month's sales.
- Ending direct materials inventory should be 30 percent of next month's production.

Expected unit sales (frames) for the upcoming months follow:
March: 320
April: 340
May: 390
June: 490
July: 465
August: 515

Variable manufacturing overhead is incurred at a rate of 0.20 per unit produced. Annual fixed manufacturing overhead is estimated to be 7,200 (600 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at 650 per month plus 0.50 per unit sold.

Iguana, Incorporated, had 10,500 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 direct materials purchases, 80 percent is paid for during the month purchased and 20 percent is paid in the following month. Direct materials purchases for March 1 totaled 2,000. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes 240 in depreciation. During April, Iguana plans to pay 2,000 for a piece of equipment.

Required:
1. Compute the budgeted cash receipts for Iguana.
2. Compute the budgeted cash payments for Iguana.
Transcript text: Iguana, Incorporated, manufactures bamboo picture frames that sell for $\$ 25$ eacn. Each bamboo, which costs $\$ 3.00$ per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $\$ 12$ per hour. Iguana has the following inventory policies: - Ending finished goods inventory should be 40 percent of next month's sales. - Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: \begin{tabular}{ll} March & 320 \\ April & 340 \\ May & 390 \\ June & 490 \\ July & 465 \\ August & 515 \end{tabular} Variable manufacturing overhead is incurred at a rate of $\$ 0.20$ per unit produced. Annual fixed manufacturing overhead is estimated to be $\$ 7,200$ ( $\$ 600$ per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $\$ 650$ per month plus $\$ 0.50$ per unit sold. Iguana, Incorporated, had $\$ 10,500$ 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 direct materials purchases, 80 percent is paid for during the month purchased and 20 percent is paid in the following month. Direct materials purchases for March 1 totaled $\$ 2,000$. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $\$ 240$ in depreciation. During April, Iguana plans to pay $\$ 2,000$ for a plece of equipment. Required: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana.
failed

Solution

failed
failed

Okay, I will compute the budgeted cash payments for Iguana, Incorporated for April.

2. Compute the budgeted cash payments for Iguana.

We need to calculate all cash outflows for Iguana in April. These include:

  • Direct Materials Purchases
  • Direct Labor
  • Variable Manufacturing Overhead
  • Fixed Manufacturing Overhead
  • Selling and Administrative Expenses
  • Equipment Purchase
  • Payment for March Direct Material Purchases

First, we need to calculate the production budget for April.

Production Budget:

  • April Sales: {340} units
  • Desired Ending Finished Goods Inventory (40% of May sales): {0.40 * 390 = 156} units
  • Total Units Needed: {340 + 156 = 496} units
  • Beginning Finished Goods Inventory (40% of April sales): {0.40 * 340 = 136} units
  • Units to Produce: {496 - 136 = 360} units

Next, we need to calculate the direct materials purchases for April.

Direct Materials Purchases Budget:

  • Units to Produce in April: {360} units
  • Units to Produce in May: {390} units
  • Bamboo per Frame: Unknown. Let's assume that each frame requires \( x \) feet of bamboo.
  • Total Bamboo Needed for April Production: {360 * x} feet
  • Desired Ending Direct Materials Inventory (30% of May production): {0.30 * 390 * x = 117x} feet
  • Total Bamboo Required: {360x + 117x = 477x} feet
  • Beginning Direct Materials Inventory (30% of April production): {0.30 * 360 * x = 108x} feet
  • Bamboo to Purchase: {477x - 108x = 369x} feet
  • Cost per Foot of Bamboo: {\$3.00}
  • Total Direct Materials Purchases: {\$3.00 * 369x = \$1107x}

However, the problem does not define "x". Instead, let's define the direct materials purchases in terms of dollars. Let's assume that each frame needs \( y \) dollars of bamboo.

  • Direct Materials Needed for April Production: {360 * y} dollars
  • Desired Ending Direct Materials Inventory (30% of May production): {0.30 * 390 * y = 117y} dollars
  • Total Direct Materials Required: {360y + 117y = 477y} dollars
  • Beginning Direct Materials Inventory (30% of April production): {0.30 * 360 * y = 108y} dollars
  • Direct Materials to Purchase: {477y - 108y = 369y} dollars

We need to somehow define the value of _y_. Let us work backwards from the March purchases which are given as {\$2000}. We know from the data that March sales are {320} frames and April production is {360} frames. Then:

Beginning Direct Materials Inventory for April = {0.30 * y * 360 = 108y} dollars, which must have come from March purchases.

We can also assume that March direct materials are proportional to the frames, so March Direct Material {320} frames, April Direct Material {360} frames (\$2000/320)*360 = {\$2250}

Therefore the total direct materials purchases are {\$2250}.

Now we can calculate the cash payments:

  • Payment for March Direct Materials: {0.20 * \$2,000 = \$400}
  • Direct Materials Purchases for April: {\$2,250}
  • Direct Materials Cash Payment (80%): {0.80 * \$2,250 = \$1,800}
  • Direct Labor (360 units * 0.5 hours/unit * \$12/hour): {\$2,160}
  • Variable Manufacturing Overhead (360 units * \$0.20/unit): {\$72}
  • Fixed Manufacturing Overhead: {\$600}
  • Selling and Administrative Expenses (\$650 + 340 units * \$0.50/unit): {\$650 + \$170 = \$820}
  • Equipment Purchase: {\$2,000}

Total Budgeted Cash Payments:

{\$400 (March DM) + \$1,800 (April DM) + \$2,160 (Labor) + \$72 (Var. OH) + \$600 (Fixed OH) + \$820 (S\&A) + \$2,000 (Equipment) = \$7,852}

Answer: The budgeted cash payments for Iguana, Incorporated for April are {\$7,852}.

Was this solution helpful?
failed
Unhelpful
failed
Helpful