Terminé

Project for Muhammad Asad K.

Hi Muhammad. i do have another task for you. We added a spreadsheet to the workbook you created for us (attached). It's the front end marketing that will generate the closed sales. I need you to connect it to your spreadsheets so instead of us populating the Whales, Sharks and Minnows manually by entering a date for each one, instead can you pull the sales from the new Marketing tab to populate the line items in the detail spreadsheets.

In other words, if the marketing spreadsheet calculates a whale in January, then you can assign it a date of 1/1 and create the line item. You can default the number of months between sales (would be ideal if that's a variable we control in the assumptions tab so I could set whales to 3 months, sharks to 2 and minnows to 1. And then we can edit the line items to make that more random, like we've done manually in your original spreadsheets.

Alternately if that's too complex, then you can use a default number set in the assumptions tab for each of the customer sizes.

Note that we have multiple marketing programs, each one resulting in closed sales of the three types so I've included a sum at the bottom of all fo the marketing programs by account type.

One other tricky thing that we'd love for you to solve is to not have partial sales close. For example, if you look under the whales in Cup DM program, it's calculating .8 of a closed sale in Feb. Ideally, you could push the sale to March as 1 sale and carry over the remainder (.6) to the next month and when that hits 1, then carry over, etc. That's more realistic in terms of timing of customers and revenue. Ideally, if you can do that for each of the sale types for each program (vs. just applying it to the sum of sales), that would be even better.

Hopefully that makes sense but if not, feel free to message me and I can clarify. I also am guessing at the cost. Let me know if I guessed wrong.

Thanks!

Chuck

P.S. Don't need this quite as fast as last time. By Monday morning (US Mountain time) will be fine.

Compétences : Comptabilité, Saisie de Données, Excel, Analyses financières, Intuit QuickBooks

en voir plus : Hi there, I need some business card design urgently. If you think you are best candidate for this project please tell me somethi, COSC 2425 – Project 3 Write an assembly language program that accumulates and reports the sales for the Albatross Corporation, The objective of the this project is to deliver a complete system that aims at performing vibration analysis of a target moving , look for project managers, look for employee for africa business project, how to look for an illustrator for a nonprofit project, muhammad asad, looking for somewhere that can design my company name and logo and then i will pay for it if it makes a requirement, look for php project freelancer, i want to design a logo for my new youtube channel about drones this is one example for the drones, i want to design a logo for my new youtube channel about ( drones ) this is one example for the drones, project muhammad may 2013, project muhammad, project management failure real life example, project vba sql server connection example

Concernant l'employeur :
( 316 commentaires ) Chandler, United States

Nº du projet : #15877322

Décerné à:

asadkhan3533

Hired by the Employer

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(44 Commentaires)
5.3