PLEASE HELP SOLVE 8.01 and 9.04 through 9.14

PART 1 Fixed and Variable Cost Determinations Unit Cost Calculations The projected cost of a lamp is calculated based upon the projected increases or decreases to current costs. The present costs to manufacture one lamp are: Expected increases for 202 When calculating projected increases round to TWO ($0.00) decimal places. 1. Material Costs are expected to increase by 2.50%. 2. Labor Costs are expected to increase by 6.50%. 3. Variable Overhead is expected to increase by 5.50%. 4. Fixed Overhead is expected to increase to $280,000. 5. Fixed Administrative expenses are expected to increase to $48,000. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 6.50%. 7. Fixed selling expenses are expected to be $33,000 in 202. 8. Variable administrative expenses (measured a per lamp basis) are expected to increase by 5.00%. 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, \$\#\#.\#\#) 3 Direct Labor Budget Labor Cost Per Lamp Production Total Labor Cost (Round to two places, \$\#\#.\#\#) 4 Factory Overhead Budget Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be Produced Total Variable Factory Overhead (Round to two places, \$\#\#.\#\#) Fixed Factory Overhead Total Factory Overhead (Round to two places, \$\#\#.\#\#) 4 Eactory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, \$\#\#.\#\#) \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & $12.11 \\ \hline \end{tabular} {9.01} 5 Cost of making one unit next vear Cost of one Lamp Kit Labor Cost Per Lamp {9.02} Factory overhead per unit Total cost of one unit \begin{tabular}{|l|l|r|} \hline & & \\ \hline & & $2.13 \\ \hline & & \\ \hline & & $ \\ \hline & & 30.64 \\ \hline \end{tabular} {9.03} (Round to two places, \$\#\#.\#\#) 6 Selling and Admin. Budget Fixed Selling Variable Selling (Round to two places, \$\#\#.\#\#) {9.04} Fixed Administrative Variable Administrative (Round to two places, \$\#\#.\#\#) Total Selling and Administrative (Round to two places, \$\#\#.\#\#) \begin{tabular}{|l|l|l|l|l|} \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} {9.05} {9.06} {9.07} {9.08} {9.09} {9.10} {9.11} {9.12} {9.13} {9.14} PART 1 Fixed and Variable Cost Determinations Unit Cost Calculations The projected cost of a lamp is calculated based upon the projected increases or decreases to current costs. The present costs to manufacture one lamp are: Expected increases for 202 When calculating projected increases round to TWO ($0.00) decimal places. 1. Material Costs are expected to increase by 2.50%. 2. Labor Costs are expected to increase by 6.50%. 3. Variable Overhead is expected to increase by 5.50%. 4. Fixed Overhead is expected to increase to $280,000. 5. Fixed Administrative expenses are expected to increase to $48,000. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 6.50%. 7. Fixed selling expenses are expected to be $33,000 in 202. 8. Variable administrative expenses (measured a per lamp basis) are expected to increase by 5.00%. 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, \$\#\#.\#\#) 3 Direct Labor Budget Labor Cost Per Lamp Production Total Labor Cost (Round to two places, \$\#\#.\#\#) 4 Factory Overhead Budget Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be Produced Total Variable Factory Overhead (Round to two places, \$\#\#.\#\#) Fixed Factory Overhead Total Factory Overhead (Round to two places, \$\#\#.\#\#) 4 Eactory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, \$\#\#.\#\#) \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & $12.11 \\ \hline \end{tabular} {9.01} 5 Cost of making one unit next vear Cost of one Lamp Kit Labor Cost Per Lamp {9.02} Factory overhead per unit Total cost of one unit \begin{tabular}{|l|l|r|} \hline & & \\ \hline & & $2.13 \\ \hline & & \\ \hline & & $ \\ \hline & & 30.64 \\ \hline \end{tabular} {9.03} (Round to two places, \$\#\#.\#\#) 6 Selling and Admin. Budget Fixed Selling Variable Selling (Round to two places, \$\#\#.\#\#) {9.04} Fixed Administrative Variable Administrative (Round to two places, \$\#\#.\#\#) Total Selling and Administrative (Round to two places, \$\#\#.\#\#) \begin{tabular}{|l|l|l|l|l|} \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} {9.05} {9.06} {9.07} {9.08} {9.09} {9.10} {9.11} {9.12} {9.13} {9.14}