Iguana, Incorporated, manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $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. Expected unit sales (frames) for the upcoming months follow: March 275 April 250 May 300 June 400 July August 375 425 Variable manufacturing overhead is incurred at a rate of $0.30 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.60 per unit sold. Iguana, Incorporated, had $10,800 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 in the following month. Direct materials purchases for March 1 totaled $2,000. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $150 in depreciation. During April, Iguana plans to pay $3,000 for 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 cash balance. No interest is charged if the loan is paid off by the end of the next quarter. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 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. Note: Leave no cell blank enter "0" wherever required. Round your answers to 2 decimal places. Beginning Cash Balance Plus: Budgeted Cash Receipts Less: Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed/Repaid Ending Cash Balance April May June 2nd Quarter Total < Required 2 Required 3 > 0.00 0.00 PA8-3 (Static) Preparing Cash Budget [LO 8-4] 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. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the budgeted cash payments for Iguana. Note: Do not round your intermediate calculations. Round final answers to 2 decimal places. April May Budgeted Cash Payments < Required 1 June 2nd Quarter Total $ 0.00 Required 3 > PA8-3 (Static) Preparing Cash Budget [LO 8-4] 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. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the budgeted cash receipts for Iguana. Note: Do not round your intermediate calculations. Round final answers to 2 decimal places. April May June 2nd Quarter Total Budgeted Cash Receipts $ 6,312.50 $ 6,312.50 < Required 1 Required 2 > PA8-1 (Static) Preparing Operating Budgets [LO 8-3a, b, c, d, e, f, g] Required: Compute the following for Iguana, Incorporated, for the second quarter (April, May, and June). Note: Do not round your intermediate calculations. 1. Budgeted Sales Revenue 2. Budgeted Production in Units 3. Budgeted Cost of Direct Material Purchases 4. Budgeted Direct Labor Cost 5. Budgeted Manufacturing Overhead 6. Budgeted Cost of Goods Sold 7. Total Budgeted Selling and Administrative Expense April May June 2nd Quarter Total $ 6,250 $ 7,500 $ 10,000 $ 23,750 270 340 390 1,000 $ 0 $ 0 $ 0 $ 0 $ 0 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 $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. Expected unit sales (frames) for the upcoming months follow: March 275 April 250 May 300 June 400 July August 375 425 Variable manufacturing overhead is incurred at a rate of $0.30 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.60 per unit sold. Iguana, Incorporated, had $10,800 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 in the following month. Direct materials purchases for March 1 totaled $2,000. All other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $150 in depreciation. During April, Iguana plans to pay $3,000 for 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 cash balance. No interest is charged if the loan is paid off by the end of the next quarter. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 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. Note: Leave no cell blank enter "0" wherever required. Round your answers to 2 decimal places. Beginning Cash Balance Plus: Budgeted Cash Receipts Less: Budgeted Cash Payments Preliminary Cash Balance Cash Borrowed/Repaid Ending Cash Balance April May June 2nd Quarter Total < Required 2 Required 3 > 0.00 0.00 PA8-3 (Static) Preparing Cash Budget [LO 8-4] 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. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the budgeted cash payments for Iguana. Note: Do not round your intermediate calculations. Round final answers to 2 decimal places. April May Budgeted Cash Payments < Required 1 June 2nd Quarter Total $ 0.00 Required 3 > PA8-3 (Static) Preparing Cash Budget [LO 8-4] 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. Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the budgeted cash receipts for Iguana. Note: Do not round your intermediate calculations. Round final answers to 2 decimal places. April May June 2nd Quarter Total Budgeted Cash Receipts $ 6,312.50 $ 6,312.50 < Required 1 Required 2 > PA8-1 (Static) Preparing Operating Budgets [LO 8-3a, b, c, d, e, f, g] Required: Compute the following for Iguana, Incorporated, for the second quarter (April, May, and June). Note: Do not round your intermediate calculations. 1. Budgeted Sales Revenue 2. Budgeted Production in Units 3. Budgeted Cost of Direct Material Purchases 4. Budgeted Direct Labor Cost 5. Budgeted Manufacturing Overhead 6. Budgeted Cost of Goods Sold 7. Total Budgeted Selling and Administrative Expense April May June 2nd Quarter Total $ 6,250 $ 7,500 $ 10,000 $ 23,750 270 340 390 1,000 $ 0 $ 0 $ 0 $ 0 $ 0
Expert Answer:
Answer rating: 100% (QA)
To analyze the financial aspects of Iguana Incorporated we need to calculate various elements such as production requirements cash collections cash disbursements and operating costs 1 Production Requi... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078025518
2nd edition
Authors: Stacey Whitecotton, Robert Libby, Fred Phillips
Posted Date:
Students also viewed these accounting questions
-
Partnership entries and statement of partnership equity The capital accounts of Hassan Khan and Dmitri Palovich have balances of $75,000 and $54,000, respectively, on January 1, 2014, the beginning...
-
Mr. Lawrence had been the manager at Pleasure Sdn Bhd (PSB) since 1 February 2016. His employment was terminated on 30 April 2021 due to disputes with the directors of PSB. After many appeals,...
-
How might knowledge of personality be used to develop an advertising campaign for the following? a) Rainforest Action Network (an environmental group), b) Smart phones, c) American Express financial...
-
The operations manager of a plant that manufactures tires wants to compare the actual inner diameters of two grades of tires, each of which is expected to be 575 millimeters. A sample of five tires...
-
Why is it important for you to know how your online data is handled?
-
Grand Lips produces a lip balm used for cold- weather sports. The balm is manufactured in a single processing department. No lip balm was in process on May 31, and Grand Lips started production on...
-
Santana Rey expects sales of Business Solutions' line of computer workstation furniture to equal 300 workstations (at a sales price of $3.300 each) for 2021. The workstations' manufacturing costs...
-
The following precedence diagram shows all the activities involved in the construction of one floor of a high-rise building. The duration of each activity is also given (in days). There are 30...
-
Consider the following -NFA. 8 b p {q} q {r} *r i. ii. iii. E a {q,r} o {p} {r} {p,q} Convert it into DFA Compute S (qo,abbbc) Give the set of all strings of length 3 or less accepted by the automaton
-
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: Project A Project B 0 1 -$300 - $400 $132 -$387 -$193 240.64 2...
-
a. What was the spot exchange rate of South Korea won for U.S. dollars (USD/KRW) on July 15, 2016? (Round your answer to 4 decimal places. (e.g., 32.1616)) b. What was the one-month forward exchange...
-
1. Zachary Fox does not make any voluntary deductions that impact eamings subject to federal income tax withholding or FICA taxes. He has authorized voluntary deductions each pay period of $10 for...
-
patron patron id 12A7 23U9 64J3 12H34 25V6 84Y8 book isbn 11353 11958 11789 11005 65345 89434 43498 44983 patron_name Juliet Beatrice Falstaff Claudius Miranda Puck age 21 14 87 city Dallas Houston...
-
Randall Fris worked as a seaman on an Exxon shipping co. oil tanker for eight years without incident. One night, he boarded the ship for duty while intoxicated, in violation of company policy. This...
-
Factor and simplify, if possible. Check your result using a graphing calculator. 3 cot 2 + 6 cot + 3
-
Describe which characteristics of HR metrics and workforce analytics are likely to result in greater return on investment and organizational impact.
-
Why are information security and privacy important considerations in the design, development, and maintenance of an HRIS?
-
List and discuss the major information security and privacy threats to organizations.
Study smarter with the SolutionInn App