Crest Products expects the following sales of its single product: September October November December January Required: Units 20,300 23,000 15,100 20,800 26,300 Crest has an ending finished goods inventory policy of 30% of the next month's sales needs. September 1 inventory is projected to be 5,700 units. Each finished unit requires 2 units of Component X and 3 units of Component Z. August 1 materials inventory includes 4,000 units of Component X and 156,000 units of Component Z. Crest desires to maintain a Component X inventory equal to 10% of next month's production needs and a Component Z inventory equal to 20% of next month's production needs. a. Prepare a production budget for Crest for the quarter ending December 31. Crest Products Production Budget For the Quarter Ending December 31 October November Budgeted unit sales Plus: Ending finished goods inventory Less: Beginning finished goods inventory Budgeted production (units) December Total

Crest Products expects the following sales of its single product: September October November December January Required: Units 20,300 23,000 15,100 20,800 26,300 Crest has an ending finished goods inventory policy of 30% of the next month's sales needs. September 1 inventory is projected to be 5,700 units. Each finished unit requires 2 units of Component X and 3 units of Component Z. August 1 materials inventory includes 4,000 units of Component X and 156,000 units of Component Z. Crest desires to maintain a Component X inventory equal to 10% of next month's production needs and a Component Z inventory equal to 20% of next month's production needs. a. Prepare a production budget for Crest for the quarter ending December 31. Crest Products Production Budget For the Quarter Ending December 31 October November Budgeted unit sales Plus: Ending finished goods inventory Less: Beginning finished goods inventory Budgeted production (units) December Total

Name: please answer within the format by providing formula the detailed work
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Crest Products expects the following sale

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14PA: Total Pops data show the following information: New machinery will be added in April. This machine...

See similar textbooks

Similar questions

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.
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
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.
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?
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 annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Ming Company has budgeted sales at 6,300 units for July, and desires to have 590 good units on hand on July 31. Inventory-is 470 units on July 1. Ming has found from past experiencethat 10% of all units produced do not pass final inspection and must therefore be destroyed.How many units should Ming plan to produce in July? a. 6,890 b. 7,062 c. 7,133 d. 7,186
Crest Products expects the following sales of its single product Units September October November December January Required: Crest has an ending finished goods Inventory policy of 30% of the next month's sales needs. September 1 Inventory is projected to be 7,400 units. Each finished unit requires 2 units of Component X and 3 units of Component Z. August 1 materials Inventory includes 3,000 units of Component X and 159,000 units of Component Z. Crest desires to maintain a Component X Inventory equal to 10% of next month's production needs and a Component Z Inventory equal to 20% of next month's production needs. a. Prepare a production budget for Crest for the quarter ending December 31. 26,800 19,700 16,100 18,700 16,000 Crest Products Production Budget For the Quarter Ending December 31 October November Budgeted unit sales Plus: Ending finished goods inventory Less: Beginning finished goods inventory Budgeted production (units) Budgeted production (units) Direct materials…
Osage Incorporated has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May June Forecast: July August 5,300 units 7,800 units September 5,900 units October 5,800 units 6,900 units 6,600 units Required: a. The firm's policy is to have finished goods inventory on hand at the end of the month that is equal to 50% of the next month's sales. It is currently estimated that there will be 2,650 units on hand at the end of June. Calculate the number of units to be produced in each of the months of July, August, and September. b. Each unit of finished product requires 8 pounds of raw materials. The firm's policy is to have raw material inventory on hand at the end of each month that is equal to 80% of the next month's estimated usage. It is currently estimated that 25,000 pounds of raw materials will be on hand at the end of June. Calculate the number of pounds of raw materials to be purchased in each of the months of July and August.…
Heather Products expects the following sales of its single product: Units May 15,000 June 16,000 July 17,500 August 18,000 September 19,000 Heather desires an ending finished goods inventory to be equal to 20% of the next month's sales needs. Actual May 1 inventory will be 3,300 units.
ABCL Corporation predicts the following sales in units for the coming four months: May June July August September Unit sales …… 400 500 520 480 540 Finished goods inventory on April 30: 120 units Raw materials inventory on April 30: 450 pounds Desired ending inventory each month: Finished goods: 30% of next month's sales Raw materials: 25% of next month's production needs Number of pounds of raw material required per finished unit: 4 lbs. Required: How many pounds of raw materials should be purchased in May?