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.75 7,000 $16.00 February 58,000 $8.75 7,500 $16.00 March 80,000 $8.75 13,000 $16.00 April 100,000 $8.75 18,000 $16.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.
FlashKick Company | ||||
Sales Budget | ||||
For the First Quarter of Next Year | ||||
January | February | March | Quarter | |
Practice ball: | ||||
Units | ||||
Unit price | $ | $ | $ | $ |
Sales | $ | $ | $ | $ |
Match ball: | ||||
Units | ||||
Unit price | $ | $ | $ | $ |
Sales | $ | $ | $ | $ |
Total sales | $ | $ | $ | $ |
Feedback
2. What if FlashKick 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 $45 each in January and February, and $48 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.
FlashKick Company | ||||
Sales Budget | ||||
For the First Quarter | ||||
January | February | March | Quarter | |
Practice ball: | ||||
Units | ||||
Unit price | $ | $ | $ | $ |
Sales | $ | $ | $ | $ |
Match ball: | ||||
Units | ||||
Unit price | $ | $ | $ | $ |
Sales | $ | $ | $ | $ |
Tournament ball: | ||||
Units | ||||
Unit price | $ | $ | $ | $ |
Sales | $ | $ | $ | $ |
Total sales | $ | $ | $ | $ |
Sales Budget | ||||||
Jan | Feb | Mar | Quarter | |||
Practice Balls | ||||||
Units | 50000 | 58000 | 80000 | 188,000 | ||
Unit Price | 8.75 | 8.75 | 8.75 | 8.75 | ||
Sales | 437500 | 507500 | 700000 | 1645000 | ||
Match Balls | ||||||
Units | 7000 | 7500 | 13000 | 27500 | ||
Unit Price | 16 | 16 | 16 | 16 | ||
Sales | 112000 | 120000 | 208000 | 440000 | ||
Total sales | 549500 | 627500 | 908000 | 2085000 | ||
Req b: | ||||||
Jan | Feb | Mar | Quarter | |||
Practice Balls | ||||||
Units | 50000 | 58000 | 80000 | 188,000 | ||
Unit Price | 8.75 | 8.75 | 8.75 | 8.75 | ||
Sales | 437500 | 507500 | 700000 | 1645000 | ||
Match Balls | ||||||
Units | 4200 | 4500 | 7800 | 16500 | ||
Unit Price | 16 | 16 | 16 | 16 | ||
Sales | 67200 | 72000 | 124800 | 264000 | ||
Soccer balls | ||||||
Units | 2800 | 3000 | 5200 | 11000 | ||
Unit Price | 48 | 48 | 48 | 48 | ||
Sales | 134400 | 144000 | 249600 | 528000 | ||
Total sales | 639100 | 723500 | 1074400 | 2437000 |
Get Answers For Free
Most questions answered within 1 hours.