I'm not sure what you need to answer so I attached the original excel spreadsheet and the revisions it wanted done to get the new answers. I just need to be shown how to get the answers for A-C please.

Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would ilike to use the folowing projections in the budget: a. What are the total expected cash collections for the year under this revised budget? Answer is complete but not entirely correct. b. What is the total required production for the year under this revised budget? (8) Answer is complete but not entirely correct. c. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? \begin{tabular}{|l|c|c|c|c|c|c|c|} \hline & 1 & 2 & 3 & 4 & Year & \multicolumn{1}{|c|}{} \\ \hline Budgeted unit salus & 40,000 & 60,000 & 100,000 & 50,000 & 250,000 & 70,000 \\ \hline Add desired finished goods inventory & 18,000 & 30,000 & 15,000 & 21,000 & 84,000 & 24,000 \\ \hline Total needs & 58,000 & 90,000 & 115,000 & 71,000 & 334,000 & 94,000 \\ \hline Less beginning inventory & 12,000 & 18,000 & 30,000 & 15,000 & 75,000 & 21,000 \\ \hline Required production & 46,000 & 72,000 & 85,000 & 56,000 & 259,000 & 73,000 \\ \hline \end{tabular}