Question: This is all the info provided - I think the fixed cost would need to be the 200,000? Please show step by step how I

 This is all the info provided - I think the fixed

This is all the info provided - I think the fixed cost would need to be the 200,000? Please show step by step how I can do this in Excel - thank you!

Problem 1. A small firm builds galvanized swing sets. The investment in plant and equipment is $200,000. The variable cost per swing set is $500. The selling price of the swing set is $1000. Using Excel, determine how many swing sets would have to be sold for the firm to break even? Show your complete Excel solution. Can you show the graph of breakeven? Problem 1. A small firm builds galvanized swing sets. The investment in plant and equipment is $200,000. The variable cost per swing set is $500. The selling price of the swing set is $1000. Using Excel, determine how many swing sets would have to be sold for the firm to break even? Show your complete Excel solution. Can you show the graph of breakeven

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!