PLEASE SHOW WORK IN EACH CELL. Fill in all blue cells
Instructions (a): Complete the incremental analysis (in total dollars) below for the decision to make or buy the locks.
Instructions (b): Create an If statement (in cell G30) to show whether Brooks Manufacturing should purchase the locks from the supplier based on the Total Annual cost calculated in part (a).
Instructions (c): Complete the incremental analysis to show the impact if Brooks Manufacturing purchased the locks from the supplier and then could earn the following rental income from the released manufacturing space.
SHOW FORMULAS FOR EACH ANSWER
Paste B I HvNumber Cells Cell Styles A16 fz (a) Complete the incremental analysis (in total dollars) below for the decision to make or buy the locks 1 Brooks Manufacturing has been manufacturing its own locks for its security doors. 3 The following is the current cost for manufacturing the locks: Dircct Materials Dircct Labor Manufacturing Ovcrhead - Variable Manufacturing Overhead - Fixcd Unit Production $4.00 per unit $5.00 per unit $3.00 per unit Grading Rub 2 for typed numbers 1 for incorrect formulas 1 for incorrect IF statement in cell G30 2 for not using an IF statement in cell G30 2 for an incorrect filename (First Name Last Name Excel #7) 10 for submitting an Excel file from a previous semester $45,000 30,000 10 Supplicr Purchase Price $12.75 per unit Avoided Fixed Costs if locks are pure hased: S10,000 13 Opportunity Costs 15 16 17 18 19 Instructions: (a) Complete the incremental analysis (in total dollars) below for the decision to make or buy the locks. Net Income Incrcasc Buy Decrcase) Make Direct Materials Direct Labor Overhead Variable Overhcad Fixed 23 25 Supplier Purchase Price: Total annual cost 26 28 (b) Create an If statement (in cell G30) to show whether Brooks Manufacturing should purchase the locks from the supplier based on the 29 Total Annual Cost calculated in cell H27 in part (a). Answer Sheet+ Paste B I HvNumber Cells Cell Styles A16 fz (a) Complete the incremental analysis (in total dollars) below for the decision to make or buy the locks 1 Brooks Manufacturing has been manufacturing its own locks for its security doors. 3 The following is the current cost for manufacturing the locks: Dircct Materials Dircct Labor Manufacturing Ovcrhead - Variable Manufacturing Overhead - Fixcd Unit Production $4.00 per unit $5.00 per unit $3.00 per unit Grading Rub 2 for typed numbers 1 for incorrect formulas 1 for incorrect IF statement in cell G30 2 for not using an IF statement in cell G30 2 for an incorrect filename (First Name Last Name Excel #7) 10 for submitting an Excel file from a previous semester $45,000 30,000 10 Supplicr Purchase Price $12.75 per unit Avoided Fixed Costs if locks are pure hased: S10,000 13 Opportunity Costs 15 16 17 18 19 Instructions: (a) Complete the incremental analysis (in total dollars) below for the decision to make or buy the locks. Net Income Incrcasc Buy Decrcase) Make Direct Materials Direct Labor Overhead Variable Overhcad Fixed 23 25 Supplier Purchase Price: Total annual cost 26 28 (b) Create an If statement (in cell G30) to show whether Brooks Manufacturing should purchase the locks from the supplier based on the 29 Total Annual Cost calculated in cell H27 in part (a). Answer Sheet+
