answer a-d

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlinea & A & & & B & c & D & E & F & G \\ \hline 91 & Chapter 8: Applying Excel & & = & & +8 & & & & \\ \hline \multicolumn{10}{|l|}{2} \\ \hline 3 & Data & & & & & & & \multicolumn{2}{|l|}{ Year 3 Casater } \\ \hline 4 & & & & 1 & 2 & 3 & 4 & 117 & 2 \\ \hline 5 & Budpoted unit sales & & & 45,000 & 70,000 & 115,000 & 60.000 & 80.000 & 100,600 \\ \hline 6 & & & & & & & & & \\ \hline 7 & - Selling price per unit & i. & 5 & 7 & per unit & & & & \\ \hline 8 & - Accounts recelvabila, beginning balance & & 5 & 65,000 & & & & & \\ \hline 9 & - Sales collected in the quarter sales are made & & & 75 & & & & & \\ \hline 10 & - Sales collected in the quarter after sales ate made & & & 25% & & & & & \\ \hline in & - Desired ending finished goods inventory in & & & 30% & \multicolumn{5}{|c|}{ di toe budgeted unit sules of the nest quarser } \\ \hline 12 & - Finished goods inventory, beghning & & & 12000 & unis & & & & \\ \hline 13 & - Raw matorials required to produce one unit & & & 5 & pounds & & & & \\ \hline 14 & - Desired ending irventory of raw materlabls is & & & 108 & \multicolumn{5}{|c|}{ of the next quarter's peoduction needs } \\ \hline 15 & - Raw materiaks knventory beginning & & & 23000 & pounds & & & & \\ \hline 16 & - Raw materlai coals & & 5 & 080 & perpound & & & & \\ \hline 17 & - Raw muterials parchases are pald & & & & \multicolumn{5}{|c|}{ in the duarter the parchates are made } \\ \hline \end{tabular} a What are the total expected cash collections for the year under this revised budget? a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production 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 budget? d. What are the total expected cash disbursenents for raw materals for the year under this revised budget? d. What are the total expected cash disbursenents for raw materals for the year under this revised budget