Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ACCA Financial Accounting Study Text 2022 23

Authors: Emile Woolf International

1st Edition

1848436831, 978-1848436831

More Books

Students also viewed these Accounting questions