Question - Fit Fran recently launched her own set of healthy nutritious drinks. She's hired you as a consultant to help assess recent performance.
|
Drink
|
Budgeted Data
|
Actual results
|
|
Qty
|
ASP
|
Cost
|
Qty
|
ASP
|
Cost
|
|
V-Sky
|
250,000
|
$1.20
|
$0.50
|
180,000
|
$1.00
|
$0.45
|
|
C-Class
|
300,000
|
$1.50
|
$0.60
|
270,000
|
$1.35
|
$0.50
|
|
Super-detox
|
200,000
|
$1.80
|
$0.70
|
330,000
|
$2.00
|
$0.75
|
|
Armored-defense
|
50,000
|
$2.50
|
$1.00
|
180,000
|
$3.00
|
$1.20
|
1. Compute the variances for the individual flavores and total sold:
a. Sales volume
b. Sales mix. Go to six decimal places.
c. Sales Quantity
2. Assess sales in 2013 based on your analysis.