!Required information[The following information applies to the questions displayed below.]Iguana, Incorporated, manufactures bamboo picture frames that sell for $20 each. Each frame requires 4 linear feet ofbamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13per 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.Expected unit sales (frames) for the upcoming months follow:MarchAprilMayJuneJulyAugust365430480580555605Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead isestimated to be $4,800 ($400 per month) for expected production of 4,000 units for the year. Selling and administrativeexpenses are estimated at $450 per month plus $0.50 per unit sold.Iguana, Incorporated, had $11,000 cash on hand on April 1. Of its sales, 80 percent is in cash. Of the credit sales, 50percent 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 in the followingmonth. Direct materials purchases for March 1 totaled $3,400. All other operating costs are paid during the monthincurred. Monthly fixed manufacturing overhead includes $330 in depreciation. During April, Iguana plans to pay $2,000for a piece of equipment.Required:1. Compute the budgeted cash receipts for Iguana.2. Compute the budgeted cash payments for Iguana.3. Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000 to maintain a $10,000 minimum cashbalance. No interest is charged if the loan is paid off by the end of the next quarter.

Cash Budget is prepared to provide for the expected cash requirements in the future period(s).All…

Required: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana. 3. Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000 to maintain a $10,000 minimum cash balance. No interest is charged if the loan is paid off by the end of the next quarter.

Required: 1. Compute the budgeted cash receipts for Iguana. 2. Compute the budgeted cash payments for Iguana. 3. Prepare the cash budget for Iguana. Assume the company can borrow in increments of $1,000 to maintain a $10,000 minimum cash balance. No interest is charged if the loan is paid off by the end of the next quarter.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 2CE: Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An...

See similar textbooks

Similar questions

Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the economic order quantity. 2. Compute the ordering, carrying, and total costs for the EOQ. 3. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?
Required information [The following information applies to the questions displayed below.] Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 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 $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 should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August 320 340 390 490 465 515 Variable manufacturing overhead is incurred at a rate of $0.20 per unit produced. Annual fixed manufacturing overhead is estimated to be $7,200 ($600 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $650 per month plus $0.50 per unit sold. Iguana, Incorporated, had…
! 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 $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 direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March 365 April Мay 430 480 June 580 July 555 August 605 Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead is estimated to be $4,800 ($400 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $450 per month plus $0.50 per unit sold. Iguana, Inc., had $11,000 cash on…
Required information [The following information applies to the questions displayed below.] Iguana, Incorporated, 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 direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August 310 320 370 470 445 495 Variable manufacturing overhead is incurred at a rate of $0.50 per unit produced. Annual fixed manufacturing overhead is estimated to be $4,800 ($400 per month) for expected production of 4,800 units for the year. Selling and administrative expenses are estimated at $500 per month plus $0.50 per unit sold. Iguana, Incorporated, had…
Required Information [The following information applies to the questions displayed below.] Iguana, Incorporated, 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 direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August 365 430 480 Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead is estimated to be $4,800 ($400 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $450 per month plus $0.50 per unit sold. 580 555 605 Iguana, Incorporated, had…
Required Information [The following information applies to the questions displayed below.] Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 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 $15 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. Expected unit sales (frames) for the upcoming months follow: March April May June July August 375 450 500 680 575 625 Variable manufacturing overhead is incurred at a rate of $0.50 per unit produced. Annual fixed manufacturing overhead is estimated to be $6,000 ($500 per month) for expected production of 5,000 units for the year. Selling and administrative expenses are estimated at $550 per month plus $0.70 per unit sold. Iguana, Incorporated, had…
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 $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 direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March 365 April Мay 430 480 June 580 July August 555 605 Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead is estimated to be $4,800 ($400 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $450 per month plus $0.50 per unit sold. Iguana, Inc., had $11,000 cash on hand…
Required information [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 direct materials inventory should be 30 percent of next month’s production. Expected unit sales (frames) for the upcoming months follow: March 295 April 290 May 340 June 440 July 415 August 465 Variable manufacturing overhead is incurred at a rate of $0.20 per unit produced. Annual fixed manufacturing overhead is estimated to be $9,000 ($750 per month) for expected production of 5,000 units for the year. Selling and administrative expenses are estimated at $800 per month plus $0.50 per unit sold. Iguana,…
[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 $11 per hour. Iguana has the following Inventory policies: information 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. Expected unit sales (frames) for the upcoming months follow: March Apr 11 May June July August 200 280 Variable manufacturing overhead la incurred at a rate of $0.60 per unit produced. Annual fixed manufacturing overhead is estimated to be $7,200 ($600 per month) for expected production of 3,000 units for the year. Selling and administrative expenses are estimated at $700 per month plus $0.50 per unit sold. 336 430 405 455 Iguans, Inc., had $11,100 cash on hand on April…
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 next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $10,800 ($900 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $950 per month plus 50.60 per unit sold. Iguana, Inc., had $11,900 cash on hand on April 1. Of its…
Itranscript Required information [The following information applies to the questions displayed below) Iguana, Incorporated, 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 next month's production. Expected unit sales (frames) for the upcoming months follow: . March April May June July August Skip to question 325 350 400 5:00 475 525 Variable manufacturing overhead is incurred at a rate of $0.30 per unit produced. Annual fixed manufacturing overhead is estimated to be $6.000 ($500 per month) for expected production of 5,000 units for the year. Selling and administrative expenses are estimated at $550 per month plus $0.60 per unit sold.…