Question

Required information SB Problem PA8-1 to PA8-3 The following information applies to the questions displayed below. Iguana, InRequired: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana. 3. Prepare theRequired 1 Required 2 Required 3 Compute the budgeted cash payments for Iguana. (Do not round your intermediate calculations.Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000 to maintain a $11,000 minimum cash

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Iguana
Sales Budget March April May June 2nd Qtr. Total July August Note
Budgeted Sales units        295.00         290.00         340.00         440.00         415.00         465.00 A
Sell price per unit          30.00           30.00           30.00           30.00           30.00           30.00 B
Budgeted Sales Revenue     8,850.00     8,700.00 10,200.00 13,200.00       32,100.00 12,450.00 13,950.00 C=A*B
Cash sale is 80%     7,080.00      6,960.00      8,160.00 10,560.00       25,680.00 D=C*80%
Credit sale is 20%     1,770.00      1,740.00      2,040.00      2,640.00         6,420.00 E=C*20%
Answer 1
Budgeted cash receipts April May June 2nd Qtr. Total
Cash sale      6,960.00      8,160.00 10,560.00       25,680.00 See D
50% of Credit sale in the same month         870.00      1,020.00      1,320.00         3,210.00 F= 50% of E
50% of Credit sale in the following same month         885.00         870.00      1,020.00         2,775.00 G= 50% of E of previous month.
Budgeted cash receipts     8,715.00 10,050.00 12,900.00       31,665.00 H=D+F+G
Budgeted Production in Units March April May June 2nd Qtr. Total July August
Budgeted Sales units        295.00         290.00         340.00         440.00         415.00         465.00 See A
Add: Closing        116.00         136.00         176.00         166.00         186.00 I= 40% of A of next month.
Less: Opening        118.00         116.00         136.00         176.00         166.00 J= 40% of A of same month.
Budgeted Production in Units        293.00         310.00         380.00         430.00         435.00 X
Budgeted cost of Raw Material Purchases March April May June 2nd Qtr. Total July
Production Budget         310.00         380.00         430.00         435.00 See X
Bamboo required per unit             4.00             4.00             4.00             4.00 K
Bamboo required      1,240.00      1,520.00      1,720.00      1,740.00 L=K*X
Add: Closing         456.00         516.00         522.00 M= 30% of L of next month.
Less: Opening         372.00         456.00         516.00 N= 30% of L of same month.
Budgeted Raw Material Purchases     1,324.00     1,580.00     1,726.00 Y
Cost per foot             2.50             2.50             2.50 O
Budgeted cost of Raw Material Purchases     2,600.00     3,310.00     3,950.00     4,315.00 P=Y*O
80% paid in same month      2,648.00      3,160.00      3,452.00         9,260.00 Q=P*80%
20% paid in next month         520.00         662.00         790.00         1,972.00 R= 20% of P of previous month.
Direct Material Payment     3,168.00     3,822.00     4,242.00       11,232.00 W=Q+R
Budgeted Direct Labor cost April May June 2nd Qtr. Total
Production Budget         310.00         380.00         430.00 See X
Labor Hour required per unit             0.50             0.50             0.50 Z
Total Labor Hour required         155.00         190.00         215.00 AA= X*Z
Labor Rate per Hour           14.00           14.00           14.00 AB
Budgeted Direct Labor cost     2,170.00     2,660.00     3,010.00         7,840.00 AC=AA*AB
Budgeted manufacturing overhead April May June 2nd Qtr. Total
Production Budget         310.00         380.00         430.00 See J
Variable manufacturing overhead per unit             0.20             0.20             0.20 S
Variable manufacturing overhead Budget           62.00           76.00           86.00            224.00 T=J*S
Fixed manufacturing overhead Budget         750.00         750.00         750.00         2,250.00 E
Budgeted manufacturing overhead         812.00         826.00         836.00         2,474.00 F=T+E
Total Selling & admin expenses Budget April May June 2nd Qtr. Total
Budgeted Sales units         290.00         340.00         440.00 See A
Variable Selling & admin expenses per unit             0.50             0.50             0.50 U
Variable Selling & admin expenses Budget         145.00         170.00         220.00            535.00 V=A*U
Fixed Selling & admin expenses Budget         800.00         800.00         800.00         2,400.00 R
Total Selling & admin expenses Budget         945.00         970.00     1,020.00         2,935.00 S=V+R
Answer 2
Budget cash payments April May June 2nd Qtr. Total
Direct Material      3,168.00      3,822.00      4,242.00       11,232.00
Direct Labor      2,170.00      2,660.00      3,010.00         7,840.00
Manufacturing Overhead (excl. depreciation)         622.00         636.00         646.00         1,904.00
Selling & admin expenses         945.00         970.00      1,020.00         2,935.00
Payment for equipment      3,400.00                  -                    -           3,400.00
Budget cash payments 10,305.00     8,088.00     8,918.00       27,311.00 W
Answer 3
Cash budget April May June 2nd Qtr. Total
Beginning Cash Balance 11,800.00 11,210.00 12,172.00
Plus: Budgeted cash receipts      8,715.00 10,050.00 12,900.00       31,665.00 See H
Less: Budget cash payments 10,305.00      8,088.00      8,918.00       27,311.00 See W
Preliminary cash balance 10,210.00 13,172.00 16,154.00
Cash borrowed/ (repaid)      1,000.00    (1,000.00)                  -                       -  
Ending cash balance 11,210.00 12,172.00 16,154.00
Add a comment
Know the answer?
Add Answer to:
Required information SB Problem PA8-1 to PA8-3 The following information applies to the questions displayed below....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required information SB Problem PA8-1 to PA8-3 The following information applies to the questions displayed below.]...

    Required information SB Problem PA8-1 to PA8-3 The following information applies to the questions displayed below.] 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 $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...

  • SB Problem PA8-1 to PA8-3 [The following information applies to the questions displayed below.] Iguana, Inc.,...

    SB Problem PA8-1 to PA8-3 [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $20 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 $13 per hour. Iguana has the following inventory policies: • Ending finished goods inventory should be 40 percent of next month's sales. • Ending raw materials inventory should be...

  • Required information SB Problem PA8-1 to PA8-3 (The following information applies to the questions displayed below.)...

    Required information SB Problem PA8-1 to PA8-3 (The following information applies to the questions displayed below.) 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 $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...

  • SB Problem PA8-1 to PAB-3 The following information applies to the questions played below Iguanane, manufactures...

    SB Problem PA8-1 to PAB-3 The following information applies to the questions played below Iguanane, manufactures bamboo picture frames that sell for $20 each Each averages $13 per hour Iguana has the following inventory policies me requires 4 linear feet of bamboo which costs $150 per foot Each trametas o mately 30 minutes to build and the laborate • Ending finished goods inventory should be 40 percent of next month's sales • Ending raw materials inventory should be 30 percent...

  • Required Information SB Problem PA8-1 to PA8-3 The following Information applies to the questions displayed below] Igu...

    Required Information SB Problem PA8-1 to PA8-3 The following Information applies to the questions displayed below] Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo. which costs $2.50 per foot. Each frame takes approximately 30 minutes to bulld, and the labor rate averages $14 per hour Iguana has the following inventory policles Ending finished goods Inventory should be 40 percent of next month's sales. Ending direct materlals inventory should be...

  • Required information (The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture...

    Required information (The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 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...

  • Required information [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture...

    Required information [The following information applies to the questions displayed below.] 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 $13 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending raw materials inventory should be 30 percent of next month’s...

  • Required information [The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture...

    Required information [The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 4 linear feet of bamboo, which costs $1.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13 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...

  • [The following information applies to the questions displayed below) Iguana, Inc., manufactures bamboo picture frames that...

    [The following information applies to the questions displayed below) 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 $12.00 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...

  • [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that...

    [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $30 each. Each frame requires 4 linear feet of bamboo, which costs $3.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13 per hour. Iguana has the following inventory policies: • Ending finished goods inventory should be 40 percent of next month's sales. • Ending raw materials inventory should be 30 percent of next month's...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT