The following information is located in the production department of Mindy Co First Quarter 14,300 Second Quarter 21,000 Third Quarter Fourth Quarter 22,500 21.300 Units produced Other information found in the production department includes: Prior Year Ending RM Inventory Prior Year Ending A/P Pounds of RM per unit S 10,725 11,775 The ending raw material inventory per month should be 25% of the following month's production needs. The desired ending inventory for the fourth quarter is 3,700 pounds. Management plans to pay for 70% of the raw material purchases in the month bought and 30% in the following month.

The following information is located in the production department of Mindy Co First Quarter 14,300 Second Quarter 21,000 Third Quarter Fourth Quarter 22,500 21.300 Units produced Other information found in the production department includes: Prior Year Ending RM Inventory Prior Year Ending A/P Pounds of RM per unit S 10,725 11,775 The ending raw material inventory per month should be 25% of the following month's production needs. The desired ending inventory for the fourth quarter is 3,700 pounds. Management plans to pay for 70% of the raw material purchases in the month bought and 30% in the following month.

Name: The following information is located in the production department of
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: The following information is located in the production department of Mindy CaSecondFirstQuarter14,300Quarter Third Quarter Fourth Quarter21,00022,50021,300Units producedOther information found in the production department includes:Prior Year Ending

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...

See similar textbooks

Similar questions

Production information shows these costs and units for the smoothing department in August. What is the value of the inventory transferred out to finished goods and the value of the WIP inventory at the end of the month, assuming conversion costs are 30% complete?
Total Pops data show the following information: New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next months requirements. Direct material requires 2 pounds per unit at a cost of $3 per pound. The ending inventory required for direct materials is 15% of the next months needs. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.
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.
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
At the end of the first year of operations, 21,500 units remained in the finished goods inventory. The unit manufacturing costs during the year were as follows: Determine the cost of the finished goods inventory reported on the balance sheet under (a) the absorption costing concept and (b) the variable costing concept.
Prepare a cost of goods sold budget for MacLaren Manufacturing Inc. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 548,000; beginning inventory of direct materials, 36,000; and ending inventory of direct materials, 23,000. Totals from other budgets included:
The fixed overhead budgeted for Ranier Industries at an expected capacity of 500,000 units is 1,500,000. Variable costing is used internally, and the net income is adjusted to an absorption costing net income at year-end. Data collected over the last three years show the following: Determine the adjustment each year to convert the variable costing income to absorption costing net income. Compute the absorption costing net income for each year.
Using the weighted-average method, compute the equivalent units of production if the beginning inventory consisted of 20,000 units; 55,000 units were started in production; and 57,000 units were completed and transferred to finished goods inventory. For this process, materials are added at the beginning of the process, and the units are 35% complete with respect to conversion.
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?
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
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.
How many units are in beginning inventory it 32,000 units are budgeted for sales, 35,000 units are produced, and the desired ending inventory is 9,000 units?