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...
icon
Related questions
Question
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
Transcribed Image 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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
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 …
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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning