642 D Strategy, Bilanced Scound, and Strategic Profitability Analysis Gianni & Sons buys T-shirts in bulk, applies its own trendsetting silk-screen designs, and then sells the T-shirts to a number of retailers, Gianni wants to be known for its trendsetting designs, and it wants every teenager to be seen in a distinctive Gianni 4 T-shirt Gianni presents the following data for its first 2 years of operations, 2019 and 2020 5 B 2. 1. Number of T-shirts purchased Number of T-shirts discarded 2019 215,000 2020 245,000 15,000 20,000 9 3. Number of T-shirts sold (row 1-row 2) 200,000 225,000 10 4. Average selling price $30.00 $31.00 5. Average cost per T-shirt $15.00 $13.00 12 6. Administrative capacity (number of customers) 4.500 4,250 13 14 15 7. Administrative costs $1,633,500 $1,593,750 8. Administrative cost per customer frow 7/row 6) 5363 5375 Administrative costs depend on the number of customers Gianni has created capacity to support, not on the actual number of 16 customers served 17 10 19 Number of customers 2019 2020 3,600 3,500 20 Use the blue shaded areas on the ENTERANSWERS tab for inputs Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you 21 will be marked wrong 22 23 Requirements 24 1 Calculate the amount and cost of unused administrative capacity at the beginning of 2020, based on the actual number of customers Gianni served in 2020. 2 Suppose Gianni can only add or reduce administrative capacity in increments of 250 customers. What is the maximum amount of costs that Gianni can save in 2020 by downsizing administrative capacity? 26 Enter all amounts as positive values INSTRUCTIONS ENTERANSWERS Ready Accessibility investigate Type here to search cho Paste Cupboard AS Calitei 12 Font C Alignment G Genera Mage & Center 1. Calculate the amount and cost of unused administrative capacity at the beginning of 2020, based on the actual number of customers Gianni served in 1 2020. (Always use cell references and formulas where appropriate to receive full credit. If 2 you copy/paste from the Instructions tab you will be marked wrong.) 3 Amount of Cost of unused 4 unused capacity capacity 5 6 2. Suppose Gianni can only add or reduce administrative capacity in increments of 250 customers. What is the maximum amount of costs that Gianni can save in 7 2020 by downsizing admistrative capacity? 8 a. Enter all amounts as positive values. (Always use cell references and formulas where appropriate to receive full credit. If 9 you copy/paste from the Instructions tab you will be marked wrong.) 10 11 12 13 14 INSTRUCTIONS Ready c Accessibility Investigate H Type here to search ENTERANSWERS D