Problem 1. (6 points). Please create graphic Excel presentations (in good form, including axis labels) of the cost behaviors described below. a. Rent on a manufacturing plant donated by the city, where the agreement calls for a fixed-fee payment of $100,000, but rent is reduced by $1 for each direct labor hour worked over 20,000 hours. b. The salary costs of shift supervisors at a production facility. Each shift is eight hours and supervisors are paid an annual salary of $60,000. The facility operates with one, two, or three shifts at various times of the year. c. Cost of direct material part, where the cost per unit decreases with the amount of material purchased. In other word, the cost of a Part A is $10 if 1 to 20 units are purchased, $9.10 per part of 21 to 40 pounds are purchased, and $8.50 per part if over 40 parts are purchased. Insert Graphics here