Anna Operates a Consignment Shop Where She Sells Cloths for Women

question 19

Essay

Anna operates a consignment shop where she sells cloths 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.

---

Definitions:

Market Equilibrium

A condition or state where the quantity demanded of a good or service at a certain price equals the quantity supplied, leading to a stable market condition.

Collusion

An agreement, usually secretive, between firms to fix prices, limit supply, or inhibit competition.

Candy Bar Manufacturers

Companies or entities that specialize in producing and distributing candy bars.

Grocery Store

A retail establishment that primarily sells food, both fresh and packaged, along with various household items.