Anna Operates a Consignment Shop Where She Sells Cloths for Women

question 8

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. Using a spreadsheet model, construct a one-way data table with number of consignments sold per month as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value. Vary the number of consignments sold per month from 400 to 1200 in increments of 100. In which interval does breakeven occur?
b. Use the appropriate Excel tool to find the exact breakeven point
​

---

Definitions:

NAD+

Nicotinamide adenine dinucleotide, a coenzyme involved in redox reactions, acting as an electron carrier.

Glycolysis

The metabolic pathway that converts glucose into pyruvate, generating ATP and NADH, occurring in the cytoplasm of cells.

Net Gain

The difference between the total earned and the total spent, resulting in either a profit or a deficit.

Citric Acid Cycle

A series of chemical reactions used by all aerobic organisms to generate energy through the oxidation of acetate derived from carbohydrates, fats, and proteins into carbon dioxide and water.