Question
Business Description: Your project group will assume the role of young entrepreneurs to start a small company. Your company will rent a retail cart inside
Business Description: Your project group will assume the role of young entrepreneurs to start a small company. Your company will rent a retail cart inside the Great Lake Mall to buy plain T-shirts and imprint them with one of the twelve beautiful pictures exclusively designed for your company by a famous artist who is a friend of yours. He has agreed to design twelve super attractive T-shirt pictures for you each year at a special discount. Your target customers are teenagers and young adults who have your kind of good taste. Your business is scheduled to launch on January 1, 2020. Cost information: 1) Stoneridge charges you $2,500 rent per month, which includes utilities, telephone, cleaning, and maintenance. You estimated that 90% of the rent was related to factory operations and 10% was related to selling and administrative activities. 2) You will order white, cotton t-shirts from a T-shirt wholesaler. Each T-shirt will cost (including taxes, shipping, and handling) $3.75 to purchase. 3) To store T-shirts that were bought, but not yet imprinted, you will rent a storage unit. The storage unit costs you $125 per month. 4) You agreed to pay your artist friend a $10,000 annual contract fee plus a $300 design fee for each of the 12 T-shirt pictures designed. This same term is renewable for the next 3 years. Each T-shirt picture will only be used for one year. Therefore, in the second year, 12 new pictures will be designed at $300 each and another $10,000 annual contract fee will be charged. 5) You will buy several items before that start of your business: a) A computer and a printer: You will pay $6,000 (including taxes, shipping and handling) to buy a computer and a printer. You expect both to last about 3 years without salvage value. You will use the straight-line method for depreciation. You estimate that about 90% of the computer and printer will be used for factory operations and 10% will be for selling and administrative activities. b) A heat press machine: You will pay $4,500 (including taxes, shipping and handling) for a heat press machine. The machine is used for imprinting t-shirts only and is expected to last 3 years without salvage value. c) Transfer paper: Each case of transfer paper costs $400 and contains 1,000 sheets of 8.511 transfer paper. You expect to use one transfer paper to print one T-shirt. d) Ink-jet cartridges: On average, each cartridge costs $50 and can make 500 prints. Each T- shirt requires one print. You also need to print flyers, etc. for selling and administrative purposes. For this non-manufacturing printing, you will print about one page for every 5 T-shirts sold.
e) Laser paper: You will buy several reams of laser paper to print promotion flyers, etc. Each ream costs $20 and contains 200 sheets of 8.511 laser paper. 6) Wrapping paper and box: Each T-shirt costs about $0.20 to wrap and box. Wrapping and boxing are not considered as manufacturing. 7) You will hire three fellow students as part-time workers. They not only help you operate the machine, but also help fold, wrap and box T-shirts. Sometimes, three of them work at the same time. But, sometimes they dont because of their different class schedules. On average, printing 10 shirts will take one labor hour. Folding and packaging 20 shirts also will take about one labor hour. You will pay each of your workers $8 per hour. Folding and wrapping are not considered as manufacturing. 8) You (the owners) do all the selling and administrative work by yourselves. You will pay yourselves a total of $12,000 per year (to be divided among all owners). 9) To protect your business from legal obligation, you will purchase a liability insurance that will cost you $3,600 per year. 10) You will hold four end-of-quarter parties to promote sales of your t-shirts. Each party costs you about $1,000. Section One Requirements: 1. Give your company an attractive name. 2. What and how much of your costs are variable costs? List your manufacturing and non- manufacturing variable cost items and present each of them in cost per T-shirt basis. 3. What and how much of your costs are fixed costs? List your manufacturing and non- manufacturing fixed cost items and present each of them in total cost per year. 4. (Write out your yearly cost formula in Y = a + bX format. Be sure to include both manufacturing costs and non-manufacturing costs in the cost formula. 5. Assume that you make and sell 7,800 t-shirts in the first year. Use your cost formula to calculate your first years total cost. If you sell these t-shirts at $15 each, how much would net profit be in the first year? Section Two Requirements: ONLY WORK ON THAT SECTION PLEASE. Now you have developed your cost estimates, lets do some evaluations on this proposed business.
1. Continue to assume that 7,800 t-shirts will be made and sold in the first year. What is your product cost per unit under absorption costing? What is your product cost per unit under variable costing? 2. Based on the estimated sales level of 7,800 t-shirts for the first year, prepare your companys (forecasted) income statement for the year ended on 12/31/2020 using both (a) the traditional format based on the absorption costing and (b) the contribution format based on the variable costing. 3. Calculate contribution margin per T-shirt and contribution margin ratio. 4. Calculate how many T-shirts you need to sell in order to break-even. Calculate how much sales in dollars you need to make in order to break-even. (Use break-even formulas.) 5. Calculate how many T-shirts you need to sell in order to make $10,000 target profit for the year. 6. Continue to assume that 7,800 T-shirts will be made and sold during the first year. Calculate your (a) margin of safety and (b) degree of operating leverage (DOL) for your business. What do these figures tell you about how risky your business is? 7. If sales could increase by 1,560 shirts (i.e. a 20% increase), by how much in dollars would net operating income increase? By what percentage would net operating income increase? (Use the quick way, i.e. contribution margin concept and DOL, you have learned in class to answer these questions. Do not recalculate net operating income.) 8. Prepare a contribution format income statement assuming a sales increase by 20% to 9,360 shirts. Compare your new net operating income with your answer in Question 2 and prove mathematically that your answers to the two questions in Question 7 are correct. 9. Ignore Questions 7 and 8. If the cost per plain t-shirt is expected to increase by 20% and sales (in number of T-shirts) are expected to be 5% less, how much is your projected net operating income (or loss)? 10. Continue Question 9. If the only expense you can cut is the salary paid to yourselves, how much salary should you cut in order to break even? 11. Ignore Question 9 and 10. Assume that you have produced 7,800 t-shirts, but the actual sales for the first year turn out to be 7,000 T-shirts instead of 7,800. I.e. you will have 800 T- shirts left at the end of the first year. Prepare (a) a traditional format income statement and (b) a contribution format income statement. Are the two net operating income figures the same? Why or why not? 12. Continue 11. At what amount would inventory be reported in the balance sheet of 12/31/2020 under (a) the absorption costing and (b) variable costing? Are the two ending inventory figures the same or different? Why?
I did section one please work on section two!!!!!
1 Q2 2 Variable Cost 3 Cost Items Cost per T-Shirt 4 Manufacturing 5 Cost of T-shirt 3.75 3.75 6 Transfer Paper (400/1000 Sheets) 0.4 7 Ink-Jet catridge ($50/500) prints 0.1 8 Labour Charges of part time workers Printing (1 Hour*$8)/10 shit 0.8 9 10 Total Variable Manufacturing Cost per T-Shirt 5.05 11 12 Non-Manufacturing 13 Ink-Jet catridge ($50/500)*1 print/5 shirts 0.2 14 Laser paper ($20/200sheets) 0.1 15 Wrapping Paper and box 0.2 16 Labour Charges of part time workers Flod,wrap and box (1 Hour 0.4 17 18 Total Variable Non-Manufacturing Cost per T-Shirt 0.72 19 Total Variable Cost per T-Shirt 5.77 Cost per Year 27000 1500 10300 1800 1500 42100 21 Q3 22 Fixed Cost 23 Cost Items 24 Manufacturing 25 Stoneridge charges(2500*12*90%) 26 Storage units (125*12) 27 Design charges (10000+300) 28 Campeuter and Printer (6000/3)*90% 29 Heat press Machine (4500/3) 30 Total Fixed Manusacturing Cost per Year 31 32 Non-Manufacturing 33 Stoneridge charges(2500*12*10%) 34 Compeuter and Printer (6000/3)*10% 35 Selling and administrative 36 Insurance 37 Party Expenses (4*1000) 38 Total Fixed Non-Manufacturing Cost per Year 39 Total Fixed Cost per Year 40 3000 200 12000 3600 4000 22800 64900 50 Q4 51 Y=a+bX 52 Y= Total cost 53 a= Fixed cost 64900 54 b= Varlable cost 5.77 55 X= Namber of T-shirts sold 56 57 Y=64900+5.77 X 58 59 Q5 60 Y=64900+5.77*7800=109606 61 Profit if the sale price is $15 per T-shirt 62 Sales=Namber of T-shirts sold*sale price 63 Sales=7800*15= 117000 64 Profit=Sales-Total cost 65 Profit=117000-109606= 7394 66 67 1 2 Product Cost under Absorption Costing 3 =DM + DL + VMOH + FMOH/# of units of products 4 = Variable Manufacting Cost + Fixed Manufacting Overhead /# of products 5 6 Product Cost under Variable Costing 7 =DM + DL + VMOH 8 = Variable Manufacting Cost 9 10 11 Company Name 12 Income Statement - Traditional Format 13 For the Year Ended Dec 31, 2020 14 Sales Revenue 15 Cost of Goods Sold 16 Gross Margin 17 Selling & Administrative Expense 18 Net Operating Income 19 20 21 22 Company Name 23 Income Statement - Contribution Format 24 For the Year Ended Dec 31, 2020 25 Sales Revenue 26 Variable Manufacting Cost 27 Variable Non-Manufacting Cost 28 Contribution Margin 29 Fixed Manufacting Cost 30 Fixed Non-Manufacting Cost 31 Net Operating Income 32 33 34 35 26 Part 1 Part 2 + Ready 1 Q2 2 Variable Cost 3 Cost Items Cost per T-Shirt 4 Manufacturing 5 Cost of T-shirt 3.75 3.75 6 Transfer Paper (400/1000 Sheets) 0.4 7 Ink-Jet catridge ($50/500) prints 0.1 8 Labour Charges of part time workers Printing (1 Hour*$8)/10 shit 0.8 9 10 Total Variable Manufacturing Cost per T-Shirt 5.05 11 12 Non-Manufacturing 13 Ink-Jet catridge ($50/500)*1 print/5 shirts 0.2 14 Laser paper ($20/200sheets) 0.1 15 Wrapping Paper and box 0.2 16 Labour Charges of part time workers Flod,wrap and box (1 Hour 0.4 17 18 Total Variable Non-Manufacturing Cost per T-Shirt 0.72 19 Total Variable Cost per T-Shirt 5.77 Cost per Year 27000 1500 10300 1800 1500 42100 21 Q3 22 Fixed Cost 23 Cost Items 24 Manufacturing 25 Stoneridge charges(2500*12*90%) 26 Storage units (125*12) 27 Design charges (10000+300) 28 Campeuter and Printer (6000/3)*90% 29 Heat press Machine (4500/3) 30 Total Fixed Manusacturing Cost per Year 31 32 Non-Manufacturing 33 Stoneridge charges(2500*12*10%) 34 Compeuter and Printer (6000/3)*10% 35 Selling and administrative 36 Insurance 37 Party Expenses (4*1000) 38 Total Fixed Non-Manufacturing Cost per Year 39 Total Fixed Cost per Year 40 3000 200 12000 3600 4000 22800 64900 50 Q4 51 Y=a+bX 52 Y= Total cost 53 a= Fixed cost 64900 54 b= Varlable cost 5.77 55 X= Namber of T-shirts sold 56 57 Y=64900+5.77 X 58 59 Q5 60 Y=64900+5.77*7800=109606 61 Profit if the sale price is $15 per T-shirt 62 Sales=Namber of T-shirts sold*sale price 63 Sales=7800*15= 117000 64 Profit=Sales-Total cost 65 Profit=117000-109606= 7394 66 67 1 2 Product Cost under Absorption Costing 3 =DM + DL + VMOH + FMOH/# of units of products 4 = Variable Manufacting Cost + Fixed Manufacting Overhead /# of products 5 6 Product Cost under Variable Costing 7 =DM + DL + VMOH 8 = Variable Manufacting Cost 9 10 11 Company Name 12 Income Statement - Traditional Format 13 For the Year Ended Dec 31, 2020 14 Sales Revenue 15 Cost of Goods Sold 16 Gross Margin 17 Selling & Administrative Expense 18 Net Operating Income 19 20 21 22 Company Name 23 Income Statement - Contribution Format 24 For the Year Ended Dec 31, 2020 25 Sales Revenue 26 Variable Manufacting Cost 27 Variable Non-Manufacting Cost 28 Contribution Margin 29 Fixed Manufacting Cost 30 Fixed Non-Manufacting Cost 31 Net Operating Income 32 33 34 35 26 Part 1 Part 2 + ReadyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started