Que 1: | |||||||
Calculation of budgeted cash receipts: | |||||||
Particulars | March | April | May | June | July | August | Total |
Expected sales in units | 285 | 270 | 320 | 420 | 395 | 445 | 1010 |
Sales price per. Unit | 30 | 30 | 30 | 30 | 30 | 30 | 90 |
Expected sales in Value | 8550 | 8100 | 9600 | 12600 | 11850 | 13350 | 30300 |
80% out of total sales is cash sales-A | 6840 | 6480 | 7680 | 10080 | 9480 | 10680 | 24240 |
20% out of total sales is Credit sales | 1710 | 1620 | 1920 | 2520 | 2370 | 2670 | 6060 |
50% of credit sales amount will be collected in the month of sale-B | 855 | 810 | 960 | 1260 | 1185 | 1335 | 3030 |
50% of credit sales amount will be collected in the following month of sale-C | 0 | 855 | 810 | 960 | 1260 | 1185 | 2625 |
Budgeted cash receipts(A+B+C) | 8145 | 9450 | 12300 | 29895 |
Que 2: | |||||||
Calculation of budgeted cash payments: | |||||||
Particulars | March | April | May | June | July | August | Total |
Expected sales in units | 285 | 270 | 320 | 420 | 395 | 445 | 1010 |
Ending Finished goods inventory should be 40% of next months | 108 | 128 | 168 | 158 | 178 | 404 | 454 |
Total production-A | 393 | 398 | 488 | 578 | 573 | 849 | 1464 |
Raw material required for production for the month | 1572 | 1572 | 1572 | 1572 | 1572 | 1572 | 4716 |
Ending Raw material should be 30% of the next month's production | 477.6 | 585.6 | 693.6 | 687.6 | 534 | 0 | 1966.8 |
Total raw material required for production | 2049.6 | 2157.6 | 2265.6 | 2259.6 | 2106 | 1572 | 6682.8 |
Paid for raw material-80% in the same month-1 | 1639.68 | 1726.08 | 1812.48 | 1807.68 | 1684.8 | 1257.6 | 5346.24 |
Paid for raw material-20% in the same month-2 | 0 | 409.92 | 431.52 | 453.12 | 451.92 | 421.2 | 1294.56 |
Labour charges per frame(Each frames take 30 minutes to build, Labour per hour-$13 so per. Frame-6.5)-C | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 19.5 |
Labour charges- A*C-3 | 2554.5 | 2587 | 3172 | 3757 | 3724.5 | 5518.5 | 9516 |
Variable manufacturing OH-D | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 1.5 |
Total variable OH-A*D-4 | 196.5 | 199 | 244 | 289 | 286.5 | 424.5 | 732 |
Fixed OH(700-170 non cash expenses-depreciation)-5 | 530 | 530 | 530 | 530 | 530 | 530 | 1590 |
Selling Expenses-6 | 750 | 750 | 750 | 750 | 750 | 750 | 2250 |
Admin. Expenses (.5 of units sold)(sales units*.5)-7 | 142.5 | 135 | 160 | 210 | 197.5 | 222.5 | 505 |
Paid to a piece of equipment-8 | 0 | 3200 | 0 | 0 | 0 | 0 | 3200 |
Total budgeted cash payments(1+2+3+4+5+6+7+8) | 9537 | 7100 | 7796.8 | 24433.8 |
Que 3: | ||||
Cash budget: | ||||
Particulars | April | May | June | Total |
Beginning cash balance | 11000 | 9608 | 11958 | 32566 |
Plus:Budgeted cash receipts | 8145 | 9450 | 12300 | 29895 |
Less:Budgeted cash payments | 9537 | 7100 | 7796.8 | 24433.8 |
Preliminary cash balance | 0 | 0 | 0 | 0 |
Cash borrowed/repaid | 0 | 0 | 0 | 0 |
Ending cash balance | 9608 | 11958 | 16461.2 | 38027.2 |
[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 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 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 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 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 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 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 production. Expected...
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 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 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 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...