Question

Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the...

Preparing a Production Budget

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales:

January 41,000
February 38,000
March 50,000
April 51,000

Patrick's policy is to have 24% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,600 drums of solvent on hand.

Required:

Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total. If required, round your answers to the nearest whole unit.

Patrick Inc.
Production Budget
For the Coming Quarter

Homework Answers

Answer #1
  • Requirement

Patrick Inc.

Production Budget

For the Coming Quarter

January

February

March

1st Quarter Total

Sales

41000

38000

50000

129000

Desired ending inventory

9120

12000

12240

12240

Total needs

50120

50000

62240

141240

Less: Beginning inventory

4600

9120

12000

4600

Units to be produced

45520

40880

50240

136640

--Working

Patrick Inc.

Production Budget

For the Coming Quarter

January

February

March

1st Quarter Total

Sales

41000

38000

50000

129000

Desired ending inventory

=38000*24%

=50000*24%

=51000*24%

12240

Total needs

50120

50000

62240

141240

50000

62240

141240

Less: Beginning inventory

4600

=38000*24%

=50000*24%

4600

Units to be produced

45520

40880

50240

136640

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 21% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,350 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 21% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,400 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should...
Preparing an Overhead Budget Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first...
Preparing an Overhead Budget Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are: January 13,140 February 12,300 March 15,075 The variable overhead rate is $0.70 per direct labor hour. Fixed overhead is budgeted at $2,890 per month. Required: Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer....
Manson Inc. makes and sells handbags. In the first 4 months of the coming year, they...
Manson Inc. makes and sells handbags. In the first 4 months of the coming year, they expect the following unit sales: January 20,000 February 24,000 March 22,000 April 29,000 Manson Inc. is to have 30% of next month's sales in ending inventory. On January 1, the beginning inventory was 6,000 handbags. Prepare a budget for the first quarter of the year.
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011: January February March April Sales (units) 35,000 31,000 38,000 29,000 Each unit requires three hours of direct labor. Additional information: Karam sells each unit for $95. Company policy is to have 30 percent of next month's sales (in units) in ending finished goods inventory. Company policy is to have 40 percent of next month's production needs in ending raw...
5-12 Preparing a production budget (LO 3) High Flyers manufactures competition stunt kites. In November, Jerry...
5-12 Preparing a production budget (LO 3) High Flyers manufactures competition stunt kites. In November, Jerry Box prepared the following production budget for the first quarter of the coming year. Desired ending inventory is based on the following month's budgeted sales. January February March Quarter Budgeted sales 20,000 35,000 30,000 85,000 Desired ending inventory 7,000 6,000 2,400 2,400 Kites needed 27,000 41,000 32,400 87,400 Less beginning inventory 4,000 7,000 6,000 4,000 Budgeted production 23,000 34,000 26,400 83,400 Following higher-than-expected sales...
BobCat Inc. is in the process of preparing a purchases budget for the third quarter of...
BobCat Inc. is in the process of preparing a purchases budget for the third quarter of 2016. The company expects its cost of goods sold to be the following amount June July August September COGS 20,000 23,000 28,000 38,000 The company would like to have ending inventory each month equal to 20% of the following month's predicted cost of sales. What would be the beginning inventory in August? A. 6,600 B. 7,600 C. 4,600 D. 5,600
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality...
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct...
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality...
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 216,000 May 264,000 June 240,000 July 288,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000. Required: Prepare a production budget for the second...