The Peanut Processing Company produces cans of peanuts. The company expects sales of 15,000 cans in January, 16,000 cans in February, 17,000 cans in March, and 17,000 cans in April. There are 1,500 cans in inventory at the beginning of January. The company tries to maintain a monthly ending inventory of cans of peanuts equal to 10% of the next months projected sales.
Prepare a production budget for the company for the months of January, February, and March.© BrainMass Inc. brainmass.com June 4, 2020, 4:49 am ad1c9bdddf
Production Budget = Expected Sales, less beginning balance, plus needed inventory for the following month
January Production Budget:
15,000 - Expected Sales
1,500 - beginning ...
This solution provides a projected production budget based on the existing inventory, projected sales and the requisite end of month inventory.