Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started