Description Multiproduct CVP analysis using data analytics and Excel Instructions Greer Golf Supplies is an online store that sees two types of all Lallis: practice balls and tournament balls. The golf balls are sold in plastic sleeves containing the gall balls. Practice balls sell for $4 persleeve: tournament balls sell for S12 per seeve. Owner Carl Ride' purchases the golf balls directly from the manufacturer and pays $1 per sleeve for the practice balls and s4 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 assumes he would sell twice as many sleeves of practice balls as tournament balls. Data: Module 01 Data Sct Practice and Tournament Balls by Month and Day Thistest allows attempts. This is attempt murber 1. Antemps Force Completion This test can be saved and resumed later. Your answers are saved automatically * Question Completion Status: Clase Wind A Moving to another ouestion will save this response. >> Question 6 1 points Save Anne Calcu ate the sales mix for each customer's purchase There are TWO purchases at the budgeted sales mix af 2:1. Find those two purchases in the data and provide the data for those purchases: DATE mm/dd it of Practice Balls sold Wor Tuurriatriel Balls Sulu DATE mm/dd # of Practice Balls sold #of Toumament Balls sold Description Multiproduct CVP analysis using data analytics and Excel Instructions Greer Golf Supplies is an online store that sees two types of all Lallis: practice balls and tournament balls. The golf balls are sold in plastic sleeves containing the gall balls. Practice balls sell for $4 persleeve: tournament balls sell for S12 per seeve. Owner Carl Ride' purchases the golf balls directly from the manufacturer and pays $1 per sleeve for the practice balls and s4 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 assumes he would sell twice as many sleeves of practice balls as tournament balls. Data: Module 01 Data Sct Practice and Tournament Balls by Month and Day Thistest allows attempts. This is attempt murber 1. Antemps Force Completion This test can be saved and resumed later. Your answers are saved automatically * Question Completion Status: Clase Wind A Moving to another ouestion will save this response. >> Question 6 1 points Save Anne Calcu ate the sales mix for each customer's purchase There are TWO purchases at the budgeted sales mix af 2:1. Find those two purchases in the data and provide the data for those purchases: DATE mm/dd it of Practice Balls sold Wor Tuurriatriel Balls Sulu DATE mm/dd # of Practice Balls sold #of Toumament Balls sold
