What formulas are needed for the blanks?

Part B. Preparation of sales and puchase budget: You are in the process of preparing budget for 20Y2 for El Paso Division. Based on the forecasts of the Sales Department, the sales are expected to increase by 20 per cent in each quarter. According to the company's policy, the desired ending inventory is expected to be 15 per cent of the budgeted sales of the current quarter. - Ending inventory at the end of the Fourth quarter of 20Y1 is 3,500 units. 1. Complete Budget assumption box in the Part B_Data file Budget. (See the comments.) 2. Prepare a Sales budget and Purchase budget for El Paso Division for 20Y2. (Use appropriate formula. Use Roundup function to calculate the number of units as a full unit in each row of the budget tables) Check figures: (Total budget sales units: 128,832 units) (Total budgeted purchase: 131,553 units) 1 Budget Assumptions for El Paso Division Side Salinas 2 Projected/Budgeted sales in unit for the Fourth Quarter of 2011 20,000 Do not hard codeUnk the appropriate od in Project Description worte 3 The percentage of sales increase from one quarter to next quarter data 20% 4 Desired Ending Inventory at the end of each quarter is 15% of the 15% Saddau, Salina 5 Budgeted sales unit of the same quarter Complete al 83, and 16 from the data provided in the part in the 6 Budgeted Ending inventory units for the Fourth quarter of 2041 3,500 Project Description worksheet. These three are the only as you are sup 7 8 Sales Budget for the 2012 9 1st quarter 2nd quarter 3rd quarter 4th quarter Total sale units 10 Sales unit 11 Answer check 13 Purchase Budget for the 2012 14 1st quarter 2nd quarter 3rd quarter 4th quarter Total sales 15 Budgeted Sales unit 16 Plus Desired Ending Inventory 17 Equal to Total need 18 Less Beginning inventory 19 Equal to Budgeted Purchase 20 Answer check 22 Project Description Part A Data Fe CVP Part 3 Data File Budget Grading Crea Part B. Preparation of sales and puchase budget: You are in the process of preparing budget for 20Y2 for El Paso Division. Based on the forecasts of the Sales Department, the sales are expected to increase by 20 per cent in each quarter. According to the company's policy, the desired ending inventory is expected to be 15 per cent of the budgeted sales of the current quarter. - Ending inventory at the end of the Fourth quarter of 20Y1 is 3,500 units. 1. Complete Budget assumption box in the Part B_Data file Budget. (See the comments.) 2. Prepare a Sales budget and Purchase budget for El Paso Division for 20Y2. (Use appropriate formula. Use Roundup function to calculate the number of units as a full unit in each row of the budget tables) Check figures: (Total budget sales units: 128,832 units) (Total budgeted purchase: 131,553 units) 1 Budget Assumptions for El Paso Division Side Salinas 2 Projected/Budgeted sales in unit for the Fourth Quarter of 2011 20,000 Do not hard codeUnk the appropriate od in Project Description worte 3 The percentage of sales increase from one quarter to next quarter data 20% 4 Desired Ending Inventory at the end of each quarter is 15% of the 15% Saddau, Salina 5 Budgeted sales unit of the same quarter Complete al 83, and 16 from the data provided in the part in the 6 Budgeted Ending inventory units for the Fourth quarter of 2041 3,500 Project Description worksheet. These three are the only as you are sup 7 8 Sales Budget for the 2012 9 1st quarter 2nd quarter 3rd quarter 4th quarter Total sale units 10 Sales unit 11 Answer check 13 Purchase Budget for the 2012 14 1st quarter 2nd quarter 3rd quarter 4th quarter Total sales 15 Budgeted Sales unit 16 Plus Desired Ending Inventory 17 Equal to Total need 18 Less Beginning inventory 19 Equal to Budgeted Purchase 20 Answer check 22 Project Description Part A Data Fe CVP Part 3 Data File Budget Grading Crea