I need help with excel task-2

종료 등록 시간: 4년 전 착불
종료 착불

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.

엑셀 데이터 입력 데이터 처리 통계 수학

프로젝트 ID: #24125204

프로젝트 소개

12 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

이 일자리에 대한 프리랜서 12 명의 평균 입찰가: $23

AMANC9336

Hii Sir please give the Format of sheet which type you want. As well as you want , as well as i will make the sheet. And i will try to complete this work with in 5 days. Thanks sir Relevant Skills and Experience Si 기타

$25 USD (10일 이내)
(0 리뷰)
0.0
srini89ch

High skilled . working profession. i can deliver with stipulated time with accuracy. I hope i could get hired for this valuable project, i will work on dedication, respond to you at any time

$21 USD (4일 이내)
(0 리뷰)
0.0
sagarhembrom

Hi Dear, Thank you for your job post, I have read your job description properly. I have 5 years working with the word, excel, data entry, web research& I have a lot of experience. I can confirm that I will be able to c 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
gonzales10

I am specialized in this field and will been doing it for quite sometime now. Will be glad if am selected for this job.

$20 USD (7일 이내)
(0 리뷰)
0.0
karan281

I an ready to do it and I had great experience in this industry and i can complete the task in the given time and without any mistake I can make a promise that you'll be happy with the work done by me

$25 USD (1일 이내)
(0 리뷰)
0.0
rajputmonu0099

I will Ensure you that your work will be done experienced staff and on time. Relevant Skills and Experience Experienced staff with Full Excel and Data entry knowledge.

$20 USD (1일 이내)
(0 리뷰)
0.0
fuseiniamadu

I have advanced knowledge of Microsoft Excel and will expeditiously handle the project.

$25 USD (1일 이내)
(0 리뷰)
0.0
deepakpoojary88

Can complete work in time good in Excel

$25 USD (1일 이내)
(0 리뷰)
0.0
Personage15

I'm an expert in social science with quantitative data analysis, an experienced statistician and a data analyst. Microsoft office professional. Relevant Skills and Experience Data Entry, Data Processing, Microsoft off 기타

$25 USD (1일 이내)
(0 리뷰)
0.0