+ Reply to Thread
Results 1 to 3 of 3

I Dont understand formulas and its frustrating trying to forecast monthly sales and growth

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    KY, USA
    MS-Off Ver
    2010
    Posts
    1

    I Dont understand formulas and its frustrating trying to forecast monthly sales and growth

    I have been working on this assignment since Friday and it was due Saturday I am at the point I am ready to scream the only steps I got right was #5 & 6 in calculations. I don't get it all! Basically I need help on 3- Step 4, 8 & 9! PLEASE! I am Begging you I have already broke my laptop screen and I can't take it anymore! In class he gave us this info:
    ((T12*365)/12) and options for Sensitivity applies to bottom up and % of annual sales option 1 calculate 10% of number, subtract value from original & option 2 Multiply number by 10% in excel #(1-%)



    Step 3 Calculate daily sales for each product, based on quantity and the per unit price. Use excel formulas to calculate the monthly sales for both products into month of January.

    Step 4 the "Growth" figure for both represents the monthly growth in sales for each product. Using excel formulas complete the 12 month sales forecast. Hint November income should total $10,168

    Step 8 Using Excel formulas Complete sensitivity approach #1 "Ground Up" Hint should be $9316 for Dec.

    Step 9 Using Excel formulas Complete sensitivity approach #2 "% numbers . Hint should have product B total annual sales as $356,250 annual sales
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: I Dont understand formulas and its frustrating trying to forecast monthly sales and gr

    One mistake that I notice: the formula in E12 is =(($T$12*365)/12)+(1-E4).
    It should be =(($T$12*365)/12)*(1+E4).

    Similarly in E13.

    Example: if you start with $100 and you want 10% more, you would write 100*(1+10%), which is $110.

    Another mistake: the formula in F12 is =E12*F4+$E$12.
    Close! But it should be =E12*F4+E12 so that it can be replicated down and across.
    Alternatively, you could write =E12*(1+F4), similar to E12.

    Finally, the formula in F14 is =$E$6*(F6). Although it produces the correct result (0) by coincidence, technically it is incorrect because there is no information in E6 and F6 related to category C.

    That's all I noticed on first glance. I really have not looked at the assignment in any detail.
    Last edited by joeu2004; 09-05-2016 at 10:49 PM. Reason: Typo: E12 -> F12

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,720

    Re: I Dont understand formulas and its frustrating trying to forecast monthly sales and gr

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sales growth vs. headcount growth for recent years
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-15-2015, 04:24 AM
  2. Interpolate monthly growth from known Annual Growth
    By nopointing in forum Excel General
    Replies: 3
    Last Post: 06-15-2014, 03:36 AM
  3. Convert 52 Week Rolling Forecast to Monthly Forecast
    By rainintl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2014, 07:24 PM
  4. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  5. Replies: 6
    Last Post: 05-05-2013, 07:17 PM
  6. Replies: 1
    Last Post: 03-08-2013, 04:18 PM
  7. Replies: 5
    Last Post: 03-07-2013, 11:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1