Single Problem

Get Single Problem Homework Help from Experts

Ask an Expert,
Get an Answer ASAP!

Single Problem

I need a sales forecast including the calculations on

Customer Question
Hello, I need a sales...
Hello, I need a sales forecast including the calculations on an excel spreadsheet
so, how do I go about achieving that goal and what kind of assumptions will you be using?
Submitted: 2 years ago.Category: Single Problem
Show More
Show Less
Ask Your Own Single Problem Question
Answered in 20 minutes by:
5/9/2015
Business Tutor: Johnmark1900, Associate Degree replied 2 years ago
Johnmark1900
Johnmark1900, Associate Degree
Category: Single Problem
Satisfied Customers: 842
Experience: I am a qualified Chartered Accountant, working as finance manager for reputable organization
Verified
Hello
My name is Johnmark.
Can you please provide me the data
Ask Your Own Single Problem Question
Customer reply replied 2 years ago
Project Overview:This is an individual project where you will be acting as a consultant to an entrepreneur who wants to start a new business. As the consultant, you’ll create a 5-year budget that supports the entrepreneur’s vision and strategy, as well as the needs for equipment, labor, and other start-up costs.Business Profile: Wireless World—Wireless Device Retail StoreVisionThe vision of the entrepreneur is to create a single-location retail operation that sells portable wireless devices called Wireless World. The company sells phones, wireless e-book readers, high-end notebook and netbook computers, iPads, and other wireless computing devices.Strategya) Market Focus/Analysis
This store targets tech-savvy individuals who are mostly students from wealthy families or working adults between the ages of 22 and 49 years of age. These individuals either purchase the products because they love wireless gadgets, think the gadgets will improve their productivity, or think the wireless gadgets are fashionable and consistent with their lifestyle. The store is located in a high-end shopping center called Millennia Mall alongside Neiman Marcus, Macy’s, and other high-end stores.b) Product
Products are cutting edge wireless devices from brand name companies, as well as specialty companies that have unique products that are not readily available at other stores.c) Basis of Competition
Customers shop at the store for the high-end shopping experience; knowledgeable staff; superior customer service and return policies; and the broad selection of well-known, brand-name products, as well as lesser known companies with highly unique and innovative wireless devices. They also shop at the store because it is stocked with cutting-edge products that are new to the market.Start-Up Requirements*Given Costs
• The cost of registering a limited liability company in Florida—filing fees listed at the bottom of the application located at h
• Renovation of the facility expected to cost $25,000
• 2.1 Sales Forecast• Here you should include a simple table showing the years and the total sales for each year, along with a brief explanation of why sales are expected to rise, fall, change, or stay the same in certain years. Provide a brief explanation of the sales forecast, indicating why you expect sales to rise or fall during the planning horizon. Your explanation should be consistent with the trends and changes in sales found in your table.
Year 1 Year 2 Year 3 Year 4 Year 5
Sales• 2.2 Methods and Assumptions• Here you should describe how you arrived at your sales forecast in section 2.1. You should also provide any detailed calculations that led you to the sales forecast values. You should also summarize any research or figures that led you to make this sales forecast.So, basically, I have to create a five year sales forecast for the wireless business but I don’t have a historical data and I am trying to be as much as accurate as I can be. With this business, I think sales will go up during the holiday seasons but I don’t know how to put all of this things together in excel and come up with the calculations and what the assumptions will be.
Customer reply replied 2 years ago
I don't have a data and the sales forecast was supposed to be for a new business
Business Tutor: F. Naz, B.Com replied 2 years ago
F. Naz
F. Naz, B.Com
Category: Single Problem
Satisfied Customers: 5,345
Experience: Have completed B.Com and CA Finalist
Verified
May I use the assumed figure, and what is your deadline, thanks.
Ask Your Own Single Problem Question
Customer reply replied 2 years ago
My deadline is Friday and I do have couple of tips that was offered by the professor:
So here is what is been considered and if you can also send me the excel spreadsheet that will be very much appreciated it with some kind of explanation because, I have to explain how I came up with those numbers.
1. This week's assignment is a five-year sales forecast--just sales for two or three products or services for five years--no expenses, no profits, no assets, no liabilities, no cash flows.2. Annualize your sales of your two or three products or services to adequate to support the costs of doing business and to earn a profit. A real business would of course probably offer more than two or three products or services.3. Each of the three course project start-up companies will have more than one specific source of revenues each year.4. 5. Look at the information given in the course project description and develop your price, volume and sales on your own for Year 1. You will use some research and some assumptions to document your numbers.5. Wireless World in The Mall at Millennia in Orlando, Florida, will sell cutting edge wireless devices as well as specialty items. A student could forecast only three specific products, to demonstrate how to use the concepts in this project, and then come up with reasonable annual sales volumes for just those three items, as if that is all that the store sold, that would support a real store.6. 7. Consider % or $ growth from year 1 to year 2, from year 2 to year 3 and so forth. How much, how so? What will the business owners DO to make sales grow? Growth in the local population means more potential customers, not more customers. Are sales growing because of local population demographics, direct selling, advertising, word of mouth, price increases, what?
Business Tutor: F. Naz, B.Com replied 2 years ago
Thanks will go through and will come back soon, take care.
Ask Your Own Single Problem Question
Business Tutor: F. Naz, B.Com replied 2 years ago
Keeping in the volume of work I have sent you the offer, please accept it so the answer my be provided by or before your deadline, thanks.
Ask Your Own Single Problem Question
Customer reply replied 2 years ago
I got another update and that is the professor has finally giving us the excel template to use for the course project:2016 2017 2018 2019 2020
iphones units sold
Sale price @ unit
Cat 1 TOTAL
Samsung Phones units sold
Sale price @ unit
Cat 2 TOTAL
Windows Surface units sold 1,000
Sale price @ unit
Cat 3 TOTAL 0 0 0 0 0
Service Repairs and Maintenance Revenue
Sale price @ unit
Cat 4 TOTAL
Annual totals: All Categories #REF! #REF! #REF! #REF! #REF!so, the work now just got little easier and what's need to be done now is just fill in how many units needs to be sold and what the sale price is going to be base on accurate numbers and research, then I have to come up with the assumptions.
Business Tutor: F. Naz, B.Com replied 2 years ago
Okay no problem will provide it by your deadline of Friday, please go through the offer sent to you, thanks.
Ask Your Own Single Problem Question
Business Tutor: F. Naz, B.Com replied 2 years ago
Waiting to start working on assignment, thanks.
Ask Your Own Single Problem Question
Customer reply replied 2 years ago
You didn't start working on the assignment yet? What do you need to start? I thought I paid already to get the solution by Friday. What's going on? am I going to get the solution by Friday? I am getting confused here.
Business Tutor: F. Naz, B.Com replied 2 years ago
I have sent you the offer if you agree with that offer, and accept it then I will start working on the assignment, thansk.
Ask Your Own Single Problem Question
Ask linda_us Your Own Question
linda_us
linda_us
linda_us, Master's Degree
Category: Single Problem
Satisfied Customers: 787
787 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

