Question

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

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 20% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,700 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
0 0
Add a comment Improve this question Transcribed image text
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 7600 10000 10200 27800
Total needs 48600 48000 60200 156800
Less: Beginning inventory 4700 7600 10000 22300
Units to be produced 43900 40400 50200 134500

--Working

Patrick Inc.
Production Budget
For the Coming Quarter
January February March 1st Quarter Total
Sales 41000 38000 50000 129000
Desired ending inventory =38000*20% =50000*20% =51000*20% 27800
Total needs =41000+7600 =38000+10000 =50000+10200 156800
Less: Beginning inventory 4700 =38000*20% =50000*20% 22300
Units to be produced =48600-4700 =48000-7600 =60200-10000 134500
Add a comment
Know the answer?
Add Answer to:
Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Part 1 Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to...

    Part 1 Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $43. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick...

  • Preparing a Production Budget Patrick Inc, makes industrial solvents. In the first months of the coming...

    Preparing a Production Budget Patrick Inc, makes industrial solvents. In the first months of the coming year Patrick expects the following unit sales: January 41.000 February 38.000 March 50.000 April $1,000 Patrick's policy is to have 23% of next months sales in ending inventory On January 1it is expected that there will be 4.550 drums April Patride's policy is to have 23 of next month's sales in ending inventory. On January 1, it is expected that there will be 4,550...

  • Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following...

    Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: 41,000 January February 38,000 50,000 March The average price for a drum is $42. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your...

  • Preparing a Direct Labor Budget Patrick Inc. makes industrial solvents. Planned production in units for the first three...

    Preparing a Direct Labor Budget Patrick Inc. makes industrial solvents. Planned production in units for the first three months of the coming year is: January 45,000 February 55,000 March 65,000 Each drum of industrial solvent takes 0.3 direct labor hours. The average wage is $17.50 per hour. Required: Prepare a direct labor 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...

  • Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drum containers....

    Preparing a Direct Materials Purchases Budget Patrick Inc. makes industrial solvents sold in 5-gallon drum containers. Planned production in units for the first 3 months of the coming year is: January 45,000 February 50,000 March 60,000 Each drum requires 6 gallons of chemicals and one plastic drum container. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met for the ending inventory of December in the...

  • please answer all Preparing a Diect Materials Prchases Budget Patrick Inc, makes industral solvents sold in...

    please answer all Preparing a Diect Materials Prchases Budget Patrick Inc, makes industral solvents sold in 5-gallon drum containers. Planned production in units for the fiest 3 moeths of the coming year anuary 45.000 ebuary 55.000 March 60.000 Each drum requires&galons of chemicals and one plastic drum container Company policy ruis that nding stor of aw maerials for each month be 20% of the et month's preduction needs. That policy sas met for the endng inventory of December in the...

  • reparing a Direct Labor Budget atrick Inc. makes industrial solvents. Planned production in units for the...

    reparing a Direct Labor Budget atrick Inc. makes industrial solvents. Planned production in units for the first three months of the coming year is: Banuary 45,000 February 50,000 March 60,000 Each drum of industrial solvent takes 0.3 direct labor hours. The average wWage is $17.80 per hour Required Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a mutiplication symbol as part of your...

  • Preparing an Overhead Budget Patrick Inc makes industrial solvent e d rector hours for the months...

    Preparing an Overhead Budget Patrick Inc makes industrial solvent e d rector hours for the months The variable overhead ate is $0.70 per direct labor hour fixed overhe starter De not include a multiplication symbol as part of your answer, Round total variable overhead Prepare an overhead budget for the month of January February, and March, as well as the total for the total overhead to the nearest dollar Patrick Inc. Overhead Budget For the Coming First Quarter Total February...

  • ABC Company produces water pumps. The unit sales for the first four months of the year...

    ABC Company produces water pumps. The unit sales for the first four months of the year for this product are as follows: Unit Sales: January 162,000 February 198,000 March 180,000 April 216,000 Company maintains ending inventory for each month at 25% of next month's sales. However, at the beginning of January, due to greater sales in December than anticipated, the beginning inventory for January is   18,900 Required: a) Compute the total number of units that should be produced for the...

  • Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...

    Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 114,000 Unit sales for December 2019 102,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 126,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT