Question: be preparing a consolidated sales forcast analysis and graph to show your results for CPU Computer Sales. Ltd. Firstly, Sales summary projections by product and

be preparing a consolidated sales forcast analysis and graph to show your results for CPU Computer Sales. Ltd. Firstly,

Sales summary projections by product and quarter for the cities of Toronto, Vancouver, Montreal. The data has been provided. Place your results in the "Sales Results Worksheet" Graph results by Yearly Totals and City. Pay attention to your linkages and results.Please provide the excel formula used

B C Vancouver Forcasted Sales 1st Quarter 2nd Quarter |3rd Quarter |4th Quarter Total 5 Notebook computers 200000 6 Desktop computers 150000 7 Software 150000 8 Total 9 10 Note: Vancouver expects a 5% increase per quarter per product for the balance of the year. 11 Montreal Forcasted Sales 12 13 1 st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total 14 15 Notebook computers 175000 180000 16 Desktop computers 125000 140000 17 Software 200000 20000 18 Total 19 20 Note: Montreal expects a 8% increase per quarter per product for the balance of the year. 21 Toronto Forcasted Sales 22 23 1st Quarter 2nd Quarter 3rd Quarter |4th Quarter Total 24 25 Notebook computers 300000 26 Desktop computers 200000 27 Software 50000 28 Total 29 30 Note: Toronto expects a 4% increase in the remaining quarters per product for the balance of the year. 31 32

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!

need help for Question 1 and 2 of the assignment fir ACCT 221 FORENSIC BUSINESS INVESTIGATION. Pertains to WorldCom scandal. QAssuming WorldCom was a company operating in Australia at the time of the...

Review the consolidated balance sheets and the related disclosures and respond to the following questions. Debt: As of June 30, 2015, what is the dollar amount of the current portion of the long-term...

Answering the following question using this the attached financial statement, which can also be found at https://www.sec.gov/Archives/edgar/data/80424/000008042415000070/fy141510-kreport.htm For each...

I need help understanding this project... Submit the Ratio Analysis portion of the final project. For this milestone, you will be analyzing the financial performance of Starbucks using the financial...

Use the flexible budget template to complete this problem The Antigua Blood bank, a private charity partly supported by government grants is located on the Caribbean island of Antigua. The blood bank...

Financial Statement analysis - Homework case number 4. Accounting for Software Revenue Recognition Is Computer Associates Being Too Aggressive? Annual Revenues at Computer Associates (CA) dropped...

I am in the process of completing my final project. Please help me the Executive Summary, Approach and recommendations portions of the project which is outlined in sections I, II and VII of the...

Microsoft Word - ACCT2212 Group Assignment 2017.doc Analyse the financial statements for FY2008 and FY2009 using the analytical methods below and discuss any material red flags which may be revealed...

Download Toro's annual report from the activities folder and try questions 1-2. What is the balance-sheet based accrual ratio of Toro for the year of 2011? Note that total debts should include debts,...

Knightly Co's stock price is currently $10 per share. Knightly's warrants have a price of $7 per warrant. Each warrant enables the holder to purchase three shares of Knightly's common stock for $8...

The following information is relevant for Mr T. Toof tax calculation for the year ended 28 February 2022: i. he received interest on his local savings account of R17 500 as well as interest on his...

The multidimensional SML predicts that the contribution of each source of risk to a security's total risk premium equals the factor Blank______ times the Blank______ of the factor portfolio tracking...

TOU Tave the land II LITIS Case Study. 1. Create a new folder for this path of Light Yoga Studio case study. 2. Modify the style sheet (yoga.css) to configure style rules for the new Con- tact page....

2-21. NONVERBAL COMMUNICATION: ANALYZING NONVERBAL SIGNALS [LO-5] Select a piece of mail, from any company, that you received at work or at home. Analyze its appearance. What nonverbal messages does...

2-20. INTERPERSONAL COMMUNICATION: LISTENING TO EMPATHIZE [LO-4] Think back over conversations you have had with friends, family members, co-workers, or classmates in the past week. Select a...

b. How well did the individual participants listen? How could you tell?