Graded Homm work $-4-2$

INSTRKRTIONS

You are to calculate the Contribution unit perminute for each of the four Proclucts $A,B,C,D.$

Your answer show be on an Excel worksheet organized as follows:

DATA PROVIDED:

Broze Company makes four products in a single facility. These products have the following unit product costs:

$x=$ you fill in deseriprian of item

$$=y_0$ fir in t amomnt

For $B,C,D$ you fill ia all $ amounts.

Additional data concerning these products are listed below.

Grinding aimites per us

Selling price per unil Variable selling onat ner

Monthly demand in units

$\backslash$table$[[$Produsts$,],[$A$,$B$,$C$,$D$,,],[3\mathrm{.}80,5\mathrm{.}30,4\mathrm{.}30,3\mathrm{.}40,,],[$$$76\mathrm{.}10,$$$93\mathrm{.}50,$$$37\mathrm{.}40,$$$10\mathrm{.}20,,],[$$$2\mathrm{.}20,$$$1\mathrm{.}20,$$$3\mathrm{.}30,$$$1\mathrm{.}60,,],[4\mathrm{.}000,4,000,3,0\mathrm{.}00,2,000,,]]$

The grinding machines are the constraint in the production facility. A total of $53,600$ minutes

are available per month on these machines.

Direct labor is a variable cost in this company.

I have partially completed calcutions for prodhat A