Find Jobs
Hire Freelancers

I need help with excel task

£10-20 GBP

Closed
Posted about 4 years ago

£10-20 GBP

Paid on delivery
So I've been tasjed in creating and excel task, for a job, but have no idea how to attack it, the briefing is this: Virgin Games. 18+ AD Over £2,200,000 Paid Out on Daily Double JackpotsPlay any Red Tiger game for your chance to win a Daily Double Jackpot. At least three Jackpots are paid out every day! Task 1. Stock, forecasting & picking for concessions. For this task, we would like you to look at 2 spreadsheets: a)     Stock download which details HotSquash’s current stock levels, plus sales over the last 30 days. (Please note some lines have been removed from our actual stock download as these are irrelevant to this task). b)     Company A Sales & returns list for the last month By using the information from these lists we would like you to create a picking list of items that should be sent to Company A to both replenish sold-out lines & also ensure enough stock for the next month. The picking list should contain: 1.     Company A Product Code 2.     HS Product Code 3.     HS Product Name 4.     Garment Colour 5.     Garment Size 6.     EAN 7.     HS current stock 8.     Quantity to pick for Company A 9.     Notes on reasons for that choice of quantity per SKU (i.e. you only need to make 1 comment against HSWD21360 for example, not a comment on the reason for each size of HSWD21360 being sent/not sent stock). It should be laid out like the below: Company A Product Code HS Product Code HS Product Name  Garment Colour Garment Size EAN  HS current stock Quantity to pick for Company A Notes   Points to note: 1.     We recognise that you may not be familiar with the garments in question, therefore we are assuming this is a non-seasonal pick (i.e. we don’t only have to send summer dresses & no winter stock or vice-versa). 2.     The format of the pick-list must be easy to understand to both the warehouse staff who would pick it & the concession staff who we would see this list stuck on the side of every box delivered so they could quickly see what it contained. 3.     Relevant reasons for picking/not picking stock would be situations like: a.     All stock of this item is currently sold out, so we will not be sending more b.     No units of this stock have sold in a month, so will not be picking anymore 4.     For the purposes of this task, we will need lines included for items that do NOT need to be picked (with Quantity to Pick listed as “0”). Obviously, we would not include these on a real pick-list, but we need to see the items you have decided not to send, as well as those you have. 5.     Please save this file to the desktop of this PC 6.     Once you have read through this instruction list & asked any questions you may have, you will have 30 mins to compile as much of the picking list as you can.
Project ID: 24123826

About the project

12 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average £16 GBP for this job
User Avatar
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
£15 GBP in 1 day
4.8 (188 reviews)
6.3
6.3
User Avatar
Greetings, I am Maurine, a bachelor in ECONOMICS & STATISTICS holder, and a proficient statistician. I offer data collection, analysis, interpretation, and presentation services. I'm competent in softwares such as Advanced excel, Eviews, Python, SPSS,STATA, and R studio. I am qualified to take up the project and would love to speak with you further about taking this project on. Regards, Maurine.
£15 GBP in 7 days
5.0 (11 reviews)
3.6
3.6
User Avatar
I can do any data entry requested I have a big experience in work in WORD EXECL you can hire me for this task.
£15 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can definetly support you. I am mechanical engineer with a master in mechanical engineering. I am suitable to achieve what you want since I have developed multiple spreadsheets and programs.
£20 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am irfan in computer science having 2 years of experience as a data analyst and data scientist with following skills: • Machine learning. • Modelling. • Data Meaning. • Data scientist. • Deep learning. • Data visualizations. • Statistical analysis. • Open Cv. • Artificial intelligence. • Image Processing. • Signal processing. • Neural networks. • Sentimental Analysis. • Finite analysis. I have ability to do your project within your deadline. I need some discussion to make the things clear.
£10 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent work experience in excel
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked with excel and i assure you with good work
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! My name is Tutor jamesvalley, and I am a full time tutor and writer. I have read your order keenly, and I can guarantee you a good grade because it falls in my field of expertise.
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i am expert in excel from the last three i used excel for different audit assignment for alot of companies maybe i am perfect for your work . please get in touch for further discussion. Thanks And Regards, Muhammad Fawad
£23 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am an advanced Excel user and have been working in data analysis for years and software development and I am sure that I can accomplish the task.
£10 GBP in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Roehampton, United Kingdom
0.0
0
Member since Feb 27, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.