I need the numbers and layout for A though N on last page.
Comprehensive Budget Project 2a West Slope Backpacks Manufacturing West Slope 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 eight year of operations and is preparing to build its master budget for the coming year, 2018. 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 2018 unit sales for each quarter and for the first two quarters of 2018 are as follows Year 2018 2018 2019 2019 Backpacks Larger Larger Backpacks First Quarter 103.950 92,400 115,500 103 930 Second Quarter 207 900 138,600 184,800 Third Quarter 161,700 69300 Fourth Quarter 136.290 23.100 150,150 B. The selling price for the above quarters is projected at $55.00 per smaller bags and S175.00 per larger bag C. West Slope 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. West Slope ended the current year (2017) with a finished goods inventory of 101,640 smaller bags and 55,440 larger bags. Because of a discouraging economic forecast, it plans to budget an ending inventory of 20% of the next quarter's unit sales. The company's ending Work-in-Process inventory is expected to be S254,100 (this number will only be used in the Cost of Goods Manufactured Statement and Balance Sheet). E. The following are the bud d standard costs to make 1 finished uct. Direct Material: Backpacks Larger Back ks .330 sq. yd. @S10.396 yd. 1.375 sq. yd. @S10.396 yd. Lining 1.110 sq yd as2.772 yd. 1.55 sq. yd. S2.772yd. Direct Labor: 110 hr. @$20.79 hr. .165 hr. (a S20.79 hr .275 hr S34.65 hr. .44 hr. @S34.65 hr variable Per Travel Bag (a $3.58 Per larger bag @S3-58