Question: Using the problem description and data from the text, construct a profit model in Excel for each of the problems listed below and use the

Using the problem description and data from the text, construct a profit model in Excel for each of the problems listed below and use the models to answer the questions. Use Goal-Seek in Excel to find the break-even points Gina Fox has started her own company, Foxy Shirts, which manufactures imprinted shirts for special occasions. Since she has just begun this operation, she rents the equipment from a local printing shop when necessary. The cost of using the equipment is $350. The materials used in one shirt cost $8, and Gina can sell these for $15 each. A- If Gina sells 20 shirts, what will her total revenue be? What will her total variable cost be? B- How many shirts must Gina sell to break even? What is the total revenue for this? C - Create a one-way table to show the sensitivity of profit to the revenue per shirt. Use revenue inputs of $12, 13, 14, 15, 16, 17 Set the Quantity at 75 units when you create your table. D- Create a graph of your table results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
