Exam 10: Spreadsheet Models

Anna operates a consignment shop where she sells clothes for women and children. The average consignments sold per month is 1000. The average material cost and the selling price of each consignment is $8 and $20, respectively. The monthly fixed cost to run this business is given below: Rental cost: $750 Utilities: $150 Advertising: $35 Insurance: $100 Labor cost: $4000 a. Build an influence diagram that illustrates how to calculate profit. b. Using mathematical notation, give a mathematical model for calculating profit. c. Implement your model from part (b) in Excel using the principles of good spreadsheet design.

Within a given range of cells, the number of times a particular condition is satisfied is computed by using the ________ function.

A clothing retail store offers a discount at the rate of 10% on the customer bill if the purchase exceeds $100. The owner of the store wishes to know the total amount that has been discounted on the customers' purchases on a particular day. The purchase amount for each of the 12 customers who visited the store on that day is given below. Display your use of the IF and SUM functions and calculate the total amount discounted on this single day purchases. $\begin{array}{cc}\text { Customer }&\text { Purchase Amount (\$) } \\1 & 123 \\2 & 114 \\3 & 43 \\4 & 123 \\5 & 32 \\6 & 72 \\7 & 119 \\8 & 52 \\9 & 89 \\10 & 116 \\11 & 176 \\12 & 9\end{array}$

The impact of two inputs on the output of interest is summarized by a