Question: i need to know the formulas needed to get the answers. thnak you A1 begin{tabular}{|l|l|r|r|r|} hline multicolumn{1}{|c|}{ A } & multicolumn{1}{|c|}{B} & C & D


i need to know the formulas needed to get the answers. thnak you
A1 \begin{tabular}{|l|l|r|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{B} & C & D & E \\ \hline 1 & Chapter 6: Applying Excel \\ \hline 2 & & & \\ \hline 3 & Data \\ \hline 4 & Selling price per unit & & \\ \hline 5 & Manufacturing costs: & $50 & \\ \hline 6 & Variable per unit produced: & & \\ \hline 7 & Direct materials & $11 & \\ \hline 8 & Direct labor & $6 & \\ \hline 9 & Variable manufacturing overhead & $3 & \\ \hline 10 & Fixed manufacturing overhead per year & $120,000 & \\ \hline 11 & Selling and administrative expenses: & & \\ \hline 12 & Variable per unit sold & $4 & \\ \hline 13 & Fixed per year & $70,000 & \\ \hline 14 & & & \\ \hline 15 & & Year 1 & Year 2 \\ \hline 16 & Units in beginning inventory & 0 & \\ \hline 17 & Units produced during the year & 10,000 & 6,000 \\ \hline 18 & Units sold during the year & 8,000 & 8,000 \\ \hline 19 & & & \\ \hline \end{tabular} 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 Compute the Ending Inventory 24262728UnitsinbeginninginventorUnitsproducedduringtheUnitssoldduringtheyearUnitsinendinginventory \begin{tabular}{|r|r|} \hline \multicolumn{1}{|c|}{ Year 1} & Year 2 \\ \hline 0 & ? \\ \hline? & ? \\ \hline? & ? \\ \hline? & ? \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
