Question: please follow the instructions and provide formulas ans functions instead of just numerical answers. thank you Jonick Sports, Inc. manufactures a unique type of protective

please follow the instructions and provide formulas ans functions instead of just numerical answers. thank you
please follow the instructions and provide formulas ans functions instead of just
numerical answers. thank you Jonick Sports, Inc. manufactures a unique type of
protective helmet. The following is the company's budget information for April: B.

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 lb. \\ \hline Plastic & $30 \\ \hline Foam lining & $18 \\ \hline \end{tabular} F. Anticipated direct labor requirements to produce each helmet: Q. Estimated factory overhead costs for April: Use the information given and/or your answers to \#1 through 6 to determine the following budget-rolated amounts for April. a. Enter answers in the yellow cels for questions \#1 through 7 using formulas andior functions. b. All answers except $2 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. \begin{tabular}{ll|l|l|} \hline 1. Estimated sales \\ 2. & Number of units to produce & & \\ \hline 3. & Total direct materials to be purchased & \\ \hline 4. & Total direct labor cost & \\ \hline 5. & Total factory overhead & \\ \hline 6. & Total manufacturing costs & \\ \hline 7. Cost of goods manufactured & \\ \hline \end{tabular} 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 lb. \\ \hline Plastic & $30 \\ \hline Foam lining & $18 \\ \hline \end{tabular} F. Anticipated direct labor requirements to produce each helmet: Q. Estimated factory overhead costs for April: Use the information given and/or your answers to \#1 through 6 to determine the following budget-rolated amounts for April. a. Enter answers in the yellow cels for questions \#1 through 7 using formulas andior functions. b. All answers except $2 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. \begin{tabular}{ll|l|l|} \hline 1. Estimated sales \\ 2. & Number of units to produce & & \\ \hline 3. & Total direct materials to be purchased & \\ \hline 4. & Total direct labor cost & \\ \hline 5. & Total factory overhead & \\ \hline 6. & Total manufacturing costs & \\ \hline 7. Cost of goods manufactured & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!