CASE 10.2 CASH BUDGETS AND TREND ANALYSIS. Blue Sky Spas is a medium-sized canchisor of luxury spa facilities. It offers the full range of spa treatments, nail specialists, fitness specialists, swimming, aquatic exercise programs, and yoga classes, Franchisees pay $25,000 for the right to use the name and receive support in setting up their spas. They, in turn, agree to buy s* of their merchandise from the franchisor. In addition, the franchisee pays Blue Sky 10% of its total sales to help support marketing programs for the entire chain. Blue Sky, the franchisor, pro- vides top-notch products to the spas, counseling and business analysis support, and marketing for the national chain. Of the products sold, the purchase cost is 60%% of the dollar amount it charges the spas. Since Blue Sky buys in large quantities, it actually can sell the marked-up goods to the local spas for less than they could negotiate a similar product's purchase on their own. Right now, Blue Sky has 2.500 franchisees that, on the average, buy $2,500 of product each month and book $30,000 in total revenues per month. Blue Sky's biggest challenge is keeping the chain growing and managing its cash flow (it has to pay for products and store them until the spas order them). The spas usually take 60 days to pay Blue Sky for both regular sales revenue and product purchases. Bruce Compton, founder of Blue Sky Spas, watches his cash flow carefully from year to year. The cash flow infor- mation for the last six months is laid out in the tables below. The monthly sales and product information is updated for the new number of franchisees each month, as you can see in the income statement. Blue Sky Spas Cash Receipts Summary January February Much April Janie 7500 2530 7510 $750,000 $1,000,000 $1,250,000 $1,500,000 $1.750,000 $1,750.000 $7,290.000 $7.410,000 $7,500,000 $7,590,000 $7,710,000 $7.860,000 Podid sales revenue $6,075,000 $6,175,000 $6,250,000 $6,325,000 $6.425,000 $5,550,000 $16.150,900 $14.115.000 $14.585,000 $15,000,000 $15.415,000 $15,885,000 Blue Sky Spas Cash Dipursements Summary February Haarch April January $4 125,000 $4.230,030 $3,795.000 $3.855,000 $3,530,000 $4,020,000 MANAGEMENT ACCOUNTINGCHAPTER TEN Blue Sky Spas Cash Dispocientals Summary March Japan February April $5 125.000 $5,186,500 $5,268.500 $5,371,000 $5.494.000 $5,637,500 $3,036,000 $3,084,000 $3,144,000 $3,216,000 $3.300,000 Franchise support $3,000,000 $1,000,090 $1,012,000 $1,028,000 $1,048,000 $1,072,000 $1,100,00g Customer serviot $1,250,000 $1 250.000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 Served over head $14,170,090 $14.339,500 $14,560,500 $14,833,000 $15.157.000 615.517,500 Blue Sky Spas Cash Summary February April Hay Beginning balance $75,000 5204000 $265.500 $705,000 $1,287,000 $2,015,303 $14,115,090 $14.585,000 $15,000,000 $15.415,000 $15.885,000 $16.160,000 514.190,000 $14,605,000 $15 265,500 $16,120,000 $17,172,000 $18.175,000 $14 170.000 $14,309-500 $14,560,500 $14 833,000 $15.157,000 $15 517 509 Ending coach baling $20,000 $265.500 $705.000 $1,287,000 $2.015,000 $2 657 509 Blue Sky Spas February March April HIT Product Sales $5,325.000 Lena Cost of Sales $6,425 000 $6 550,000 $6, 7007000 $5,875,/090 $(3,795,000) $(3,835/000) $(3.930,000) $(4 020.040) $2 500 000 $2,530.000 $2.570,000 $2,630,030 $750,000 $2,620,000 $750,000 $1,000 000 $1 250,030 $1 500,000 Total Gross Margin $7.540,009 ST.710,000 $10,750,090 ST.260 000 58 040_000 310.#70,000 $11,280,090 $11, 730,000 $12,720,000 $5.1.25,030 45.186,500 $41500 000 $3,268,500 $5,371.070 $5,494 000 $1,600.030 $3.216 000 $1,412 030 $3,144,000 $1.250.090 $1,024,900 $1,048,000 $1,072_060 #15,375,080 $1,250,000 $1 250,000 $1.230.030 $375 000 $80 630 500 $10,813,030 $11.032 050 #41 12,300) (114,650) $9IT,000 $1,148,900 $267 400 (194,450) $(ass, 400) $260,850 $(275,100) $454 650 5641.100 562 MANAGEMENT ACCOUNTINGSETTING PERFORMANCE EXPECTATIONS AT THE ENTITY LEVEL Bruce is considering a new marketing blitz that would increase the number of new franchisees by 250 per month for the next three months, at which point it would drop back to the normal 60 new franchisees per month. Bruce would need to buy product to support each of these franchisees the month before they come online (just as he does now), which he would pay for in the month of purchase (that is, one month before he actually sells the goods to the franchisee). He would need to wait 60 days to receive payment for the goods and services the franchisee books. Bruce would provide services to the franchisees at the same level as he does now, which is $2,050 for market- ng on average per franchisee, $1,200 per month per franchisee for franchise support, and $400 per month for customer service per franchisee. The new marketing blitz would add another $2.5 milion to Blue Sky's July cash budget requirements. Fixed general overhead would increase to $1.5 million due to the increase in volume of franchisees. The question is: Can Bruce support this level of cash outlay to gain the new franchisees? REQUIRED: d. Extend the cash flow tables to cover July through December. Remember that the payments received are delayed by 60 days, so sales and product receipts made in June are not collected until August. Also remember that Bruce buys product one month in advance, so he buys and pays for goods for the next month's level of franchisees. b. Complete the income statement for the 12 months. Remember there is no lag here. E. With your 12 months of cash data, do a trend analysis chart of cash receipts, cash disbursements, and ending cash balance on the same chart. d. How do Blue Sky's cash flow projections look given these projections? Does the new marketing plan look like a good idea? Why or why not