AutoSave OFF AH ? C GO ... w- BECN 200 Assignment 2 Summer 2022 Home Insert Draw Design Layout References Mailings Review View Table Design Layout ? Tell me Share Comments Arial v 12 A" A Aa A EEVEEVEE AaBbCcDdE AaBbCcDdE AaBbCcD AaBbCcDdE AaBb Paste BIUvab X2 X A LAv Norma No Spacing Heading 1 Heading 2 Title Styles Dictate Sensitivity Editor Pane Assignment 2 Summer 2022 A company produces designer shirts. The cost per shirt is: Materials $10.00 Packaging $.1.50 Design on shirt $5.00 Shipping and handling $3.50 Each worker earns $15,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 for the shirts is paid $200,000 annually. Senior management are paid a total of $270,000 annually. Other annual costs are: Taxes and Insurance $18,000 Utilities $80,000 Rent $300,000 Miscellaneous Overhead Office Expenses $32,000 The following production is possible No. Of 6 10 12 14 Workers No. O 2000 4000 6000 9000 13000 15000 14000 shirts that can be made Question 1 Using all information provided, complete the following table. It would be easier if you set this up in an Excel spreadsheet. When you are done, please insert it into a Word moment with your answers. You will use this table t answer Questions 2 and 3. We are working in dollars and cents so your answers should be in dollars and cents as well 2 decimal places. (6 marks) # of workers Q TVC AVC AFC TC ATC MC 2 2000 4 4000 6 6000 -onon Page 3 of 6 1085 words X English (Canada) 2 Accessibility: Investigate Focus E + 70%