I already have the answers, but I just need the FORMULAS in excel to put into the sheet. please complete the answers using the excel formulas and show the formulas as well. thank you
B. folmated imentorie s at Apet t. 0. Coect maieriset used to petodece eari hibest Use the information given andlor your answers to \#1 through 6 to determine the following budgef-related amounts for April, a. Enter answers in the yellow cells for questions \#1 through 7 using formulas and/or functions. b. All answers except H2 are asking for dollar amounts. c. Use variables/cell references rather than typing numbers into the formulas. d. Use the SUM and SUMPRODUCT functions at least once each. BUDOET PAOLEM Inetructions Wonick sports, ine mandactures a unique type of prothctive hemet B. Estimated imentories of Apeil 1: C. Desirediantipliped inventenes at Apil 30 : D. Bured materials used to produce each belsel. 6. Ansoipatied coes per pound of purchases and invertary amounts of direct materisis. Jonick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget information for April: B. Estimated inventories at April 1: C. Desired/anticipated inventories at April 30: D. Direct materials used to produce each helmet: E. Anticipated cost per pound of purchases and inventory amounts of direct materials: \begin{tabular}{|l|c} \hline & Cost per Ib. \\ \hline Plastic & $29 \\ \hline Foam lining & $14 \\ \hline \end{tabular} F. Anticipated direct labor requirements to produce each helmet: Q. Estimated factory overhead costs for April: B. folmated imentorie s at Apet t. 0. Coect maieriset used to petodece eari hibest Use the information given andlor your answers to \#1 through 6 to determine the following budgef-related amounts for April, a. Enter answers in the yellow cells for questions \#1 through 7 using formulas and/or functions. b. All answers except H2 are asking for dollar amounts. c. Use variables/cell references rather than typing numbers into the formulas. d. Use the SUM and SUMPRODUCT functions at least once each. BUDOET PAOLEM Inetructions Wonick sports, ine mandactures a unique type of prothctive hemet B. Estimated imentories of Apeil 1: C. Desirediantipliped inventenes at Apil 30 : D. Bured materials used to produce each belsel. 6. Ansoipatied coes per pound of purchases and invertary amounts of direct materisis. Jonick Sports, Inc. manufactures a unique type of protective helmet. The following is the company's budget information for April: B. Estimated inventories at April 1: C. Desired/anticipated inventories at April 30: D. Direct materials used to produce each helmet: E. Anticipated cost per pound of purchases and inventory amounts of direct materials: \begin{tabular}{|l|c} \hline & Cost per Ib. \\ \hline Plastic & $29 \\ \hline Foam lining & $14 \\ \hline \end{tabular} F. Anticipated direct labor requirements to produce each helmet: Q. Estimated factory overhead costs for April
