URGENT please help, please answer which excel calculations would be used to find the answers to #6. Must be excel specific, thanks!

(background info included)

GOLD MEDAL ATHLETIC CO. Cost of Goods Sold Budget For the Month Endina March 31. 2014 Supporting calculations: Units Cost Total Finished goods inventory, March 1, 2014: Batting helmet Football helmet Total Finished goods inventory, March 31, 2014: Batting helmet Football helmet Total Direct materials inventory, March 1, 2014 Plastic Foam lining Total Direct materials inventory, March 31, 2014 Plastic Foam lining Total The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: a. Estimated sales for March: Batting helmet. Football helmet . a. Estimated sales for March: Batting helmet. Football helmet . b. Estimated inventories at March 1: Direct materials: Plastic........... 90lb. Foam lining ........ 80lb. c. Desired inventories at March 31: d. Direct materials used in production: In manufacture of batting helmet: Plastic.. Foam lining. In manufacture of football helmet: Plastic.. Foam lining. e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Batting helmet: Molding Department . Assembly Department. Football helmet: Molding Department.. Assembly Department. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment h. Estimated operating expenses for March: Sales salaries expense Advertising expense h. Estimated operating expenses for March: i. Estimated other income and expense for March: GOLD MEDAL ATHLETIC CO. Cost of Goods Sold Budget For the Month Endina March 31. 2014 Supporting calculations: Units Cost Total Finished goods inventory, March 1, 2014: Batting helmet Football helmet Total Finished goods inventory, March 31, 2014: Batting helmet Football helmet Total Direct materials inventory, March 1, 2014 Plastic Foam lining Total Direct materials inventory, March 31, 2014 Plastic Foam lining Total The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: a. Estimated sales for March: Batting helmet. Football helmet . a. Estimated sales for March: Batting helmet. Football helmet . b. Estimated inventories at March 1: Direct materials: Plastic........... 90lb. Foam lining ........ 80lb. c. Desired inventories at March 31: d. Direct materials used in production: In manufacture of batting helmet: Plastic.. Foam lining. In manufacture of football helmet: Plastic.. Foam lining. e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Batting helmet: Molding Department . Assembly Department. Football helmet: Molding Department.. Assembly Department. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment h. Estimated operating expenses for March: Sales salaries expense Advertising expense h. Estimated operating expenses for March: i. Estimated other income and expense for March