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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!