+ Reply to Thread
Results 1 to 2 of 2

Production calculation Spreadsheet

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver

    Production calculation Spreadsheet

    I have a question, I'm not getting any solution, I want this ExcelSpreadsheet, please help for this, the question is:
    This is about some muesli bars: 32 pcs x 280 displays = 8960 bars / pallet. You had mentioned 22 pallets would make it 197.120 bars per year. 1200 point of sales (shops) )sold one display per week we would come to 998,400 bars per annum. If they same amount of stores sold one display every other week we could still arrive at 449.200 bars per year. Selling one display per week would require 4,5 bars to be sold per day, or for one display to be sold bi-weekly it would take 2,2 bars per day per store. (Hope the math is correct). This is of course a hypothetical example, and an average. In reality depending on location of store and foot traffic etc they sell very different numbers."



  2. #2
    Forum Expert
    Join Date
    Newcastle, England
    MS-Off Ver
    2003 & 2013

    Re: Production calculation Spreadsheet

    Thats a lot of muelsi bars but what is the actual question?
    If someone has helped you then please add to their Reputation

+ 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. employees production and productivity calculation
    By Giri.hb in forum Excel General
    Replies: 4
    Last Post: 06-29-2014, 10:04 AM
  2. Spreadsheet which shows production values in a given week
    By starstar88 in forum Excel General
    Replies: 1
    Last Post: 05-23-2013, 02:45 PM
  3. Lead time calculation for different production Line
    By Krishantha in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-04-2013, 08:30 AM
  4. Production Line Calculation
    By ows246 in forum Excel General
    Replies: 15
    Last Post: 01-08-2013, 04:45 AM
  5. Replies: 5
    Last Post: 11-06-2012, 01:17 PM
  6. Compiling a production spreadsheet, and need assistance.
    By Falbrav in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-20-2012, 06:36 AM
  7. Developing Production Calendar Spreadsheet - Help!
    By rjbrooks01 in forum Excel General
    Replies: 1
    Last Post: 02-18-2012, 11:29 PM

Tags for this Thread


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