I need a tailored stock control system
- or -
Post a project like this3053
$$
- Posted:
- Proposals: 6
- Remote
- #956630
- Completed
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
59968120827066003475264995618311341
Description
Experience Level: Intermediate
General information for the business: I make specialist fruit preserves
Industry: Food and Beverage
Description of excel work: I need a system to keep track of stock from the point of bringing in ingredients to finished sales. I need it to keep a tally of my raw materials, how much stock that will make, how long it will last (kg/week), when and to whom it was sold etc. If possible I would like the system to also keep a tally of the cost of ingredients too.
Extra notes: To give you an idea I attach a copy of the headings I currently use, but these need to be modified as I need the stages beforehand as well (i.e. the raw materials in stock). The fruit I use is seasonal; I bring it in and freeze it to use throughout the year. I need to know how much stock I have remaining in the freezer and how much product that would make per week until the season starts again. Each fruit has a different season.
Please email if there is any other information you need or would find helpful
Industry: Food and Beverage
Description of excel work: I need a system to keep track of stock from the point of bringing in ingredients to finished sales. I need it to keep a tally of my raw materials, how much stock that will make, how long it will last (kg/week), when and to whom it was sold etc. If possible I would like the system to also keep a tally of the cost of ingredients too.
Extra notes: To give you an idea I attach a copy of the headings I currently use, but these need to be modified as I need the stages beforehand as well (i.e. the raw materials in stock). The fruit I use is seasonal; I bring it in and freeze it to use throughout the year. I need to know how much stock I have remaining in the freezer and how much product that would make per week until the season starts again. Each fruit has a different season.
Please email if there is any other information you need or would find helpful
Hazel G.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
2 Feb 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies