. please include the formulas. thank you

A B D E F G 40 41 42 Given 43 Except 44 Prepare the Revenue Budget Given Total Total 45 Per Unit Units Revenues 46 Chick $ 41.75 400 $ 16,700 47 Hippo $ 39.00 350 $ 13,650 48 Frog $ 38.60 250$ 9,650 49 Total Budgeted Revenues $ 1,000 $ 40,000 50 51 52 53 Prepare the Production Budget 54 Animals 55 Budgeted Units to sell 56 ADD: Target Ending Finished Goods Inventory units 15 Given 57 Total Required Budgeted Units for Year 58 LESS: Beginning Finished Goods Inventory units 10 Given 59 Budgeted Production Units 60 61 Prepare the Direct Materials Usage Budget 62 63 Production Units 64 Skeins of yarn per animal 2 Given 65 Total skeins of yarn needed for production 66 67 68 Total skeins of yarn needed for production 69 Skeins of yarn in beginning raw material Inventory Given 10 Cost per skein-Given $ 4.80 70 Skeins of yarn to be used out of purchased raw material inventory Cost per skein-Given $ 5.00 71 1:01:01 72 73 Cost Budget on Materials to be USED in Budget Period: 74 Skeins of yarn in beg raw mat iny 75 Skeins of yarn used out of total Purchases this Bud Yr 76 77 78 79 30 31 33 34 35 36 37 Prepare the Direct Materials Purchases Budget THREE 38 5 Given 89 Total skeins of yarn needed for production 90 ADD: target ending raw materials 91 Total required budgeted raw materials 92 LESS: beginning raw materials inventory 3 Raw material purchases 10 Given 34 35 26 Total Hrs 37 98 Prepare the Direct Manufacturing Labor Budget Hr No of 39 Per Unit Prod Units 00 1.00 hour per animal 1.0 01 Given Total Hrs 02 D/L Cost Budget $ 10.00 03 Given hours Tot Lab $'s 104 105 Prepare the Manf Overhead Costs Budget - Allocated based on D/L Hours 106 107 Variable: 1108 Supplies Given $ 25 109 Maintenance Given $ 100 110 Indirect Labor Given $ 200 111 112 Fixed: 113 Depreciation Given $ 75 114 Property Taxes Given $ 25 115 Plant Supervision Given $ 300 116 117 Total Manufacturing Costs 118 119 120 Factory overhead rate calculation: 121 122 Total Overhead Dollars 123 Total Driver (hours) 124 125 Overhead rate per hour 126 127 FOUR Units 1 2 3 Prepare the Ending Inventories Budget 4 =5 Ending Finished Goods 6 =7 DM in Ending Finished Goods: 58 Skein of yarn per animal 9 Cost per skein -O DM per animal =1 2 DL in Ending Finished Goods: -3 Hrs per animal 4 Hourly Rate 5 DL per animal -6 7 8 9 Manf O/H in Ending Finished Goods: 0 1 FO rate 2 D/L hours per animal 3 Manf O/H per animal -4 5 Total cost per animal 6 7 Total Cost of Finished Ending Inventory Rounded