Response:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
Justification:
Below is the formula intended to be entered in cell C8:
=IF(C5>35000,IF(C5>25000<35000,IF(C5<25000,0.05*C5),0.04*C5),0.02*C5)
This formula computes the bonus based on the provided data, utilizing the IF function. The formula begins with an equal sign, followed by IF and the application of all relevant terms.
Product G Product B Selling price per unit $120 $160 Variable costs per unit $40 $90 Contribution margin per unit $80 $70 Machine hours per unit 0.4 hours 1.0 hours Max. unit sales per month 600 units 200 units The machine operates for 8 hours daily over 22 days each month, leading to 176 machine hours total. Product G Product B Machine hours per unit 0.4 hours 1.0 hours Contribution margin per machine hour $200 $70 Total hours required for max production 240 200 440. The company should focus solely on producing Product G, as it can produce 440 units monthly, resulting in a contribution margin of $35,200. If the company opts for a two-shift schedule, it could manufacture 600 units of Product G (using 240 machine hours) and allocate the remaining 112 machine hours to produce 112 units of Product B, yielding a total contribution margin of $48,000 + $7,840 = $55,840. The additional contribution margin gained equals $20,640, surpassing the extra costs from operating two shifts, ultimately leading to an increase in profits by $5,640 ($20,640 - $15,000).
The total unique names equal 8,200.
You start by emailing a list of 5000 names, then a second list of 3900 names, resulting in 8900 total. Subtracting the 700 duplicates common to both lists gives a final count of 8,200 unique names.
