Bagas Aji P. (C1H018030) Budgeting Sales Budget.xlsx - Bagas Aji P C1H018030 Year 2012 2013 2014 2015 2016 Year 2012 2013 2014 2015 2016 Sum Sales Price

Bagas Aji P. (C1H018030) Budgeting Sales Budget.xlsx -...

This preview shows page 1 out of 1 page.

Bagas Aji P. C1H018030 Year 2012 165 130 2013 155 130 2014 185 133 2015 165 135 2016 195 137 Year X XY 2012 165 -2 4 -330 2013 155 -1 1 -155 2014 185 0 0 0 2015 165 1 1 165 2016 195 2 4 390 Sum 865 10 70 a = 173 b = 7 Y' = 173 + 7X 1. Sales forecast 2017 = 173 + 7(3) = 194 Distribution: Jakarta = 0.7 x 194 = 135.8 Surabaya = 0.3 x 194 58.2 Quarter Jakarta Surabaya I 33.95 14.55 II 40.74 17.46 III 33.95 14.55 IV 27.16 11.64 Saled budget price increase 15% = 137 x 115% = 157.55 KANAYA Co. Sales Budget 2017 Time Jakarta Surabaya Total Unit Price Total Unit
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Summer '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes