Reference no: EM131577214

Arrowdale Manufacturing

Budget Information

Arrowdale Manufacturing is a family owned business that has been in operation for over 50 years.

Although the actual manufacturing process has greatly changed due to huge advances in technology, the chief product produced by Arrowdale remains the same - a high-quality stainless steel thermos bottle that is popular with construction workers and others needing a product with a high level of durability.

The company is considering opening a second shift and hiring a number of new employees. Before this decision is finalized, the board of directors would like to have a sense of what they can expect in terms of sales for the upcoming year.

In preparation for the next board meeting, you, as the group of managers over sales, have been asked to prepare an annual sales budget, a production budget, a direct materials budget, a direct labor budget, and a budgeted income statement for next year.

Your group must be able to answer questions that board members might have concerning your calculations and how they impact the decision making. Your assistants have provided the following data:

Sales budget
Anticipated volume in units	600,000
Unit selling price	$22.50
Production budget
Desired ending inventory	40,000
Beginning inventory	35,000
Direct materials budget
Direct materials per unit (pounds)	2.5
Desired ending direct materials in pounds	45,000
Beginning direct materials in pounds	50,000
Cost per pound (unit price)	$3.50
Direct labor budget
Direct labor hours per unit	0.5
Direct labor cost per hour	$12.00
Budgeted income statement
Total Cost of Goods Manufactured per unit	$18.00
Selling expenses	660,000
Administrative expenses	540,000
Interest expense	5,000
Income tax rate	30%
Balance sheet - current year
Finished goods inventory	25,000
Budgeted balance sheet - next year
Finished goods inventory	20,000