Question

Required information (The following information applies to the questions displayed below.) Iguana, Inc., manufactures bambooRequired: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana. 3. Prepare theComplete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 . Compute the budgeted caRequired 1 Required 2 Required 3 Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000 to

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Description March April   May June July August
Sale-Quantity a                       350                400                 450                  550                525               575
Sale revenue @ 25 per unit $               8,750 $      10,000 $        11,250 $        13,750 $      13,125 $     14,375
Cash Sale-80% A $               7,000 $         8,000 $          9,000 $        11,000 $      10,500 $     11,500
Credit Sale-20% $               1,750 $         2,000 $          2,250 $          2,750 $         2,625 $        2,875
Credit sale collection- same month-50% B $                  875 $         1,000 $          1,125 $          1,375 $         1,313 $        1,438
Credit sale collection- next month-50% C $            875 $          1,000 $          1,125 $         1,375
Monthly sale collection- Cash sale + Credit sale collection same month + Credit sale collection next month D=A+B+C $               7,875 $         9,875 $        11,125 $        13,500 $      13,188 $     12,938
Finished Stock
Opening Stock-Quanitity b                160                 180                  220                210               230
Closing Stock -40% of following month sale c=a*40%                       160                180                 220                  210                230                  -  
Required Units= (Sale+Closing stock) a+c                       510                580                 670                  760                755               575
less openign stock                          -                  160                 180                  220                210               230
Production during the month d=a+c-b                       510                420                 490                  540                545               345
Raw material Bamboo required for production @ 4 Feet e=d*4                   2,040             1,680              1,960              2,160             2,180            1,380
Opening Stock-Quanitity g                504                 588                  648                654               414
Closing Stock -30% of following month production f=e*30%                       504                588                 648                  654                414                  -  
Raw Material Purchase h=e+f-g             1,764              2,020              2,166             1,940               966
Raw Material Purchase cost @ 2.5 per feet h*2.5 $               2,500 $         4,410 $          5,050 $          5,415 $         4,850 $        2,415
Raw material payment- Same month-80% $               2,000 $         3,528 $          4,040 $          4,332 $         3,880 $        1,932
Raw material payment- Next month- 20% $            500 $             882 $          1,010 $         1,083 $           970
Total Payment $               2,000 $        4,028 $          4,922 $          5,342 $        4,963 $       2,902
Labour hours @ 0.5 hours per unit production i=d*0.5                       255                210                 245                  270                273               173
Labour cost @ 14 per hour i*14 $               3,570 $         2,940 $          3,430 $          3,780 $         3,815 $        2,415
Variable overhead @ 0.4 per unit produced j=d*0.4 $                  204 $            168 $             196 $             216 $            218 $           138
Fixed overhead $                  900 $            900 $             900 $             900 $            900 $           900
Selling overheads
Fixed charges $                  650 $            650 $             650 $             650 $            650 $           650
Depreciation $                  300 $            300 $             300 $             300 $            300 $           300
Variable a*0.6 $                  210 $            240 $             270 $             330 $            315 $           345
Budgetd cash payments E= AP payment + Labor cost + Overheads-Depreciation $               7,534 $         8,926 $        10,368 $        11,218 $      10,861 $        7,350
Opening cash $      11,900 $        11,849 $        11,606
Budgeted Receipts D $         9,875 $        11,125 $        13,500
Budgeted Cash payments $       (8,926) $      (10,368) $      (11,218)
Equipment $       (2,000)
Preliminary cash balance $      10,849 $        12,606 $        13,888
Borrow/(paid back) $         1,000 $        (1,000) $                 -  
Closing cash balance $      11,849 $        11,606 $        13,888
Add a comment
Know the answer?
Add Answer to:
Required information (The following information applies to the questions displayed below.) Iguana, Inc., manufactures bamboo picture...
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 [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...

  • [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...

  • 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 $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...

  • [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 raw materials inventory should be 30 percent of next month's...

  • [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.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 raw materials inventory should be 30 percent of next month's...

  • [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 production. Expected...

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

    [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.50 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 raw materials inventory should be 30 percent of next month's production. Expected...

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

    [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 production. Expected...

  • 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 $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...

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