i can not figure out how to do 5 8 9 10 in excel. any help would be approciated. also how would i figure out the forcast sales for july? would it have to be goven to me or is there a way to figure it out?

2) Production Budget in units for each month (somewhere near your budget you should calculate cost per unit) 3) Direct Labor Budget for each month 4) Overhead Budget (remember, some of this is depreciation) 5) Administrative Expenses Budget (remember some of this is depreciation) 6) Cash Collections Budget for each month 7) Purchases Budget for Raw Material for each month 8) Cash Disbursements Budget for each month 9) Cash Budget for each month 10) Income Statement for each month Each unit sells for $99 January February March April May June Forecasted Sales 20,000 22,000 23.000 27,000 21 ,000 17.000 Each unit requires 3 pounds of material Each unit requires 2.5 hours of Direct Labor Each unit requires 1.5 hours of machine time Each pound of material costs $5 Each machine hour costs $9 of which I is depreciation Each Direct Labor hour costs $17 Your desired Finished Goods inventory is 20% of next month's sales Your desired Raw Material ending inventory is 25% of next month's usage Your cash collections are 60% during the month of sale, 24% the next month and 15% two months later, you never collect 1% Your cash payments of raw material are 60% the month of purchase and 40% the next month Actual Beginning Inventory for Finished Goods is 4,000 units Actual Beginning Inventory for Raw Material is 15,300 pounds January February March April May June Administrative expenses $400,000 $380,000 $430,000 $450,000 $370,000 $360,000 $20,000 of administrative expenses are depreciation The Tax rate is 25% of pre-tax net income 1) Sales Budget in units and dollars for each month