FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick's best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 50,000 $8.25 7,000 $15.00 February 58,000 $8.25 8,000 $15.00 March 80,000 $8.25 14,000 $15.00 April 100,000 $8.25 18,000 $15.00 Required: 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent. Flash Kick Company Sales Budget For the First Quarter of Next Year January February March Quarter Practice ball: Units 50,000 58,000 80,000 188,000 Unit price 8.25 $ 8.25 $ 8.25 8.25 Sales 412,500 478,500 660,000 $ 1,551,000 Match ball: Units 7,000 7,500 X 13,000 X 27,500 Unit price 15 15 $ 15 $ 15 Sales $ 112,000 $ 120,000 $ 208,000 $ 440,000 x Total sales 524,500 $ 598,500 $ 868,000 $ 1,991,000 X Feedback Check My Work The Sales Budget is the projection approved by the budget committee that describes expected sales for each product in units and dollars. The sales budget must be constructed first, before other budgets can be constructed. 2. What if Flash Kick added a third line-tournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of $42 each in January and February, and $45 each in March? Prepare a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent 2. What if Flash Kick added a third line-tournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of $42 each in January and February, and $45 each in March? Prepare a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent. Flash Kick Company Sales Budget For the First Quarter January February March Quarter Practice ball: Units 50,000 58,000 80,000 188,000 Unit price 8.25 $ 8.25 $ 8.25 8.25 Sales 412,500 478,500 660,000 1,551,000 Match ball: Units 7,000 4,500 X 78,000 X 16,500 X Unit price 16 X $ 16 X $ 16 X $ 16 Sales 67,200 72,000 124,800 X $ 264,000 X Tournament ball: Accounting numeric field 5,200 X 11,000 X Units 2,800 3,000 X Unit price 45 X $ 45 X $ 48 X $ 46.42 X Sales 126,000 X 135,000 X $ 249,600 X $ 510,600 X Total sales 605,700 X $ 685,500X $ 1,034,400 X $ 2,325,600 X
