Make$-$or$-$buy decision

rate of $44\%$ of direct labor cost. The unit costs to produce comparable carrying cases are expected to be as follows:

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

Differential Analysis

Make $($Alt$.1)$ or Buy $($Alt$.2)$ Carrying Case

May $31$

Make$-$or$-$buy decision

The following data is provided for Pizana Computer Company:

DATA

REQUIRED:

Prepare a differential analysis dated May $31$ to determine whether the company should make $($Alternative $1)$ or buy $($Alternative $2)$ the carrying case.

Using formulas and cell references from the problem data, perform the required analysis.

Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv$2$

for grading.