Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help my team with some professional advice! Name Price O Promo Sales Benchmark Your Gross Variable Contrib Less Budget Budget Prediction O Forecast O

Please help my team with some professional advice!

image text in transcribed
Name Price O Promo Sales Benchmark Your Gross Variable Contrib Less Budget Budget Prediction O Forecast O Revenue O Costs O Margin O Promo/Sales O Baker 29.00 $ 1,300 $ 2,330 2,319 $ 67,241 $ 46,578 $ 20,663 $ 17,033 Bead 21.00 $ 1,300 $ 3,495 1,567 $ 32,904 $ 20,852 $ 12,052 $ 7,257 Bid 31.50 $ 300 $ 2,330 106 $ 3,324 $ 2,595 $ 729 ($ 1,901) Bold 30.50 $ 800 $ 1,748 129 $ 3,920 $ 3,111 $ 809 ($ 1,738) Buddy 30.50 $ 800 $ 1,748 153 0 $ 4,657 $ 3,431 $ 1,226 ($ 1,321) NA $0.0 $0 $0 0 $0 $0 $ 0 $ 0 NA $0.0 $0 $0 O $0 $ 0 $ 0 $ 0 NA $0.0 $0 $0 0 $0 $0 $0 $0 Total $ 4,500 $ 11,651 4,272 0 $ 112,046 $ 76,567 $ 35,479 $ 19,329 A/R Lag (days) : 30 A/P Lag (days) @ :[ 30 Revenue Forecast Unit Sales Forecast 75 $67,241 3 2,319 50 2 1,567 Revenue forecast (in 000's) $32,904 Unit Sales forecast (in 000's) 25 $5,225 $5,659 $5,979 106 129 153 0 0 Baker Bead Bid Bold Buddy Baker Bead Bid Bold Buddy Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management Awareness And Change

Authors: Frank Martin , John Thompson , Jonathan M.Scott

8th Edition

1473726336, 978-1473726338

More Books

Students also viewed these General Management questions

Question

Why did the WTO rule against the European Union?

Answered: 1 week ago