In the “W2_W4 LT Guillermo exercise data eresource 20111119” using the sheet “Income information” as a source, enter into your destination sheet (either on your own excel file that you create or a sheet that you create within the LT exercise file):

a) indicate the number of units produced on lines 10 & 11 the currently(column B) and the hi-tech and broker scenario (production levels for the broker and hi tech scenario (columns c&d) assume full capacity as described in column E).

b) Indicate, given the indicated price per unit on line 27, what the total sales would be by units under the current business model, and under the broker and hi-tech scenario.

c) using the cost data per unit in materials and labor, indicate the gross margin under each of the three business scenarios.