linda_us

linda_us

Master's Degree

787 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

Manal Elkhoshkhany

Manal Elkhoshkhany

Bachelor's Degree

491 satisfied customers

Finished my BA degree with a GPA of 4.0.

F. Naz

F. Naz

B.Com

5,345 satisfied customers

Have completed B.Com and CA Finalist

Mr. Gregory White

Mr. Gregory White

Master's Degree

279 satisfied customers

M.A., M.S. Education / Educational Administration

Bizhelp

Bizhelp

CPA

265 satisfied customers

BA degree and Certified Public Accountant

Dave CPA

Dave CPA

Accountant

98 satisfied customers

Sound knowledge base in accounting and finance.

MyVirtualCPA

MyVirtualCPA

Master's Degree

96 satisfied customers

Master's Degree in Accounting with excellent math and reasoning skills

< Previous | Next >

Related Single Problem Questions
What is the final amount of $105.00 that is put into a
What is the final amount of $105.00 that is put into a savings account work 8% interest rate for 25 yesterday, if the interest is compounded 4 times a year? … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
I am self-employed. I relocated temporarily to so I can work
I am self-employed. I relocated temporarily to Virginia so I can work while my home recovers from hurricane. I read the IRS allows deductions for temporary housing and transportation costs as business… read more
Barbara
Barbara
Enrolled Agent, Paralegal
3,466 satisfied customers
Florida Home Health is a small home care agency owned by a
For Manal Elkhoshkhany Florida Home Health is a small home care agency owned by a group practice of nurses and physical therapists in Tampa, Florida. During the past few years, the company reported th… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
Hand written tax return #4 is not in the book and it's NOT
Hand written tax return #4 is not in the book and it's NOT hand written. Please do this return on the COMPUTER, but this is not a group tax return! Please do this on your own. The information is in th… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
F. Naz
F. Naz
B.Com
5,345 satisfied customers
In problem 89 of Chapter 9, you were asked to determine the
In problem 89 of Chapter 9, you were asked to determine the initial basis of Emelio and Charita's business, investment, and personal use assets. In this problem, you are to determine the adjusted basi… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
You are the resident tax expert for Wetzel's Pretzels, an
You are the resident tax expert for Wetzel's Pretzels, an international producer of junk food. The controller has come to you with the company's capital expenditures budget for next year. The budget s… read more
PDtax
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
INCLUDE THIS ******* AS A FIRST NAME JASPER ******* AS A
PLEASE INCLUDE THIS DAVID ******* AS A FIRST NAME JASPER ******* AS A LAST NAME Please read the entire problem for David and Darlene Jasper starting on pages 6-69 before entering any information in yo… read more
PDtax
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Develop a progressive yet competitive compensation plan that
Develop a progressive yet competitive compensation plan that will support recruiting and retention efforts and lower the employee turnover rate. Traditionally, Motors and More has provided employees m… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
I like to address this to a teacher. Who has or is teaching
Hello: I like to address this to a teacher. Who has or is teaching at the Community College level. Or a school administrator at the Junior College level. This is my 3rd semester at San Diego City Coll… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
FOR MANAL ELKHOSHKHANY Assignment Steps Resources: OECD
FOR MANAL ELKHOSHKHANYAssignment Steps Resources: OECD Database, Corporate Finance Prepare a 12- to 15-slide PowerPoint® presentation with speaker notes requesting initial funding of $500,000 to start… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
You are to submit the tax return which is generated by
You are to submit the tax return which is generated by Appendix A, Phases One and Two. Phase Two builds on Phase One. Pay close attention, because some of the new information in Phase Two may change t… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
I'm replacing the wheles on a bed frame. I need to replace
I'm replacing the wheles on a bed frame. I need to replace the plastic inserts that go into the frame so the caster stems fit and swivel. What are the plastic inserts called? I want to order them but … read more
F. Naz
F. Naz
B.Com
5,345 satisfied customers
On January 1, 2014, Seller Corp and Buyer Corp closed on the
On January 1, 2014, Seller Corp and Buyer Corp closed on the sale of a factory building for $30,000,000 with the following payment terms: Buyer Corp paid $3,000,000 at closing. Buyer Corp assumed $7,0… read more
F. Naz
F. Naz
B.Com
5,345 satisfied customers
Question #4. New Beginnings Corp. began 2XXX with the
Question #4. New Beginnings Corp. began 2XXX with the following account balances. … read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
187 satisfied customers
Emelio and Charita are married taxpayers with 2 dependent
Emelio and Charita are married taxpayers with 2 dependent children. Emelio starts a computer consulting business in 2017. Charita works as a real estate broker. Dur- ing 2017, they have the following … read more
PDtax
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Morningside Nursing Home, a single not-for-profit facility,
For Manal Elkhoshkhany Morningside Nursing Home, a single not-for-profit facility, is estimating its corporate cost of capital. Its tax-exempt debt currently requires an interest rate of 6.2 percent, … read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Bachelor's Degree
491 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x