Question
Productions and related Budgets. Water from Heaven Manufactures Pty Ltd produces plastic rainwater tanks for household use. The following information has been gathered so that
Productions and related Budgets.
Water from Heaven Manufactures Pty Ltd produces plastic rainwater tanks for household use. The following information has been gathered so that a production budget, a direct materials budget and a direct labor budget for part of 2014 can be prepared.
The materials and labor requirements per tank are as follows.
Quantity Cost
Plastic (weather resistant) 50 kilograms $12 per kilogram
Plastic pipes 2.2 metres 2 per metre
Moulding and welding 2 hours 22 per hour
Finishing labor 0.5 hours 18 per hour
Management prefers a finished goods ending inventory for each quarter that equals 25% of expected sales for the next quarter. Also the ending inventory balance of direct materials should equal 25% of the next quarter's production requirements. The inventory balances on 1 January 2014 forecast as:
Plastic (weather resistant) 266,250 kilograms
Plastic pipes 11,715 metres
Tanks 5100
The forecast quarterly sales in units are:
March 2014 20400
June 2014 24000
September2014 22800
December2014 16500
Required:
A. Prepare quarterly production budget, in units only , for the March,June and September quarters for 2014.
B. Prepare direct materials budget for the March and June quarters of 2014 in both units and dollars.
C. Prepare direct labor budget for the March and June quarters of 2014.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started