A spreadsheet to support the decision making needs of SCTC’s managers

SPREADSHEET EXERCISE: PERFORMING BREAKEVEN ANALYSIS AND SENSITIVITY ANALYSIS Selmore Collectible Toy Company (SCTC) makes toy sets consisting of collectible trucks, vans, and cars for the retail market. The firm is developing a new toy set that includes a battery-powered tractor-trailer, complete with cab and trailer, sports car, and motorcycle. Each set sells for $100. Table 1 shows the major components of SCTC’s annual fixed costs for the toy set. Each component includes the cost of purchases, depreciation, and operating expenses. Table 2 shows the major components of SCTC’s variable costs. Prepare a spreadsheet to support the decision making needs of SCTC’s managers. The spreadshe... click for more