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 put tired a sew marketing manager who is that ut she can be dramately by dropping the from 50 e 55. The marketing manage would he to the following projection the b Table Summary Pest row of tall gives bratel un sales for six quarters-four quarters for Year and to parters for Your 3 The pan leadey Years Quarter appears over clams for for quarters. The spenner headeg Year 3 Quire person for t The drow shows the selling pre per unit 1 Balgeted t 13 Sling price per 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 IN What are the total expected cash collectives for the year under this revised budget? 20 What is the total required production for the year under this revised budget 21 What is the total out of raw materials to be punthased for the year under this revised budget? D 4 Yar