ปิด

Design a Monthly Reporting Package

Design Brief

Client : NKT

Project: To design a visually appealing monthly management reporting package.

Required skills: Strong excel background, marketing and design

Colour Scheme: Shades of PMS 325C

Deadline: 24 hours for draft, 7 days for completion.

This project is about presenting numbers in a visual manner using images, charts and colour. We require a template that can be used each month for reporting quantitative and qualitative information. Preferred format is Excel but powerpoint is another option with an excel database.

Quantitative figures should coming through from an excel spreadsheet. When the spreadsheet is updated these figures should flow through to the reporting package.

Number of pages: 10 (plus supporting excel data behind)

Page 1 – Cover Page

Must contain an area to insert client logo

Text space to include wording Monthly Reporting Package for ………….. Date XXXX

An image and small text in the footer to include a second logo.

Image to add client product

Page 2 – Contents

Page 3 - Sales Figures

2 ranges – Commercial and Consumer

Need to show total sales, then broken up between consumer and commercial sales as a %

A graph showing sales in each category against budget figures

A section for adding in text to discuss results

Page 4: Sales per region

Map of Australia with sales in $ figure on each state. % increase or decrease from prior period and variance from budgeted sales, maybe show % in red if below budget another colour if budget hit.

Text section to discuss qualitative information.

Page 5: Campaign Analysis

Image to show current campaign

Listing of the past 6 monthly campaigns ie December Cosmopolitan issue

Visually reflect the % increase in sales on total revenue, break up between the consumer and the professional range.

Show increase in sales staff costs to actual sales.

Page 6: Cost Analysis

Bubble chart to show the several major expenses, bubble size represents the cost of each expense. 8 expense categories.

Freight analysis, show monthly freight costs against budget

Page 7: Break Even Point

Show BEP

A bar graph that shows when BEP has been met as above the line and when it hasn’t as below.

A separate cash flow chart which shows the amount of cash inflow or outflow from operating activities.

Text section to discuss the results

Page 8: Effect of Product Recall

Show 24 months sales in a graph including with a colour code for the months the recall occurred

Track costs relating to the recall which get added in each month to give total cost.

Track Benefits received i.e. reduction in stock costs.

Page 9: International Launch

Include a map of the UK, USA, Australia.

Ability to report total costs so far per country.

Text to discuss results

Page 10: Simple Ratios

Monthly ratios presented visually

Current Ratio, quick ratio, inventory turnover and net profit margin.

ทักษะ: ออกแบบโบรชัวร์, Excel, ออกแบบใบปลิว, การตลาด, การเขียนรายงาน

ดูเพิ่มเติม : through the line marketing, text effect design, simple reporting, shades logo design, qualitative design, project report cover page, project report cover design, project management flow charts, professional powerpoint design, product launch powerpoint, product launch design, product design project report, product design brief template, product design and analysis, product cost analysis template, product brief template, presenting logo design, powerpoint usa design, powerpoint design usa, powerpoint design point

เกี่ยวกับนายจ้าง:
( 0 บทวิจารณ์ ) Australia

หมายเลขโปรเจค: #8686947

freelancer 54 คน กำลังเสนอราคาเฉลี่ยที่ $412 สำหรับงานนี้

theDesignerz

