Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what are the formulas needed for the questions (1-7) BUDGET PROBLEM Instructions Enter formulas and/or functions in the yellow cells for questions #1 through 7
what are the formulas needed for the questions (1-7)
BUDGET PROBLEM Instructions Enter formulas and/or functions in the yellow cells for questions \#1 through 7 that result in various budget-related amounts for April. Jonick Sports, Inc. manufactures a unique type of protective helmet. a. Use variables/cell references rather than typing numbers into the formulas. The following is the company's budget information for April: b. Only reference cells where data is given or where you entered a previous answer. Do nat use "helper cells". c. Use the SUM and SUMPRODUCT functions at least once each. A. Estimated sales of helmets for April: All items except #2 are asking for dollar amounts. 1. Estimated sales B. Estimated inventories at April 1: 2. Number of units to produce 3. Total direct materials to be purchased Direct materials: 4. Total direct labor cost 5. Total factory overhead 6. Total manufacturing costs 7. Cost of goods manufactured \begin{tabular}{|l|} \hline$1,738,000 \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} C. Desired/anticipated inventories at April 30: Direct materials: D. Direct materials used to produce each helmet: \begin{tabular}{|l|c|} \hline & Pounds \\ \hline Plastic & 2.5 \\ \hline Foam lining & 0.5 \\ \hline \end{tabular} E. Anticipated cost per pound of purchases and inventory amounts of direct materials: \begin{tabular}{|l|c|} \hline & Cost per lb. \\ \hline Plastic & $29 \\ \hline Foam lining & $17 \\ \hline \end{tabular} F. Anticipated direct labor requirements to produce each helmet: \begin{tabular}{|l|c|c|} \hline & Hours & Hourly cost \\ \hline Molding Department & 2.0 & $30 \\ \hline Assembly Department & 0.5 & 22 \\ \hline Finishing Department & 0.25 & 16 \\ \hline Packing Department & 0.25 & 12 \\ \hline \end{tabular} G. Estimated factory overhead costs for April: \begin{tabular}{|l|r|} \hline Indirect factory wages & \multicolumn{1}{|c|}{ Amount } \\ \hline Depreciation of plant and equipment & $109,500 \\ \hline Utilities & 19,100 \\ \hline Insurance & 12,300 \\ \hline Property tax & 6,300 \\ \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