Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Recalculate M Marketing Name Price Promo Sales Benchmark Your Budget Budget Prediction Forecast Gross Revenue Variable Contrib Costs Margin Teamname: Andrews | Round: 1
Recalculate M Marketing Name Price Promo Sales Benchmark Your Budget Budget Prediction Forecast Gross Revenue Variable Contrib Costs Margin Teamname: Andrews | Round: 1 | Year: 2023 Draft saved at Nov 30, 2023 11:18PM CST Less Promo/Sales I Art $ 42.00 $ 1200 $ 1000 1,486 0 $ 62,396 $38,125 $ 24,271 $ 22,071 Ant $ 26.00 -SA $ 1200 $ 2000 769 0 $ 19,981 $ 10,982 $8,999 $ 5,799 Ace $ 32.00 $ 1200 $ 1000 1,957 0 $ 62,637 $ 37,982 $ 24,656 $ 22,456 Axe $ 40.00 SA $ 1200 $ 1000 2,045 0 $ 81,781 $52,766 $ 29,016 $ 26,816 NA $0.0 $0 $0 0 $ 0 $ 0 $ 0 $0 $0.0 $0 $ 0 0 $0 $ 0 $ 0 $0 $0.0 $ 0 $ 0 0 $ 0 $ 0 $ 0 $0 NA $0.0 $0 $ 0 0 $ 0 $ 0 $ 0 $0 Total $ 4,800 $ 5,000 6,256 0 $226,795 $ 139,854 $ 86,941 $ 77,141 A/R Lag (days) : 30 A/P Lag (days) : 30 Revenue Forecast 100 Unit Sales Forecast 3k Revenue forecast (in 000's) 75 $62,396 50 25 $19,981 $81,782 $62,638 Art Ant Ace Variable Cost Marketing Margin After Marketing Axe Unit Sales forecast (in 000's) 2k 1,486 1k 769 2,045 1,957 Ok Art Ant Ace Axe Thrift Core Nano Elite
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started