The following information applies to the questions displayed below lguana, Inc.

Question

The following information applies to the questions displayed below lguana, Inc. to build, and the labor rete averages $13 per hour lguana has the following inventory policies bamboo picture frames that sell for $25 each Each frame requires 4 linear feet of bamboo, which costs $200 per foot Each frame takes approximately 30 minutes Ending row materials inventory should be 30 percent of next onshy's production overheed is incurred at a rate of $0.50 per unit produced Annual fixed is estimated to be $4.800(5400 per monthj for expected production of 4.800 units for the year Selling and administerative expenses are estimated at $500 per month plus $O.50 per unit sold 10 enahe bed sosoo eash on hand on Aprl lores wes 90 per cent is during the cash the eredt sales, 50 percent is collected during the moneh ofthe sale, and 50 percent is collected 80 percent is paid for during the month purchased and 20 percent is paid in the following month Raw materials purchases for March 1 totaled $2.200 Al e pe d durngthe month reumed MontNy fred manufacting overhead ncludes $220 in depreciation Durng Apr. Iguana plans to pay $3. 700 for 0 piece of com equipment

Explanation / Answer

Kindly also check the answer you already filled by comparing with my answer.

Thank you

Iguana Inc April May June 2nd quarter total Beginning cash Balance 10500 10067.64 11655.4 Plus : Budgeted Cash receipts 8175 9125 11500 28800 Less : Budgted Cash Payments 9607.36 7537.24 8470.2 25614.8 Preliminary Cash balance 9067.64 11655.4 14685.2 Cash Borrowed/Repaid 1000 0 0 Ending Cash Balance 10067.64 11655.4 14685.2 Sales Budget Month Unit Sales Unit sale Price Sales Revenue Ending Finished Inventory in units Cash sales @ 80% of sales Revnue Cash from Customer in the same month Balance Cash from customer in month following the sale Total Cash collected from customer March 390 25 9750 128 7800 975 April 320 25 8000 148 6400 800 975 8175 May 370 25 9250 188 7400 925 800 9125 June 470 25 11750 178 9400 1175 925 11500 July 445 25 11125 198 8900 1112.5 1175 11187.5 August 495 25 12375 9900 1237.5 1112.5 Production Bughet Opening Finished goods Inventory -A Units sold-B Closing Finished goods Inventory-C Units manufactured D=B+C-A Raw Material(Bambo Feet)quantity required D*4 Opening Bamboo feet Inventory Closing Bamboo feet Inventory Bamboo Feet Invnentroy to be purchased cost of per Bamboo feet Total Raw Material Purchase Value Month March 390 128 374.4 April 156 320 148 312 1248 374.4 516 1389.6 2 2779.2 May 128 370 188 430 1720 516 600 1804 2 3608 June 148 470 178 500 2000 600 546 1946 2 3892 July 188 445 198 455 1820 546 0 August 178 495 0 Raw Material Purchase Value as calculated Cash Payment for raw Material In the same Month Cash payment for Raw Material in the month following purchase Payment of Monthly Fixed Manufacturing expenses Payment of Monthly Variable Manufacturing expenses Payment of Monthly Fixed sellign & administrative expenses Payment of Monthly Variable selling & administrative expenses Payment for Direct Labor Special equipment to be purchased Total cash Payment to be made Month March 2200 1760 400 0 500 195 April 2779.2 2223.36 440 400 156 500 160 2028 3700 9607.36 May 3608 2886.4 555.84 400 215 500 185 2795 7537.24 June 3892 3113.6 721.6 400 250 500 235 3250 8470.2 July 778.4 400 227.5 500 222.5 2957.5 August 400 0 500 247.5

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.