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.

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.

Name: Anna operates a consignment shop where she sells clothes for women and
Uploaded: 2024-03-20T07:06:41.000Z
Channel: Bartleby
Description: 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 t

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter6: Linear Systems

Section6.8: Linear Programming

Problem 4SC: If the cost of each Robust tablet increases to 75 c and the cost of each Vigortab increases to 80 c...

See similar textbooks

Similar questions

If the cost of each Robust tablet increases to 75 c and the cost of each Vigortab increases to 80 c , find the minimum cost.
calculate the producers surplus p=7+2q^1/3 p=20
Your University magazine, The Indus Magazine, has fixed production costs of Rs.1.5 million peredition, and printing and distribution costs of Rs.80/copy. The Indus Magazine sells forRs.150/copy. a. Write down the associated cost, revenue, and profit functions
The Verizon publishing company pays its salespeople a weekly salary plus a 2% commission on all net sales over $5,000 (no commission on returned goods).Complete the following table. Employee Gross sales Return Net sales Given quota Commission sales Commission rate Total commission Regular wage Total wage Pat Brown $12,585 $135 $5,000 2 % $250 I need help working these situations out.
The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1,200 Satin 24 20 15 2,000 Plain fabric 40 40 30 7,500 Leather 11 11 10 1,000 Profit per model $50 $44 $40 a. Identify the decision variables, objective function, and constraints in simple verbal statements. b. Mathematically formulate a linear optimization model. c. Implement the linear optimization model that you developed on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver…
A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Noyan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 How many product mix units must be sold to break even? How does it translate into sales of individual games?
A person is choosing between two cellphone plans. Data Plan A has a monthly fee of $40 with a charge of $13 per gigabyte (GB). Data Plan B has a monthly fee of $30 with a charge of $23 per GB. Complete parts a and b below. a) For how many GB of data will the costs for the two data plans be the same? What will be the cost for each plan?
Kimberly works four days per week, Monday through Thursday. She rides the Metropolitan Transit System bus to and from work. The bus cost schedule is shown in the table below. If Kimberly has three weeks of vacation each year, what type of bus ticket should Kimberly buy to save the most money each year? Metropolitan Transit System Bus Pricing single ride: adult/youth: $2.25 senior/disabled/Medicare: $1.10 children 5 and under: free when accompanied by a paying adult 1-day pass: $5.00 2-day pass: $9.00 4-day pass: $15.00 14-day pass: $43.00 monthly pass: adult: $72.00 18 & under: $36.00 senior/disabled/Medicare: $18.00
suppose you prefer The Department has a total budget of $50 million annually to implement four projects (A, B, C, and D). If the budget for Project A is 30% higher than the budget for Project B, the budget for Project D is the same as Project B, and the combined budgets for Project C and D are $20 million. 1. What is the budget for Projects A, B, C, and D (rounded)? a. A: $13 million; B: $10 million; C: $10 million; D: $10 million b. A: $21 million; B: $9 million; C: $11 million; D: $9 million c. Information is insufficient to calculate the budgets for each project. d. A: $17 million; B: $13 million; C: $7 million; D: $13 million
As Sales Manager for Montevideo Productions, Inc., you are planning to review the prices you charge clients for television advertisement development. You currently charge each client an hourly development fee of $2,700. With this pricing structure, the demand, measured by the number of contracts Montevideo signs per month, is 13 contracts. This is down 6 contracts from the figure last year, when your company charged only $2,100. The costs to Montevideo Productions are estimated as follows. Fixed costs: $150,000 per month Variable costs: $60,000 per contract Express Montevideo Productions' monthly cost as a function of the number q of contracts. C(q) = Express Montevideo Productions' monthly cost as a function of the hourly production charge p. C(p) =
A general example of common area maintenance (CAM) charges might be as follows: (1) a retail mall contains 2 million square feet of space, of which 1.2 million is rentable area and 800,000 square feet is common area; (2) total CAM expenses are $3,000,000 for the year; and (3) anchor tenants occupy 700,000 square feet of rentable area and in-line tenants occupy 500,000 square feet. The owner of the mall has negotiated with four anchor tenants that they will pay $2 per rentable foot for CAM charges on a combined total of 700,000 square feet. As per this example, what will be the CAM charges per rentable square foot for in-line tenants?
The water-supply manager for a Midwest city needs to supply the city with at least 10 million gal of potable (drinkable) water per day. The supply may be drawn from the local reservoir or from a pipeline to an adjacent town. The local reservoir has a maximum daily yield of 6 million gallons of potable water, and the pipeline has a maximum daily yield of 10 million gallons. By contract, the pipeline is required to supply a minimum of 6 million gallons/day. If the cost for 1 million gallons of reservoir water is $300 and that for pipeline water is $600, how much water should the manager get from each source to minimize daily water costs, C, for the city?