Greer Golf Supplies is an online store that sells two types of golf balls: practice balls and tournament balls. The golf balls are sold in plastic sleeves containing three golf balls. Practice balls sell for $4 per sleeve; tournament balls sell for $12 per sleeve. Owner Carl Rider purchases the golf balls directly from the manufacturer and pays $1 per sleeve for the practice balls and $4 per sleeve for the tournament balls. Fixed costs total $14,000 per month and include Carl's salary, website hosting, and accounting and legal fees. When preparing the sales forecast for the year, Carl assumed he would sell twice as many sleeves of practice balls as tournament balls.

Required

a. Calculate the annual breakeven point for Greer Golf Supplies.

b. Carl has gathered the sales data for the past year. Use Excel's CHART function to prepare a 100% stacked bar chart of the monthly sales mix based on the actual sales data. You will first need to calculate the monthly sales total for each type of ball using the SUMIF function.

c. Calculate the actual sales mix for the year. Round to one decimal place as needed.

d. Calculate the sales mix for each customer's purchase. Did any customer purchase golf balls in the 2:1 assumed sales mix? In the actual mix you calculated above in part c?

e. Prepare Greer's contribution format income statement for the year using the actual sales data. Assume all prices and costs were as projected.

f. Using the actual sales mix, calculate the breakeven point for the year. Fixed costs were $14,000 per month. How does this compare to the projected breakeven point Carl used in preparing his sales forecast?