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 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 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
January February March 1st Quarter Total
Sales
Desired ending inventory
Total needs
Less: Beginning inventory
Units to be produced

Homework Answers

Answer #1
Patrick Inc.
Production Budget
For the Coming Quarter
January February March 1st Quarter Total
Sales 41,000 38,000 50,000 129,000
Desired ending inventory 38,000 x 21% = 7,980 50,000 x 21% = 10,500 51,000 x 21% = 10,710 29,190
Total needs 48,980 48,500 60,710 158,190
Less: Beginning inventory -4,400 -7,980 -10,500 22,880
Units to be produced 44,580 40,520 50,210 135,310
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 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...
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....
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...
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.
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...
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...
Production Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Production Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s 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: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.75 7,000 $16.00 February 56,000 $8.75 8,000 $16.00 March 80,000...
Production Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and...
Production Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s 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: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.75 7,000 $16.00 February 56,000 $8.75 8,000 $16.00 March 80,000...