2nd Quarter | |||||
April | May | June | Total | ||
1 | Budgeted Sales Revenue | 5600 | 6300 | 7700 | 19600 |
2 | Budgeted Production in Units | 420 | 490 | 540 | 1450 |
3 | Budgeted Cost of Raw Material Purchases | 4410 | 5050 | 5415 | 14875 |
4 | Budgeted Direct Labor Cost | 2940 | 3430 | 3780 | 10150 |
5 | Budgeted Manufacturing Overhead | 1060 | 1080 | 1120 | 3260 |
6 | Budgeted Cost of Goods Sold | 39200 | 44100 | 53900 | 137200 |
7 | Total Budgeted Selling and adm. Expenses | 1190 | 1220 | 1280 | 3690 |
Workings:
Sales | March | April | May | June | July | August |
Expected Unit sales | 350 | 400 | 450 | 550 | 525 | 575 |
Sales (Expected unit Sales x 14) | 4900 | 5600 | 6300 | 7700 | 7350 | 8050 |
Cost of goods sold (Expected unit Sales x 7) | 34300 | 39200 | 44100 | 53900 | 51450 | 56350 |
Finished goods at end of the month (40% of next months sales) | 160 | 180 | 220 | 210 | 230 | |
Production units | ||||||
Finished goods-End of the month | 160 | 180 | 220 | 210 | 230 | |
Expected Sales | 350 | 400 | 450 | 550 | 525 | |
(-) Finished goods- Opening | -140 | -160 | -180 | -220 | -210 | |
Production units | 370 | 420 | 490 | 540 | 545 | |
Cost of raw material purchases | ||||||
Raw materials - End of the month [(30% of next month production)*($2.5 x 4) | 1260 | 1470 | 1620 | 1635 | ||
Raw materials consumed (Production units x 4 x $ 2.5) | 3700 | 4200 | 4900 | 5400 | ||
(-) Raw materials-opening | -1110 | -1260 | -1470 | -1620 | ||
Raw material purchased | 4410 | 5050 | 5415 | |||
Direct labour cost | ||||||
( Production units x 30Minutes/60minuts x $14) | 2590 | 2940 | 3430 | 3780 | 3815 | |
Manufacturing overhead | ||||||
Fixed | 900 | 900 | 900 | 900 | 900 | 900 |
Variable (Expected unit Sales x 0.40) | 140 | 160 | 180 | 220 | 210 | 230 |
1040 | 1060 | 1080 | 1120 | 1110 | 1130 | |
Selling and Administrative expenses | ||||||
Fixed | 950 | 950 | 950 | 950 | 950 | 950 |
Variable (Expected unit Sales x 0.60) | 210 | 240 | 270 | 330 | 315 | 345 |
1160 | 1190 | 1220 | 1280 | 1265 | 1295 | |
Credit sales ( 20% x Sales) | 980 | 1120 | 1260 | 1540 | 1470 | 1610 |
Required: Compute the following for Iguana, Inc., for the second quarter (April, May, and June) 2...
Compute the following for Iguana inc for the second quarter (April, May, June) We were unable to transcribe this imageIguana, Inc., had $11,100 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...
33.33 points Required information Required: Compute the following for Iguana, Inc, for the second quarter (April, May, and June) April May 1. Budgeted Sales Revenue 2. Budgeted Production in Unts Budgeled Cost of Raw Material Purchases Budgeted Direct Labor Cost 4. & Budgeled Cost of Goods Sold Total Budgeted Seling and Adm. Expenses $000 References eBook & Resources Cojecve: 08-03a Prepare the foloning Learring Objntive: 08-03 Prepare following components of the operating budget Production budge Leaming Objective: 08-03 Prepare the...
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 raw materials inventory should be 30 percent of next month’s production. Expected unit sales (frames) for the upcoming months follow: March...
[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...
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...
[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...
Thank you for your help! 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...
I just need the budgeted cost of goods sold 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 $15 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...