1. Using all this information complete the following table and answer the questions. It would be easier if you set this up in an Excel spreadsheet. When you are done, you must submit it as a Word document with your answers. You will use this table to answer questions 2 and 3. (4 marks) Your first step is to identify which are fixed costs and which are variable costs. If you will have to keep paying the cost whether you produce 0 units of the product or 10,000 units, then it is a fixed cost. In the short run you have to keep paying it: In the long run you may be able to change these fixed costs. A variable cost changes based on how much of the product you produce. But the variable costs may not change all at th same time. # of workers Q TVC AVC AFC TC ATC MC TVC IQ FCIQ FC + VC TC/Q ATC / 0 0 1 12000 21000 N 3 35000 4 50000 A company produces gold picture frames. The cost per picture frame is: Materials Packaging Decorations on the frame Shipping and handling $9 $1 $5 $1.5 Each worker earns $30,000 annually in salary and benefits. The number of workers changes based on the level of production. This means this is a variable cost. The artist who creates the designs on the picture frames is paid $25,000 annually. Senior management are paid a total of $200,000 annually. Other annual costs are: I Taxes and Insurance Utilities Rent Miscellaneous Overhead Expenses $17,000 $50,000 $300,000 $24,000 1 The following production is possible: No. Of 0 2 3 4 5 6 7 Workers No. Of 0 12,000 21,000 35,000 50,000 65,000 73,000 | 71,000 Picture Frames that can be made