managerial. excel chpt 8

Excel Home Com File Edit View Insert Format Tools Data Window Help AutoSaver lastname MgriB Insert Draw Page Layout Formulas >> Tell me Share A % Conditional Formatting Format as Table Font Alignment Number Cells Editing Cell Styles x V fx C D E F G Your Company makes 7000 units of a component part. At this level of activity, the cost per part Clipboard D15 Exercise 3 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total cost per part $3.00 $4.00 $2.00 $6.00 $15.00 An outside supplier has offered to sell the parts to Your Co. for $12 each. If Your Co accepts this offer, it will be able to increase production of another product and earn an additional $21000 profit. Of the fixed manufacturing overhead, 60% is allocated and 40% direct. Complete the following table to determine whether you should make or buy the part. Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Purchase price Opportunity cost Total cost SO TI What is the difference in cost? Should you make or buy the part? A6 27 Ready Page: 1 of 1