Rouse Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 900 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires two pounds of polypropylene (a type of plastic). The company wants to have 10% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound. Read the requirements. Show Transcribed Text Data Table Number of planters to be sold January 3,600 February 3,300 March........ 3,100 April 4,700 May 4,900 Requirement 1. Prepare a production budget for each month in the first quarter of the year, including production in units for each month and for the quarter. Rouse Manufacturing Production Budget For the Months of January through March Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce Show Transcribed Text January February Direct Materials Budget March Quarter February March Quarter Units to be produced For the Months of January through March January Multiply by: Quantity of direct materials needed per unit Quantity needed for production Plus: Desired ending inventory of direct materials Beginning inventory of direct materials Total quantity needed Less: Quantity to purchase Multiply by: Cost per pound Total cost of direct material purchases Show Transcribed Text
Rouse Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 900 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires two pounds of polypropylene (a type of plastic). The company wants to have 10% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound. Read the requirements. Show Transcribed Text Data Table Number of planters to be sold January 3,600 February 3,300 March........ 3,100 April 4,700 May 4,900 Requirement 1. Prepare a production budget for each month in the first quarter of the year, including production in units for each month and for the quarter. Rouse Manufacturing Production Budget For the Months of January through March Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce Show Transcribed Text January February Direct Materials Budget March Quarter February March Quarter Units to be produced For the Months of January through March January Multiply by: Quantity of direct materials needed per unit Quantity needed for production Plus: Desired ending inventory of direct materials Beginning inventory of direct materials Total quantity needed Less: Quantity to purchase Multiply by: Cost per pound Total cost of direct material purchases Show Transcribed Text
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning