Hello, I'm having trouble with this problem. I need to get the "4th Qtr. Production Cost per Finished Unit" to equal $20.80. I keep getting $17.60- not sure what i am doing wring. please provide excel formulas if possible. thank you.
-please reapond BEFORE saturday 11/18/2022
Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2023 Mrif mene ton 8 Finished Goods Inventory Budgot - for the Profit Planning Year Jan. 1 to Dec. 31, 2023 MyArmor, Ine. Calculation of 4 th Quarter Production Cost per Finished Unit. Fik the Fonsut of al while ctes example on Py 1 of the Finished Coods inventory Fludiget pdt document, what would be the valle of the 100 Finished Units if 4 th q. cost of an heur of Direct Lober was $8 thather than 510? A. $8,400 B. $7,600 c. $6,800 D. $56,000 2. Which one of the following statements is corfect? A. Finished Goods Inventory as of Dec 31,2023 is an inpur to tha Cost of Coods Sold Budget B. Finished Goods invontory as ofDec. 31,2023 is an input to thin Raw Materials Budget. C. Finished Goods Inventory as or Dec 31,2023 is an input to the Cashi Budgot. D. None of the above statements are corrod. Finished Goods Inventory Budget - for the Profit Planning Year Jan, 1 to Dec, 31, 2023 MyArmor, Ine. Calculation of 4 th Quarter Production Cost per Finished Unit, Fix the Format of An weste Calls Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2023 MyArmor, Inc. of Insuat Values Back Fix the Fonmat of All Yellowe Calle Raw Materials Budget Direct Labor Butget \begin{tabular}{|l|l|l|l|l|l|} \hline Drect Labor Hours (hrs) per Finished Unt & 0.20 his & & \\ \hline Average Cost of a Drect Labor Hour & 518 per hour & $18 per hour & $20 per hour & $20 per hour & \\ \hline \end{tabular} Manufacturing Overhead Budget \begin{tabular}{|c|c|c|} \hline Variable Overhead Cost Rate per Direct Labor Hour (DLH) & $8perDLH & \\ \hline Total Foed Manufacturing Overhead Cost per Quarter & $50.000 & \\ \hline Depresiation per Quarter included in Fined Manulacturing Overhead & $9.000 & \\ \hline \end{tabular} Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2023 Mrif mene ton 8 Finished Goods Inventory Budgot - for the Profit Planning Year Jan. 1 to Dec. 31, 2023 MyArmor, Ine. Calculation of 4 th Quarter Production Cost per Finished Unit. Fik the Fonsut of al while ctes example on Py 1 of the Finished Coods inventory Fludiget pdt document, what would be the valle of the 100 Finished Units if 4 th q. cost of an heur of Direct Lober was $8 thather than 510? A. $8,400 B. $7,600 c. $6,800 D. $56,000 2. Which one of the following statements is corfect? A. Finished Goods Inventory as of Dec 31,2023 is an inpur to tha Cost of Coods Sold Budget B. Finished Goods invontory as ofDec. 31,2023 is an input to thin Raw Materials Budget. C. Finished Goods Inventory as or Dec 31,2023 is an input to the Cashi Budgot. D. None of the above statements are corrod. Finished Goods Inventory Budget - for the Profit Planning Year Jan, 1 to Dec, 31, 2023 MyArmor, Ine. Calculation of 4 th Quarter Production Cost per Finished Unit, Fix the Format of An weste Calls Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2023 MyArmor, Inc. of Insuat Values Back Fix the Fonmat of All Yellowe Calle Raw Materials Budget Direct Labor Butget \begin{tabular}{|l|l|l|l|l|l|} \hline Drect Labor Hours (hrs) per Finished Unt & 0.20 his & & \\ \hline Average Cost of a Drect Labor Hour & 518 per hour & $18 per hour & $20 per hour & $20 per hour & \\ \hline \end{tabular} Manufacturing Overhead Budget \begin{tabular}{|c|c|c|} \hline Variable Overhead Cost Rate per Direct Labor Hour (DLH) & $8perDLH & \\ \hline Total Foed Manufacturing Overhead Cost per Quarter & $50.000 & \\ \hline Depresiation per Quarter included in Fined Manulacturing Overhead & $9.000 & \\ \hline \end{tabular}
