Question

In: Accounting

Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2017 On...

Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2017

On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017.

Sales units: First quarter 6,000; second quarter 6,900; third quarter 7,400
Ending raw materials inventory: 40% of the next quarter’s production requirements
Ending finished goods inventory: 25% of the next quarter’s expected sales units
Third-quarter production: 7,840 units.


The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to production and sales that occur in 2017. 4 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $5 per pound.

Solutions

Expert Solution

production budget
                        Quarter                          
1 2 Year 3
expected sale units 6,000 6,900 7,400
Add: Ending inventory 1725 1850
total needs 7,725 8,750
less: Beginning inventory 1500 1725
production required 6,225 7,025 13,250
Direct materials budget
Quarter
1 2 six months
production required 6,225 7,025 7840
pounds required per units 4 4 4
total pounds 24900 28100 31360
add: ending inventory 11240 12544
total need 36140 40644
less Beginning inventory 9960 11,240
materials required 26180 29,404
cost per pound 5 5
materials cost 130900 147020

Related Solutions

Prepare the sales, production, and direct materials budgets by quarters for 2017.
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.Sales. Sales for the year are expected to total 1,100,000 units. Quarterly sales are 22%, 27%, 26%, and 25%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $45 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher than...
E13-6   Prepare production and direct materials budgets by quarters for 6 months. (LO 2), AP On...
E13-6   Prepare production and direct materials budgets by quarters for 6 months. (LO 2), AP On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000. Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,200 units. The ending raw...
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30....
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30. Include the following detailed budgets (by month and in total): Sales budget Schedule of expected cash collections from sales Purchases budget (in units and in dollars) Expected cash disbursements for merchandise purchases Sales price of product = $10/unit Actual Sales are as follows: January $20,000 February $26,000 March $40,000 Budgeted sales: September $25,000 August $28,000 July $30,000 June $50,000 May $100,000 April $65,000 We...
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30....
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30. Include the following detailed budgets (by month and in total): Sales budget Schedule of expected cash collections from sales Purchases budget (in units and in dollars) Expected cash disbursements for merchandise purchases Sales price of product = $10/unit Actual Sales are as follows: January $20,000 February $26,000 March $40,000 Budgeted sales: September $25,000 August $28,000 July $30,000 June $50,000 May $100,000 April $65,000 We...
Prepare a statement of cash flows for the year ended June 30, 2017, using the indirect...
Prepare a statement of cash flows for the year ended June 30, 2017, using the indirect method Assets Cash $ 105,700 $ 47,000 Accounts receivable, net 69,500 54,000 Inventory 66,800 91,000 Prepaid expenses 4,700 6,000 Total current assets 246,700 198,000 Equipment 127,000 118,000 Accum. depreciation—Equipment (28,500 ) (10,500 ) Total assets $ 345,200 $ 305,500 Liabilities and Equity Accounts payable $ 28,000 $ 34,500 Wages payable 6,300 15,600 Income taxes payable 3,700 4,400 Total current liabilities 38,000 54,500 Notes payable...
Prepare a statement of Cash Flows For the year ended June 30th, 2020 6/30/20 6/30/19 Debits...
Prepare a statement of Cash Flows For the year ended June 30th, 2020 6/30/20 6/30/19 Debits Credits Debits Credits Cash $6,300 $-   $5,000 $-   Accounts Receivable 1,200 750 Prepaid Insurance 760 530 Land 9,000 -   Equipment 15,000 15,000 Accumulated Depreciation - Equipment 1,350 350 Building 40,000 -   Accumulated Depreciation - Building 2,000 -   Notes Payable 5,000 1,000 Accounts Payable 570 250 Salaries and Wages Payable 450 300 Interest Payable 50 50 Deferred Revenue 800 800 Long Term Debt 32,000 -  ...
Prepare GradyGrady​'s direct materials​ budget, direct labor​ budget, and manufacturing overhead budget for the year. Round...
Prepare GradyGrady​'s direct materials​ budget, direct labor​ budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for​ production, budgeted overhead​ costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number. Grady​, Inc. manufactures model airplane kits and projects production at 650​, 500​, 450​, and 600 kits for the next four quarters. First Quarter                                                            Second   Quarter        Third Quarter               Fourth Quarter                   Total Direct materials (ounces) per kit Direct...
What is a budget Prepare examples of Revenue, production, direct materials, labor budget What is a...
What is a budget Prepare examples of Revenue, production, direct materials, labor budget What is a cash budget Why are budgets important for organizations
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the...
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the direct method, ignoring GST. Show all workings on the Workings page. (b) Using the relevant information from the question above, identify two (2) specific items (including their values) which causes a difference between Net Profit and Net Cash from Operating Activities and analyse why it causes a difference. The following financial statements relate to Clarke Ltd for the financial year ended 30 June 2020....
Prepare a sales, production, direct materials, direct labor, overhead, and selling & administrative expense budget by...
Prepare a sales, production, direct materials, direct labor, overhead, and selling & administrative expense budget by quarter for the year 2020 for the Budgets R Us Co. using the following assumptions: Sales quantity by quarter: 10,000, 11,000, 12,000, 13,000, 14,000, 15,000. Selling price per unit = $20. Ending FG inventory = 10%. RM pounds per unit = 4. Ending RM inventory = 20%. RM price per pound = $2 Direct labor hours per unit = 2 Direct labor hourly rate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT