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}.