for requirement 4 i need:

backpacks column, purses & total

$ $ Payton Bags (PB) is a designer of high-quality backpacks and purses. Each design is made in small batches. Each spring, PB comes out with new designs for the backpack and for the purse. The company uses these designs for a year and then moves on to the next trend. The bags are all made on the same fabrication equipment that is expected to operate at capacity. The equipment must be switched over to a new design and set up to prepare for the production of each new batch of products. When completed, each batch of products is immediately shipped to a wholesaler. Shipping costs vary with the number of shipments. Budgeted information for the year is as follows: (Click the icon to view the budgeted Information) Read the requirements Direct labor-purses Number of purses The cost is determined by the number of output Direct labor-backpacks Number of backpacks The cost is determined by the number of output Setup Number of batches The cost is determined by the number of batches. Shipping Number of batches The cost is determined by the number of batches. Design Number of designs The cost is determined by the number of designs. Plant utilities and administration Hours of production The more the machines are used the higher the cost Requirement 3. Calculate the budgeted cost per unit of cost driver for each cost category. (Round the cost driver rates to four decimal places. Abbreviations used: "util. = utilities, "admin" = administration, "DM* = direct materials, "OL" = direct labor.) Cost Total quantity of cost driver = Cost driver rate DM-purses $ 396,000 3,600 = 5 110.00 per purse DM-backpacks $ 442,500 5,900 = 75.00 per backpack DLpurses 115,200 - 3,600 $ 3200 per purse DL-backpacks $ 115,050 Setup costs $ 163,280 Data table Shipping costs $ 74,880 Design costs $ 169,000 Plant util, and admin $ 216,000 Payton Bags Budget for Costs and Activities Requirement 4. Calculate the budgeted total costs and cost cent. X.XX.) For the Year Ended February 28, 2014 $ Direct materials-purses Backpacks 396,000 Direct materials 442,500 442500 Direct materials-backpacks Direct manufacturing labor-purses 115,200 Direct labor 115050 Direct manufacturing labor-backpacks 115,050 Setup Setup 163 280 Shipping Shipping 74,880 Design Design 169,000 Plant utilities and administration Plant utilities and administration 216,000 Total costs $ 1,691,910 Other budget information follows: Etext pages Help me solve this Get Backpacks Purses Total Number of bags 5.900 3.600 9,500 Total Data table Payton Bags Budget for Costs and Activities For the Year Ended February 28, 2014 Direct materials-purses $ Direct materials-backpacks Direct manufacturing labor-purses Direct manufacturing labor-backpacks Setup Shipping Design 396,000 442,500 115,200 115,050 163,280 74,880 169,000 216,000 Plant utilities and administration $ 1,691,910 Total Total Other budget information follows: Backpacks Number of bags 5,900 Hours of production 1,425 Number of batches 158 Purses 3,600 2,575 9,500 4,000 50 208 2 Number of designs 2 4 Print Done Plant util. and admin. $ 216,000 Requirement 4. Calculate the budgeted total costs and cost per unit for each pro cent, X.XX.) Backpacks 442500 Direct materials 115050 Direct labor Setup Shipping Design Plant utilities and administration Total costs Help me solve this Etext pages Get more help