Please show all work using excel.

\begin{tabular}{c|c|c} Instruction & 1st Part & 2nd Part \\ \hline \end{tabular} Required: 1. Enter all cells that contain question marks in worksheet '1st Part'. 2. Complete the following requirments in worksheet '2nd Part'. The company has just hired a new marketing manager who insiss that unit sales can be dramatically increased hy dropping the selling price from 56 to \$5- The marketing manager noald like to use the following projections in the badget: Table Summary: First row of table gives budgeted unit siles for six quarters -four quartens for Year 2 and tho quartens for Year 3 The spanner beeding Year 2 Quarter appears over coluans for four quarters. The spanner heading Year 3 Quarter appears oner coluans for two quarters. The second row shows the selling price per unit. Badgeted unit sales Selling price per unit First, Reconstruct the Sales Budgets, Schuedule of Cash Collections, Production Budgets and Raw Materials Purchases budgets using new budgeted units sales in '2nd part' worksheet. Then, Answer the following Questions a. What are the total expected cash collections for the year under this revised badget? b. What is the total required prochaction for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised bualget? \begin{tabular}{c|c|c} Instruction & 1st Part & 2nd Part \\ \hline \end{tabular} Required: 1. Enter all cells that contain question marks in worksheet '1st Part'. 2. Complete the following requirments in worksheet '2nd Part'. The company has just hired a new marketing manager who insiss that unit sales can be dramatically increased hy dropping the selling price from 56 to \$5- The marketing manager noald like to use the following projections in the badget: Table Summary: First row of table gives budgeted unit siles for six quarters -four quartens for Year 2 and tho quartens for Year 3 The spanner beeding Year 2 Quarter appears over coluans for four quarters. The spanner heading Year 3 Quarter appears oner coluans for two quarters. The second row shows the selling price per unit. Badgeted unit sales Selling price per unit First, Reconstruct the Sales Budgets, Schuedule of Cash Collections, Production Budgets and Raw Materials Purchases budgets using new budgeted units sales in '2nd part' worksheet. Then, Answer the following Questions a. What are the total expected cash collections for the year under this revised badget? b. What is the total required prochaction for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised bualget