Greener Grass Fertilizer Company plans to sell 230,000 units of finished product in July and anticipates a growth rate in sales of 3 percent per month. The desired monthly ending inventory in units of finished product is 80 percent of the next month's estimated sales. There are 184,000 finished units in inventory on June 30. Each unit of finished product requires 4 pounds of raw material at a cost of $1.25 per pound. There are 700,000 pounds of raw material in inventory on June 30. Required: 1. Compute the company's total required production in units of finished product for the entire three-month period ending September 30. (Round all intermediate calculations and your final answer to the nearest unit.) 2. Independent of your answer to requirement 1, assume the company plans to produce 760,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in that period. Compute the total estimated cost of raw-material purchases for the entire three-month period ending September 30. 1. Total required production in units 2. Total estimated cost
Q: Iguana inc. manufactures bamboo picture frames that sell for 20 dollars each. each frame requires 4…
A: Solution 1: Sales Budget - Iguana Inc. Particulars April May June 2nd Quarter Total…
Q: The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for…
A: Please find the answer to the above questions below:
Q: Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units…
A: Beginning inventory of the finished goods on July = Expected sales for the month of July x Desired…
Q: Greener Grass Fertilizer Company plans to sell 280,000 units of finished product in July and…
A: The question is based on the concept of Cost Accounting.
Q: Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units…
A: Budgets are the estimates that are made for a future period of time. These are the quantitative…
Q: Tilson Corporation has projected sales and production in units for the second quarter of the coming…
A: Particulars April May June Total Production units 69000 59000 59000 187000 Budgeted production…
Q: To meet projected annual sales, Bluegill Manufacturers, Inc. needs to produce 75,000 machines for…
A: Definition: Sales Revenue: Sales Revenue is considered as the income received from the sale of the…
Q: Samuelson will produce 20,000 units in January using level production. If each unit costs $500 to…
A: Production = 20,000 Units Opening balance = 10000 Units Sales = 15000 Units Cost per unit = $500
Q: Parwin Corporation plans to sell 25,000 units during August. If the company has 9,000 units on hand…
A: Formula For Units to be Produced Units to be produced =Closing Stock + Sales - Opening Stock
Q: Pardee Company plans to sell 12,000 units during the month of August. If the company has 2,500 units…
A: Production refers to the process of conversion of raw material to finished goods.
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: Delsing Plumbing Company has beginning inventory of 24,000 units, will sell 70,000 units for the…
A: Given Beginning Inventory = 24,000 units Sell = 70,000 units Ending Inventory = 40% of Beginning…
Q: Parker Corp., which operates on a calendar year, expects to sell 5140 units in January and expects…
A: Budgeted revenues for a month are computed from the unit sales and the sales price prevailing for…
Q: Budget Electronics is planning to sell 2,200 and produce 2,000 wicker baskets during June. Each unit…
A: Hey, since there are multiple questions posted, we will answer the first question. If you want any…
Q: MAXI Co. has the following information: *Projected sales for four (4) months are as follows:…
A: Budgets are the forecasts or estimates that are made for future period of time. It can be sales…
Q: Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units…
A: Beginning inventory of the finished goods on July = Expected sales for the month of July x Desired…
Q: Croy Inc. has the following projected sales for the next five months: Month Sales in Units 3,850…
A: Direct materials required and cost of direct materials can be found out using the production…
Q: Williams Company sells women’s hats for $12 each. Actual and budgeted sales in units for nine months…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Direct material closing inventory should be 30% of next months production units needed Direct…
Q: Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units…
A: Units are required for production for the quarter ended September= 164,600
Q: Company expects sales of Product F to be 59,000 units in April, 75,000 units in May and 70,000 units…
A: Estimated Production = Estimated Sales + Ending inventory - Beginning inventory
Q: NUBD Corp, plans to sell 200,000 units of LIB product in July and anticipate a growth in sales of 7%…
A: Given information, Sales in July = 200,000 units Growth in sales =7% per month Therefore, •Sales in…
Q: how would i find the total cash reciepts for this problem
A: Determine sales revenue for each month.
Q: Budget Electronics is planning to sell 2,200 and produce 2,000 wicker baskets during June. Each unit…
A: Total budgeted direct labor hours for production in June = (Expected production in June x Direct…
Q: Shadee Corp. expects to sell 550 sun visors in May and 310 in June. Each visor sells for $16.…
A: Sales revenue = Number of units sold x selling price per unit.
Q: Bidbid Company's production budget for month of February is 37,000 units, and the Company's ending…
A: It is pertinent to note that inventory management helps the entity in order to reduce the holding…
Q: Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks.…
A: Operating budgets: These are the statements that show the projected expenses and revenues of an…
Q: Bear, Inc. estimates its sales at 200,000 units in the first quarter and that sales will increase by…
A: Production for any specific period = Sales units + Ending finished goods - Beginning finished goods
Q: Danner Inc. has projected sales to be $100,000 in June, $90,000 in July, and $70,000 in August.…
A: Month Projected Sales Amount June $100000 July $90000 August $70000
Q: Prepare a production budget for the first quarter of the year. Show the number of drums that should…
A: Hi student Since there are multiple questions, we will answer only first question.
Q: Muscat Manufacturing plans to sell 6,000 chairs during May, 5,700 in June, and 6,000 during July.…
A: Units to be produced in particular period means how many units needed to coverup sales demand and…
Q: Gentlemen Company expects the total costs of goods sold to be $43,000 in November and $73,000 in…
A: Purchases = Ending inventory + Cost of goods sold - Beginning inventory where, Ending inventory =…
Q: MAXI Co. has the following information: *Projected sales for four (4) months are as follows:…
A: The budget is prepared to estimate the requirements for the future period.
Q: Swansong plans to sell 10,000 units of a particular product during July, and expects sales to…
A: Formulas: Purchases = Cost of goods sold + Opening inventory - Closing inventory
Q: ConstructAB'S cash budget for the next three months.
A: Cash budget is the budget which is made by the company to determine the cash inflows and outflows of…
Q: a, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear…
A: Solution: Budgeted cash receipts includes cash collection for sales or from accounts receivable.…
Q: The sales department of LDonovan Manufacturing, Inc. has completed the following sales forecast for…
A: Budgetary Control: This topic is the related to management accounting. Under this, the firms are…
Q: Each production worker can produce 4 wooden chairs per hour. During the month of June, Chairs Inc.…
A: Introduction:- The following formula used to calculate as follows:- Units of Production = Units…
Q: Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units…
A: Answer) Calculation of Quantity of Resins required to be purchased in August (In Ounces)…
Q: Bidbid Company's production budget for month of February is 16,600 units, and the Company's ending…
A: It is pertinent to note that entities manage inventories so that they can reduce their holding and…
Q: b. Management expects to sell 7,600 cases of water in August and 9,500 cases in September. Each case…
A: Formula: Total sales = Cash sales + Credit sales Sum of both cash and credit sales derives the total…
Q: Lexi Company forecasts unit sales of 1,040,000 in April, 1,220,000 in May, 980,000 in June, and…
A: Budgeted purchases: Budgeted purchases are the estimates of purchases of a particular month based on…
Q: Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4…
A: Answer - Working Note - 1. Cost per Unit Particular Amt DM 8 DL 6 Variable OH 0.3…
Q: Greener Grass Fertilizer Company plans to sell 200,000 units of finished product in July and…
A: Requirement 1:
Q: Ruiz Co. provides the following sales forecast for the next four months: April May June…
A: Production budget: Production budget is the estimation or projection of number of units the company…
Q: *Three (3) kilos of materials are required per unit produced. Every kilo of material is $20. Raw…
A: Introduction: Operating budgets are the primary component of master budget and involve examining the…
Q: Ajax Manufacturing produces a single product, which takes 8.0 pounds of direct material per unit…
A: Budgeting is used to analyze and evaluate the future situation. basically it is based on past…
Q: Parwin Corporation plans to sell 39,000 units during August. If the company has 16,000 units on hand…
A: Formula: Units produced during the month = Ending inventory + August month sales - Beginning…
I'm having trouble figuring out the total required production in units and the total estimated cost in this problem.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget? FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKicks best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Required: 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. 2. What if FlashKick added a third linetournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of 45 each in January and February, and 48 each in March? Prepare a sales budget for Flash- Kick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter.Pasadena Candle Inc. projected sales of 800,000 candles for January. The estimated January 1 inventory is 35,000 units, and the desired January 31 inventory is 20,000 units. What is the budgeted production (in units) for January?
- Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
- Preparing a Direct Labor Budget Tulum Inc. makes a Mexican chocolate mix. Planned production in units for the first 3 months of the coming year is: Each box of chocolate mix takes 0.4 direct labor hour. The average wage is 17 per hour. Required: Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2015 and 2016: May 2015 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2016 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2015 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2015. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.Navigator sells GPS trackers for $50 each. It expects sales of 5,000 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.