Question

Could you do letter D. Direct labor budget

Comprehensive Budget Project 2a Confluence Backpacks Manufacturing Confluence Backpacks Manufacturing produces nylon backpacks and larger packs to sell to tourists visiting the Western United States and other tourist areas. The design of the two products is unique and represents a breakthrough in the industry. The company is completing its eighth year of operations and is preparing to build its master budget for the coming year, 2019. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information: A. Projected 2019 unit sales for each quarter and for the first two quarters of 2020 are as follows Year 2019 2019 2020 2020 Backpacks LargeBackpacks Backpacks Larger Backpacks 41,580 60,060 Produce 46,200 73,920 First Quarter 55,440 27,720 9,240 Second Quarter83,160 Third 64,680 Fourth Quarter 54,516 B. The selling price for the above quarters is projected at $55.00 per smaller bags and S175.00 per larger bag. C. Confluence carefully screens its customers and expects no uncollectable accounts. For budget purposes, each quarter has the following collection pattern: 10% of the total is cash sales, 40% of the total will be collected later in the quarter of sale, 50% of the total will be collected in the quarter following the sale. D. Confluence ended the current year (2017) with a finished goods inventory of 50,820 smaller bags and 27,720 larger bags. Because of a discouraging economic forecast, it plans to budget an ending inventory of20% of the next quarter's unit sales. The company's ending Work-in-Process inventory is expected to be $254,100 (this number will only be used in the Cost of Goods Manufactured Statement and Balance Sheet). E. The following are the budgeted standard costs to make 1 finished product BackpacksLarger Backpacks Direct Material Nylon330 sq. yd. @$10.396 yd. 1.375 sq. yd. @$10.396 yd. Linin 110 sq yd. @$2.772 yd.55 sq, yd.@$2.772 yd Direct Labor |@$20.79 hr..165 hr. Cutting Sewing 1.110hr. 275 hr. $34.6hr. 44 hr [email protected] hr. @$34.65 hr Overhead Variable Per Travel Bag a$3.58 Per larger bag a$3.58 Fixed Per travel@$2.356 Per larger bag@$2.356 bag

Answer 1

Closing stock is 20%of next quarter sales

Thus for bagpacks =20%*46200=9240 units

Larger bagpacks=20%*41580=8316 units

Production of units during the year

	Bagpacks	Larger bagpacks
Sales during the year	243936	129360
Add:Desired inventory at the end of year (20%)	9240	8216
Less: opening inventory	50820	27720
Production	202356	129360

Direct labour budget

	Bagpacks	Largerbagpacks	Total hours	Rate	Total Cost
Cutting Department	202356*0.110 hrs =22259.16 hrs	109956*0.165hrs =18142.74 hrs	40402 hrs	$20.79	$839957.58
Sewing Department	202356*0.275 hrs=55647.9 hrs	109956*0.44hrs =48380.64hrs	104029 hrs (approx)	$34.65	$3604604.85
Total			144431 hrs		$4444562.43

HAPPY LEARNING :)