Three cubic centimetres (cc) of solvent Q80 are required to manufacture each unit of Fineclay, one of the company's products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Fineclay occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 3.600 units of Fineclay plus 15% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 12,000 units. b. The raw materials inventory on hand at the end of each month must be equal to one-half of the following month's production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 64,800 cc of solvent Q80. c. The company maintains no work-in-process inventories. A sales budget for Fineclay for the last six months of the year follows: July August September October November December Budgeted sales (units) Budgeted Sales in Units Required: 1. Prepare a production budget for Fineclay for the months of July to October Total needs 42,000 48,000 60,000 36,000 24,000 12,000 DAISY PRODUCTS LIMITED Production Budget July August September October

Three cubic centimetres (cc) of solvent Q80 are required to manufacture each unit of Fineclay, one of the company's products. The company is now planning raw materials needs for the third quarter, the quarter in which peak sales of Fineclay occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 3.600 units of Fineclay plus 15% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 12,000 units. b. The raw materials inventory on hand at the end of each month must be equal to one-half of the following month's production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 64,800 cc of solvent Q80. c. The company maintains no work-in-process inventories. A sales budget for Fineclay for the last six months of the year follows: July August September October November December Budgeted sales (units) Budgeted Sales in Units Required: 1. Prepare a production budget for Fineclay for the months of July to October Total needs 42,000 48,000 60,000 36,000 24,000 12,000 DAISY PRODUCTS LIMITED Production Budget July August September October

Name: Please do not give solution in image format thanku Three cubic centime
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Please do not give solution in image format thanku Three cubic centimetres (cc) of solvent Q80 are required to manufacture each unit of Fineclay, one of the company's products. Thecompany is now planning raw materials needs for the third quarter, the

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

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.
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?
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.
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
A firm expects to achieve the following level of sales, to make the following purchases of raw materials, and to make the following payments for indirect expenses for the first 4 months of the year. All sales and purchases of raw materials are on credit. 70% of sales are paid for in the month after the sale, with the balance paid in the following month. 90% of purchases are paid for in the month after the purchase, with the balance paid in the following month. Indirect expenses are paid for in the month they are incurred. Sales in December totalled $75 and purchases of raw materials in December totalled $54. The opening cash balance at the beginning of January was $117. What is the budgeted closing balance of accounts receivable (rounded to the nearest dollar) at the end of April? Jan Feb Mar Apr Sales 72 70 76 80 Purchases of raw materials 51 53 60 55 Indirect expenses 15 18 16 16 a. $106 b. $105 c. $108 d. $103 Please solve correctly with all working and steps
The production department of Zan Corporation has submitted Le following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced In addition, 7,700 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $4,580. Required production in units of finished goods Each unit requires 9.70 grams of raw material that costs $160 per gram Management desires to end each quarter with an inventory of raw materials equal to 20% of the following quarter's production needs. The desired ending inventory for the 4th quarter is 9,700 grams. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.40 direct labour-hours and direct labourers are paid $8.10 per hour. Required: 1. Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for materials for the upcoming fiscal…
Hank Manufacturing makes cleaning solvent sold in large container with a plastic liner. Their monthly sales forecast consists of: January 40,000 units, February 38,500 units, and March 39,750 units. Desired ending inventory of finished goods (in units) is 10% of the next month's sales forecast. Planned production (in units) for next quarter is: January February March 43,800 units 41,000 units 50,250 units Further, each container of cleaning solvent consists of: 6 gallons of chemicals 1 plastic liner Company policy requires that ending inventories of raw materials for each month be 15% of the next month's production needs. The policy was met for the ending inventory of December in the prior year. The cost of one gallon of chemicals is $2.00. The cost of one liner is $1.60.
The production planning team of Red Velvet Inc showed that each product requires 3 units of raw materials costing 10 each. The inventory manager requires that 20% of the total raw materials purchased during the month must be kept as monthly ending inventory to avoid shortage The marketing team estimates that the demand of the product is 10,000 units in September 12,000 units in October, and 15,000 units in November. The starting inventory in September for the raw materials is 7,200 units. 1. What is the total units of raw materials needed to be purchased on the month of September to meet the requirements of different departments? 2. What is the total units of raw materials needed for the production of October estimated demand?
King purchases two components for its primary product. They need 3 of Component A and 2 of Component B for each unit of the primary product. Component A costs $3; Component B costs $5. Other facts: Forecasted Primary Product Production: January: 19,500 units February: 19,600 units March: 23,000 units April: 27,000 units Ending component inventory should equal 20% of next month’s production needs. Assume December’s ending inventory met this requirement. Calculate purchases for both Components in both units and dollars by month for Q1.
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 1st Quarter 5,600 2nd 3rd 4th Quarter Quarter Quarter 8,600 7,600 6,600 In addition, 6,600 grams of raw materials Inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,480. Each unit requires 8.60 grams of raw material that costs $1.20 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter's production needs. The desired ending Inventory for the 4th quarter is 8,600 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter. Each unit requires 0.20 direct labour-hours and direct labourers are paid $10.30 per hour. Required: 1. Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for…
‏The ABC Company consumes inventory of 67,500 units of components per year . The carrying cost per unit is RO 1.50 . The fixed order cost is RO 25 per order . The production planning is 365 - day year . a . What is the Economic Order Quantity ( EOQ ) ? Interpret . b . Calculate and interpret the optimal number of orders to be placed. c. If it takes five days to receive an order from suppliers, at what inventory level should ABC Company place another order? Interpret .
Assume that a company expects to produce 10,300, 11,300, and 13,300 units of finished goods in January, February, and March, respectively. Each unit of finished goods requires 4 pounds of raw material and each pound of raw material costs $1.75. The company always maintains an ending raw materials inventory equal to 25% of next month’s production needs. What is the amount of expected raw materials purchases for February?