Welcome to theDesignerz ( #1 Provider in Graphic and Logo Design on Freelancer) The concept originated as a Studio full of vibrant and creative ideas. The Ideas were given life with the name of theDesignerz. We int เพิ่มเติม

$400 AUD ใน 2 วัน
(483 บทวิจารณ์)
7.8
DezineGeek

Good day, We can do this project for you!!! Make an impact with the top notch design; we are ready to work on your project. We offer professional services of innovative graphic design at a very reasonable price. O เพิ่มเติม

$500 AUD ใน 4 วัน
(589 บทวิจารณ์)
8.0
Olywebart

A proposal has not yet been provided

$500 AUD ใน 5 วัน
(150 บทวิจารณ์)
7.0
zExcel

A proposal has not yet been provided

$500 AUD ใน 4 วัน
(204 บทวิจารณ์)
7.2
priyal1997

Hi There, My name is Priyal. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of such excel based dynamic reports for various cli เพิ่มเติม

$500 AUD ใน 5 วัน
(147 บทวิจารณ์)
6.5
JonnaNueros121

I am a professional full time academic research writer fully proficient in HARVARD, APA, MLA, Chicago and Oxford writing styles. I am competent in writing dissertations, thesis, reports, case studies, personal developm เพิ่มเติม

$250 AUD ใน 6 วัน
(152 บทวิจารณ์)
7.0
Dezinestar

Hello Client Dezinestar offers custom brochure design services to set your product, company or service apart from the competition. We follow a streamlined process to design and deliver brochure design with print-ready เพิ่มเติม

$250 AUD ใน 2 วัน
(104 บทวิจารณ์)
6.3
mrbrave

Hi, Can I have a excel database for review? I can develop a Excel/VBA system, which can auto generate the Powerpoint report based on settings. I would like to view dataset and Powerpoint basic template. It will เพิ่มเติม

$300 AUD ใน 2 วัน
(153 บทวิจารณ์)
6.1
ambalaonline1

Hello! I have a passion for good design that communicates clearly and effectively. We are a company of awesomely passionate graphic artists My goal is to create amazing, original, and high quality work for every singl เพิ่มเติม

$315 AUD ใน 4 วัน
(94 บทวิจารณ์)
6.3
raghav1101

Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent) with 5 years of experience in the field of accounts and finance. I have 8 years of experience in Microsoft Excel includi เพิ่มเติม

$474 AUD ใน 5 วัน
(62 บทวิจารณ์)
5.9
coolwriter30

A proposal has not yet been provided

$515 AUD ใน 10 วัน
(49 บทวิจารณ์)
5.7
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b เพิ่มเติม

$500 AUD ใน 10 วัน
(14 บทวิจารณ์)
5.5
tania06

Greetings, I've checked your project description and I am confident that I can deliver top quality service. Over 550 projects completed successfully represent my credibility on freelancer. I’d like to share my เพิ่มเติม

$526 AUD ใน 7 วัน
(48 บทวิจารณ์)
5.6
weaji

Hello, With help of my Fine Arts background and 15 years of experience,I can create awesome graphics for your business. I can come up with first draft in 24 hours or less Please see my profile for my work http:// เพิ่มเติม

$315 AUD ใน 0 วัน
(54 บทวิจารณ์)
5.0
saeedyasir

Hello Although I am not a designer but since having written a number of reports and doing financial analysis in Excel, I am ready to do this project for you. This is no big deal for me in creating 10 pages monthly r เพิ่มเติม

$473 AUD ใน 10 วัน
(23 บทวิจารณ์)
5.1
someka

This is just my proficiency! You dont need to award me now. Just drop me a message so that we can discuss further about pricing and job details. I have a 6 years of business analyst experience in a global compan เพิ่มเติม

$368 AUD ใน 3 วัน
(38 บทวิจารณ์)
4.7
mahamudrony

Hi, I am expert Format and Layout Visual designer, Adobe InDesign master with 7 years professional experience. Past time I have complete many creative Reporting Design project like this project. To check my design เพิ่มเติม

$750 AUD ใน 3 วัน
(53 บทวิจารณ์)
4.8
transformindesi9

Hello, I aim to provide maximum effort to transform ideas into real design. With decades of experience I am able to apply not only theoretical knowledge, but also technical ability and creative influence to all are เพิ่มเติม

$350 AUD ใน 6 วัน
(22 บทวิจารณ์)
4.7
creativegurus

Greetings! I see that you are looking for a creative & experienced designer to design a monthly reporting package For quality assurance, please see my reviews, portfolio and preferred freelancer badge. https://w เพิ่มเติม

$736 AUD ใน 6 วัน
(17 บทวิจารณ์)
4.8
SvetaZ

Hi, My name's Svetlana. I'm from Ukraine, based in Singapore now. I'm a Senior designer in our family company with 20+ years successful experience in graphic design, advertising, B2B and B2C marketing. Please, t เพิ่มเติม

$631 AUD ใน 7 วัน
(8 บทวิจารณ์)
4.7